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]
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 mailto:[EMAIL PROTECTED] http://www.bigbang.net.au 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
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
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
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 cflock around the cfauthenticate 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!!!!
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]
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 mailto:[EMAIL PROTECTED] http://www.bigbang.net.au 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]
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 mailto:[EMAIL PROTECTED] http://www.bigbang.net.au 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
yep you can get an unlimited internet connectivity license. ! --- Neil Clark Senior Web Applications Engineer mcb digital Tel. +44 (0)20 8941 3232 Tel. +44 (0)20 8408 8131 [Direct] 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
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
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?
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 !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" HTMLHEAD META content=3D"text/html; charset=3Diso-8859-1" = http-equiv=3DContent-Type META content=3D"MSHTML 5.00.2314.1000" name=3DGENERATOR STYLE/STYLE /HEAD BODY bgColor=3D#ff DIVFONT size=3D2Dear Friends,/FONT/DIV DIVFONT size=3D2nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; 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. /FONT/DIV DIVnbsp;/DIV DIVFONT size=3D2How do we disable the BACK button using CF, instead = of using=20 Javascript/FONT/DIV DIVFONT size=3D2history.back() ?/FONT/DIV DIVnbsp;/DIV DIVFONT size=3D2Another way is using session struct to record each = template=20 ID./FONT/DIV DIVFONT size=3D2/FONTnbsp;/DIV DIVFONT size=3D2Can we implement more efficient way to do = it?/FONT/DIV DIVFONT size=3D2Thanks in advance./FONT/DIV DIVnbsp;/DIV DIVFONT size=3D2Regards,/FONT/DIV DIVnbsp;/DIV DIVFONT size=3D2Karenina/FONT/DIV DIVnbsp;/DIV/BODY/HTML --=_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
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
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 cfcache at the top of my cfhttp 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...
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
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!!!!
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?)
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
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!!!!
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?
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 img src="#images#" 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
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: cfexecute name="c:\winnt\system32\net.exe" arguments="user testme testme /add" /cfexecute 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?
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 img src="#images#" 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?
Did you view the source to make sure the img src"#images#' 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 img src="#images#" 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
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 g 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 g 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?
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 img src="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 img src="#images#" 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?
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
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 !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" HTMLHEAD META content=3D"text/html; charset=3Diso-8859-1" = http-equiv=3DContent-Type META content=3D"MSHTML 5.00.3013.2600" name=3DGENERATOR STYLE/STYLE /HEAD BODY bgColor=3D#ff DIV DIRFONT size=3D2 PWe 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/P PThis 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/P PThe 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./P PHas anybody else had trouble with this version of the ODBC driver? If = so,=20 what is the work-around?/P PThank you ahead of time,/P Pnbsp;/P PGary :-)/P/DIR/FONT/DIV/BODY/HTML --=_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
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..) cfscript 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 = ""; /cfscript 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
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?
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?)
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 a few dynamic gif reports? (I've looked at the various graphing tags and none of them are suitable (read limited) , and
Re: need help w/ session management
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
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 cfparam name="action" value="" a href="index.cfm?action=MemberUpdate"Member Update/a cfswitch expression="#action# cfcase value="MemberUpdate cfinclude template="MemberUpdate/index.cfm /cfcase /cfswitch -- MemberUpdate/index.cfm cfswitch expression="#go#" cfdefaultcase value="ChoosePhoto" cfinclude template="dsp_ChoosePhotoForm.cfm" /cfdefaultcase cfcase value="UpdatePhoto" cfinclude template="dsp_UpdatePhotoForm.cfm" /cfcase /cfswitch 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
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 g 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 g 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-archive.com/cf-talk@houseoffusion.com/ Unsubscribe:
CF Studio Server 5.0 Costs? :: Budget :: Next Year
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
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 !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN" HTML HEAD META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; = charset=3Diso-8859-1" META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = 5.5.2650.12" TITLERE: How To Determine Logged In Users/TITLE /HEAD BODY PFONT SIZE=3D2You could always insert the user info into a table = when then login./FONT /P PFONT SIZE=3D2Shawn Regan/FONT BRFONT SIZE=3D2[EMAIL PROTECTED]/FONT BRFONT SIZE=3D2Cold Fusion Developer/FONT BRFONT SIZE=3D2Pacific Technology Solutions/FONT /P BR PFONT SIZE=3D2-Original Message-/FONT BRFONT SIZE=3D2From: AustralianAccommodation.com Pty. Ltd./FONT BRFONT SIZE=3D2[A = HREF=3D"mailto:[EMAIL PROTECTED]"mailto:director@Aus= tralianAccommodation.com/A]/FONT BRFONT SIZE=3D2Sent: Wednesday, November 15, 2000 12:51 PM/FONT BRFONT SIZE=3D2To: CF-Talk/FONT BRFONT SIZE=3D2Subject: How To Determine Logged In Users/FONT /P BR PFONT SIZE=3D2Just 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 wantingnbsp; to try and take it to = the next step so that I can see who exactly is logged in /FONT/P BR PFONT SIZE=3D2Kind Regards/FONT /P PFONT SIZE=3D2Claude Raiola (Director)/FONT BRFONT SIZE=3D2AustralianAccommodation.com Pty. Ltd./FONT BRFONT SIZE=3D2Email: [EMAIL PROTECTED]/FONT BRFONT SIZE=3D2Developers Of:/FONT BRFONT = SIZE=3D2nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; = Website: www.AustralianAccommodation.com/FONT BRFONT = SIZE=3D2nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; = Website: www.AccommodationNewZealand.com/FONT /P BR PFONT = SIZE=3D2---= -/FONT BRFONT SIZE=3D2Archives: A = HREF=3D"http://www.mail-archive.com/cf-talk@houseoffusion.com/" = TARGET=3D"_blank"http://www.mail-archive.com/cf-talk@houseoffusion.com/= /A/FONT BRFONT SIZE=3D2Unsubscribe: A = HREF=3D"http://www.houseoffusion.com/index.cfm?sidebar=3Dlists" = TARGET=3D"_blank"http://www.houseoffusion.com/index.cfm?sidebar=3Dlists= /A or send a message with 'unsubscribe' in the body to = [EMAIL PROTECTED]/FONT/P /BODY /HTML --_=_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]
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 !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN" HTML HEAD META HTTP-EQUIV=3D3D"Content-Type" CONTENT=3D3D"text/html; =3D charset=3D3Diso-8859-1" META NAME=3D3D"Generator" CONTENT=3D3D"MS Exchange Server version =3D 5.5.2650.12" TITLEcd-rom based applications/TITLE /HEAD BODY PFONT SIZE=3D3D2has 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?/FONT/P PFONT SIZE=3D3D2Shawn Regan/FONT BRFONT SIZE=3D3D2[EMAIL PROTECTED]/FONT BRFONT SIZE=3D3D2Cold Fusion Developer/FONT BRFONT SIZE=3D3D2Pacific Technology Solutions/FONT /P P=A0=A0=A0=A0=A0=A0=A0=3D20 /P /BODY /HTML --_=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 !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN" HTML HEAD META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; = charset=3Diso-8859-1" META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = 5.5.2650.12" TITLERE: [cd-rom based applications]/TITLE /HEAD BODY PFONT SIZE=3D2No this has to run on the cd no install of any = kind./FONT /P PFONT SIZE=3D2Shawn Regan/FONT BRFONT SIZE=3D2[EMAIL PROTECTED]/FONT BRFONT SIZE=3D2Cold Fusion Developer/FONT BRFONT SIZE=3D2Pacific Technology Solutions/FONT /P BR PFONT SIZE=3D2-Original Message-/FONT BRFONT SIZE=3D2From: Alex [A = HREF=3D"mailto:[EMAIL PROTECTED]"mailto:[EMAIL PROTECTED]/A]/FON= T BRFONT SIZE=3D2Sent: Wednesday, November 15, 2000 6:46 PM/FONT BRFONT SIZE=3D2To: CF-Talk/FONT BRFONT SIZE=3D2Subject: Re: [cd-rom based applications]/FONT /P BR PFONT SIZE=3D2does the client have cf installed?/FONT /P PFONT SIZE=3D2Shawn Regan lt;[EMAIL PROTECTED]gt; wrote:/FONT BRFONT SIZE=3D2This message is in MIME format. Since your mail = reader does not understand/FONT BRFONT SIZE=3D2this format, some or all of this message may not be = legible./FONT /P PFONT SIZE=3D2--_=3D_NextPart_001_01C04F54.76265940/FONT BRFONT SIZE=3D2Content-Type: text/plain;/FONT BRnbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; FONT = SIZE=3D2charset=3Dquot;iso-8859-1quot;/FONT /P PFONT SIZE=3D2has anyone done a cd-rom application for any client = that had to have/FONT BRFONT SIZE=3D2searching functions? If so how did you go about = doing it?/FONT /P PFONT SIZE=3D2Shawn Regan/FONT BRFONT SIZE=3D2[EMAIL PROTECTED]/FONT BRFONT SIZE=3D2Cold Fusion Developer/FONT BRFONT SIZE=3D2Pacific Technology Solutions/FONT /P Pnbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;=20 /P PFONT SIZE=3D2--_=3D_NextPart_001_01C04F54.76265940/FONT BRFONT SIZE=3D2Content-Type: text/html;/FONT BRnbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; FONT = SIZE=3D2charset=3Dquot;iso-8859-1quot;/FONT BRFONT SIZE=3D2Content-Transfer-Encoding: quoted-printable/FONT /P PFONT SIZE=3D2lt;!DOCTYPE HTML PUBLIC quot;-//W3C//DTD HTML = 3.2//ENquot;gt;/FONT BRFONT SIZE=3D2lt;HTMLgt;/FONT BRFONT SIZE=3D2lt;HEADgt;/FONT BRFONT SIZE=3D2lt;META
RE: 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_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 !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN" HTML HEAD META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; = charset=3Diso-8859-1" META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = 5.5.2650.12" TITLEcd-rom based applications/TITLE /HEAD BODY PFONT SIZE=3D2has anyone done a cd-rom application for any client = that had to have searching functions? If so how did you go about doing = it?/FONT/P PFONT SIZE=3D2Shawn Regan/FONT BRFONT SIZE=3D2[EMAIL PROTECTED]/FONT BRFONT SIZE=3D2Cold Fusion Developer/FONT BRFONT SIZE=3D2Pacific Technology Solutions/FONT /P Pnbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;=20 /P /BODY /HTML --_=_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 !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN" HTML HEAD META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; = charset=3Diso-8859-1" META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = 5.5.2650.12" TITLERE: cd-rom based applications/TITLE /HEAD BODY PFONT SIZE=3D2I 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./FONT/P PFONT SIZE=3D2Shawn Regan/FONT BRFONT SIZE=3D2[EMAIL PROTECTED]/FONT BRFONT SIZE=3D2Cold Fusion Developer/FONT BRFONT SIZE=3D2Pacific Technology Solutions/FONT /P BR PFONT SIZE=3D2-Original Message-/FONT BRFONT SIZE=3D2From: Paul Mone [A = HREF=3D"mailto:[EMAIL PROTECTED]"mailto:[EMAIL PROTECTED]/A]/FONT= BRFONT SIZE=3D2Sent: Wednesday, November 15, 2000 9:17 PM/FONT BRFONT SIZE=3D2To: CF-Talk/FONT BRFONT SIZE=3D2Subject: RE: cd-rom based applications/FONT /P BR PFONT SIZE=3D2What are you using to build the application?/FONT /P PFONT SIZE=3D2If you're using Director, I'm pretty sure you can = accompplish something like/FONT BRFONT SIZE=3D2this via Lingo.nbsp; Then again, this all depends = on what you're searching?/FONT /P PFONT SIZE=3D2If you're searching files, you'll have to consider = the different/FONT BRFONT SIZE=3D2platforms/filesystems that your CDROM will be = running on./FONT /P PFONT SIZE=3D2-Original Message-/FONT BRFONT SIZE=3D2From: Shawn Regan [A = HREF=3D"mailto:[EMAIL PROTECTED]"mailto:[EMAIL PROTECTED]/A]/FONT BRFONT SIZE=3D2Sent: Wednesday, November 15, 2000 2:36 PM/FONT BRFONT SIZE=3D2To: CF-Talk/FONT BRFONT SIZE=3D2Subject: cd-rom based applications/FONT /P BR PFONT SIZE=3D2This message is in MIME format. Since your mail = reader does not understand/FONT BRFONT
Re: How to include ampersand in NT command line SET statement?
Try putting double quotes around it like: set query_string="one=1two=2three=3" HTH, Howie - Original Message - From: "Lawrence B. Afrin, M.D." [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Wednesday, November 15, 2000 4:28 PM Subject: How to include ampersand in NT command line SET statement? This is a multi-part message in MIME format. --E7774448A625D015C2801112 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Howdy -- For reasons not worth going into, I'm trying to run a CF template via a SQL Server trigger doing an "exec master..xp_cmdshell batchfile.cmd" where the batchfile invokes cfml.exe to run the template. My problem is that I need to feed the template a query string with multiple parameters. I know that, theoretically, the way to do this is to set the QUERY_STRING environment variable to the query string I want (e.g., "SET QUERY_STRING=one=1two=2three=3") before running cfml.exe, but my problem is that the NT cmd interpreter is picking up the ampersand as a special character and terminating the SET at the first ampersand. Is there some special "escape" syntax that'll let me include an ampersand as part of the value for a SET statement? There are no clues in HELP SET. I've tried backslashes, double and single quotes, and other things, but I can't seem to find the magic combination, and I know there must be a way to do this. Anybody? -- Larry Afrin, M.D. Medical University of South Carolina [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
try www.cfcertification.com , it has sample questions and other resources for getting through the exam. -Original Message- From: Nick Betts [mailto:[EMAIL PROTECTED]] Sent: Friday, November 10, 2000 9:48 AM To: CF-Talk Subject: Certification Exam Hi, I may be going through Allaire certification exam, has anyone out there done exam and got any tips for success!?? Nick -Original Message- From: Todd Ashworth [mailto:[EMAIL PROTECTED]] Sent: 10 November 2000 15:50 To: CF-Talk Subject: Re: CFX_NNTP --- snip --- | disrupts a standard | Query to insert those messages into a Database (whether this is an Access | problem, ODBC problem, or any DB I don't know - but AFAIK you can't insert a | field with quotes into a table). --- snip --- What does your insert statement look like and what is the data type of the field that you are inserting into? I just inserted values into my database with both "" and '', with no problems. Todd Ashworth 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]
SQL Server error
I am getting 2 strange errors.. ODBC Error Code = 37000 (Syntax error or access violation) | [Microsoft][ODBC SQL Server Driver][SQL Server]Database 'thethin' is already open and can only | have one user at a time. | ODBC Error Code = S1T00 (Timeout expired) [Microsoft][ODBC SQL Server Driver]Timeout expired The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (69:1) to (69:89) in the template file D:\THETHIN\FAQS.CFM. = the query is simple: cfquery name="list" datasource="#SQLds#" username="#sqluser#" password="#sqlpassword#" select id,submitted,q,score from faq where (approved = 1) cfif category is not '-1' and cfif findnocase('1', category)category like '%1%'cfset more=1/cfif cfif findnocase('2', category)cfif more is 1 or cfelsecfset more=1/cfifcategory like '%2%'/cfif cfif findnocase('3', category)cfif more is 1 or cfelsecfset more=1/cfifcategory like '%3%'/cfif cfif findnocase('4', category)cfif more is 1 or cfelsecfset more=1/cfifcategory like '%4%'/cfif cfif findnocase('5', category)cfif more is 1 or cfelsecfset more=1/cfifcategory like '%5%'/cfif cfif findnocase('6', category)cfif more is 1 or cfelsecfset more=1/cfifcategory like '%6%'/cfif /cfif cfif sortby is 'score' order by score desc,submitted desc cfelse order by submitted desc,score desc /cfif /cfquery === This is SQL server 7, Cold fusion 4.5.1 - on separate boxes.. There has been no change to the cold fusion templates on this website in about 6 months. These errors started popping up very infrequently a few weeks ago.. Maybe once every few days. When the first error happens, I have to reboot the cold fusion server and it works again. The second one clears itself quickly and works again. The only change I see is a increase in the database size, as well as an increase in the number of visitors to the site. When this happens, other databases still work. That query takes only about 200ms. How could it time out? Any ideas? I do not have any other programs opening it - the servers are co-located, and do not even have MS access installed. I do use MTS packages to copy the database to my home computer a few times a day.. would that exclusively lock the table and cause problems? Thanks Al Musella, DPM A1webs.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: Dreamweaver Ultradev 4 - any good?
He has already. Same thing as Dreamweaver just supports color coding with ASP, JSP, and CF. I prefer CF studio. Rob From: "Stephen M. Aylor" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: Re: Dreamweaver Ultradev 4 - any good? Date: Wed, 15 Nov 2000 14:57:06 -0800 MIME-Version: 1.0 Received: from [207.31.122.140] by hotmail.com (3.2) with ESMTP id MHotMailBBDCC46B008CD820F3BACF1F7A8C0E9F0; Wed Nov 15 22:06:43 2000 Received: from tio.tiocom ([207.211.39.56]) by www.houseoffusion.com (Post.Office MTA v3.5.3 release 223 ID# 0-54969U100L100S0V35) with ESMTP id com for [EMAIL PROTECTED]; Thu, 16 Nov 2000 00:10:02 -0500 Received: from aia-inc.com (unverified [209.233.135.236]) by tio.tiocom (Rockliffe SMTPRA 3.3.1) with ESMTP id [EMAIL PROTECTED] for [EMAIL PROTECTED]; Wed, 15 Nov 2000 15:12:46 -0800 Received: from aiawdoc8g8f9iv [10.101.11.2] by aia-inc.com [10.101.11.254]with SMTP (MDaemon.v3.1.1.R)for [EMAIL PROTECTED]; Wed, 15 Nov 2000 15:00:03 -0800 From [EMAIL PROTECTED] Wed Nov 15 22:07:21 2000 Message-ID: 059001c04f57$60d7fa50$020b650a@aiawdoc8g8f9iv References: [EMAIL PROTECTED] 004601c04f3a$5e648f80$[EMAIL PROTECTED] Return-Path: [EMAIL PROTECTED] I think I'll wait till after ivanopolo reviews it :-) kidding... Steve 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] _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.msn.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: Dynamic image display question?
Rick, Here's what I do. First, I'm assuming here that the directory for your images is a subdirectory of the current template directory. Given that I typically set up a ColdFusion variable for the image directory as: CFSET ImageDir= GetDirectoryFromPath(ExpandPath("*.*")) "images\" This allows me just to have the name of the image file in the database without path information, as that may change at any point. Then I run a query to get the image stuff: CFQUERY NAME="ImageDB" DATASOURCE="#DSN#" DBTYPE="ODBC" BLOCKFACTOR="100" CACHEDWITHIN="#CreateTimeSpan(0,0,30,0)#" SELECT ImageName,Caption,image_ID,Short_Desc FROM Images ORDER BY image_ID /CFQUERY Then I make sure that the image really exists in the specified directory, and if it does, display the image, otherwise display a default image: cfset Image_Name = ImageDir ImageDB.ImageName CFIF FileExists(Image_Name) cfoutputimg src="#Image_Name#"/cfoutput CFELSE img src="images/default.gif" /CFELSE hth, larry -- Larry C. Lyons ColdFusion/Web Developer EBStor.com 8870 Rixlew Lane, Suite 201 Manassas, Virginia 20109-3795 tel: (703) 393-7930 x253 fax: (703) 393-2659 http://www.ebstor.com http://www.pacel.com email: [EMAIL PROTECTED] Chaos, panic, and disorder - my work here is done. -- Richard L Smith wrote: 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 img src="#images#" 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: RegEx help PLEASE hurry...
Try this REReplaceNoCase(string, '([a-z0-9]) ([a-z0-9])', '\1\2', 'all') This will look for a character followed by a space and then a character and replace it with the first and second character (without the space in between. Hello all I have a page of text that looks like this... H e l l o A l l I want to condense it to... Hello All (getting rid of one space following every character) I know I can do it with regEx in studio replace pane... but I don't know the syntax... Anyone, Anyone, Beuhler??? TIA jp _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.msn.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: Nested Structures and Arrays - Addendum
Sorry I miss typed the code, what I meant was cfscript 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.Guardian[1].Employer.Address.StreetAddress = ""; /cfscript I still get the error: "The member "EMPLOYER.ADDRESS" in dimension 1 of object "Session.Intake.Guardian" cannot be found. Please, modify the member name" -Original Message- From: Christopher Olive, CIO [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 16, 2000 7:17 AM To: CF-Talk Subject: RE: Nested Structures and Arrays 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..) cfscript 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 = ""; /cfscript 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] 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: Certified ColdFusion Developers
How about CF_Cert? If you have more than one Cf_Cert By="Allaire,Brainbench" Lon Lentz Applications Developer CyberEntomologist - Alvion Technologies DataWarehousing and List Sales - Market Your Lists on the Net! [EMAIL PROTECTED] 941-574-8600 Ext. 210 Just out of curiosity... since I notice that most of us who passed the Certification have adjusted their Sigs to say "Certified ColdFusion Developer", wouldn't it be easier to use an abbreviation? 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]
Allaire CF Tuning Class
Has anyone taken the 2 day CF Tuning class? How is it oriented? What's the emphasis on? Coding or server settings? Did it help you make things run smoother and/or faster? Lon Lentz Applications Developer CyberEntomologist - Alvion Technologies DataWarehousing and List Sales - Market Your Lists on the Net! [EMAIL PROTECTED] 941-574-8600 Ext. 210 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: I need a specific tree control for use with CF...
If the data does not change often, you can have the "tree" file re-built with CFFILE after the updates. This gives you a much quicker way to view the tree... This would ony be usefull if the data canges daily or so, not every ten minutes : ) === 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, 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!!!!
http://developer.netscape.com/docs/technote/dynhtml/collapse/index.html The example DHTML code on this page in netscape's site doesn't work in Netscape 6. =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Simon Park Computer Systems Management, Inc. Ph: 703-823-4300 x119 205 South Whiting Street #201 fax: 703-823-4301 Alexandria, VA 22304 http://www.csmi.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: Novell Advanced Security Woes
I don't use Advanced Security, but I have and do authenticate to Novell's LDAP server via the CFLDAP tag. Kevin [EMAIL PROTECTED] 11/15/00 12:10PM I know that if you want to do a look up to NDS with cfldap you can. But you can't authenticate to it. Allaire has never tested it and they say it won't work. The built it for Netscape DS. The siteminder piece doesn't recognize Novell DS. I got your same problem some time ago and opened a ticket.and nothing..doesn't work...You can verify the connection and it works, but if you were to go to your policy and check the users your shouldn't see anything... sorry... Now should anyone have successfully auth against Novell DS, using cf 4.5.1, and advanced security please lets talk. Thanks [EMAIL PROTECTED] 11/06/00 10:32AM Yes, I should have mentioned Rick's tool. I was going down the CF specific route but, Rick's tool can solve your problem too. Steve -Original Message- From: Rick Osborne [Mojo] [mailto:[EMAIL PROTECTED]] Sent: Monday, November 06, 2000 1:06 AM To: CF-Talk Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: Novell Advanced Security Woes FYI, I wrote an ISAPI DLL for IIS to do pretty much exactly what Steve talks about at the end there. It is completely free and comes with source. It is available at: http://www.rixsoft.com/NWAuth/ Of course, it means that IIS does the authentication instead of CF, but that may be good or bad depending on your situation. -Original Message- From: Steve Bernard [mailto:[EMAIL PROTECTED]] Sent: Saturday, November 04, 2000 22:41 To: CF-Talk Subject: RE: Novell Advanced Security Woes With native CF capability you'll have to use CFLDAP to query NDS' LDAP interface directly. This doesn't allow you to use NDS as your AS repository but, it's better than nothing. You could try hand building the schema in NDS. Another option is to use native OS authentication/authorization but, have that redirected to NDS. Like using Client32 for NT. Steve 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: Certification Exam
There is a free 40 question CF 4.5 Certification exam available at brainbench.com. I have been told that if you score at least a 4 (on a 5 point system), you have a good chance of passing the Allaire test. Good luck! Shane Witbeck www.digitalsanctum.com -- Original Message -- From: "Mark W. Breneman" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Thu, 16 Nov 2000 09:39:14 -0600 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 g 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 g 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]
Re: How To Determine Logged In Users
Actually, the way I do it is set a cookie. Then at the top of all the pages that are "login" protected, I check for the cookie.. if it exists I know they are logged in since the cookie can't be set unless they are successfully login. United Federation of Slow (not very smart) CF Programmers, Jake - Original Message - From: "Shawn Regan" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Thursday, November 16, 2000 10:50 AM Subject: RE: How To Determine Logged In Users 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 !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN" HTML HEAD META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; = charset=3Diso-8859-1" META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = 5.5.2650.12" TITLERE: How To Determine Logged In Users/TITLE /HEAD BODY PFONT SIZE=3D2You could always insert the user info into a table = when then login./FONT /P PFONT SIZE=3D2Shawn Regan/FONT BRFONT SIZE=3D2[EMAIL PROTECTED]/FONT BRFONT SIZE=3D2Cold Fusion Developer/FONT BRFONT SIZE=3D2Pacific Technology Solutions/FONT /P BR PFONT SIZE=3D2-Original Message-/FONT BRFONT SIZE=3D2From: AustralianAccommodation.com Pty. Ltd./FONT BRFONT SIZE=3D2[A = HREF=3D"mailto:[EMAIL PROTECTED]"mailto:director@Aus= tralianAccommodation.com/A]/FONT BRFONT SIZE=3D2Sent: Wednesday, November 15, 2000 12:51 PM/FONT BRFONT SIZE=3D2To: CF-Talk/FONT BRFONT SIZE=3D2Subject: How To Determine Logged In Users/FONT /P BR PFONT SIZE=3D2Just 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 wantingnbsp; to try and take it to = the next step so that I can see who exactly is logged in /FONT/P BR PFONT SIZE=3D2Kind Regards/FONT /P PFONT SIZE=3D2Claude Raiola (Director)/FONT BRFONT SIZE=3D2AustralianAccommodation.com Pty. Ltd./FONT BRFONT SIZE=3D2Email: [EMAIL PROTECTED]/FONT BRFONT SIZE=3D2Developers Of:/FONT BRFONT = SIZE=3D2nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; = Website: www.AustralianAccommodation.com/FONT BRFONT = SIZE=3D2nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; = Website: www.AccommodationNewZealand.com/FONT /P BR PFONT = SIZE=3D2---= -/FONT BRFONT SIZE=3D2Archives: A = HREF=3D"http://www.mail-archive.com/cf-talk@houseoffusion.com/" = TARGET=3D"_blank"http://www.mail-archive.com/cf-talk@houseoffusion.com/= /A/FONT BRFONT SIZE=3D2Unsubscribe: A = HREF=3D"http://www.houseoffusion.com/index.cfm?sidebar=3Dlists" = TARGET=3D"_blank"http://www.houseoffusion.com/index.cfm?sidebar=3Dlists= /A or send a message with 'unsubscribe' in the body to = [EMAIL PROTECTED]/FONT/P /BODY /HTML --_=_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] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send
RE: Dreamweaver Ultradev 4 - any good?
whats the who table? -paul -Original Message- From: Greg Wolfinger [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, November 15, 2000 10:06 PM To: CF-Talk Subject: Re: Dreamweaver Ultradev 4 - any good? 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] 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: I need a specific tree control for use with CF...
Write the query on your page to include on the appropriate records. For example, the default query could return a subset of records. The tree control can show those items as clickable links, calling the same page and passing a url parameter which is then used in your query to get some next-level subset of records. -Original Message- From: Jablonski, Adam, MTC-DCLCx [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 16, 2000 7:42 AM To: CF-Talk Subject: I need a specific tree control for use with CF... 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?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?sidebarRsts or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
CFFTP - CFLOOP Prob.
I can't see what I am doing wrong. I have the index page where the user types in the name of the directory, chooses the file to upload finally selects which servers to send it to via checkbox. Since there is a possibility of multiple servers, I use CFLOOP to loop throught the delimitered list. This works fine and all. But if I select any server minus the first one, I get an error with CFFTP. I know that the CFFTP code works and that the list is understandable. Any clues here? Thanks in advance. Richard Ramos Network Administrator Softitler Net, Inc. www.softitler.com [EMAIL PROTECTED] index3.cfm html body cfquery name="site" datasource="upload" SELECT * FROM Servers /cfquery cfloop index="servername" list="#session.servername#" cfoutput cfif #site.name# IS "#servername#" cfftp connection="ftp" action="open" username="#site.username#" password="#site.password#" server="#site.address#" /cfif cfftp connection="ftp" action="changedir" directory="SomeDir" cfftp connection="ftp" action="createdir" directory="#session.directory#" failifexists="Yes" cfftp connection="ftp" action="changedir" directory="#session.directory#" cfftp connection="ftp" action="putfile" localfile="C:\Inetpub\ftp\SomeDir\#session.directory#\#session.filename#" remotefile="#session.filename#" stoponerror="yes" transfermode="binary" cfftp connection="ftp" action="close" cfoutput #servername# uploadedbr /cfoutput /cfloop /body /html -- 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]
I don't think CF is your solution, then. Scott Brader USAV Group 5485 S. Westridge Dr. PO Box 510620 New Berlin, WI 53151-0620 Phone: 262.814.2000 Fax: 262.814.2006 Amateurs practice until they get it right, Experts practice until they can't get it wrong. Any opinions expressed are mine and are not representative of USAV Group. -Original Message- From: Shawn Regan [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 16, 2000 9:53 AM To: CF-Talk Subject: RE: [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_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 !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN" HTML HEAD META HTTP-EQUIV=3D3D"Content-Type" CONTENT=3D3D"text/html; =3D charset=3D3Diso-8859-1" META NAME=3D3D"Generator" CONTENT=3D3D"MS Exchange Server version =3D 5.5.2650.12" TITLEcd-rom based applications/TITLE /HEAD BODY PFONT SIZE=3D3D2has 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?/FONT/P PFONT SIZE=3D3D2Shawn Regan/FONT BRFONT SIZE=3D3D2[EMAIL PROTECTED]/FONT BRFONT SIZE=3D3D2Cold Fusion Developer/FONT BRFONT SIZE=3D3D2Pacific Technology Solutions/FONT /P P=A0=A0=A0=A0=A0=A0=A0=3D20 /P /BODY /HTML --_=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 !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN" HTML HEAD META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; = charset=3Diso-8859-1" META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = 5.5.2650.12" TITLERE: [cd-rom based applications]/TITLE /HEAD BODY PFONT SIZE=3D2No this has to run on the cd no install of any = kind./FONT /P PFONT SIZE=3D2Shawn Regan/FONT BRFONT SIZE=3D2[EMAIL PROTECTED]/FONT BRFONT SIZE=3D2Cold Fusion Developer/FONT BRFONT SIZE=3D2Pacific Technology Solutions/FONT /P BR PFONT SIZE=3D2-Original Message-/FONT BRFONT SIZE=3D2From: Alex [A = HREF=3D"mailto:[EMAIL PROTECTED]"mailto:[EMAIL PROTECTED]/A]/FON= T BRFONT SIZE=3D2Sent: Wednesday, November 15, 2000 6:46 PM/FONT BRFONT SIZE=3D2To: CF-Talk/FONT BRFONT SIZE=3D2Subject: Re: [cd-rom based applications]/FONT /P BR PFONT SIZE=3D2does the client have cf installed?/FONT /P PFONT SIZE=3D2Shawn Regan lt;[EMAIL PROTECTED]gt; wrote:/FONT BRFONT SIZE=3D2This message is in MIME format. Since your mail = reader does not understand/FONT BRFONT SIZE=3D2this format, some or all of this message may not be = legible./FONT /P PFONT SIZE=3D2--_=3D_NextPart_001_01C04F54.76265940/FONT BRFONT SIZE=3D2Content-Type: text/plain;/FONT BRnbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; FONT = SIZE=3D2charset=3Dquot;iso-8859-1quot;/FONT /P PFONT SIZE=3D2has anyone done a cd-rom application for any client = that had to have/FONT BRFONT SIZE=3D2searching functions? If so how did you go about = doing it?/FONT /P PFONT SIZE=3D2Shawn Regan/FONT BRFONT SIZE=3D2[EMAIL PROTECTED]/FONT BRFONT SIZE=3D2Cold Fusion Developer/FONT BRFONT SIZE=3D2Pacific Technology
testing process
Does anybody know of a resource to help test code before releasing? Like a checklist or process? I need help learning to better test my code... 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
the new generator lets you do all kinds of crazy stuff. like integrate flash with databases... etc.. my buddy at chuck-e-cheese has been messing with it.. it's amazing. jake - Original Message - From: "Shawn Regan" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Thursday, November 16, 2000 10:55 AM Subject: RE: 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_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 !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN" HTML HEAD META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; = charset=3Diso-8859-1" META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = 5.5.2650.12" TITLEcd-rom based applications/TITLE /HEAD BODY PFONT SIZE=3D2has anyone done a cd-rom application for any client = that had to have searching functions? If so how did you go about doing = it?/FONT/P PFONT SIZE=3D2Shawn Regan/FONT BRFONT SIZE=3D2[EMAIL PROTECTED]/FONT BRFONT SIZE=3D2Cold Fusion Developer/FONT BRFONT SIZE=3D2Pacific Technology Solutions/FONT /P Pnbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;=20 /P /BODY /HTML --_=_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 !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN" HTML HEAD META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; = charset=3Diso-8859-1" META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = 5.5.2650.12" TITLERE: cd-rom based applications/TITLE /HEAD BODY PFONT SIZE=3D2I 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./FONT/P PFONT SIZE=3D2Shawn Regan/FONT BRFONT SIZE=3D2[EMAIL PROTECTED]/FONT BRFONT SIZE=3D2Cold Fusion Developer/FONT BRFONT SIZE=3D2Pacific Technology Solutions/FONT /P BR PFONT SIZE=3D2-Original Message-/FONT BRFONT SIZE=3D2From: Paul Mone [A = HREF=3D"mailto:[EMAIL PROTECTED]"mailto:[EMAIL PROTECTED]/A]/FONT= BRFONT SIZE=3D2Sent: Wednesday, November 15, 2000 9:17 PM/FONT BRFONT SIZE=3D2To: CF-Talk/FONT BRFONT SIZE=3D2Subject: RE: cd-rom based applications/FONT /P BR PFONT SIZE=3D2What are you using to build the application?/FONT /P PFONT SIZE=3D2If you're using Director, I'm pretty sure you can = accompplish something like/FONT BRFONT SIZE=3D2this via Lingo.nbsp; Then again, this all depends = on what you're searching?/FONT /P PFONT SIZE=3D2If you're searching files, you'll have to consider = the different/FONT BRFONT SIZE=3D2platforms/filesystems that your
RE: cd-rom based applications
yes, I have done a fully searchable (RAM-updateable) database on a CD-ROM good experience and quite fun to do... N ! --- Neil Clark Senior Web Applications Engineer mcb digital Tel. +44 (0)20 8941 3232 Tel. +44 (0)20 8408 8131 [Direct] 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: append variable to a variable??
Thanks Everyone!! Sal From: "Andrew" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: RE: append variable to a variable?? Date: Wed, 15 Nov 2000 22:40:23 -0500 Sal: Sure there is. try this for instance: cfset numvar = "2" cfset "Edname#numvar#" = "test" cfoutputEdname2 is #Edname2#/cfoutput How's that? Andrew Hewitt Web Application Developer webworld studios, inc. www.wwstudios.com cf_certified/ -Original Message- From: S R [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 15, 2000 7:56 PM To: CF-Talk Subject: append variable to a variable?? Is there anyway to do this? I have six variables in my database they are called: EdName1, EdName2, etc. It would be awesome if I could set a variable that could dynamically change the number of each variable for me so I don't have to hard code the variable. For example (I know this doesn't work but it will get my point across: cfset numvar = "2" #EdName#numvar## = EdName2 Thanks for your help Sal _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.msn.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] _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.msn.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: Locking while deleting
directly analogous to constants; I like to use the Request scope for constants, though, as it's not stored in memory and avoids the need for locking. Where are they stored then? -- 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]
Anyone familiar with php?
This is a multi-part message in MIME format. --=_NextPart_000_09AB_01C04FC2.7DA94970 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Problem one registration form that posts to a local action form against = one data structure and also posts to a remote php action form. I can't see the variables posted to the = remote form..=20 I told that a record is being posted to the remote datasource but all = the fields are empty.=20 Anyone familiar with php. I haven't been able to get the remote script = to know what is happening there. There link looks like = http://www.name.com/form.php2?variable=3D$variablevariable2=3D$variable2= Here is how I am trying to send the URL variables to the form. See = anything wrong?? Should I try changing the method to GET??=20 cfhttp url=3D"Http://www.name.com/form.php3" method=3D"POST" = resolveurl=3D"true" cfif #form.title# is 0 cfhttpparam type=3D"URL" name=3D"variable" value=3D"01" cfelseif #form.title# is 1 cfhttpparam type=3D"URL" name=3D"variable" value=3D"02" cfelseif #form.title# is 2 cfhttpparam type=3D"URL" name=3D"variable" value=3D"03" cfelse cfhttpparam type=3D"URL" name=3D"varibable" value=3D"04" /cfif --=_NextPart_000_09AB_01C04FC2.7DA94970 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" HTMLHEAD META content=3D"text/html; charset=3Diso-8859-1" = http-equiv=3DContent-Type META content=3D"MSHTML 5.00.2920.0" name=3DGENERATOR STYLE/STYLE /HEAD BODY bgColor=3D#ff DIVFONT face=3DArial size=3D2Problem one registration form that = posts to a local=20 action form against one data structure and also posts/FONT/DIV DIVFONT face=3DArial size=3D2to a remote php action form. I can't = see the=20 variables posted to the remote form.. /FONT/DIV DIVFONT face=3DArial size=3D2I told that a record is being posted to = the remote=20 datasource but all the fields are empty. /FONT/DIV DIVnbsp;/DIV DIVFONT face=3DArial size=3D2Anyone familiar with php. I haven't = been able to=20 get the remote script to know what is happening there./FONT/DIV DIVFONT face=3DArial size=3D2There link looks like A=20 href=3D"http://www.name.com/form.php2?variable=3D$variableamp;variable2=3D= $variable2amp;"http://www.name.com/form.php2?variable=3D$variableamp;v= ariable2=3D$variable2amp;/A/FONT/DIV DIVnbsp;/DIV DIVFONT face=3DArial size=3D2Here is how I am trying to send the URL = variables=20 to the form. See anything wrong??/FONT/DIV DIVFONT face=3DArial size=3D2Should I try changing the method to = GET??=20 /FONT/DIV DIVnbsp;/DIV DIVFONT face=3DArial size=3D2lt;cfhttp = url=3D"Http://www.name.com/form.php3"=20 method=3D"POST" resolveurl=3D"true"gt;BRnbsp;lt;cfif #form.title# = is=20 0gt;BRnbsp;nbsp;lt;cfhttpparam type=3D"URL" name=3D"variable"=20 value=3D"01"gt;BRnbsp;lt;cfelseif #form.title# is=20 1gt;BRnbsp;nbsp;lt;cfhttpparam type=3D"URL" name=3D"variable"=20 value=3D"02"gt;BRnbsp;lt;cfelseif #form.title# is=20 2gt;BRnbsp;nbsp;lt;cfhttpparam type=3D"URL" name=3D"variable"=20 value=3D"03"gt;BRnbsp;lt;cfelsegt;BRnbsp;nbsp;lt;cfhttpparam = type=3D"URL"=20 name=3D"varibable"=20 value=3D"04"gt;BRnbsp;lt;/cfifgt;/FONT/DIV/BODY/HTML --=_NextPart_000_09AB_01C04FC2.7DA94970-- 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 Studio Server 5.0 Costs? :: Budget :: Next Year
sounds like a question you should ask Allaire sales dept - Original Message - From: "Paul Ihrig" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Thursday, November 16, 2000 10:41 AM Subject: CF Studio Server 5.0 Costs? :: Budget :: Next Year 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] 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
One thing to keep in mind is that everyone who has taken the exam is under a non-disclosure agreement with regards to the exam. While a high level overview of the areas to study is reasonable, going much further than that is not appropriate. DC -- David E. Crawford Certified ColdFusion Developer Actek, Inc. 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 error
--openmail-part-352daad2-0001 Content-Type: text/plain; charset=ISO-8859-1 Content-Disposition: inline ;Creation-Date="Thu, 16 Nov 2000 11:41:44 -0600" Content-Transfer-Encoding: 8bit re: [Microsoft][ODBC SQL Server Driver][SQL Server]Database 'thethin' is already open and can only | have one user at a time. | Do you have any of the tables in "Design View" I havent checked how this affects SQL server but I know with Access this can sometimes be the case. Misty -Original Message- From: musella [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 16, 2000 10:12 AM To: cf-talk Cc: musella Subject: SQL Server error I am getting 2 strange errors.. ODBC Error Code = 37000 (Syntax error or access violation) | [Microsoft][ODBC SQL Server Driver][SQL Server]Database 'thethin' is already open and can only | have one user at a time. | ODBC Error Code = S1T00 (Timeout expired) [Microsoft][ODBC SQL Server Driver]Timeout expired The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (69:1) to (69:89) in the template file D:\THETHIN\FAQS.CFM. = the query is simple: cfquery name="list" datasource="#SQLds#" username="#sqluser#" password="#sqlpassword#" select id,submitted,q,score from faq where (approved = 1) cfif category is not '-1' and cfif findnocase('1', category)category like '%1%'cfset more=1/cfif cfif findnocase('2', category)cfif more is 1 or cfelsecfset more=1/cfifcategory like '%2%'/cfif cfif findnocase('3', category)cfif more is 1 or cfelsecfset more=1/cfifcategory like '%3%'/cfif cfif findnocase('4', category)cfif more is 1 or cfelsecfset more=1/cfifcategory like '%4%'/cfif cfif findnocase('5', category)cfif more is 1 or cfelsecfset more=1/cfifcategory like '%5%'/cfif cfif findnocase('6', category)cfif more is 1 or cfelsecfset more=1/cfifcategory like '%6%'/cfif /cfif cfif sortby is 'score' order by score desc,submitted desc cfelse order by submitted desc,score desc /cfif /cfquery === This is SQL server 7, Cold fusion 4.5.1 - on separate boxes.. There has been no change to the cold fusion templates on this website in about 6 months. These errors started popping up very infrequently a few weeks ago.. Maybe once every few days. When the first error happens, I have to reboot the cold fusion server and it works again. The second one clears itself quickly and works again. The only change I see is a increase in the database size, as well as an increase in the number of visitors to the site. When this happens, other databases still work. That query takes only about 200ms. How could it time out? Any ideas? I do not have any other programs opening it - the servers are co-located, and do not even have MS access installed. I do use MTS packages to copy the database to my home computer a few times a day.. would that exclusively lock the table and cause problems? Thanks Al Musella, DPM A1webs.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] --openmail-part-352daad2-0001-- 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]
Suggestions on Allaire Tech Support problem
Hello, Our company is having a difficult time getting an issue resolved with Allaire tech support. We initially called Tech support on Oct 9th and did the whole credit card thing talk to someone. Left a message waited... waited... called back left another message... still nothingFinally 9 days later we got some communication from Allaire. It turns out that our problem was in fact verified to be a bug (Bug # 19980). Basically the bug is in the Linux versions of CF 4.51 (works fine in windows, not sure about Solaris), that deals with a secure cfhttp post and kills the server. They've verified that it has something to do with ssl version incompatibilities between the Linux cf server and the other server. According to the Allaire bug system, it hasn't been verified as a bug, I assume the developers must verify this also, and we cannot get any info from Allaire as to an ETA for fixing this or if they even plan to fix it. With SP2 in RC stage, it's not looking good for that service pack. This is a very, very important part of a big application that we are doing (live payment processing for an ecommerce mall) and is not something that we can really work around without doing some sort of a hack with a windows box and with our current configuration it would make things very ugly. Anyway, the people that pay the bills around here are getting pretty upset about this problem, and we haven't been able to get anywhere with Allaire. Any suggestion? People at Allaire that we can contact to get this resolved? You can contact me off list if you'd prefer. Thanks -Erik [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: SQL Server error
I had a similiar error once. That problem was that the single user option had gotten checked. That is under properties the access can be set to DBO use only - Single user - Read only Jeff Craig - Original Message - From: "Al Musella, DPM" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Thursday, November 16, 2000 10:11 AM Subject: SQL Server error I am getting 2 strange errors.. ODBC Error Code = 37000 (Syntax error or access violation) | [Microsoft][ODBC SQL Server Driver][SQL Server]Database 'thethin' is already open and can only | have one user at a time. | ODBC Error Code = S1T00 (Timeout expired) [Microsoft][ODBC SQL Server Driver]Timeout expired The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (69:1) to (69:89) in the template file D:\THETHIN\FAQS.CFM. = the query is simple: cfquery name="list" datasource="#SQLds#" username="#sqluser#" password="#sqlpassword#" select id,submitted,q,score from faq where (approved = 1) cfif category is not '-1' and cfif findnocase('1', category)category like '%1%'cfset more=1/cfif cfif findnocase('2', category)cfif more is 1 or cfelsecfset more=1/cfifcategory like '%2%'/cfif cfif findnocase('3', category)cfif more is 1 or cfelsecfset more=1/cfifcategory like '%3%'/cfif cfif findnocase('4', category)cfif more is 1 or cfelsecfset more=1/cfifcategory like '%4%'/cfif cfif findnocase('5', category)cfif more is 1 or cfelsecfset more=1/cfifcategory like '%5%'/cfif cfif findnocase('6', category)cfif more is 1 or cfelsecfset more=1/cfifcategory like '%6%'/cfif /cfif cfif sortby is 'score' order by score desc,submitted desc cfelse order by submitted desc,score desc /cfif /cfquery === This is SQL server 7, Cold fusion 4.5.1 - on separate boxes.. There has been no change to the cold fusion templates on this website in about 6 months. These errors started popping up very infrequently a few weeks ago.. Maybe once every few days. When the first error happens, I have to reboot the cold fusion server and it works again. The second one clears itself quickly and works again. The only change I see is a increase in the database size, as well as an increase in the number of visitors to the site. When this happens, other databases still work. That query takes only about 200ms. How could it time out? Any ideas? I do not have any other programs opening it - the servers are co-located, and do not even have MS access installed. I do use MTS packages to copy the database to my home computer a few times a day.. would that exclusively lock the table and cause problems? Thanks Al Musella, DPM A1webs.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]
rounding to first decimal
I thought this would be simple. How can round a long integer eg: 2.146752 to the first decimal point? 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: CF Studio Server 5.0 Costs? :: Budget :: Next Year
Hey man, dont hesitate to go to the source. Call Allaire. jon - Original Message - From: "Paul Ihrig" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Thursday, November 16, 2000 10:41 AM Subject: CF Studio Server 5.0 Costs? :: Budget :: Next Year 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] 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?
Ok, is everyone here special?I haven't seen anything about UD4 except for Macromedia's page, which says coming soon. Anyone have a link? jon - Original Message - From: "Greg Wolfinger" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Wednesday, November 15, 2000 10:05 PM Subject: Re: Dreamweaver Ultradev 4 - any good? 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] 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: Certified ColdFusion Developers
Just curious how the Brainbench Certification is looked at, is this a respected certification? -Adrian -Original Message- From: Lon Lentz [mailto:[EMAIL PROTECTED]] How about CF_Cert? If you have more than one Cf_Cert By="Allaire,Brainbench" 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]
read binary?
I am looking at CFFILE action="ReadBinary" I haven't ever used this and can't think of any situation where I would. Anyone know of a case where I may need to read a binary file with CF rather than C++? Thank you for any input... 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!!!!
Known Netscape 6 bug list. http://www.richinstyle.com/bugs/mozilla.html jon - Original Message - From: "Robert Everland" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Thursday, November 16, 2000 9:04 AM Subject: RE: Netscape 6 out UGH 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] 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: Certified ColdFusion Developers
If we did not make it to the last CF Conference, how can we get certified in our local area. My area is in Houston, Texas and how much is the certification test. Rob From: "Lon Lentz" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: RE: Certified ColdFusion Developers Date: Thu, 16 Nov 2000 11:35:36 -0500 MIME-Version: 1.0 Received: from [207.31.122.140] by hotmail.com (3.2) with ESMTP id MHotMailBBDD6D21005DD82197DBCF1F7A8C0AD70; Thu Nov 16 10:06:35 2000 Received: from ns2.getlists.com ([64.244.183.74]) by www.houseoffusion.com (Post.Office MTA v3.5.3 release 223 ID# 0-54969U100L100S0V35) with SMTP id com for [EMAIL PROTECTED]; Thu, 16 Nov 2000 11:39:43 -0500 Received: from LPL ([172.16.5.24]) by alvion.com ( IA Mail Server Version: 3.2.1. Build: 1084 ) ) ; Thu, 16 Nov 2000 11:32:21 -0500 From [EMAIL PROTECTED] Thu Nov 16 10:08:14 2000 Message-ID: [EMAIL PROTECTED] In-Reply-To: [EMAIL PROTECTED] Importance: Normal Return-Path: [EMAIL PROTECTED] How about CF_Cert? If you have more than one Cf_Cert By="Allaire,Brainbench" Lon Lentz Applications Developer CyberEntomologist - Alvion Technologies DataWarehousing and List Sales - Market Your Lists on the Net! [EMAIL PROTECTED] 941-574-8600 Ext. 210 Just out of curiosity... since I notice that most of us who passed the Certification have adjusted their Sigs to say "Certified ColdFusion Developer", wouldn't it be easier to use an abbreviation? 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] _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.msn.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: export excel charts - COM and CF (vs MSChart?)
I don't know what this is worth since I did not implement it myself. A friend told me that he created an object that allowed him to mime the HTML data from the CF Web Site to Excel by creating a macro through the GUI and then using that MACRO with CFOBJECT to create a function that can take the format and color features between Excel and CF program intact. I will be trying to implement this soon, so if this is asked again and you all are still stuck. I will most my implementation. Rob From: Rich Wild [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: RE: export excel charts - COM and CF (vs MSChart?) Date: Thu, 16 Nov 2000 15:16:29 - MIME-Version: 1.0 Received: from [207.31.122.140] by hotmail.com (3.2) with ESMTP id MHotMailBBDD5999001D40042A08CF1F7A8C098A27; Thu Nov 16 08:45:59 2000 Received: from bluemountain.e-mango.com ([195.217.219.253]) by www.houseoffusion.com (Post.Office MTA v3.5.3 release 223 ID# 0-54969U100L100S0V35) with ESMTP id com for [EMAIL PROTECTED]; Thu, 16 Nov 2000 10:32:33 -0500 Received: by bluemountain.e-mango.com with Internet Mail Service (5.5.2650.21)id W1251NWQ; Thu, 16 Nov 2000 15:16:37 - From [EMAIL PROTECTED] Thu Nov 16 08:46:46 2000 Message-ID: [EMAIL PROTECTED] Return-Path: [EMAIL PROTECTED] 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
Conference materials available?
I had heard that materials presented at the DC conference such as code examples, slides, etc. would be made available in some form after the conference concluded. Does anyone know anything about this or where these materials might be obtained? TIA, Stephen 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 CF Tuning Class
I didn't take the class, but I attended the DevCon2000 session where 2 Allaire techs gave a presentation on how they tune. They surprised me by saying they tested "Limit simultaneous requests" settings up to 30 or so. I'd never before heard anyone go that high. Another presenter at DevCon200 suggested the 3 to 5 we've all heard (with 3 for CF-intensive apps and 5 for DB-intensive apps). best, paul At 11:42 AM 11/16/00 -0500, you wrote: Has anyone taken the 2 day CF Tuning class? How is it oriented? What's the emphasis on? Coding or server settings? Did it help you make things run smoother and/or faster? 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 include ampersand in NT command line SET statement?
Hmm, you can use the urlencoded value ("%26"). D:\set QUERY_STRING=one=1%26two=2 D:\echo %QUERY_STRING% one=1%26two=2 -Original Message- From: Lawrence B. Afrin, M.D. [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 15, 2000 1:29 PM To: CF-Talk Subject: How to include ampersand in NT command line SET statement? This is a multi-part message in MIME format. --E7774448A625D015C2801112 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Howdy -- For reasons not worth going into, I'm trying to run a CF template via a SQL Server trigger doing an "exec master..xp_cmdshell batchfile.cmd" where the batchfile invokes cfml.exe to run the template. My problem is that I need to feed the template a query string with multiple parameters. I know that, theoretically, the way to do this is to set the QUERY_STRING environment variable to the query string I want (e.g., "SET QUERY_STRING=one=1two=2three=3") before running cfml.exe, but my problem is that the NT cmd interpreter is picking up the ampersand as a special character and terminating the SET at the first ampersand. Is there some special "escape" syntax that'll let me include an ampersand as part of the value for a SET statement? There are no clues in HELP SET. I've tried backslashes, double and single quotes, and other things, but I can't seem to find the magic combination, and I know there must be a way to do this. Anybody? -- Larry Afrin, M.D. Medical University of South Carolina [EMAIL PROTECTED] --E7774448A625D015C2801112 Content-Type: text/x-vcard; charset=us-ascii; name="afrinl.vcf" Content-Transfer-Encoding: 7bit Content-Description: Card for Lawrence B. Afrin, M.D. Content-Disposition: attachment; filename="afrinl.vcf" begin:vcard n:Afrin, M.D.;Lawrence tel;fax:843-792-3200 tel;work:843-792-4271 x-mozilla-html:FALSE org:Hollings Cancer Center and the Division of Hematology/Oncology, Medical University of South Carolina version:2.1 email;internet:[EMAIL PROTECTED] title:Assistant Professor of Medicine adr;quoted-printable:;;Division of Hematology/Oncology, CSB903=0D=0AP.O. Box 250623, 96 Jonathan Lucas Street;Charleston;SC;29425;USA x-mozilla-cpt:;0 fn:Afrin, M.D., Lawrence end:vcard --E7774448A625D015C2801112-- 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]
OT: Java/ActiveX ComboBox, anyone?
Does anyone out there have a good Java/ActiveX ComboBox and an example of how to use it on a page? I need a ComboBox that allows you to type in the edit control and sort the list items. I already know about the custom tag that creates the JavaScript "ComboBox" with query results, but I've got too many list items to use it. The JavaScript is way too slow, anyway. I've found a couple of ActiveX ComboBoxes, but they all suck. I'd be very grateful if you sent me a link, or example source for one that you like/use. Thanks! Byron 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]
weird error
I have a form field on a site with two select boxes for month and year. For some strange reason, on odd occasions the select boxes fields do not get posted. I cannot for the life of me recreate this error. The only odd thing I can see is the browser is listed as Cold Fusion 4.0...? jon Error resolving parameter MONTH ColdFusion was unable to determine the value of the parameter. This problem is very likely due to the fact that either: 1.. You have misspelled the parameter name, or 2.. You have not specified a QUERY attribute for a CFOUTPUT, CFMAIL, or CFTABLE tag. The error occurred while evaluating the expression: expdate = "#month##year#" The error occurred while processing an element with a general identifier of (CFSET), occupying document position (2:1) to (2:33). Date/Time: 11/15/00 09:15:37 Browser: ColdFusion 4.0 Remote Address: 216.136.29.251 Template: e:\www\cookbrothers.com\shoppingcart\order\completeorder.cfm 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
--openmail-part-3530c1cd-0001 Content-Type: text/plain; charset=ISO-8859-1 Content-Disposition: inline ;Creation-Date="Thu, 16 Nov 2000 13:11:11 -0600" Content-Transfer-Encoding: 8bit I just finished taking the test this morning. Definitely know your arrays and structures and some database knowledge is helpful as well. Also don't be in a rush, I stopped in on my way to work with only about 30 minutes to run in and take the exam. I passed which is what counts but probably could have scored higher if I would have had more time. Oh and to answer your question number 3 on if you can go back at all, yes it is computer based and they give you the option with each question to come back at the end and review it to make changes. You can also mark it to add comments to. Personally some of the questions where they ask what is the "best" way to do things I found a little irritating. Whats best for you might not be best for me. Just my 2 cents of course... Misty CFCustomtags.com -Original Message- From: webmaster [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 16, 2000 10:56 AM To: cf-talk Cc: webmaster Subject: RE: Certification Exam There is a free 40 question CF 4.5 Certification exam available at brainbench.com. I have been told that if you score at least a 4 (on a 5 point system), you have a good chance of passing the Allaire test. Good luck! Shane Witbeck www.digitalsanctum.com -- Original Message -- From: "Mark W. Breneman" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Thu, 16 Nov 2000 09:39:14 -0600 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 g 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 g 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
Resolved: including ampersand in NT command line
This is a multi-part message in MIME format. --E6E02FE204B286EA6F976EC8 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Howdy, folks -- For those of you who took time to think about my problem (how to include an ampersand on the NT command line, so that I can pass (via the QUERY_STRING environment variable) a whole list of parameters to a CF template being run by a command-line invocation of CFML.EXE), thanks anyway, but I finally found the answer buried in Microsoft's knowledge base. Since the ampersand separates multiple commands on the NT command line, I knew there had to be some way to "escape" the character, but nothing I tried worked. Turns out the escape character simply is the caret (^), which is also used to transform A through Z into Control-A through Control-Z. Thus: SET QUERY_STRING=one=1^two=2 will get you QUERY_STRING=one=1two=2 Thanks again. -- LBA --E6E02FE204B286EA6F976EC8 Content-Type: text/x-vcard; charset=us-ascii; name="afrinl.vcf" Content-Transfer-Encoding: 7bit Content-Description: Card for Lawrence B. Afrin, M.D. Content-Disposition: attachment; filename="afrinl.vcf" begin:vcard n:Afrin, M.D.;Lawrence tel;fax:843-792-3200 tel;work:843-792-4271 x-mozilla-html:FALSE org:Hollings Cancer Center and the Division of Hematology/Oncology, Medical University of South Carolina version:2.1 email;internet:[EMAIL PROTECTED] title:Assistant Professor of Medicine adr;quoted-printable:;;Division of Hematology/Oncology, CSB903=0D=0AP.O. Box 250623, 96 Jonathan Lucas Street;Charleston;SC;29425;USA x-mozilla-cpt:;0 fn:Afrin, M.D., Lawrence end:vcard --E6E02FE204B286EA6F976EC8-- 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
you misunderstand I have the login system created where it detects where login sessions are active or not I am trying to determine how to find out the user name that is logged in at a given time - Original Message - From: "Jake Hileman - Patmos" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Friday, November 17, 2000 3:08 AM Subject: Re: How To Determine Logged In Users Actually, the way I do it is set a cookie. Then at the top of all the pages that are "login" protected, I check for the cookie.. if it exists I know they are logged in since the cookie can't be set unless they are successfully login. United Federation of Slow (not very smart) CF Programmers, Jake - Original Message - From: "Shawn Regan" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Thursday, November 16, 2000 10:50 AM Subject: RE: How To Determine Logged In Users 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 !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN" HTML HEAD META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; = charset=3Diso-8859-1" META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = 5.5.2650.12" TITLERE: How To Determine Logged In Users/TITLE /HEAD BODY PFONT SIZE=3D2You could always insert the user info into a table = when then login./FONT /P PFONT SIZE=3D2Shawn Regan/FONT BRFONT SIZE=3D2[EMAIL PROTECTED]/FONT BRFONT SIZE=3D2Cold Fusion Developer/FONT BRFONT SIZE=3D2Pacific Technology Solutions/FONT /P BR PFONT SIZE=3D2-Original Message-/FONT BRFONT SIZE=3D2From: AustralianAccommodation.com Pty. Ltd./FONT BRFONT SIZE=3D2[A = HREF=3D"mailto:[EMAIL PROTECTED]"mailto:director@Aus= tralianAccommodation.com/A]/FONT BRFONT SIZE=3D2Sent: Wednesday, November 15, 2000 12:51 PM/FONT BRFONT SIZE=3D2To: CF-Talk/FONT BRFONT SIZE=3D2Subject: How To Determine Logged In Users/FONT /P BR PFONT SIZE=3D2Just 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 wantingnbsp; to try and take it to = the next step so that I can see who exactly is logged in /FONT/P BR PFONT SIZE=3D2Kind Regards/FONT /P PFONT SIZE=3D2Claude Raiola (Director)/FONT BRFONT SIZE=3D2AustralianAccommodation.com Pty. Ltd./FONT BRFONT SIZE=3D2Email: [EMAIL PROTECTED]/FONT BRFONT SIZE=3D2Developers Of:/FONT BRFONT = SIZE=3D2nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; = Website: www.AustralianAccommodation.com/FONT BRFONT = SIZE=3D2nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; = Website: www.AccommodationNewZealand.com/FONT /P BR PFONT = SIZE=3D2---= -/FONT BRFONT SIZE=3D2Archives: A = HREF=3D"http://www.mail-archive.com/cf-talk@houseoffusion.com/" = TARGET=3D"_blank"http://www.mail-archive.com/cf-talk@houseoffusion.com/= /A/FONT BRFONT SIZE=3D2Unsubscribe: A = HREF=3D"http://www.houseoffusion.com/index.cfm?sidebar=3Dlists" = TARGET=3D"_blank"http://www.houseoffusion.com/index.cfm?sidebar=3Dlists= /A or send a message with 'unsubscribe' in the body to = [EMAIL PROTECTED]/FONT/P /BODY /HTML --_=_NextPart_001_01C04FE4.F1C0BA90-- -- -- Archives:
RE: cd-rom based applications
Eh, care to share how ? :-) ~J -Original Message- From: Neil Clark [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 16, 2000 5:29 PM To: CF-Talk Subject: RE: cd-rom based applications yes, I have done a fully searchable (RAM-updateable) database on a CD-ROM good experience and quite fun to do... N ! --- Neil Clark 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
Any idea how much that runs? -Original Message- From: Neil Clark [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 16, 2000 3:12 AM To: CF-Talk Subject: RE: SQL Server Licesning yep you can get an unlimited internet connectivity license. ! --- Neil Clark Senior Web Applications Engineer mcb digital Tel. +44 (0)20 8941 3232 Tel. +44 (0)20 8408 8131 [Direct] 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] 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: CFFTP - CFLOOP Prob.
Richard: When using CFFTP the connection attribute is used so you don't have to retype a lot of the other attributes over and over again. It essentially saves the connection data for you which is quite useful. However if you try to connect to another server and specify the same connection you'll run into problems as it will try to use the old connection data. I think an easy solution to your problem is to make your connection attribute use a dynamic name. You could do this by tacking a random number on to the connection name or by using the name/ip of the server itself as the connection name. Let me know if this helps. Andrew Hewitt Web Application Developer webworld studios, inc. www.wwstudios.com -Original Message- From: Richard Ramos [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 16, 2000 12:16 PM To: CF-Talk Subject: CFFTP - CFLOOP Prob. I can't see what I am doing wrong. I have the index page where the user types in the name of the directory, chooses the file to upload finally selects which servers to send it to via checkbox. Since there is a possibility of multiple servers, I use CFLOOP to loop throught the delimitered list. This works fine and all. But if I select any server minus the first one, I get an error with CFFTP. I know that the CFFTP code works and that the list is understandable. Any clues here? Thanks in advance. Richard Ramos Network Administrator Softitler Net, Inc. www.softitler.com [EMAIL PROTECTED] index3.cfm html body cfquery name="site" datasource="upload" SELECT * FROM Servers /cfquery cfloop index="servername" list="#session.servername#" cfoutput cfif #site.name# IS "#servername#" cfftp connection="ftp" action="open" username="#site.username#" password="#site.password#" server="#site.address#" /cfif cfftp connection="ftp" action="changedir" directory="SomeDir" cfftp connection="ftp" action="createdir" directory="#session.directory#" failifexists="Yes" cfftp connection="ftp" action="changedir" directory="#session.directory#" cfftp connection="ftp" action="putfile" localfile="C:\Inetpub\ftp\SomeDir\#session.directory#\#session.filename#" remotefile="#session.filename#" stoponerror="yes" transfermode="binary" cfftp connection="ftp" action="close" cfoutput #servername# uploadedbr /cfoutput /cfloop /body /html -- 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: append variable to a variable??
Using SetVariable is better cfset setvariable("Edname" numvar, "test") Justin -Original Message- From: S R [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 16, 2000 5:29 PM To: CF-Talk Subject: RE: append variable to a variable?? Thanks Everyone!! Sal From: "Andrew" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: RE: append variable to a variable?? Date: Wed, 15 Nov 2000 22:40:23 -0500 Sal: Sure there is. try this for instance: cfset numvar = "2" cfset "Edname#numvar#" = "test" cfoutputEdname2 is #Edname2#/cfoutput How's that? Andrew Hewitt Web Application Developer webworld studios, inc. www.wwstudios.com cf_certified/ -Original Message- From: S R [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 15, 2000 7:56 PM To: CF-Talk Subject: append variable to a variable?? Is there anyway to do this? I have six variables in my database they are called: EdName1, EdName2, etc. It would be awesome if I could set a variable that could dynamically change the number of each variable for me so I don't have to hard code the variable. For example (I know this doesn't work but it will get my point across: cfset numvar = "2" #EdName#numvar## = EdName2 Thanks for your help Sal _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.msn.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] _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.msn.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: Locking while deleting
They are not resident beyond the single request, but they stay alive for the entire request, even in custom tag calls. Think of them in terms of a global variable for the life of a single request. Kevin [EMAIL PROTECTED] 11/16/00 09:35AM directly analogous to constants; I like to use the Request scope for constants, though, as it's not stored in memory and avoids the need for locking. Where are they stored then? -- 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] 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]
CFLoop problem
Hi! I've got this weird problem that I cannot solve. I get the same answers on each line. CFOUTPUT query="table" cfset ID = evaluate("#FORM.hid#ID") cfloop query="Lang" cfset txt=evaluate('table.#FORM.hlang##Lang.Abrev#') td class="txt9yellow"#txt#/td /cfloop /CFOutput I get: 1 Producteur Producer Productor 2 Producteur Producer Productor 3 Producteur Producer Productor 4 Producteur Producer Productor 5 Producteur Producer Productor 6 Producteur Producer Productor Instead of: 1 ProducteurProducer Productor 2 CommercialisationMarketingComercialización 3 Sous-traitantSubcontractor 4 Entreprise de services Service provider 5 Organisme gouvernemental Government agency 6 Autre Other Any ideas? 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 tell between MS 2000, 97, 95, etc. with Cold Fusion
I wanted to allow users to upload various file of similar formats that differ in versions. Is there a way to this. Most users are not willing to do a "Save As" on file so I have to handle this on the CF end... IF POSSIBLE! Anyone know a way to distinguish between different file formats such as word 2000, and 97. Are there COM object that give this information? Are ther e other ways? Any help on this subject would help? Does not have to apply soley to MS products (that was just an example)? PLEASE HELP!!! Jerry 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, I don't think that CF can do this. What you want is a stand alone app that can access a database. Probably the best way to do this is with M$ Director with a database plugin. larry -- Larry C. Lyons ColdFusion/Web Developer EBStor.com 8870 Rixlew Lane, Suite 201 Manassas, Virginia 20109-3795 tel: (703) 393-7930 x253 fax: (703) 393-2659 http://www.ebstor.com http://www.pacel.com email: [EMAIL PROTECTED] Chaos, panic, and disorder - my work here is done. -- -Original Message- From: Shawn Regan [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 16, 2000 9:53 AM To: CF-Talk Subject: RE: [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_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 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
Hey I just passed the Brainbench CF 4.5 certification. What exactly does that mean? Can I call myself a Certified ColdFusion Developer now or do I need to pass Allair's test for that title?? Thanks, Rich -Original Message- From: David E. Crawford [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 16, 2000 12:41 PM To: CF-Talk Subject: Re: Certification Exam One thing to keep in mind is that everyone who has taken the exam is under a non-disclosure agreement with regards to the exam. While a high level overview of the areas to study is reasonable, going much further than that is not appropriate. DC -- David E. Crawford Certified ColdFusion Developer Actek, Inc. 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: cd-rom based applications
You can do that with Lingo, using their FileIO library. Unforuntately you can't pick up director and Lingo overnight. -Original Message- From: Shawn Regan [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 16, 2000 7:55 AM To: CF-Talk Subject: RE: 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_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 !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN" HTML HEAD META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; = charset=3Diso-8859-1" META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = 5.5.2650.12" TITLEcd-rom based applications/TITLE /HEAD BODY PFONT SIZE=3D2has anyone done a cd-rom application for any client = that had to have searching functions? If so how did you go about doing = it?/FONT/P PFONT SIZE=3D2Shawn Regan/FONT BRFONT SIZE=3D2[EMAIL PROTECTED]/FONT BRFONT SIZE=3D2Cold Fusion Developer/FONT BRFONT SIZE=3D2Pacific Technology Solutions/FONT /P Pnbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;=20 /P /BODY /HTML --_=_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 !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN" HTML HEAD META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; = charset=3Diso-8859-1" META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = 5.5.2650.12" TITLERE: cd-rom based applications/TITLE /HEAD BODY PFONT SIZE=3D2I 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./FONT/P PFONT SIZE=3D2Shawn Regan/FONT BRFONT SIZE=3D2[EMAIL PROTECTED]/FONT BRFONT SIZE=3D2Cold Fusion Developer/FONT BRFONT SIZE=3D2Pacific Technology Solutions/FONT /P BR PFONT SIZE=3D2-Original Message-/FONT BRFONT SIZE=3D2From: Paul Mone [A = HREF=3D"mailto:[EMAIL PROTECTED]"mailto:[EMAIL PROTECTED]/A]/FONT= BRFONT SIZE=3D2Sent: Wednesday, November 15, 2000 9:17 PM/FONT BRFONT SIZE=3D2To: CF-Talk/FONT BRFONT SIZE=3D2Subject: RE: cd-rom based applications/FONT /P BR PFONT SIZE=3D2What are you using to build the application?/FONT /P PFONT SIZE=3D2If you're using Director, I'm pretty sure you can = accompplish something like/FONT BRFONT SIZE=3D2this via Lingo.nbsp; Then again, this all depends = on what you're searching?/FONT /P PFONT SIZE=3D2If you're searching files, you'll have to consider = the different/FONT BRFONT SIZE=3D2platforms/filesystems that your CDROM will be = running on./FONT /P PFONT SIZE=3D2-Original Message-/FONT BRFONT SIZE=3D2From: Shawn Regan [A = HREF=3D"mailto:[EMAIL
RE: Certification Exam
OH goodie got a 4.3 there is hope for me yet... -Original Message- From: Shane Witbeck [SMTP:[EMAIL PROTECTED]] Sent: Thursday, November 16, 2000 11:56 AM To: CF-Talk Subject: RE: Certification Exam There is a free 40 question CF 4.5 Certification exam available at brainbench.com. I have been told that if you score at least a 4 (on a 5 point system), you have a good chance of passing the Allaire test. Good luck! Shane Witbeck www.digitalsanctum.com -- Original Message -- From: "Mark W. Breneman" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Thu, 16 Nov 2000 09:39:14 -0600 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 g 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 g 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. **
Re: [cd-rom based applications]
Whoops my bad. That should have been MacroMedia Director, not M$. -- Larry C. Lyons ColdFusion/Web Developer EBStor.com 8870 Rixlew Lane, Suite 201 Manassas, Virginia 20109-3795 tel: (703) 393-7930 x253 fax: (703) 393-2659 http://www.ebstor.com http://www.pacel.com email: [EMAIL PROTECTED] Chaos, panic, and disorder - my work here is done. -- "Larry C. Lyons" wrote: Shawn, I don't think that CF can do this. What you want is a stand alone app that can access a database. Probably the best way to do this is with M$ Director with a database plugin. larry 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: RegEx help PLEASE hurry...
Firstly, I'm pretty sure you don't need to escape a space. Secondly, no question mark is required, because I want to replace exactly one character followed by exactly one space with just the character. And thirdly, you don't have to specify that the character is not a space, because a space gets turned into two spaces, remember, so also needs a space stripped. David Cummins Rob Keniger wrote: on 11/16/00 10:50 AM, David Cummins at [EMAIL PROTECTED] wrote: cfset blah=REReplace(blah,"(.) ","\1","ALL") This is the regExp syntax, but you would need to use this regexp to do the job properly: cfset blah=REReplace(blah,"([^\ .]?\ ?)\ ","\1","ALL") -- Rob Keniger big bang solutions mailto:[EMAIL PROTECTED] http://www.bigbang.net.au 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]
OT: MS Access query
I'm trying to write an MS Access query like this: SELECT Table1.Title FROM Table1, Table2 WHERE Table1.Title = Table2.Title The problem is that the Title fields' values may not be exactly equal. Table2.Title may have additional text in parentheses at the end. For example: Table1.Title = "The cow jumped over the moon" Table2.Title = "The cow jumped over the moon (really)" I thought of using the LIKE operator, but it appears that LIKE only works when comparing a field and a string, not two fields. If I'm wrong, please tell me the syntax. Any other suggestions on how to do this query? Thanks. -David 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: testing process
No formal test process that I know of, usually I just turn the Village idiot in the company loose on my application and see what happens :-) Seriously though, testing software is strictly proprietary based on what the application is built to do, but answer the following questions when testing: 1) How well does this system perform under light load, moderate load, heavy load, whatthehell load? 2) If I enter any out of bounds information into an application (through either form or URL variables), what will happen? 3) Any security risks that you know of? High risk tags should be secured very tightly against any such data, aka CFFILE, CFDIRECTORY, CFREGISTRY (please on this one!), CFCONTENT and others 4) Broken links (duh) 5) Typos (duh) 6) Look and feel errors (ranging from as simple to a spellcheck to interface or graphic looking wrong) and on and on and on. In short, pick what's appropriate and go crazyif your application is live already, feel free to email me off-list with a URL, I love trying to break ppl's apps and websites in my spare time and I'll charge my low rate of 0$/hr (note this is a hobby, not a job...) :-) Gregory Harris Web Developer Stirling Bridge Group LLC - Original Message - From: "Craig M. Rosenblum" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Thursday, November 16, 2000 9:24 AM Subject: testing process Does anybody know of a resource to help test code before releasing? Like a checklist or process? I need help learning to better test my code... -- -- 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] Structure your ColdFusion code with Fusebox. Get the official book at https://secure.houseoffusion.com Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: rounding to first decimal
try this: RoundedValue = Round(10 * Value)/10 [EMAIL PROTECTED] 11/16/00 09:17AM I thought this would be simple. How can round a long integer eg: 2.146752 to the first decimal point? 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] Structure your ColdFusion code with Fusebox. Get the official book at https://secure.houseoffusion.com Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists