export excel charts - COM and CF

[Rich Wild]

Has anyone tried the following:

Connecting to an instance of excel thru com, inserting data, running a macro
on that inserted data which creates a chart based on that data, then exports
the chart as gif - then tidying up (close com connection, use cffile to move
gif to webroot and serve).

I'm not particulary worried about the first bit or the last bit, but the
firing off the macro and exporting is the bit that I'm seeking help about.
Nate Weiss had some handy tips about ensuring that the macro security is set
to the proper level for the NT account that CF runs under, which wasn't
something I had considered quite frankly...
Are there any other things I should be aware of? Opinions on the efficiency
of such a task to serve up a few dynamic gif reports? (I've looked at the
various graphing tags and none of them are suitable (read limited) , and
cfx_graphicsserver is too pricey an option)

Help appreciated.

:)
---
Rich Wild
Senior Web Designer

---
e-mango.com ltd  Tel: 01202 587 400
Lansdowne Place  Fax: 01202 587 401
17 Holdenhurst Road
Bournemouth   Mailto:[EMAIL PROTECTED]
BH8 8EW, UK  http://www.e-mango.com

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

Re: Netscape 6 out UGH!!!! [OT]

[Rob Keniger]

on 11/16/00 8:57 AM, Scott, Andrew at [EMAIL PROTECTED] wrote:

> I would consider Web Design easy, because it actually is. However its when
> you wish to start to do application development that it becomes harder.

I disagree with this statement. GOOD web design is not easy and the way in
which you dismiss HTML design as somehow inferior to application design
smacks of snobbery. It takes a great deal of knowledge about visual design,
technical HTML issues, browser foibles, and usability design. to produce a
good website.

In my experience most programmers are poor web designers and vice versa. It
is a rare find when you come across someone who can do both well.

Sure you can whack out a quick site with Frontpage but it will not be a
*good* site.

There are very many poor web sites out there.

-- 

Rob Keniger

big bang solutions





Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

RE: Studio - left panel missing

[Nick Betts]

Try View, Resource Windows, Dock All..that should bring them all back!
Nick Betts
Poulternet, UK.

-Original Message-
From: Walker, Matthew [mailto:[EMAIL PROTECTED]]
Sent: 15 November 2000 21:01
To: CF-Talk
Subject: RE: Studio - left panel missing


> For some bizarre reason the left panel, with directory 
> structure and Docs,
> in CF Studio has vanished.

Try looking uner the F9 key.


Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a
message with 'unsubscribe' in the body to
[EMAIL PROTECTED]

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

RE: export excel charts - COM and CF

[Rich Wild]

Aha.

If anyone is interested, I wrote a macro to handle the data > chart creation
and gif export that runs whenever a certain cell's value changes.

Through CFOBJECT I'll see if I can insert data - hence triggering the macro,
exporting the gif. Then free the connection, move the file using cffile (or
set the macro to save the gif in the webroot) and serve the gif using
cfcontent or something similar. 

Just got to get it working now, but the theory is so far sound unless anyone
can spot any glaring holes. ;) 

---
Rich Wild
Senior Web Designer

---
e-mango.com ltd  Tel: 01202 587 400
Lansdowne Place  Fax: 01202 587 401
17 Holdenhurst Road
Bournemouth   Mailto:[EMAIL PROTECTED]
BH8 8EW, UK  http://www.e-mango.com
---
This message may contain information which is legally
privileged and/or confidential.  If you are not the
intended recipient, you are hereby notified that any
unauthorised disclosure, copying, distribution or use
of this information is strictly prohibited. Such
notification notwithstanding, any comments, opinions,
information or conclusions expressed in this message
are those of the originator, not of e-mango.com ltd,
unless otherwise explicitly and independently indicated
by an authorised representative of e-mango.com ltd.
---




> -Original Message-
> From: Rich Wild [mailto:[EMAIL PROTECTED]]
> Sent: 16 November 2000 07:59
> To: CF-Talk
> Subject: export excel charts - COM and CF
> 
> 
> 
> Has anyone tried the following:
> 
> Connecting to an instance of excel thru com, inserting data, 
> running a macro
> on that inserted data which creates a chart based on that 
> data, then exports
> the chart as gif - then tidying up (close com connection, use 
> cffile to move
> gif to webroot and serve).
> 
> I'm not particulary worried about the first bit or the last 
> bit, but the
> firing off the macro and exporting is the bit that I'm 
> seeking help about.
> Nate Weiss had some handy tips about ensuring that the macro 
> security is set
> to the proper level for the NT account that CF runs under, 
> which wasn't
> something I had considered quite frankly...
> Are there any other things I should be aware of? Opinions on 
> the efficiency
> of such a task to serve up a few dynamic gif reports? (I've 
> looked at the
> various graphing tags and none of them are suitable (read 
> limited) , and
> cfx_graphicsserver is too pricey an option)
> 
> Help appreciated.
> 
> :)
> ---
> Rich Wild
> Senior Web Designer
> 
> ---
> e-mango.com ltd  Tel: 01202 587 400
> Lansdowne Place  Fax: 01202 587 401
> 17 Holdenhurst Road
> Bournemouth   Mailto:[EMAIL PROTECTED]
> BH8 8EW, UK  http://www.e-mango.com
> --
> --
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: 
http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with
'unsubscribe' in the body to [EMAIL PROTECTED]

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

More locking

[Tage Widsell]

Hi,

Adding to the recent discussion on locking application and session 
variables.

I just got mail from a friendly Allaire employee that pointed out that a
stability issue I've been having with Advanced Security may very well be
related to the fact that I don't lock the session variables and this may
cause some troubles, especially since my site uses frames and the
simultaneous requests may cause writing and reading of the same variables.

Now, please enlighten me someone who knows more about this (I'm a web dude,
Jim - not a programmer). I never explicitly set any session variables since
Advanced Security is handling this for me. Does that mean that I have to set
the  around the  tag?

Also, I use a bunch of server variables that _never_ changes. I only use
them to keep track of server paths etc that I use in my apps. Do I need to
lock these variables too?

Thankful for help
Tage Widsell
Webmaster
Propellerhead Software


Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

RE: Netscape 6 out UGH!!!!

[DeVoil, Nick]

In case it helps anyone, this is the resource that I used to
make my stuff work in N6 as well as the other two:

http://sites.netscape.net/ekrock/standards.html

It tells you everything you need to know about what N6 *deliberately*
won't handle.

Doesn't help you with the N6 bugs of course.

These 2 are also interesting & readable but I don't think they
add anything to what's in the first one:

http://developer.netscape.com/viewsource/goodman_cross/goodman_cross.htm

http://hotwired.lycos.com/webmonkey/00/04/index1a.html?tw=authoring


And this is the actual W3C DOM spec as specialised for HTML documents:

http://www.w3.org/TR/WD-DOM/level-one-html.html

HTH

Nick


**
Information in this email is confidential and may be privileged. 
It is intended for the addressee only. If you have received it in error,
please notify the sender immediately and delete it from your system. 
You should not otherwise copy it, retransmit it or use or disclose its
contents to anyone. 
Thank you for your co-operation.
**

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

RE: Netscape 6 out UGH!!!! [OT]

[Nick Betts]

Rob, I agree with your comments, but after looking at your company website
(home page and contact us only?) I wonder whether you are putting your
thoughts into actions..  

Nick Betts.

-Original Message-
From: Rob Keniger [mailto:[EMAIL PROTECTED]]
Sent: 16 November 2000 09:52
To: CF-Talk
Subject: Re: Netscape 6 out UGH [OT]


on 11/16/00 8:57 AM, Scott, Andrew at [EMAIL PROTECTED] wrote:

> I would consider Web Design easy, because it actually is. However its when
> you wish to start to do application development that it becomes harder.

I disagree with this statement. GOOD web design is not easy and the way in
which you dismiss HTML design as somehow inferior to application design
smacks of snobbery. It takes a great deal of knowledge about visual design,
technical HTML issues, browser foibles, and usability design. to produce a
good website.

In my experience most programmers are poor web designers and vice versa. It
is a rare find when you come across someone who can do both well.

Sure you can whack out a quick site with Frontpage but it will not be a
*good* site.

There are very many poor web sites out there.

-- 

Rob Keniger

big bang solutions






Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a
message with 'unsubscribe' in the body to
[EMAIL PROTECTED]

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

Re: Netscape 6 out UGH!!!! [OT]

[Rob Keniger]

on 11/16/00 8:39 PM, Nick Betts at [EMAIL PROTECTED] wrote:

> Rob, I agree with your comments, but after looking at your company website
> (home page and contact us only?) I wonder whether you are putting your
> thoughts into actions..

You are, of course, free to assume what you like.

-- 

Rob Keniger

big bang solutions





Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

RE: SQL Server Licesning

[Neil Clark]

yep you can get an unlimited internet connectivity license.  

http://www.mcbdigital.com
--->




Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

RE: MAIL, HELP ME FOR THE LOVE OF GOD

[JustinMacCarthy]

Sorry for the delay in responding:

Anyway look for cfx_mail at allaires site, you can add any headers you want
Another option is iMS from www.coolfusion.com. It's a great product.
If you just want to send mail it's only $70...


Justin


> -Original Message-
> From: Robert Everland [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, November 15, 2000 6:05 PM
> To: CF-Talk
> Subject: MAIL, HELP ME FOR THE LOVE OF GOD
>
>
>   Ok I have been trying all day to find a way to send an email to efax
> with an attachment that will take it. I guesse because of the way cfmail
> encodes the email it doesn't know what type of attachment it has. I have
> been trying to get the Dundas email to work but it uses a
> collection and the
> com  object keeps erroring out in the to field. Anyone out there
> either find
> a workaround to mail efax or know of an easy com object that will just
> encode an attachment? Need it very urgently.
>
> Robert Everland III
> Web Developer
> Dixon Ticonderoga
> --
> --
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
> or send a message with 'unsubscribe' in the body to
> [EMAIL PROTECTED]
>
>


Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

Word mail merge and SQL Server 7

[Aidan Whitehall]

We're trying to do a mail merge in Word using records from a SQL Server 7
database on one network and a PC on a different network.

The network admin doesn't want to install any SQL Server components on the
PC with Word.

The solution we're trying at the moment is triggering a ColdFusion template
to query the database, generate a tab delimited file which then gets
e-mailed to the person doing the mail merge.

I thought if we could set up a DSN using the Microsoft Text Driver on his
PC, he could save the attachment to the same directory every time and get
Word to snag the records from it.

I thought it would be a doddle but I'm really struggling to set up the text
DSN.

Initially, trying to set it up displayed the error "Cannot insert attribute
values (null) into (null)".

Somehow, that stopped and the set-up seemed OK, with the schema.ini file
containing the details of the basic text file in the same directory:

==
CONTACTS.TXT
Contact Company Address1TownOrCity  Postcode
Aidan Whitehall The Net Profits 116 Ledburn SkelmersdaleWN8 6TX
Paul Halliday   NetshopperukInnovation HouseRainfordWA11
8LZ
==
SCHEMA.INI
[Contacts.txt]
ColNameHeader=True
Format=TabDelimited
MaxScanRows=1
CharacterSet=OEM
Col1=Contact Char Width 255
Col2=Company Char Width 255
Col3=Address1 Char Width 255
Col4=TownOrCity Char Width 255
Col5=Postcode Char Width 255
==

But, when you query the data source via ColdFusion, you see this error:

=
ODBC Error Code = S1000 (General error)

[Microsoft][ODBC Text Driver] The Microsoft Jet database engine cannot open
the file '(unknown)'. It is already opened exclusively by another user, or
you need permission to view its data.

Hint: The cause of this error is usually either (1) You have used an
incorrect data source name, or (2) You have changed the location of your
data source either by moving it or renaming one of its parent directories.
After moving a data source make sure you update its attributes using the
ColdFusion Administrator.
=


Does anyone have any ideas on how to solve this? And does anyone know
whether the CharacterSet should be OEM or ANSI?

And if this solution is *completely* the wrong way of doing it, please say
(skinning cats 'n all that).


Thanks muchly.

-- 
Aidan Whitehall <[EMAIL PROTECTED]>
Netshopper UK Ltd
Advanced Web Solutions & Services

http://www.netshopperuk.com/
Telephone +44 (01744) 648650
Fax +44 (01744) 648651

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

How to prevent BACK and FORWARD button from clicked?

[Karenina]

This is a multi-part message in MIME format.

--=_NextPart_000_006B_01C05006.4FC350C0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Dear Friends,
   I have created a critical web based application which is not =
allowed the user to press BACK and FORWARD button in order to prevent =
data integrity.=20

How do we disable the BACK button using CF, instead of using Javascript
history.back() ?

Another way is using session struct to record each template ID.

Can we implement more efficient way to do it?
Thanks in advance.

Regards,

Karenina


--=_NextPart_000_006B_01C05006.4FC350C0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable








Dear Friends,
   I have created =
a critical=20
web based application which is not allowed the user to press BACK and =
FORWARD=20
button in order to prevent data integrity. 
 
How do we disable the BACK button using CF, instead =
of using=20
Javascript
history.back() ?
 
Another way is using session struct to record each =
template=20
ID.
 
Can we implement more efficient way to do =
it?
Thanks in advance.
 
Regards,
 
Karenina
 

--=_NextPart_000_006B_01C05006.4FC350C0--


Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

RE: Allaire Advanced Fusion Developement Class

[Daye, Marianne]

I took it with Productivity Point.  Details are covered on their Web site:
http://www.propoint.com/featuresheets/Aadvcf_ftr.htm

Marianne

-Original Message-
From: Kevin Miller [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, November 15, 2000 5:11 PM
To: CF-Talk
Subject: RE: Allaire Advanced Fusion Developement Class



What are the topics covered?

Thanks,

Kevin

>>> [EMAIL PROTECTED] 11/15/00 10:50AM >>>
I liked it a lot!  I would recommend it to anybody who's comfortable
with
the basics of CF.  The course book has a lot of easy to follow
explanations
of everything, and makes for a good reference.  I left with valuable
knowledge.

Marianne Daye

-Original Message-
From: Willy Ray [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, November 15, 2000 11:27 AM
To: CF-Talk
Subject: OT: Allaire Advanced Fusion Developement Class



I'm trying to get my superiors to send me to the Advanced Developement
class.  Anybody been to this?  How did you like it?



Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ 
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or
send a
message with 'unsubscribe' in the body to
[EMAIL PROTECTED]


Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ 
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or
send a message with 'unsubscribe' in the body to
[EMAIL PROTECTED]


Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a
message with 'unsubscribe' in the body to [EMAIL PROTECTED]

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

RE: Caching CFHTTP results

[Paul Johnston]

How about storing the cfhttp.filecontent variable in a database (which you
can cache the query on) or in a server variable or something?  Then you can
just overwrite it whenever you want and it's always there!

Paul

> -Original Message-
> From: Owens, Howard [mailto:[EMAIL PROTECTED]]
> Sent: 15 November 2000 22:06
> To: CF-Talk
> Subject: Caching CFHTTP results
>
>
>
> I would like to use CFHTTP to pull an HTML page from one server to another
> (we own both servers ... one Unix, the other NT -- I'm pulling from the NT
> to the Unix -- too complicated to explain why.) and have the output cached
> so that we cut down on the number of actual requests passing from the Unix
> server to the NT.  We really need to cut the load to the NT.
>
> As far as I can tell, using  at the top of my 
> page doesn't
> do the trick.
>
> What happens is that if the NT is overloaded with requests, this page
> outputs a "connection failure" error.  I thought if I could cache a good
> clean output then the page would then display the output on the Unix box
> even if the NT isn't responding.  This isn't happening.
>
> Any suggestions?
>
> H.
>
>
>
> =
> Howard Owens
> Web Producer
> InsideVC.com
> mailto:[EMAIL PROTECTED]
> =
>
>
> --
> --
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
> or send a message with 'unsubscribe' in the body to
> [EMAIL PROTECTED]
>



Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

I need a specific tree control for use with CF...

[Jablonski, Adam, MTC-DCLCx]

Hello,  

What I do is trying to show a hierarchical structure of data that I
extract from database. My client want it to be done using a tree control (a
good choice anyway). Then after selecting an item it should be editable in
other frame ...etc, so it's kind of editor. My problem is that using CFTree
is not a proper solution for my needs because the database is quite big and
populating the tree all at once is a nonsense, especially that the editor is
an online tool. What I need is a tree control that behaves like for example
Windows Explorer tree control. I mean that I want only the first level of
objects to be displayed and the children to be loaded on the fly after
clicking the 'plus' sign and so on. Can anybody point me to such a control
or give me any kind of advice, please ?

Thanks in advance for helping me,
Adam

> mmannesmann
> m   TeleCommerce
* Daniel-Goldbach-Straße 17-19 - 40880 Ratingen
> * +49 21 02 97 8512
* mailto:[EMAIL PROTECTED]
* http://www.mannesmann-telecommerce.de


Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebarRsts or send a message with 
'unsubscribe' in the body to [EMAIL PROTECTED]

Re: newbie question, checkboxes

[Tammy Schilling]

Many and vast thanks to everyone who replied to my question about the checkboxes.  
It's incredible how long one can beat their head against a wall at what
would seem like the obvious (I guess it keeps me humble, bleck).

Thanks,

Tammy Schilling



> On 11/13/00, Tammy Schilling penned:
> >I'm relatively new to CF.  I'm trying to design an interface for a local
> >non-profit that holds monthly meetings to track attendance at those
> >meetings.  I have an Access db with a table called Attendance.  This
> >tables columns are the ID for each member and one for each month,
> >Jan-Dec.  They keep a "rolling calendar", so year is not a factor in the
> >attendance tracking.  They just want each month's attendance to write
> >over the attendance in that month from the year before.
> >
> >The ID column is a number column and each of the month columns are
> >yes/no.  I have an interface which pulls the names of members who've
> >attended in the last 12 months (in order to minimize the number
> >displayed and make it more useable) along with a check box to be checked
> >if the person was at that month's meeting, but I can't seem to get the
> >form to work.  I know it's probably something simple, but I've been
> >banging my head against it for too many hours now and can't think
> >anymore.  Some help would be appreciated, please.
> >

--
personal copy designs
better living through computer graphics
http://www.personal-copy.com
410 219 5300



Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

RE: Netscape 6 out UGH!!!!

[Robert Everland]

That should be products not shopping. Sorry brain fart, oh and by the way I
did not design this an outside firm did, I definitely would have coded it
different but that's what we have now and it works.

Robert Everland III
Web Developer
Dixon Ticonderoga


-Original Message-
From: Robert Everland III [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, November 15, 2000 8:07 PM
To: CF-Talk
Subject: RE: Netscape 6 out UGH


Go to www.dixonusa.com then click no flash then click shopping. That little
application works perfect in IE 4-5 and Netscape 4.7 not 6


Bob

-Original Message-
From: Gavin Myers [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, November 15, 2000 3:31 PM
To: CF-Talk
Subject: RE: Netscape 6 out UGH


I just downloaded N6 and didn't really see anything wrong with it so far. It
has better support for CSS (a: hover works finally).

But as of yet (last 30 minutes) i haven't seen any mission critical things
with it yet.

Does anyone have any specific examples of things that don't work like they
used to? Like when using js what doesn't work, or websites that used to work
in other browsers that don't in n6?

thanks,
Gavin




Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a
message with 'unsubscribe' in the body to [EMAIL PROTECTED]



Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a
message with 'unsubscribe' in the body to [EMAIL PROTECTED]

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

RE: export excel charts - COM and CF (vs MSChart?)

[mark_wimer]

Rich,

I'm interested in seeing the macro, especially the gif export part. I am
also wondering if people are using the MSChart object for this task,
without Excel. Wouldn't this be less overhead than opening excel? Or does
that not factor in if excel is already running on the server?

Mark

Mark Wimer
American Bird Conservancy, c/o
USGS-Patuxent Wildlife Research Center
12100 Beech Forest Road, Laurel, MD  20708-4038
Ph: 301-497-5596   Email: [EMAIL PROTECTED]



Aha.

If anyone is interested, I wrote a macro to handle the data > chart
creation
and gif export that runs whenever a certain cell's value changes.

Through CFOBJECT I'll see if I can insert data - hence triggering the
macro,
exporting the gif. Then free the connection, move the file using cffile (or
set the macro to save the gif in the webroot) and serve the gif using
cfcontent or something similar.

Just got to get it working now, but the theory is so far sound unless
anyone
can spot any glaring holes. ;)

---
Rich Wild
Senior Web Designer

---
e-mango.com ltd  Tel: 01202 587 400
Lansdowne Place  Fax: 01202 587 401
17 Holdenhurst Road
Bournemouth   Mailto:[EMAIL PROTECTED]
BH8 8EW, UK  http://www.e-mango.com
---
This message may contain information which is legally
privileged and/or confidential.  If you are not the
intended recipient, you are hereby notified that any
unauthorised disclosure, copying, distribution or use
of this information is strictly prohibited. Such
notification notwithstanding, any comments, opinions,
information or conclusions expressed in this message
are those of the originator, not of e-mango.com ltd,
unless otherwise explicitly and independently indicated
by an authorised representative of e-mango.com ltd.
---




> -Original Message-
> From: Rich Wild [mailto:[EMAIL PROTECTED]]
> Sent: 16 November 2000 07:59
> To: CF-Talk
> Subject: export excel charts - COM and CF
>
>
>
> Has anyone tried the following:
>
> Connecting to an instance of excel thru com, inserting data,
> running a macro
> on that inserted data which creates a chart based on that
> data, then exports
> the chart as gif - then tidying up (close com connection, use
> cffile to move
> gif to webroot and serve).
>
> I'm not particulary worried about the first bit or the last
> bit, but the
> firing off the macro and exporting is the bit that I'm
> seeking help about.
> Nate Weiss had some handy tips about ensuring that the macro
> security is set
> to the proper level for the NT account that CF runs under,
> which wasn't
> something I had considered quite frankly...
> Are there any other things I should be aware of? Opinions on
> the efficiency
> of such a task to serve up a few dynamic gif reports? (I've
> looked at the
> various graphing tags and none of them are suitable (read
> limited) , and
> cfx_graphicsserver is too pricey an option)
>
> Help appreciated.
>
> :)
> ---
> Rich Wild
> Senior Web Designer
>
> ---
> e-mango.com ltd  Tel: 01202 587 400
> Lansdowne Place  Fax: 01202 587 401
> 17 Holdenhurst Road
> Bournemouth   Mailto:[EMAIL PROTECTED]
> BH8 8EW, UK  http://www.e-mango.com
> --
> --
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe:
http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with
'unsubscribe' in the body to [EMAIL PROTECTED]


Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a
message with 'unsubscribe' in the body to
[EMAIL PROTECTED]





Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

Re: newbie question, checkboxes

[Kevin Schmidt]

That's why my cube has rubber walls
- Original Message -
From: "Tammy Schilling" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, November 16, 2000 7:46 AM
Subject: Re: newbie question, checkboxes


> Many and vast thanks to everyone who replied to my question about the
checkboxes.  It's incredible how long one can beat their head against a wall
at what
> would seem like the obvious (I guess it keeps me humble, bleck).
>
> Thanks,
>
> Tammy Schilling
>
>
>
> > On 11/13/00, Tammy Schilling penned:
> > >I'm relatively new to CF.  I'm trying to design an interface for a
local
> > >non-profit that holds monthly meetings to track attendance at those
> > >meetings.  I have an Access db with a table called Attendance.  This
> > >tables columns are the ID for each member and one for each month,
> > >Jan-Dec.  They keep a "rolling calendar", so year is not a factor in
the
> > >attendance tracking.  They just want each month's attendance to write
> > >over the attendance in that month from the year before.
> > >
> > >The ID column is a number column and each of the month columns are
> > >yes/no.  I have an interface which pulls the names of members who've
> > >attended in the last 12 months (in order to minimize the number
> > >displayed and make it more useable) along with a check box to be
checked
> > >if the person was at that month's meeting, but I can't seem to get the
> > >form to work.  I know it's probably something simple, but I've been
> > >banging my head against it for too many hours now and can't think
> > >anymore.  Some help would be appreciated, please.
> > >
>
> --
> personal copy designs
> better living through computer graphics
> http://www.personal-copy.com
> 410 219 5300
>
>
> --
--
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send
a message with 'unsubscribe' in the body to
[EMAIL PROTECTED]
>



Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

RE: Netscape 6 out UGH!!!!

[Benjamin S. Rogers]

> In case it helps anyone, this is the resource that I used to
> make my stuff work in N6 as well as the other two:

Thanks.

Benjamin S. Rogers
Web Developer, c4.net
voice: (508) 240-0051
fax: (508) 240-0057

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

Dynamic image display question?

[Richard L Smith]

Hello:

I am using CF4.0 with an Access 97 db to display an image the field containd
the path to the image it's
images/a100101.gif  this is then passed to an  tag when
I run it, all I get is an
empty image container but know error messages.

Any ideas

Thanks

Rick




Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

RE: execute a batch file

[Simon Horwith]

Take a look at:
http://forums.allaire.com/DevConf/Thread.cfm?&&Message_ID=34145&_#Message331
98
Courtesy of Bob Segal.

~Simon

> Simon Horwith
> Certified ColdFusion Developer
> Fig Leaf Software
> 1400 16th St NW, # 220
> Washington DC 20036
> 202.797.6570 (direct line)
> www.figleaf.com
> 


-Original Message-
From: Brad Squires [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, November 15, 2000 8:06 PM
To: CF-Talk
Subject: RE: execute a batch file


Is there a way to authenticate an NT user through this method?

We are trying to execute script that modifes multiple servers, but we are
running into the fact that the admin is not logged on to each box...



-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 25, 2000 3:52 PM
To: CF-Talk
Cc: '[EMAIL PROTECTED]'
Subject: RE: execute a batch file


> Can I execute a batch file and send it parameters through cold
> fusion?

Yes. In CF 4.5.x, you can use the CFEXECUTE tag. Here's an example, which
will add a user to the local NT account database:




If you're using an older version of CF, you'll need to install a CFX tag to
run command-line programs. You can get one from Lewis Sellers' site
(http://www.intrafoundation.com/).

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444


Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a
message with 'unsubscribe' in the body to [EMAIL PROTECTED]



Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a
message with 'unsubscribe' in the body to [EMAIL PROTECTED]

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

RE: Dynamic image display question?

[Gavin Myers]

right click the empty container and see what the path is set to, is it
correct?

-Original Message-
From: Richard L Smith [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 16, 2000 8:30 AM
To: CF-Talk
Subject: Dynamic image display question?


Hello:

I am using CF4.0 with an Access 97 db to display an image the field containd
the path to the image it's
images/a100101.gif  this is then passed to an  tag when
I run it, all I get is an
empty image container but know error messages.

Any ideas

Thanks

Rick





Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a
message with 'unsubscribe' in the body to [EMAIL PROTECTED]

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

Re: Dynamic image display question?

[Kevin Schmidt]

Did you view the source to make sure the  came out like
you wanted it.  Also is your path right.  Is the images folder in the same
folder as the cfm that the image is displaying dynamically in.

Kevin Schmidt
Allaire Certified Cold Fusion Developer
Internet Services Manager
PWB, Inc. Integrated Marketing and Communications
Office: 734.995.5000
Mobile: 734.649.4843

- Original Message -
From: "Richard L Smith" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, November 16, 2000 8:29 AM
Subject: Dynamic image display question?


> Hello:
>
> I am using CF4.0 with an Access 97 db to display an image the field
containd
> the path to the image it's
> images/a100101.gif  this is then passed to an  tag
when
> I run it, all I get is an
> empty image container but know error messages.
>
> Any ideas
>
> Thanks
>
> Rick
>
>
>
> --
--
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send
a message with 'unsubscribe' in the body to
[EMAIL PROTECTED]
>



Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

RE: Certification Exam

[Tristram Charnley]

Have a look at the Brainbench CF exam. - http://www.brainbench.com 
The questions cover most advanced CF topics with the odd no-brainer
thrown in. I can't remember the pass mark but I passed easily after 
about 9 months CF experience. Because its unsupervised you can use 
reference material(like the real world) but your completion time 
is factored in.

I'd say its a good dress rehearsal for the CF exam - and its free!!!

Tristram Charnley
_
e-mail:  [EMAIL PROTECTED]




> -Original Message-
> From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]]
> Sent: 15 November 2000 20:20
> To: CF-Talk
> Subject: RE: Certification Exam
> 
> 
> > The test is easy enough, especially considering you only 
> need 60%.  Many
> of
> > the questions are ambiguous so if you are not sure you can 
> get a decent
> > amount wrong.
> 
> Hopefully they'll change the questions soon.
> 
> One thing to note is that they have a large bank of questions, so you
> shouldn't get the same exam if you sit it twice (some people 
> were at the
> Conference)
> 
> > If you've been coding for about a year or two and are
> > familiar with the majority of CF tags you'll be fine.
> 
> As an ammendment to Andrew's comment - be familiar with the 
> majority of the
> CF4.5 tags, knowing CF4 will get you by, but they do ask some 
> CF4.5 specific
> questions
> 
> > Look over the tags
> > and functions, as well as error processing and how cf 
> handles copying from
> > one variable to another (remember cf is pass-by-reference).
> 
> Also brush up on how CFScript works - it's fairly important... oh, and
> knowing HTML, JavaScript and how a website basically works is 
> a damn good
> idea 
> 
> > Brush up on your queries
> 
> A decent, but not amazing, knowledge of SQL is (pseudo) 
> required, so knowing
> only "SELECT * FROM TABLE" won't cut it...
> 
> > and last but not least... get a good night's sleep.
> 
> Erm, I took it on 3 hours sleep over 40 hours... running on 
> coffee, but
> having sleep is a DAMN good idea 
> 
> Overall, know as much about CF as you can - pretty bleeding 
> obvious, but
> there were some people at the Conf who took it after using CF 
> for only a
> couple of months (from those I chatted to and what I heard), 
> which is a very
> bad idea - you can't just know the manuals parrot fashion - 
> you MUST know
> the material!
> 
> BTW, 60% isn't a difficult target to hit, it was annoying 
> when a question
> has multiple answers but the system only allows one!
> 
> Philip Arnold
> Director
> Certified ColdFusion Developer
> ASP Multimedia Limited
> T: +44 (0)20 8680 1133
> 
> "Websites for the real world"
> 
> **
> This email and any files transmitted with it are confidential and
> intended solely for the use of the individual or entity to whom they
> are addressed. If you have received this email in error please notify
> the system manager.
> **
> 
> 
> --
> --
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: 
> http://www.houseoffusion.com/index.cfm?sidebar=lists or send 
> a message with 'unsubscribe' in the body to 
> [EMAIL PROTECTED]
> 

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

RE: Dynamic image display question?

[Eric J Hoffman]

When I get something like that in the page, I right click on the container
and review the full path of the image.  Is it correct as a standard url to
the image?  Or do you need to remember a / or the like?  Generally my urls
to images (as I do the dynamic display as well) is
http://www.purplepride.org/#queryname.imagepath#">

Eric J Hoffman, MAIP
Director of Internet Development
Small Dog Design

-Original Message-
From: Richard L Smith [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 16, 2000 8:30 AM
To: CF-Talk
Subject: Dynamic image display question?


Hello:

I am using CF4.0 with an Access 97 db to display an image the field containd
the path to the image it's
images/a100101.gif  this is then passed to an  tag when
I run it, all I get is an
empty image container but know error messages.

Any ideas

Thanks

Rick





Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a
message with 'unsubscribe' in the body to [EMAIL PROTECTED]


Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

RE: Netscape 6 out UGH!!!! - i cant get to load, anyone else?

[Mike Amburn]

i've tried four installations and still i can't netscape 6 to load. it
installs fine. but when i launch it, it displays the the splash screen
that says "Netscape 6", the java console loads in my system tray, and
that's all that happens. the process continues to run (using no CPU)
until i end it with Task Manager.

has anyone else had this problem? i'm very eager to see how complient
our software is with Netscape 6, but it helps it would help if i could
actually get Netscape 6 to run on my machine.

(FYI, me = Windows 2000)

-mike

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebarRsts or send a message with 
'unsubscribe' in the body to [EMAIL PROTECTED]

ODBC Driver Problem

[Gary Ashbaugh]

This is a multi-part message in MIME format.

--=_NextPart_000_0007_01C04FAD.11E6D190
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

We are having trouble with a ColdFusion application running on a laptop. =
This laptop has Microsoft NT, ColdFusion 4.0, Microsoft Personal Web =
Server, Access 97, MDAC 2.1 which shows the Access Driver as =
4.00.4403.02

This very same application is working fine on our server running =
Microsoft NT, Microsoft IIS, ColdFusion 4.0, Access 2000, which shows =
the Access Driver as version 4.00.4202.00

The error message is an ODBC error and says too few of parameters. Since =
the programs and the database files on the laptop are the same ones as =
what is on the server I am lost as to what is causing the problem unless =
it is the ODBC driver itself.

Has anybody else had trouble with this version of the ODBC driver? If =
so, what is the work-around?

Thank you ahead of time,



Gary :-)


--=_NextPart_000_0007_01C04FAD.11E6D190
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable










We are having trouble with a ColdFusion application running on a =
laptop. This=20
laptop has Microsoft NT, ColdFusion 4.0, Microsoft Personal Web Server, =
Access=20
97, MDAC 2.1 which shows the Access Driver as 4.00.4403.02
This very same application is working fine on our server running =
Microsoft=20
NT, Microsoft IIS, ColdFusion 4.0, Access 2000, which shows the Access =
Driver as=20
version 4.00.4202.00
The error message is an ODBC error and says too few of parameters. =
Since the=20
programs and the database files on the laptop are the same ones as what =
is on=20
the server I am lost as to what is causing the problem unless it is the =
ODBC=20
driver itself.
Has anybody else had trouble with this version of the ODBC driver? If =
so,=20
what is the work-around?
Thank you ahead of time,
 
Gary :-)

--=_NextPart_000_0007_01C04FAD.11E6D190--



Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

RE: Nested Structures and Arrays

[Christopher Olive, CIO]

you haven't declared Session.Intake.Parent as anything yet.

chris olive, cio
cresco technologies
[EMAIL PROTECTED]
http://www.crescotech.com



-Original Message-
From: Eric Gilbert [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, November 15, 2000 9:01 PM
To: CF-Talk
Subject: Nested Structures and Arrays


I'm encountering something odd, and I'm not sure if it is a bug with the
version of CFServer I'm using or a deeper CF language issue.

I get the error:
"The member "EMPLOYER.ADDRESS" in dimension 1 of object
"Session.Intake.Parent" cannot be found. Please, modify the member name"

when I try to execute the following script block (with proper locking..)


Session.Intake = structnew();
Session.Intake.URLToken = URLToken;
Session.Intake.Guardian = arrayNew(1);
Session.Intake.Guardian[1] = structnew();
Session.Intake.Guardian[1].Employer = structnew();
Session.Intake.Guardian[1].Employer.Name = "";
Session.Intake.Guardian[1].Employer.Address = structnew();

//Works great till here
Session.Intake.Parent[1].Employer.Address.StreetAddress = "";



I'm running PWS on Win98 with a developer's edition of CFServer.

Server Product ColdFusion Server
 Version 4, 0, 0, 0




Eric Gilbert
Developer
Stone Ground Solutions
560 Sutter St., Suite 400
San Francisco, CA 94102
415.252.0600 voice
415.252.0123 fax
www.stoneground.com



Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a
message with 'unsubscribe' in the body to [EMAIL PROTECTED]


Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

RE: CF-Talk V1 #124

[Guy J. McDowell]

Rich,

I could sure use a macro like that. Hope it works for you.

Yours In Conservation,

Guy J. McDowell,
Webmaster
The Ontario Federation of Anglers & Hunters
E-mail: [EMAIL PROTECTED]
Phone: (705) 748-6324 ext. 262

P.S. You may want to check out the fresh new look of www.OFAH.org
Launched 1st November 2000.
Don't forget our other great sites:
www.AuctionForWildlife.com - Your chance to make your bid for
conservation.
www.EcoEd.org - an online adventure for kids in grades 1 through 8.
www.HuntingDog.org - Celebrating our Hunting Dog Heritage.
www.AHTV.com - Your online companion to the Angler and Hunter
Television show.
www.OHEP.net -  Where to find out and learn about the Ontario Hunter
Education Program.




Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

Re: Dreamweaver Ultradev 4 - any good?

[Greg Wolfinger]

Dreamweaver is great for our graphic design department that doesn't
ColdFusion and (even though they say they do) HTML too.  For me, a web
developer I find that it slows me down.  They did improve the who table
support quite a bit however. But ooops I signed an NDA at the conference
last week.  S.

Greg
- Original Message -
From: Tom Muck <[EMAIL PROTECTED]>
To: CF-Talk <[EMAIL PROTECTED]>
Sent: Wednesday, November 15, 2000 2:29 PM
Subject: Re: Dreamweaver Ultradev 4 - any good?


> UD4 is awesome.  The Server Behavior builder will let you fill in your own
> code snippets with your own parameters so the next time you want to insert
> the code, a custom dialogue box will pop up and let you fill in all the
> parameters.  It also does generation of some basic code so that you can
get
> basic database-driven pages up there quickly.  UD1 was a little limiting
for
> CF, but UD4 is great.
>
> tom
>
> - Original Message -
> From: "Shawn Regan" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Wednesday, November 15, 2000 11:38 AM
> Subject: RE: Dreamweaver Ultradev 4 - any good?
>
>
> > This message is in MIME format. Since your mail reader does not
understand
> > this format, some or all of this message may not be legible.
> >
> > --_=_NextPart_001_01C04F22.71BFB9D0
> > Content-Type: text/plain;
> > charset="iso-8859-1"
> >
> > I think it looks better then 3, they have added to some code editing
> > features and SQL and more read  or take the product tour on it.
> >
> > Shawn Regan
> > [EMAIL PROTECTED]
> > Cold Fusion Developer
> > Pacific Technology Solutions
> >
>
>
> --
--
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send
a message with 'unsubscribe' in the body to
[EMAIL PROTECTED]
>


Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

RE: export excel charts - COM and CF (vs MSChart?)

[Rich Wild]

Mark,

I've posted the code here:

http://www.cfcomet.com/cfcomet/forum/ViewThread.cfm?ThreadID=12000E3E-9979-4
0B3-BABA4F2429E67135

hmmm - MSChart... to be honest and expose my utter lack of knowledge - I
didn't know you could - I can't seem to find an example of anyone doing it
through CFobject, but there's an asp version (which you could translate) at:


http://www.4guysfromrolla.com/webtech/MSChartExample.shtml

By the way, has anyone used Cold Fusion Graphlets (
http://forums.allaire.com/cfo/graphlets.htm )?? or are they the
icky-spare-5-minutes java applets that they look like? (examples weren't
working)

---
Rich Wild
Senior Web Designer

---
e-mango.com ltd  Tel: 01202 587 400
Lansdowne Place  Fax: 01202 587 401
17 Holdenhurst Road
Bournemouth   Mailto:[EMAIL PROTECTED]
BH8 8EW, UK  http://www.e-mango.com
---
This message may contain information which is legally
privileged and/or confidential.  If you are not the
intended recipient, you are hereby notified that any
unauthorised disclosure, copying, distribution or use
of this information is strictly prohibited. Such
notification notwithstanding, any comments, opinions,
information or conclusions expressed in this message
are those of the originator, not of e-mango.com ltd,
unless otherwise explicitly and independently indicated
by an authorised representative of e-mango.com ltd.
---




> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: 16 November 2000 14:16
> To: CF-Talk
> Subject: RE: export excel charts - COM and CF (vs MSChart?)
> 
> 
> 
> Rich,
> 
> I'm interested in seeing the macro, especially the gif export 
> part. I am
> also wondering if people are using the MSChart object for this task,
> without Excel. Wouldn't this be less overhead than opening 
> excel? Or does
> that not factor in if excel is already running on the server?
> 
> Mark
> 
> Mark Wimer
> American Bird Conservancy, c/o
> USGS-Patuxent Wildlife Research Center
> 12100 Beech Forest Road, Laurel, MD  20708-4038
> Ph: 301-497-5596   Email: [EMAIL PROTECTED]
> 
> 
> 
> Aha.
> 
> If anyone is interested, I wrote a macro to handle the data > chart
> creation
> and gif export that runs whenever a certain cell's value changes.
> 
> Through CFOBJECT I'll see if I can insert data - hence triggering the
> macro,
> exporting the gif. Then free the connection, move the file 
> using cffile (or
> set the macro to save the gif in the webroot) and serve the gif using
> cfcontent or something similar.
> 
> Just got to get it working now, but the theory is so far sound unless
> anyone
> can spot any glaring holes. ;)
> 
> ---
> Rich Wild
> Senior Web Designer
> 
> ---
> e-mango.com ltd  Tel: 01202 587 400
> Lansdowne Place  Fax: 01202 587 401
> 17 Holdenhurst Road
> Bournemouth   Mailto:[EMAIL PROTECTED]
> BH8 8EW, UK  http://www.e-mango.com
> ---
> This message may contain information which is legally
> privileged and/or confidential.  If you are not the
> intended recipient, you are hereby notified that any
> unauthorised disclosure, copying, distribution or use
> of this information is strictly prohibited. Such
> notification notwithstanding, any comments, opinions,
> information or conclusions expressed in this message
> are those of the originator, not of e-mango.com ltd,
> unless otherwise explicitly and independently indicated
> by an authorised representative of e-mango.com ltd.
> ---
> 
> 
> 
> 
> > -Original Message-
> > From: Rich Wild [mailto:[EMAIL PROTECTED]]
> > Sent: 16 November 2000 07:59
> > To: CF-Talk
> > Subject: export excel charts - COM and CF
> >
> >
> >
> > Has anyone tried the following:
> >
> > Connecting to an instance of excel thru com, inserting data,
> > running a macro
> > on that inserted data which creates a chart based on that
> > data, then exports
> > the chart as gif - then tidying up (close com connection, use
> > cffile to move
> > gif to webroot and serve).
> >
> > I'm not particulary worried about the first bit or the last
> > bit, but the
> > firing off the macro and exporting is the bit that I'm
> > seeking help about.
> > Nate Weiss had some handy tips about ensuring that the macro
> > security is set
> > to the proper level for the NT account that CF runs under,
> > which wasn't
> > something I had considered quite frankly...
> > Are there any other things I should be aware of? Opinions on
> > the efficiency
> > of such a task to serve up

Re: need help w/ session management

[Greg Wolfinger]

cfvault.com put out a nice article on this last month i believe.

Greg
- Original Message -
From: Jesse <[EMAIL PROTECTED]>
Newsgroups: cf-talk
To: CF-Talk <[EMAIL PROTECTED]>
Sent: Wednesday, November 15, 2000 3:09 PM
Subject: need help w/ session management


> I'm basically just trying to create an application that requires login.
> depending on what id is used to log in with will depend on what pages that
> person can view and what fields in a shared database they will have access
> to view and or update. I'm still a newbie and use 3 different coldfusion
> books as a reference but still can't figure out how to set this up
> correctly. Does anyone know of any good web based tutorials on this
matter.
>
> thanks
>
>
> --
--
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send
a message with 'unsubscribe' in the body to
[EMAIL PROTECTED]
>


Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

fusebox problem

[sebastian palmigiani]

I understand that each directory is to have its own index.cfm page which
acts as a switchboard for that directory.

What I don't understand is how to access them from the main home page and
have the main home page display the different actions from each sub
directory.

Example of what I have.

--

home page: index.cfm


Member Update











How do I get the different actions of MemberUpdate/index.cfm to display in
the main home page?

Sebastian



Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

RE: Certification Exam

[Mark W. Breneman]

Don't take it too lightly.  I took it three times and failed.  I always
thought of my self as a good (better than average) cf programmer.  Only
missed it by one question the last time.

I will not complain until after I pass it.  But, I knew that the result was
not going to be pretty when I guessed on five or six CFSCRIPT questions.  I
have never used cfscript before.

Note: The 61 test questions are pulled from about 100 to 150 questions
(guessing).

Study:
CFscript
Array (pay attention to the names of the array tags)
Anything related to Structures. (and looping over them)
Application tag
SQL insert and wildcard selects

http://www.cfcertification.com

Hope this helps
Mark W. Breneman
-Cold Fusion Developer
-Network Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770

-Original Message-
From: Leong Yew [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, November 15, 2000 6:14 PM
To: CF-Talk
Subject: Re: Certification Exam


Hi,

I'm pretty new to this thread. Not knowing what's transpired, I'm just
wondering if anyone who's taken the certification exam could comment on the
following:

1. What sort of familiarity are you expected to have with each CF tag and
function? Are you supposed to know every attribute that you can use with
each tag?

2. Can anyone recommed any exam preparation material or books? I found it
really disappointing that compared to the more established exams (eg
Microsoft's or Novell's) there aren't a lot of published materials or sample
exams (not questions) you can refer to.

3. When you're taking the exam, can you return to previous questions or must
you answer each question there and then? (I guess I'd have to admit that I'm
not sure if its computerized or paper-based).

Leong

- Original Message -
From: "Philip Arnold - ASP" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, November 16, 2000 6:49 AM
Subject: RE: Certification Exam


> > The test is easy enough, especially considering you only need 60%.  Many
> of
> > the questions are ambiguous so if you are not sure you can get a decent
> > amount wrong.
>
> Hopefully they'll change the questions soon.
>
> One thing to note is that they have a large bank of questions, so you
> shouldn't get the same exam if you sit it twice (some people were at the
> Conference)
>
> > If you've been coding for about a year or two and are
> > familiar with the majority of CF tags you'll be fine.
>
> As an ammendment to Andrew's comment - be familiar with the majority of
the
> CF4.5 tags, knowing CF4 will get you by, but they do ask some CF4.5
specific
> questions
>
> > Look over the tags
> > and functions, as well as error processing and how cf handles copying
from
> > one variable to another (remember cf is pass-by-reference).
>
> Also brush up on how CFScript works - it's fairly important... oh, and
> knowing HTML, JavaScript and how a website basically works is a damn good
> idea 
>
> > Brush up on your queries
>
> A decent, but not amazing, knowledge of SQL is (pseudo) required, so
knowing
> only "SELECT * FROM TABLE" won't cut it...
>
> > and last but not least... get a good night's sleep.
>
> Erm, I took it on 3 hours sleep over 40 hours... running on coffee, but
> having sleep is a DAMN good idea 
>
> Overall, know as much about CF as you can - pretty bleeding obvious, but
> there were some people at the Conf who took it after using CF for only a
> couple of months (from those I chatted to and what I heard), which is a
very
> bad idea - you can't just know the manuals parrot fashion - you MUST know
> the material!
>
> BTW, 60% isn't a difficult target to hit, it was annoying when a question
> has multiple answers but the system only allows one!
>
> Philip Arnold
> Director
> Certified ColdFusion Developer
> ASP Multimedia Limited
> T: +44 (0)20 8680 1133
>
> "Websites for the real world"
>
> **
> This email and any files transmitted with it are confidential and
> intended solely for the use of the individual or entity to whom they
> are addressed. If you have received this email in error please notify
> the system manager.
> **
>
>
> --
--
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send
a message with 'unsubscribe' in the body to
[EMAIL PROTECTED]



Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a
message with 'unsubscribe' in the body to [EMAIL PROTECTED]


Archives: http://www.mail-ar

CF Studio & Server 5.0 Costs? :: Budget :: Next Year

[Paul Ihrig]

hello all!
i need to make up next fiscal years budget, before i leave for thanks
giving.
i cant find costs for CF Studio & Server Ent 5.0

i need to get this into our budget before tomorrow.

if any one can contact me i would appreciate it!

thanks

-paul

Web Developer, NBBJ
Work:   [EMAIL PROTECTED]
614 241-3534

Home:   [EMAIL PROTECTED]
614 449-1681

[EMAIL PROTECTED]
icq:47658358


Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

RE: How To Determine Logged In Users

[Shawn Regan]

This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.

--_=_NextPart_001_01C04FE4.F1C0BA90
Content-Type: text/plain;
charset="iso-8859-1"

You could always insert the user info into a table when then login.

Shawn Regan
[EMAIL PROTECTED]
Cold Fusion Developer
Pacific Technology Solutions


-Original Message-
From: AustralianAccommodation.com Pty. Ltd.
[mailto:[EMAIL PROTECTED]]
Sent: Wednesday, November 15, 2000 12:51 PM
To: CF-Talk
Subject: How To Determine Logged In Users


Just wondering how I can go about coding so I can determine the names of
those members who are currently logged into my website. At the moment I can
determine the number of persons logged in and their ip addresses however I
am wanting  to try and take it to the next step so that I can see who
exactly is logged in 


Kind Regards

Claude Raiola (Director)
AustralianAccommodation.com Pty. Ltd.
Email: [EMAIL PROTECTED]
Developers Of:
  Website: www.AustralianAccommodation.com
  Website: www.AccommodationNewZealand.com




Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a
message with 'unsubscribe' in the body to [EMAIL PROTECTED]

--_=_NextPart_001_01C04FE4.F1C0BA90
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable






RE: How To Determine Logged In Users



You could always insert the user info into a table =
when then login.


Shawn Regan
[EMAIL PROTECTED]
Cold Fusion Developer
Pacific Technology Solutions



-Original Message-
From: AustralianAccommodation.com Pty. Ltd.
[mailto:[EMAIL PROTECTED]">mailto:director@Aus=
tralianAccommodation.com]
Sent: Wednesday, November 15, 2000 12:51 PM
To: CF-Talk
Subject: How To Determine Logged In Users



Just wondering how I can go about coding so I can =
determine the names of those members who are currently logged into my =
website. At the moment I can determine the number of persons logged in =
and their ip addresses however I am wanting  to try and take it to =
the next step so that I can see who exactly is logged in 


Kind Regards


Claude Raiola (Director)
AustralianAccommodation.com Pty. Ltd.
Email: [EMAIL PROTECTED]
Developers Of:
  =
Website: www.AustralianAccommodation.com
  =
Website: www.AccommodationNewZealand.com



---=
-
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/" =
TARGET=3D"_blank">http://www.mail-archive.com/cf-talk@houseoffusion.com/=

Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=3Dlists" =
TARGET=3D"_blank">http://www.houseoffusion.com/index.cfm?sidebar=3Dlists=
 or send a message with 'unsubscribe' in the body to =
[EMAIL PROTECTED]



--_=_NextPart_001_01C04FE4.F1C0BA90--

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

RE: [cd-rom based applications]

[Shawn Regan]

This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.

--_=_NextPart_001_01C04FE5.4035C310
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

No this has to run on the cd no install of any kind.

Shawn Regan
[EMAIL PROTECTED]
Cold Fusion Developer
Pacific Technology Solutions


-Original Message-
From: Alex [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, November 15, 2000 6:46 PM
To: CF-Talk
Subject: Re: [cd-rom based applications]


does the client have cf installed?

Shawn Regan <[EMAIL PROTECTED]> wrote:
This message is in MIME format. Since your mail reader does not =
understand
this format, some or all of this message may not be legible.

--_=3D_NextPart_001_01C04F54.76265940
Content-Type: text/plain;
charset=3D"iso-8859-1"

has anyone done a cd-rom application for any client that had to have
searching functions? If so how did you go about doing it?

Shawn Regan
[EMAIL PROTECTED]
Cold Fusion Developer
Pacific Technology Solutions

=09

--_=3D_NextPart_001_01C04F54.76265940
Content-Type: text/html;
charset=3D"iso-8859-1"
Content-Transfer-Encoding: quoted-printable






cd-rom based applications



has anyone done a cd-rom application for any client =
=3D
that had to have searching functions? If so how did you go about doing =
=3D
it?

Shawn Regan
[EMAIL PROTECTED]
Cold Fusion Developer
Pacific Technology Solutions


=A0=A0=A0=A0=A0=A0=A0=3D20




--_=3D_NextPart_001_01C04F54.76265940--
=


Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=3Dlists or =
send a
message with 'unsubscribe' in the body to =
[EMAIL PROTECTED]



Get free email and a permanent address at =
http://www.netaddress.com/?N=3D1
=


Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=3Dlists or =
send a
message with 'unsubscribe' in the body to =
[EMAIL PROTECTED]

--_=_NextPart_001_01C04FE5.4035C310
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable






RE: [cd-rom based applications]



No this has to run on the cd no install of any =
kind.


Shawn Regan
[EMAIL PROTECTED]
Cold Fusion Developer
Pacific Technology Solutions



-Original Message-
From: Alex [mailto:[EMAIL PROTECTED]">mailto:[EMAIL PROTECTED]]
Sent: Wednesday, November 15, 2000 6:46 PM
To: CF-Talk
Subject: Re: [cd-rom based applications]



does the client have cf installed?


Shawn Regan <[EMAIL PROTECTED]> wrote:
This message is in MIME format. Since your mail =
reader does not understand
this format, some or all of this message may not be =
legible.


--_=3D_NextPart_001_01C04F54.76265940
Content-Type: text/plain;
    charset=3D"iso-8859-1"


has anyone done a cd-rom application for any client =
that had to have
searching functions? If so how did you go about =
doing it?


Shawn Regan
[EMAIL PROTECTED]
Cold Fusion Developer
Pacific Technology Solutions


   =20


--_=3D_NextPart_001_01C04F54.76265940
Content-Type: text/html;
    charset=3D"iso-8859-1"
Content-Transfer-Encoding: quoted-printable












has anyone done a =
cd-rom application for any client =3D
that had to have searching functions? If so how did =
you go about doing =3D
it?


Shawn =
Regan

[EMAIL PROTECTED]

Cold Fusion =
Developer

Pacific Technology =
Solutions



=A0=A0=A0=A0=A0=A0=A0=3D20





--_=3D_NextPart_001_01C04F54.76265940--
---=
-
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/" =
TARGET=3D"_blank">http://www.mail-archive.com/cf-talk@houseoffusion.com/=

Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=3Dlists" =
TARGET=3D"_blank">http://www.houseoffusion.com/index.cfm?sidebar=3Dlists=
 or send a
message with 'unsubscribe' in the body to =
[EMAIL PROTECTED]



___=
_
Get free email and a permanent address at http://www.netaddress.com/?N=3D1" =
TARGET=3D"_blank">http://www.netaddress.com/?N=3D1
-

RE: cd-rom based applications

[Shawn Regan]

This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.

--_=_NextPart_001_01C04FE5.9D3B4D10
Content-Type: text/plain;
charset="iso-8859-1"

I need to search a file that will hold information on 90 products. So i need
to do a catalog search by partnumber, and then i need to give them a
different search front that lets them put in three vars.

Shawn Regan
[EMAIL PROTECTED]
Cold Fusion Developer
Pacific Technology Solutions


-Original Message-
From: Paul Mone [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, November 15, 2000 9:17 PM
To: CF-Talk
Subject: RE: cd-rom based applications


What are you using to build the application?

If you're using Director, I'm pretty sure you can accompplish something like
this via Lingo.  Then again, this all depends on what you're searching?

If you're searching files, you'll have to consider the different
platforms/filesystems that your CDROM will be running on.

-Original Message-
From: Shawn Regan [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, November 15, 2000 2:36 PM
To: CF-Talk
Subject: cd-rom based applications


This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.

--_=_NextPart_001_01C04F54.76265940
Content-Type: text/plain;
charset="iso-8859-1"

has anyone done a cd-rom application for any client that had to have
searching functions? If so how did you go about doing it?

Shawn Regan
[EMAIL PROTECTED]
Cold Fusion Developer
Pacific Technology Solutions



--_=_NextPart_001_01C04F54.76265940
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable






cd-rom based applications



has anyone done a cd-rom application for any client =
that had to have searching functions? If so how did you go about doing =
it?

Shawn Regan
[EMAIL PROTECTED]
Cold Fusion Developer
Pacific Technology Solutions


   =20




--_=_NextPart_001_01C04F54.76265940--


Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a
message with 'unsubscribe' in the body to [EMAIL PROTECTED]



Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a
message with 'unsubscribe' in the body to [EMAIL PROTECTED]

--_=_NextPart_001_01C04FE5.9D3B4D10
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable






RE: cd-rom based applications



I need to search a file that will hold information on =
90 products. So i need to do a catalog search by partnumber, and then i =
need to give them a different search front that lets them put in three =
vars.

Shawn Regan
[EMAIL PROTECTED]
Cold Fusion Developer
Pacific Technology Solutions



-Original Message-
From: Paul Mone [mailto:[EMAIL PROTECTED]">mailto:[EMAIL PROTECTED]]=

Sent: Wednesday, November 15, 2000 9:17 PM
To: CF-Talk
Subject: RE: cd-rom based applications



What are you using to build the application?


If you're using Director, I'm pretty sure you can =
accompplish something like
this via Lingo.  Then again, this all depends =
on what you're searching?


If you're searching files, you'll have to consider =
the different
platforms/filesystems that your CDROM will be =
running on.


-Original Message-
From: Shawn Regan [mailto:[EMAIL PROTECTED]">mailto:[EMAIL PROTECTED]]
Sent: Wednesday, November 15, 2000 2:36 PM
To: CF-Talk
Subject: cd-rom based applications



This message is in MIME format. Since your mail =
reader does not understand
this format, some or all of this message may not be =
legible.


--_=3D_NextPart_001_01C04F54.76265940
Content-Type: text/plain;
    charset=3D"iso-8859-1"


has anyone done a cd-rom application for any client =
that had to have
searching functions? If so how did you go about =
doing it?


Shawn Regan
[EMAIL PROTECTED]
Cold Fusion Developer
Pacific Technology Solutions




--_=3D_NextPart_001_01C04F54.76265940
Content-Type: text/html;
    charset=3D"iso-8859-1"
Content-Transfer-Encoding: quoted-printable












has anyone done a =
cd-rom application for any client =3D
that had to have searching functions? If so how did =
you go about doing =3D
it?


Shawn =
Regan

[EMAI