JRun closed connection
Heya All, I've got a high volume site that's constantly giving me the following error: --- Server Error The server encountered an internal error and was unable to complete your request. JRun closed connection. --- Stopping and restarting CFMX will make the error go away, but it comes back after a few hours. I've updated the JDBC drivers to the one supplied my Microsoft.. does anyone know other reasons why this might be happening? Its running CFMX 6.1 on a Win 2003 Server. Thanks... --- Ryan Sabir Newgency Pty Ltd 2a Broughton St Paddington 2021 Sydney, Australia Ph (02) 9331 2133 Fax (02) 9331 5199 Mobile: 0411 512 454 http://www.newgency.com/index.cfm?referer=rysig [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFMX 6.1, Apache WinXP Pro
Should you not have installed ColdFusion to Apache and not as a standalone installation (on port 8500)? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, 8 October 2003 6:19 AM To: CF-Talk Subject: CFMX 6.1, Apache WinXP Pro I've done several searches on the web for this problem with no results... I find it hard to believe I'm the only one having this problem. Here's what I've done: 1. Installed Apache 2.0.47 for windows. The installation works, going to http://localhost shows the default Apache index page. 2. Installed ColdFusion MX 6.1 as Standalone. This installation also works, admin at http://localhost:8500/CFIDE/Administrator allows login to CFMX Admin. 3. Opened the Apache httpd.conf file and added the following: Alias /CFIDE C:/CFusionMX/wwwroot/CFIDE Alias /cfide C:/CFusionMX/wwwroot/CFIDE Directory C:/CFusionMX/wwwroot/CFIDE Options Indexes FollowSymLinks MultiViews IncludesNoExec AddOutputFilter Includes html AllowOverride None Order allow,deny Allow from all /Directory 4. Restarted Apache 5. Edited c:\cfusionmx\bin\connectors\Apache_connector.bat to reflect path to Apache conf director 6. Verified that both Apache and CFMX 6.1 were running 7. Ran the Apache_connector.bat --- here's where the problem is: Created file C:\CFusionMX\runtime\lib\wsconfig\jrunwin32.dll Could not connect to any Jrun/ColdFusion servers on host localhost. Possible causes: Server not running -Start Macromedia JRun4 or ColdFusion MX server Server running -JNDI listen port in jndi.properties blocked by TCP/IP filtering or firewall on server -host restriction in security.properties blocking communications with server Press any key to continue... What am I doing wrong? I have no firewall installed and this is a standard Windows XP Professional installation. Has anyone else had these issues? Any ideas? I ran into this same problem a while back with IIS, and finally gave up and used the built-in server. But this time I really need to use Apache. Thanks, Jonathan __ Jonathan Mauney Web Application Developer / Manager, Digital Media Properties 1110 WBT AM / 107.9 the LINK (WLNK-FM) / JP Radio Network Jefferson-Pilot Communications Co. www.wbt.com www.1079thelink.com www.bobandsheri.com www.mattandramona.com www.pamstoneshow.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Client variable initialization errors in cfapplication
On Tuesday 07 Oct 2003 17:55 pm, Jeremy Bruck wrote: Thomas, Here is Line 87 in the Application.cfm... Line 84: cfapplication name=#request.applicationName# cfapplication should be at the top of your Application.cfm, shouldn't it ? What's above it ? -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: FYI
On Tuesday 07 Oct 2003 20:29 pm, Brad Roberts wrote: That's exactly what I thought.Seems like developers should be able to sue for the time it's going to take us to update our code.I'd say our combined time would cost somewhere in the ballpark of $520 million, give or take. Nope you can't, read the license you agreed to when you used IE. Thought the is a case going on atm, which seeks to have restrictive licenses like MS's ruled illegal. -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
[Macromedia][SQLServer JDBC Driver] No more data available to read
Alan, Did you ever find out anything about the error that reads: [Macromedia][SQLServer JDBC Driver] No more data available to read Or anyone else? Also I have the August 1 drivers that resolve the 100 percent cpu problem. Thanks, Calvin [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: returning an image via cfhttp
Ok I tried this, CFHTTP METHOD=GET URL="" PROTECTED]/GetMap.asp CFHTTPPARAM TYPE=FORMFIELD VALUE=#XML_DOC# NAME=xmlparams /CFHTTP CFCONTENT TYPE=image/gifCFOUTPUT#toString(CFHTTP.FileContent)#/cfoutput/CFCONT ENT but it still does not show the image, I tried writing the image to disk successfully, CFHTTP METHOD=GET URL="" PROTECTED]/GetMap.asp PATH=\\physical_root\ FILE=test.gif CFHTTPPARAM TYPE=FORMFIELD VALUE=#XML_DOC# NAME=xmlparams /CFHTTP So there seems to be some problem with my CFCONTENT method. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Looping through a list, setting each listItem to a column
Hello Everybody, I am trying to read a log file and display the results on a webpage. Here is what the log file looks. DateTime User Webpage Visited Status 2003/09/01 11:52:15, User\testUser1, /wwwroot/code/article_1.shtml, OK 2003/09/01 11:53:35, User\testUser2, /wwwroot/code/article_2.shtml, OK 2003/09/01 12:04:55, User\testUser3, /wwwroot/code/article_3.shtml, OK 2003/09/01 12:04:58, User\testUser4, /wwwroot/code/article_4.shtml, OK 2003/09/01 12:05:11, User\testUser5, /wwwroot/code/article_5.shtml, OK Here is the code to read the log file cffile action=""> file=C:\myLogFile.log variable=fOutput Take a look at the code below. As you can see I am looping through the list, finding the Carriage Return character. This is all fine, what I want to be able to do is loop through each individual row which is again a comma seprated list (2003/09/01 11:52:15, User\testUser1, /wwwroot/code/article_1.shtml, OK) append each list item in a temp table column. cfset qTmp=QueryNew(DateTime,User,Document,Status) cfloop list=#fOutput# index=lIndex delimiters=#Chr(10)# cfset i = 0 cfset tmpstart=listLen(lIndex,',') cfset tmp=QueryAddRow(qTmp,listLen(lIndex,',')) cfloop list=#lIndex# index=innerList delimiters=, cfscript tmp=QuerySetCell(qTmp,DateTime, innerList); tmp=QuerySetCell(qTmp,User, innerList); tmp=QuerySetCell(qTmp,Document, innerList); tmp=QuerySetCell(qTmp,Status, innerList); /cfscript cfset i = i + 1 /cfloop /cfloop cfquery name=lquery dbtype=query SELECT DISTINCT * FROM qTmp /cfquery The code above is not right, and I've tried hard to figure out how to loop through the inner comma separated list and assign the value to the query column. Can somebody please show me how to do this. I know my explaination is not very clear but I hope you know what I'm trying to do. If you think there is an easier way to do this then please let me know. Please can somebody help Regards John __ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Looping through a list, setting each listItem to a column
Try this.. cfset qTmp=QueryNew(DateTime,User,Document,Status) cfloop list=#fOutput# index=lIndex delimiters=#Chr(10)# cfset i = 0 cfset tmpstart=listLen(lIndex,',') cfset tmp=QueryAddRow(qTmp,listLen(lIndex,',')) cfloop list=#lIndex# index=innerList delimiters=, cfscript tmp=QuerySetCell(qTmp,DateTime, listGetAt(innerList,1)); tmp=QuerySetCell(qTmp,User, listGetAt(innerList,2)); tmp=QuerySetCell(qTmp,Document, listGetAt(innerList,3)); tmp=QuerySetCell(qTmp,Status, listGetAt(innerList,4)); /cfscript cfset i = i + 1 /cfloop /cfloop The listgetat function inside your inner loop is the only change i've made -Original Message- From: Allan Clarke [mailto:[EMAIL PROTECTED] Sent: 08 October 2003 11:16 To: CF-Talk Subject: Looping through a list, setting each listItem to a column Hello Everybody, I am trying to read a log file and display the results on a webpage. Here is what the log file looks. DateTime User Webpage Visited Status 2003/09/01 11:52:15, User\testUser1, /wwwroot/code/article_1.shtml, OK 2003/09/01 11:53:35, User\testUser2, /wwwroot/code/article_2.shtml, OK 2003/09/01 12:04:55, User\testUser3, /wwwroot/code/article_3.shtml, OK 2003/09/01 12:04:58, User\testUser4, /wwwroot/code/article_4.shtml, OK 2003/09/01 12:05:11, User\testUser5, /wwwroot/code/article_5.shtml, OK Here is the code to read the log file cffile action=""> file=C:\myLogFile.log variable=fOutput Take a look at the code below. As you can see I am looping through the list, finding the Carriage Return character. This is all fine, what I want to be able to do is loop through each individual row which is again a comma seprated list (2003/09/01 11:52:15, User\testUser1, /wwwroot/code/article_1.shtml, OK) append each list item in a temp table column. cfset qTmp=QueryNew(DateTime,User,Document,Status) cfloop list=#fOutput# index=lIndex delimiters=#Chr(10)# cfset i = 0 cfset tmpstart=listLen(lIndex,',') cfset tmp=QueryAddRow(qTmp,listLen(lIndex,',')) cfloop list=#lIndex# index=innerList delimiters=, cfscript tmp=QuerySetCell(qTmp,DateTime, innerList); tmp=QuerySetCell(qTmp,User, innerList); tmp=QuerySetCell(qTmp,Document, innerList); tmp=QuerySetCell(qTmp,Status, innerList); /cfscript cfset i = i + 1 /cfloop /cfloop cfquery name=lquery dbtype=query SELECT DISTINCT * FROM qTmp /cfquery The code above is not right, and I've tried hard to figure out how to loop through the inner comma separated list and assign the value to the query column. Can somebody please show me how to do this. I know my explaination is not very clear but I hope you know what I'm trying to do. If you think there is an easier way to do this then please let me know. Please can somebody help Regards John __ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re:Looping through a list, setting each listItem to a column
Craig, I tried running your code and get this error, Invalid list index 2. In function ListGetAt(list, index [, delimiters]), the value of index, 2, is not a valid as the first argument (this list has 1 elements). Valid indexes are in the range 1 through the number of elements in the list. Any ideas? Try this.. cfset qTmp=QueryNew(DateTime,User,Document,Status) cfloop list=#fOutput# index=lIndex delimiters=#Chr(10)# cfset i = 0 cfset tmpstart=listLen(lIndex,',') cfset tmp=QueryAddRow(qTmp,listLen(lIndex,',')) cfloop list=#lIndex# index=innerList delimiters=, cfscript tmp=QuerySetCell(qTmp,DateTime, listGetAt(innerList,1)); tmp=QuerySetCell(qTmp,User, listGetAt(innerList,2)); tmp=QuerySetCell(qTmp,Document, listGetAt(innerList,3)); tmp=QuerySetCell(qTmp,Status, listGetAt(innerList,4)); /cfscript cfset i = i + 1 /cfloop /cfloop The listgetat function inside your inner loop is the only change i've made -Original Message- From: Allan Clarke [mailto:[EMAIL PROTECTED] Sent: 08 October 2003 11:16 To: CF-Talk Subject: Looping through a list, setting each listItem to a column Hello Everybody, I am trying to read a log file and display the results on a webpage. Here is what the log file looks. DateTime User Webpage Visited Status 2003/09/01 11:52:15, User\testUser1, /wwwroot/code/article_1.shtml, OK 2003/09/01 11:53:35, User\testUser2, /wwwroot/code/article_2.shtml, OK 2003/09/01 12:04:55, User\testUser3, /wwwroot/code/article_3.shtml, OK 2003/09/01 12:04:58, User\testUser4, /wwwroot/code/article_4.shtml, OK 2003/09/01 12:05:11, User\testUser5, /wwwroot/code/article_5.shtml, OK Here is the code to read the log file cffile action=""> file=C:\myLogFile.log variable=fOutput Take a look at the code below. As you can see I am looping through the list, finding the Carriage Return character. This is all fine, what I want to be able to do is loop through each individual row which is again a comma seprated list (2003/09/01 11:52:15, User\testUser1, /wwwroot/code/article_1.shtml, OK) append each list item in a temp table column. cfset qTmp=QueryNew(DateTime,User,Document,Status) cfloop list=#fOutput# index=lIndex delimiters=#Chr(10)# cfset i = 0 cfset tmpstart=listLen(lIndex,',') cfset tmp=QueryAddRow(qTmp,listLen(lIndex,',')) cfloop list=#lIndex# index=innerList delimiters=, cfscript tmp=QuerySetCell(qTmp,DateTime, innerList); tmp=QuerySetCell(qTmp,User, innerList); tmp=QuerySetCell(qTmp,Document, innerList); tmp=QuerySetCell(qTmp,Status, innerList); /cfscript cfset i = i + 1 /cfloop /cfloop cfquery name=lquery dbtype=query SELECT DISTINCT * FROM qTmp /cfquery The code above is not right, and I've tried hard to figure out how to loop through the inner comma separated list and assign the value to the query column. Can somebody please show me how to do this. I know my explaination is not very clear but I hope you know what I'm trying to do. If you think there is an easier way to do this then please let me know. Please can somebody help Regards John __ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Looping through a list, setting each listItem to a column
Will probably be the header row as it doesn't contain commas and hence has no delimiter. Original Message- From: ColdFusion Programmer [mailto:[EMAIL PROTECTED] Sent: 08 October 2003 11:32 To: CF-Talk Subject: Re:Looping through a list, setting each listItem to a column Craig, I tried running your code and get this error, Invalid list index 2. In function ListGetAt(list, index [, delimiters]), the value of index, 2, is not a valid as the first argument (this list has 1 elements). Valid indexes are in the range 1 through the number of elements in the list. Any ideas? Try this.. cfset qTmp=QueryNew(DateTime,User,Document,Status) cfloop list=#fOutput# index=lIndex delimiters=#Chr(10)# cfset i = 0 cfset tmpstart=listLen(lIndex,',') cfset tmp=QueryAddRow(qTmp,listLen(lIndex,',')) cfloop list=#lIndex# index=innerList delimiters=, cfscript tmp=QuerySetCell(qTmp,DateTime, listGetAt(innerList,1)); tmp=QuerySetCell(qTmp,User, listGetAt(innerList,2)); tmp=QuerySetCell(qTmp,Document, listGetAt(innerList,3)); tmp=QuerySetCell(qTmp,Status, listGetAt(innerList,4)); /cfscript cfset i = i + 1 /cfloop /cfloop The listgetat function inside your inner loop is the only change i've made -Original Message- From: Allan Clarke [mailto:[EMAIL PROTECTED] Sent: 08 October 2003 11:16 To: CF-Talk Subject: Looping through a list, setting each listItem to a column Hello Everybody, I am trying to read a log file and display the results on a webpage. Here is what the log file looks. DateTime User Webpage Visited Status 2003/09/01 11:52:15, User\testUser1, /wwwroot/code/article_1.shtml, OK 2003/09/01 11:53:35, User\testUser2, /wwwroot/code/article_2.shtml, OK 2003/09/01 12:04:55, User\testUser3, /wwwroot/code/article_3.shtml, OK 2003/09/01 12:04:58, User\testUser4, /wwwroot/code/article_4.shtml, OK 2003/09/01 12:05:11, User\testUser5, /wwwroot/code/article_5.shtml, OK Here is the code to read the log file cffile action=""> file=C:\myLogFile.log variable=fOutput Take a look at the code below. As you can see I am looping through the list, finding the Carriage Return character. This is all fine, what I want to be able to do is loop through each individual row which is again a comma seprated list (2003/09/01 11:52:15, User\testUser1, /wwwroot/code/article_1.shtml, OK) append each list item in a temp table column. cfset qTmp=QueryNew(DateTime,User,Document,Status) cfloop list=#fOutput# index=lIndex delimiters=#Chr(10)# cfset i = 0 cfset tmpstart=listLen(lIndex,',') cfset tmp=QueryAddRow(qTmp,listLen(lIndex,',')) cfloop list=#lIndex# index=innerList delimiters=, cfscript tmp=QuerySetCell(qTmp,DateTime, innerList); tmp=QuerySetCell(qTmp,User, innerList); tmp=QuerySetCell(qTmp,Document, innerList); tmp=QuerySetCell(qTmp,Status, innerList); /cfscript cfset i = i + 1 /cfloop /cfloop cfquery name=lquery dbtype=query SELECT DISTINCT * FROM qTmp /cfquery The code above is not right, and I've tried hard to figure out how to loop through the inner comma separated list and assign the value to the query column. Can somebody please show me how to do this. I know my explaination is not very clear but I hope you know what I'm trying to do. If you think there is an easier way to do this then please let me know. Please can somebody help Regards John __ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Looping through a list, setting each listItem to a column
This works... cfset qTmp=QueryNew(DateTime,User,Document,Status) cfloop list=#fOutput# index=lIndex delimiters=#Chr(10)# cfset tmp=QueryAddRow(qTmp,1) cfloop list=#lIndex# index=i cfscript tmp=QuerySetCell(qTmp,DateTime, listGetAt(lIndex,1)); tmp=QuerySetCell(qTmp,User, listGetAt(lIndex,2)); tmp=QuerySetCell(qTmp,Document, listGetAt(lIndex,3)); tmp=QuerySetCell(qTmp,Status, listGetAt(lIndex,4)); /cfscript /cfloop /cfloop -Original Message- From: ColdFusion Programmer [mailto:[EMAIL PROTECTED] Sent: 08 October 2003 11:32 To: CF-Talk Subject: Re:Looping through a list, setting each listItem to a column Craig, I tried running your code and get this error, Invalid list index 2. In function ListGetAt(list, index [, delimiters]), the value of index, 2, is not a valid as the first argument (this list has 1 elements). Valid indexes are in the range 1 through the number of elements in the list. Any ideas? Try this.. cfset qTmp=QueryNew(DateTime,User,Document,Status) cfloop list=#fOutput# index=lIndex delimiters=#Chr(10)# cfset i = 0 cfset tmpstart=listLen(lIndex,',') cfset tmp=QueryAddRow(qTmp,listLen(lIndex,',')) cfloop list=#lIndex# index=innerList delimiters=, cfscript tmp=QuerySetCell(qTmp,DateTime, listGetAt(innerList,1)); tmp=QuerySetCell(qTmp,User, listGetAt(innerList,2)); tmp=QuerySetCell(qTmp,Document, listGetAt(innerList,3)); tmp=QuerySetCell(qTmp,Status, listGetAt(innerList,4)); /cfscript cfset i = i + 1 /cfloop /cfloop The listgetat function inside your inner loop is the only change i've made -Original Message- From: Allan Clarke [mailto:[EMAIL PROTECTED] Sent: 08 October 2003 11:16 To: CF-Talk Subject: Looping through a list, setting each listItem to a column Hello Everybody, I am trying to read a log file and display the results on a webpage. Here is what the log file looks. DateTime User Webpage Visited Status 2003/09/01 11:52:15, User\testUser1, /wwwroot/code/article_1.shtml, OK 2003/09/01 11:53:35, User\testUser2, /wwwroot/code/article_2.shtml, OK 2003/09/01 12:04:55, User\testUser3, /wwwroot/code/article_3.shtml, OK 2003/09/01 12:04:58, User\testUser4, /wwwroot/code/article_4.shtml, OK 2003/09/01 12:05:11, User\testUser5, /wwwroot/code/article_5.shtml, OK Here is the code to read the log file cffile action=""> file=C:\myLogFile.log variable=fOutput Take a look at the code below. As you can see I am looping through the list, finding the Carriage Return character. This is all fine, what I want to be able to do is loop through each individual row which is again a comma seprated list (2003/09/01 11:52:15, User\testUser1, /wwwroot/code/article_1.shtml, OK) append each list item in a temp table column. cfset qTmp=QueryNew(DateTime,User,Document,Status) cfloop list=#fOutput# index=lIndex delimiters=#Chr(10)# cfset i = 0 cfset tmpstart=listLen(lIndex,',') cfset tmp=QueryAddRow(qTmp,listLen(lIndex,',')) cfloop list=#lIndex# index=innerList delimiters=, cfscript tmp=QuerySetCell(qTmp,DateTime, innerList); tmp=QuerySetCell(qTmp,User, innerList); tmp=QuerySetCell(qTmp,Document, innerList); tmp=QuerySetCell(qTmp,Status, innerList); /cfscript cfset i = i + 1 /cfloop /cfloop cfquery name=lquery dbtype=query SELECT DISTINCT * FROM qTmp /cfquery The code above is not right, and I've tried hard to figure out how to loop through the inner comma separated list and assign the value to the query column. Can somebody please show me how to do this. I know my explaination is not very clear but I hope you know what I'm trying to do. If you think there is an easier way to do this then please let me know. Please can somebody help Regards John __ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Looping through a list, setting each listItem to a column
It does if you skip the header row, sorry, should have said so. -Original Message- From: Craig Dudley Sent: 08 October 2003 11:38 To: CF-Talk Subject: RE: Looping through a list, setting each listItem to a column This works... cfset qTmp=QueryNew(DateTime,User,Document,Status) cfloop list=#fOutput# index=lIndex delimiters=#Chr(10)# cfset tmp=QueryAddRow(qTmp,1) cfloop list=#lIndex# index=i cfscript tmp=QuerySetCell(qTmp,DateTime, listGetAt(lIndex,1)); tmp=QuerySetCell(qTmp,User, listGetAt(lIndex,2)); tmp=QuerySetCell(qTmp,Document, listGetAt(lIndex,3)); tmp=QuerySetCell(qTmp,Status, listGetAt(lIndex,4)); /cfscript /cfloop /cfloop -Original Message- From: ColdFusion Programmer [mailto:[EMAIL PROTECTED] Sent: 08 October 2003 11:32 To: CF-Talk Subject: Re:Looping through a list, setting each listItem to a column Craig, I tried running your code and get this error, Invalid list index 2. In function ListGetAt(list, index [, delimiters]), the value of index, 2, is not a valid as the first argument (this list has 1 elements). Valid indexes are in the range 1 through the number of elements in the list. Any ideas? Try this.. cfset qTmp=QueryNew(DateTime,User,Document,Status) cfloop list=#fOutput# index=lIndex delimiters=#Chr(10)# cfset i = 0 cfset tmpstart=listLen(lIndex,',') cfset tmp=QueryAddRow(qTmp,listLen(lIndex,',')) cfloop list=#lIndex# index=innerList delimiters=, cfscript tmp=QuerySetCell(qTmp,DateTime, listGetAt(innerList,1)); tmp=QuerySetCell(qTmp,User, listGetAt(innerList,2)); tmp=QuerySetCell(qTmp,Document, listGetAt(innerList,3)); tmp=QuerySetCell(qTmp,Status, listGetAt(innerList,4)); /cfscript cfset i = i + 1 /cfloop /cfloop The listgetat function inside your inner loop is the only change i've made -Original Message- From: Allan Clarke [mailto:[EMAIL PROTECTED] Sent: 08 October 2003 11:16 To: CF-Talk Subject: Looping through a list, setting each listItem to a column Hello Everybody, I am trying to read a log file and display the results on a webpage. Here is what the log file looks. DateTime User Webpage Visited Status 2003/09/01 11:52:15, User\testUser1, /wwwroot/code/article_1.shtml, OK 2003/09/01 11:53:35, User\testUser2, /wwwroot/code/article_2.shtml, OK 2003/09/01 12:04:55, User\testUser3, /wwwroot/code/article_3.shtml, OK 2003/09/01 12:04:58, User\testUser4, /wwwroot/code/article_4.shtml, OK 2003/09/01 12:05:11, User\testUser5, /wwwroot/code/article_5.shtml, OK Here is the code to read the log file cffile action=""> file=C:\myLogFile.log variable=fOutput Take a look at the code below. As you can see I am looping through the list, finding the Carriage Return character. This is all fine, what I want to be able to do is loop through each individual row which is again a comma seprated list (2003/09/01 11:52:15, User\testUser1, /wwwroot/code/article_1.shtml, OK) append each list item in a temp table column. cfset qTmp=QueryNew(DateTime,User,Document,Status) cfloop list=#fOutput# index=lIndex delimiters=#Chr(10)# cfset i = 0 cfset tmpstart=listLen(lIndex,',') cfset tmp=QueryAddRow(qTmp,listLen(lIndex,',')) cfloop list=#lIndex# index=innerList delimiters=, cfscript tmp=QuerySetCell(qTmp,DateTime, innerList); tmp=QuerySetCell(qTmp,User, innerList); tmp=QuerySetCell(qTmp,Document, innerList); tmp=QuerySetCell(qTmp,Status, innerList); /cfscript cfset i = i + 1 /cfloop /cfloop cfquery name=lquery dbtype=query SELECT DISTINCT * FROM qTmp /cfquery The code above is not right, and I've tried hard to figure out how to loop through the inner comma separated list and assign the value to the query column. Can somebody please show me how to do this. I know my explaination is not very clear but I hope you know what I'm trying to do. If you think there is an easier way to do this then please let me know. Please can somebody help Regards John __ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com _ _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re:Looping through a list, setting each listItem to a column
Yes it does work now, thanks a ton for your speedy help. Cheers This works... cfset qTmp=QueryNew(DateTime,User,Document,Status) cfloop list=#fOutput# index=lIndex delimiters=#Chr(10)# cfset tmp=QueryAddRow(qTmp,1) cfloop list=#lIndex# index=i cfscript tmp=QuerySetCell(qTmp,DateTime, listGetAt(lIndex,1)); tmp=QuerySetCell(qTmp,User, listGetAt(lIndex,2)); tmp=QuerySetCell(qTmp,Document, listGetAt(lIndex,3)); tmp=QuerySetCell(qTmp,Status, listGetAt(lIndex,4)); /cfscript /cfloop /cfloop -Original Message- From: ColdFusion Programmer [mailto:[EMAIL PROTECTED] Sent: 08 October 2003 11:32 To: CF-Talk Subject: Re:Looping through a list, setting each listItem to a column Craig, I tried running your code and get this error, Invalid list index 2. In function ListGetAt(list, index [, delimiters]), the value of index, 2, is not a valid as the first argument (this list has 1 elements). Valid indexes are in the range 1 through the number of elements in the list. Any ideas? Try this.. cfset qTmp=QueryNew(DateTime,User,Document,Status) cfloop list=#fOutput# index=lIndex delimiters=#Chr(10)# cfset i = 0 cfset tmpstart=listLen(lIndex,',') cfset tmp=QueryAddRow(qTmp,listLen(lIndex,',')) cfloop list=#lIndex# index=innerList delimiters=, cfscript tmp=QuerySetCell(qTmp,DateTime, listGetAt(innerList,1)); tmp=QuerySetCell(qTmp,User, listGetAt(innerList,2)); tmp=QuerySetCell(qTmp,Document, listGetAt(innerList,3)); tmp=QuerySetCell(qTmp,Status, listGetAt(innerList,4)); /cfscript cfset i = i + 1 /cfloop /cfloop The listgetat function inside your inner loop is the only change i've made -Original Message- From: Allan Clarke [mailto:[EMAIL PROTECTED] Sent: 08 October 2003 11:16 To: CF-Talk Subject: Looping through a list, setting each listItem to a column Hello Everybody, I am trying to read a log file and display the results on a webpage. Here is what the log file looks. DateTime User Webpage Visited Status 2003/09/01 11:52:15, User\testUser1, /wwwroot/code/article_1.shtml, OK 2003/09/01 11:53:35, User\testUser2, /wwwroot/code/article_2.shtml, OK 2003/09/01 12:04:55, User\testUser3, /wwwroot/code/article_3.shtml, OK 2003/09/01 12:04:58, User\testUser4, /wwwroot/code/article_4.shtml, OK 2003/09/01 12:05:11, User\testUser5, /wwwroot/code/article_5.shtml, OK Here is the code to read the log file cffile action=""> file=C:\myLogFile.log variable=fOutput Take a look at the code below. As you can see I am looping through the list, finding the Carriage Return character. This is all fine, what I want to be able to do is loop through each individual row which is again a comma seprated list (2003/09/01 11:52:15, User\testUser1, /wwwroot/code/article_1.shtml, OK) append each list item in a temp table column. cfset qTmp=QueryNew(DateTime,User,Document,Status) cfloop list=#fOutput# index=lIndex delimiters=#Chr(10)# cfset i = 0 cfset tmpstart=listLen(lIndex,',') cfset tmp=QueryAddRow(qTmp,listLen(lIndex,',')) cfloop list=#lIndex# index=innerList delimiters=, cfscript tmp=QuerySetCell(qTmp,DateTime, innerList); tmp=QuerySetCell(qTmp,User, innerList); tmp=QuerySetCell(qTmp,Document, innerList); tmp=QuerySetCell(qTmp,Status, innerList); /cfscript cfset i = i + 1 /cfloop /cfloop cfquery name=lquery dbtype=query SELECT DISTINCT * FROM qTmp /cfquery The code above is not right, and I've tried hard to figure out how to loop through the inner comma separated list and assign the value to the query column. Can somebody please show me how to do this. I know my explaination is not very clear but I hope you know what I'm trying to do. If you think there is an easier way to do this then please let me know. Please can somebody help Regards John __ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Interesting! CFMX SyncML
I am after a CF developer for a fixed price piece of work. I require someone to write a piece of code that will synchronise a mobile device using SyncML technology to an SQL \ Access DB. I am interested in synchronising all the data from the phone, so this encompasses vCards, vCals, VNotes etc. etc. I have cold hard cash and am willing to part with it! I am interested in getting this done asap, ideally within 1wk. If you think you can do it want to do it, please let me know what you feel is appropriate remuneration.Also I realise there is an almost endless scope to this request, so when deciding on your remuneration please feel free to include a scope. Rgds Ben Scammell (please contact me at [EMAIL PROTECTED]) [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Looping through a list, setting each listItem to a column
Had a proper look at it, you actualy only need 1 loop. cfset qTmp = QueryNew(DateTime,User,Document,Status) cfloop list=#fOutput# index=fileLine delimiters=#Chr(10)# cfif listLen(fileLine) eq 4 cfset tmp = QueryAddRow(qTmp,1) cfscript tmp=QuerySetCell(qTmp,DateTime, listGetAt(fileLine,1)); tmp=QuerySetCell(qTmp,User, listGetAt(fileLine,2)); tmp=QuerySetCell(qTmp,Document, listGetAt(fileLine,3)); tmp=QuerySetCell(qTmp,Status, listGetAt(fileLine,4)); /cfscript /cfif /cfloop That should ignore any invalid lines too. -Original Message- From: ColdFusion Programmer [mailto:[EMAIL PROTECTED] Sent: 08 October 2003 11:52 To: CF-Talk Subject: Re:Looping through a list, setting each listItem to a column Yes it does work now, thanks a ton for your speedy help. Cheers This works... cfset qTmp=QueryNew(DateTime,User,Document,Status) cfloop list=#fOutput# index=lIndex delimiters=#Chr(10)# cfset tmp=QueryAddRow(qTmp,1) cfloop list=#lIndex# index=i cfscript tmp=QuerySetCell(qTmp,DateTime, listGetAt(lIndex,1)); tmp=QuerySetCell(qTmp,User, listGetAt(lIndex,2)); tmp=QuerySetCell(qTmp,Document, listGetAt(lIndex,3)); tmp=QuerySetCell(qTmp,Status, listGetAt(lIndex,4)); /cfscript /cfloop /cfloop -Original Message- From: ColdFusion Programmer [mailto:[EMAIL PROTECTED] Sent: 08 October 2003 11:32 To: CF-Talk Subject: Re:Looping through a list, setting each listItem to a column Craig, I tried running your code and get this error, Invalid list index 2. In function ListGetAt(list, index [, delimiters]), the value of index, 2, is not a valid as the first argument (this list has 1 elements). Valid indexes are in the range 1 through the number of elements in the list. Any ideas? Try this.. cfset qTmp=QueryNew(DateTime,User,Document,Status) cfloop list=#fOutput# index=lIndex delimiters=#Chr(10)# cfset i = 0 cfset tmpstart=listLen(lIndex,',') cfset tmp=QueryAddRow(qTmp,listLen(lIndex,',')) cfloop list=#lIndex# index=innerList delimiters=, cfscript tmp=QuerySetCell(qTmp,DateTime, listGetAt(innerList,1)); tmp=QuerySetCell(qTmp,User, listGetAt(innerList,2)); tmp=QuerySetCell(qTmp,Document, listGetAt(innerList,3)); tmp=QuerySetCell(qTmp,Status, listGetAt(innerList,4)); /cfscript cfset i = i + 1 /cfloop /cfloop The listgetat function inside your inner loop is the only change i've made -Original Message- From: Allan Clarke [mailto:[EMAIL PROTECTED] Sent: 08 October 2003 11:16 To: CF-Talk Subject: Looping through a list, setting each listItem to a column Hello Everybody, I am trying to read a log file and display the results on a webpage. Here is what the log file looks. DateTime User Webpage Visited Status 2003/09/01 11:52:15, User\testUser1, /wwwroot/code/article_1.shtml, OK 2003/09/01 11:53:35, User\testUser2, /wwwroot/code/article_2.shtml, OK 2003/09/01 12:04:55, User\testUser3, /wwwroot/code/article_3.shtml, OK 2003/09/01 12:04:58, User\testUser4, /wwwroot/code/article_4.shtml, OK 2003/09/01 12:05:11, User\testUser5, /wwwroot/code/article_5.shtml, OK Here is the code to read the log file cffile action=""> file=C:\myLogFile.log variable=fOutput Take a look at the code below. As you can see I am looping through the list, finding the Carriage Return character. This is all fine, what I want to be able to do is loop through each individual row which is again a comma seprated list (2003/09/01 11:52:15, User\testUser1, /wwwroot/code/article_1.shtml, OK) append each list item in a temp table column. cfset qTmp=QueryNew(DateTime,User,Document,Status) cfloop list=#fOutput# index=lIndex delimiters=#Chr(10)# cfset i = 0 cfset tmpstart=listLen(lIndex,',') cfset tmp=QueryAddRow(qTmp,listLen(lIndex,',')) cfloop list=#lIndex# index=innerList delimiters=, cfscript tmp=QuerySetCell(qTmp,DateTime, innerList); tmp=QuerySetCell(qTmp,User, innerList); tmp=QuerySetCell(qTmp,Document, innerList); tmp=QuerySetCell(qTmp,Status, innerList); /cfscript cfset i = i + 1 /cfloop /cfloop cfquery name=lquery dbtype=query SELECT DISTINCT * FROM qTmp /cfquery The code above is not right, and I've tried hard to figure out how to loop through the inner comma separated list and assign the value to the query column. Can somebody please show me how to do this. I know my explaination is not very clear but I hope you know what I'm trying to do. If you think there is an easier way to do this then please let me know. Please can somebody help Regards John __ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com _ _ _ [Todays Threads] [This Message]
re: Checking input, Cont'd thread from yesterday
Hi all, I've used all the suggestions from this list but I still can't get it to work. I've included my code. I've also left in the code that I'm using to test. Basically what I want to happen is this. The file is loaded but the cfquery I don't want to run unless some text is entered in the input box and the Jump button is clicked. The file reloads itself but this time runs the cfquery. The cfquery get run ONLY if text is entered in the input and ONLY then. Help please cfparam name=tempVar default= !--- Dump Session Variables cfdump var=#session# --- !--- check if form.redirect was passed --- cfif IsDefined(form.redirect) is True !--- check if form.redirect is not blank --- cfif form.redirect is not !--- if not, set redirect to value of form.redirect --- cfset redirect = form.redirect TEXT WAS ENTERED IN THE input FIELD. RUN THE cfquery cfelse NO TEXT ENTERED. IGNORE THE cfquery /cfif /cfif /cfoutput cfif isdefined(redirect) cfquery name=qRedirect datasource=interface_alias SELECT* FROMalias WHERE env_var = '#redirect#' /cfquery !--- Get the strShowMe results --- cfquery name=qGetData datasource=interface_prefs SELECT strShowMe FROM tblProfiles WHERE strUsername = '#auth#' /cfquery cfif qredirect.recordcount cfif FindNoCase(redirect,qGetData.strShowMe,1) cflocation url=""> cfelse cfset request.errlookup = You must select the directory [ #redirect# ] in your preferences before it can be viewed. /cfif cfelse cfset request.errlookup = The directory [ #redirect# ] does not exist or the alias has to be added to the database.brContact the a href='' Administrator/a /cfif /cfif table cellpadding=0 cellspacing=0 border=0 tr align=left td cfoutput table width=100% cellpadding=0 cellspacing=0 border=0 cfform action="" method=GET name=redirect tr td table cellpadding=0 cellspacing=0 border=0 tr tdnbsp;nbsp;input class=formfield type=text name=redirect value= size=8 maxlength=15 class=dirlinks/td td align=rightinput class=formbuttons type=hidden name=defined value=input class=formbuttons type=submit value=Jump class=dirlinks name=results/td /tr /table /td /tr /cfform /table /cfoutput /td [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Checking input, Cont'd thread from yesterday
cfif IsDefined(form.redirect) AND Len(Trim(form.redirect)) !--- run query --- /cfif Pascal -Oorspronkelijk bericht- Van: Bushy [mailto:[EMAIL PROTECTED] Verzonden: wo 8/10/2003 13:37 Aan: CF-Talk CC: Onderwerp: re: Checking input, Cont'd thread from yesterday Hi all, I've used all the suggestions from this list but I still can't get it to work. I've included my code. I've also left in the code that I'm using to test. Basically what I want to happen is this. The file is loaded but the cfquery I don't want to run unless some text is entered in the input box and the Jump button is clicked. The file reloads itself but this time runs the cfquery. The cfquery get run ONLY if text is entered in the input and ONLY then. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re:Looping through a list, setting each listItem to a column
thanks Craig, you've really been of great help. I have another question for you, what I've noticed is a couple of rows are not displayed because the document column has a documnet name with a comma in it. Here is an example. 2003/09/09 14:49:05, TestUser1, /Doc/News/Budgeting,Forecasting Reporting.doc, OK As you can see the document name /Doc/News/Budgeting,Forecasting Reporting.doc has a comma in it. And because our delimeter is , the list finds 4 items. Can you think of any way of getting round this problem. Cheers Allan Had a proper look at it, you actualy only need 1 loop. cfset qTmp = QueryNew(DateTime,User,Document,Status) cfloop list=#fOutput# index=fileLine delimiters=#Chr(10)# cfif listLen(fileLine) eq 4 cfset tmp = QueryAddRow(qTmp,1) cfscript tmp=QuerySetCell(qTmp,DateTime, listGetAt(fileLine,1)); tmp=QuerySetCell(qTmp,User, listGetAt(fileLine,2)); tmp=QuerySetCell(qTmp,Document, listGetAt(fileLine,3)); tmp=QuerySetCell(qTmp,Status, listGetAt(fileLine,4)); /cfscript /cfif /cfloop That should ignore any invalid lines too. -Original Message- From: ColdFusion Programmer [mailto:[EMAIL PROTECTED] Sent: 08 October 2003 11:52 To: CF-Talk Subject: Re:Looping through a list, setting each listItem to a column Yes it does work now, thanks a ton for your speedy help. Cheers This works... cfset qTmp=QueryNew(DateTime,User,Document,Status) cfloop list=#fOutput# index=lIndex delimiters=#Chr(10)# cfset tmp=QueryAddRow(qTmp,1) cfloop list=#lIndex# index=i cfscript tmp=QuerySetCell(qTmp,DateTime, listGetAt(lIndex,1)); tmp=QuerySetCell(qTmp,User, listGetAt(lIndex,2)); tmp=QuerySetCell(qTmp,Document, listGetAt(lIndex,3)); tmp=QuerySetCell(qTmp,Status, listGetAt(lIndex,4)); /cfscript /cfloop /cfloop -Original Message- From: ColdFusion Programmer [mailto:[EMAIL PROTECTED] Sent: 08 October 2003 11:32 To: CF-Talk Subject: Re:Looping through a list, setting each listItem to a column Craig, I tried running your code and get this error, Invalid list index 2. In function ListGetAt(list, index [, delimiters]), the value of index, 2, is not a valid as the first argument (this list has 1 elements). Valid indexes are in the range 1 through the number of elements in the list. Any ideas? Try this.. cfset qTmp=QueryNew(DateTime,User,Document,Status) cfloop list=#fOutput# index=lIndex delimiters=#Chr(10)# cfset i = 0 cfset tmpstart=listLen(lIndex,',') cfset tmp=QueryAddRow(qTmp,listLen(lIndex,',')) cfloop list=#lIndex# index=innerList delimiters=, cfscript tmp=QuerySetCell(qTmp,DateTime, listGetAt(innerList,1)); tmp=QuerySetCell(qTmp,User, listGetAt(innerList,2)); tmp=QuerySetCell(qTmp,Document, listGetAt(innerList,3)); tmp=QuerySetCell(qTmp,Status, listGetAt(innerList,4)); /cfscript cfset i = i + 1 /cfloop /cfloop The listgetat function inside your inner loop is the only change i've made -Original Message- From: Allan Clarke [mailto:[EMAIL PROTECTED] Sent: 08 October 2003 11:16 To: CF-Talk Subject: Looping through a list, setting each listItem to a column Hello Everybody, I am trying to read a log file and display the results on a webpage. Here is what the log file looks. DateTime User Webpage Visited Status 2003/09/01 11:52:15, User\testUser1, /wwwroot/code/article_1.shtml, OK 2003/09/01 11:53:35, User\testUser2, /wwwroot/code/article_2.shtml, OK 2003/09/01 12:04:55, User\testUser3, /wwwroot/code/article_3.shtml, OK 2003/09/01 12:04:58, User\testUser4, /wwwroot/code/article_4.shtml, OK 2003/09/01 12:05:11, User\testUser5, /wwwroot/code/article_5.shtml, OK Here is the code to read the log file cffile action=""> file=C:\myLogFile.log variable=fOutput Take a look at the code below. As you can see I am looping through the list, finding the Carriage Return character. This is all fine, what I want to be able to do is loop through each individual row which is again a comma seprated list (2003/09/01 11:52:15, User\testUser1, /wwwroot/code/article_1.shtml, OK) append each list item in a temp table column. cfset qTmp=QueryNew(DateTime,User,Document,Status) cfloop list=#fOutput# index=lIndex delimiters=#Chr(10)# cfset i = 0 cfset tmpstart=listLen(lIndex,',') cfset tmp=QueryAddRow(qTmp,listLen(lIndex,',')) cfloop list=#lIndex# index=innerList delimiters=, cfscript tmp=QuerySetCell(qTmp,DateTime, innerList); tmp=QuerySetCell(qTmp,User, innerList); tmp=QuerySetCell(qTmp,Document, innerList); tmp=QuerySetCell(qTmp,Status, innerList); /cfscript cfset i = i + 1 /cfloop /cfloop cfquery name=lquery dbtype=query SELECT DISTINCT * FROM qTmp /cfquery The code above is not right, and I've tried hard to figure out how to loop through the inner comma separated list
Re: FYI
I'm thinking that Brad was thinking about suing Eolas, not Microsoft... - Calvin - Original Message - From: Thomas Chiverton To: CF-Talk Sent: Wednesday, October 08, 2003 5:40 AM Subject: Re: FYI On Tuesday 07 Oct 2003 20:29 pm, Brad Roberts wrote: That's exactly what I thought.Seems like developers should be able to sue for the time it's going to take us to update our code.I'd say our combined time would cost somewhere in the ballpark of $520 million, give or take. Nope you can't, read the license you agreed to when you used IE. Thought the is a case going on atm, which seeks to have restrictive licenses like MS's ruled illegal. -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Checking input, Cont'd thread from yesterday
I just tried the below and all it returns is Do Nothing. See below: cfif IsDefined(form.redirect) AND Len(Trim(form.redirect)) Run Query cfelse Do nothing /cfif Is there something wrong with my input syntax? It looks like something is getting clobbered. --Original Message Text--- From: Pascal Peters Date: Wed, 8 Oct 2003 13:43:44 +0200 cfif IsDefined(form.redirect) AND Len(Trim(form.redirect)) !--- run query --- /cfif Pascal -Oorspronkelijk bericht- Van: Bushy [mailto:[EMAIL PROTECTED] Verzonden: wo 8/10/2003 13:37 Aan: CF-Talk CC: Onderwerp: re: Checking input, Cont'd thread from yesterday Hi all, I've used all the suggestions from this list but I still can't get it to work. I've included my code. I've also left in the code that I'm using to test. Basically what I want to happen is this. The file is loaded but the cfquery I don't want to run unless some text is entered in the input box and the Jump button is clicked. The file reloads itself but this time runs the cfquery. The cfquery get run ONLY if text is entered in the input and ONLY then. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFHTTP Posts with Bluedragon free
Craig could it perhaps be something to do with the size? I noticed you said the packets are quite large. Does it work with smaller packets? Does it work for non XML calls? Also have you tried adjusting the timeout to a larger value? Kola -Original Message- From: Craig Dudley [mailto:[EMAIL PROTECTED] Sent: 07 October 2003 13:44 To: CF-Talk Subject: RE: CFHTTP Posts with Bluedragon free Thanks for the suggestion Kola, Have tried it on 5.0 and 6.1 , it works without issue. Craig. -Original Message- From: Kola Oyedeji [mailto:[EMAIL PROTECTED] Sent: 07 October 2003 13:45 To: CF-Talk Subject: RE: CFHTTP Posts with Bluedragon free As a suggestion, why don't you try the same portion of code on a Coldfusion to See if the error is Blue Dragon related or some other issue. Kola -Original Message- From: Craig Dudley [mailto:[EMAIL PROTECTED] Sent: 07 October 2003 12:56 To: CF-Talk Subject: CFHTTP Posts with Bluedragon free While I never usually use cfhttp, a particular client wishes to use Bluedragon 3.0 free edition as a bridge for his internal system and our web server, I'm formatting xml packets form his queries and posting to our box, or trying to. I simply cannot get CFHTTP to POST at all, GET's work fine but the packets are far too big for a url. Code as below... cfhttp url="" url port=80 method=POST timeout=15 cfhttpparam type=FORMFIELD name=test value=#urlencodedformat(test)# /cfhttp This just returns Failed to connect with a HTTP staus code of 100 which is continue, this sounds to me as if BD is connecting with the web server but not actually doing the post. I'm more or less sure status code 100 is the web server basically saying go on then, do your post. Anyone use CFHTTP with BD? Ever got a POST to work? Am I missing a BD specific attribute or something? If this doesn't work I'm going to have to write some XML handling code for Access97, and that's not going to be pretty. Unfortunatley the client isn't going to stump up for CFMX of the more advanced version of BD ( so I can use cfobject/java cfx's ), at least not yet. Craig Dudley Senior Developer Netstep Corporate Communications Ltd Direct Line: +44(0) 1422 319712 Phone: +44(0) 1422 200308 Fax: +44(0) 1422 200306 e-mail: [EMAIL PROTECTED] MS Messenger: [EMAIL PROTECTED] www: www.netstep.co.uk _ _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFMX 6.1, Apache WinXP Pro
I did that my first go round and got an error at the end of the installation process saying that it could not install the connectors and that I would need to do it manually. So I uninstalled CFMX and deleted the cfusionmx directory and followed the steps below as recommended in other forums and Macromedia's website. I've also tried stopping all other services that might interfere and still no luck. Jonathan -Original Message- From: Peter Tilbrook [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 08, 2003 3:45 AM To: CF-Talk Subject: RE: CFMX 6.1, Apache WinXP Pro Should you not have installed ColdFusion to Apache and not as a standalone installation (on port 8500)? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, 8 October 2003 6:19 AM To: CF-Talk Subject: CFMX 6.1, Apache WinXP Pro I've done several searches on the web for this problem with no results... I find it hard to believe I'm the only one having this problem. Here's what I've done: 1. Installed Apache 2.0.47 for windows. The installation works, going to http://localhost http://localhostshows the default Apache index page. 2. Installed ColdFusion MX 6.1 as Standalone. This installation also works, admin at http://localhost:8500/CFIDE/Administrator http://localhost:8500/CFIDE/Administratorallows login to CFMX Admin. 3. Opened the Apache httpd.conf file and added the following: Alias /CFIDE C:/CFusionMX/wwwroot/CFIDE Alias /cfide C:/CFusionMX/wwwroot/CFIDE Directory C:/CFusionMX/wwwroot/CFIDE Options Indexes FollowSymLinks MultiViews IncludesNoExec AddOutputFilter Includes html AllowOverride None Order allow,deny Allow from all /Directory 4. Restarted Apache 5. Edited c:\cfusionmx\bin\connectors\Apache_connector.bat to reflect path to Apache conf director 6. Verified that both Apache and CFMX 6.1 were running 7. Ran the Apache_connector.bat --- here's where the problem is: Created file C:\CFusionMX\runtime\lib\wsconfig\jrunwin32.dll Could not connect to any Jrun/ColdFusion servers on host localhost. Possible causes: Server not running -Start Macromedia JRun4 or ColdFusion MX server Server running -JNDI listen port in jndi.properties blocked by TCP/IP filtering or firewall on server -host restriction in security.properties blocking communications with server Press any key to continue... What am I doing wrong? I have no firewall installed and this is a standard Windows XP Professional installation. Has anyone else had these issues? Any ideas? I ran into this same problem a while back with IIS, and finally gave up and used the built-in server. But this time I really need to use Apache. Thanks, Jonathan __ Jonathan Mauney Web Application Developer / Manager, Digital Media Properties 1110 WBT AM / 107.9 the LINK (WLNK-FM) / JP Radio Network Jefferson-Pilot Communications Co. www.wbt.com www.1079thelink.com www.bobandsheri.com www.mattandramona.com www.pamstoneshow.com _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: FYI
On Wednesday 08 Oct 2003 13:01 pm, Calvin Ward wrote: I'm thinking that Brad was thinking about suing Eolas, not Microsoft... On what grounds ? -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Looping through a list, setting each listItem to a column
Yes a regular _expression_ (regex) , what you would want is a regex that finds any commas that are between quotation marks and either escapes them or replaces them. I'm no regex expert and that would take me quite a while to figure out, maybe later if youre still stuck. Good luck. -Original Message- From: ColdFusion Programmer [mailto:[EMAIL PROTECTED] Sent: 08 October 2003 12:55 To: CF-Talk Subject: Re:Looping through a list, setting each listItem to a column thanks Craig, you've really been of great help. I have another question for you, what I've noticed is a couple of rows are not displayed because the document column has a documnet name with a comma in it. Here is an example. 2003/09/09 14:49:05, TestUser1, /Doc/News/Budgeting,Forecasting Reporting.doc, OK As you can see the document name /Doc/News/Budgeting,Forecasting Reporting.doc has a comma in it. And because our delimeter is , the list finds 4 items. Can you think of any way of getting round this problem. Cheers Allan Had a proper look at it, you actualy only need 1 loop. cfset qTmp = QueryNew(DateTime,User,Document,Status) cfloop list=#fOutput# index=fileLine delimiters=#Chr(10)# cfif listLen(fileLine) eq 4 cfset tmp = QueryAddRow(qTmp,1) cfscript tmp=QuerySetCell(qTmp,DateTime, listGetAt(fileLine,1)); tmp=QuerySetCell(qTmp,User, listGetAt(fileLine,2)); tmp=QuerySetCell(qTmp,Document, listGetAt(fileLine,3)); tmp=QuerySetCell(qTmp,Status, listGetAt(fileLine,4)); /cfscript /cfif /cfloop That should ignore any invalid lines too. -Original Message- From: ColdFusion Programmer [mailto:[EMAIL PROTECTED] Sent: 08 October 2003 11:52 To: CF-Talk Subject: Re:Looping through a list, setting each listItem to a column Yes it does work now, thanks a ton for your speedy help. Cheers This works... cfset qTmp=QueryNew(DateTime,User,Document,Status) cfloop list=#fOutput# index=lIndex delimiters=#Chr(10)# cfset tmp=QueryAddRow(qTmp,1) cfloop list=#lIndex# index=i cfscript tmp=QuerySetCell(qTmp,DateTime, listGetAt(lIndex,1)); tmp=QuerySetCell(qTmp,User, listGetAt(lIndex,2)); tmp=QuerySetCell(qTmp,Document, listGetAt(lIndex,3)); tmp=QuerySetCell(qTmp,Status, listGetAt(lIndex,4)); /cfscript /cfloop /cfloop -Original Message- From: ColdFusion Programmer [mailto:[EMAIL PROTECTED] Sent: 08 October 2003 11:32 To: CF-Talk Subject: Re:Looping through a list, setting each listItem to a column Craig, I tried running your code and get this error, Invalid list index 2. In function ListGetAt(list, index [, delimiters]), the value of index, 2, is not a valid as the first argument (this list has 1 elements). Valid indexes are in the range 1 through the number of elements in the list. Any ideas? Try this.. cfset qTmp=QueryNew(DateTime,User,Document,Status) cfloop list=#fOutput# index=lIndex delimiters=#Chr(10)# cfset i = 0 cfset tmpstart=listLen(lIndex,',') cfset tmp=QueryAddRow(qTmp,listLen(lIndex,',')) cfloop list=#lIndex# index=innerList delimiters=, cfscript tmp=QuerySetCell(qTmp,DateTime, listGetAt(innerList,1)); tmp=QuerySetCell(qTmp,User, listGetAt(innerList,2)); tmp=QuerySetCell(qTmp,Document, listGetAt(innerList,3)); tmp=QuerySetCell(qTmp,Status, listGetAt(innerList,4)); /cfscript cfset i = i + 1 /cfloop /cfloop The listgetat function inside your inner loop is the only change i've made -Original Message- From: Allan Clarke [mailto:[EMAIL PROTECTED] Sent: 08 October 2003 11:16 To: CF-Talk Subject: Looping through a list, setting each listItem to a column Hello Everybody, I am trying to read a log file and display the results on a webpage. Here is what the log file looks. DateTime User Webpage Visited Status 2003/09/01 11:52:15, User\testUser1, /wwwroot/code/article_1.shtml, OK 2003/09/01 11:53:35, User\testUser2, /wwwroot/code/article_2.shtml, OK 2003/09/01 12:04:55, User\testUser3, /wwwroot/code/article_3.shtml, OK 2003/09/01 12:04:58, User\testUser4, /wwwroot/code/article_4.shtml, OK 2003/09/01 12:05:11, User\testUser5, /wwwroot/code/article_5.shtml, OK Here is the code to read the log file cffile action=""> file=C:\myLogFile.log variable=fOutput Take a look at the code below. As you can see I am looping through the list, finding the Carriage Return character. This is all fine, what I want to be able to do is loop through each individual row which is again a comma seprated list (2003/09/01 11:52:15, User\testUser1, /wwwroot/code/article_1.shtml, OK) append each list item in a temp table column. cfset qTmp=QueryNew(DateTime,User,Document,Status) cfloop list=#fOutput# index=lIndex
RE: CFHTTP Posts with Bluedragon free
Yer, tried all of those. If I post formfield 'test' with a value of 'test' it still doesn't work. I've tried all sorts of timeout values also. And every combination of CFHTTP settings I can think of. I've pretty much come to the conclusion that CFHTTP posts are just broken in BD server 3.02, unfortunatley. The only thing I can think of is that it's not working because I'm using the BD internal Java Web Server, though I'm not sure that should make any difference and can't test it from IIS anyway right now. Thanks for the suggestions. -Original Message- From: Kola Oyedeji [mailto:[EMAIL PROTECTED] Sent: 08 October 2003 13:13 To: CF-Talk Subject: RE: CFHTTP Posts with Bluedragon free Craig could it perhaps be something to do with the size? I noticed you said the packets are quite large. Does it work with smaller packets? Does it work for non XML calls? Also have you tried adjusting the timeout to a larger value? Kola [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: FYI
I'm also thinking it was more of a musing than anything else. - Calvin - Original Message - From: Thomas Chiverton To: CF-Talk Sent: Wednesday, October 08, 2003 8:20 AM Subject: Re: FYI On Wednesday 08 Oct 2003 13:01 pm, Calvin Ward wrote: I'm thinking that Brad was thinking about suing Eolas, not Microsoft... On what grounds ? -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
OT: SQLServer2000 and Win2003? any issues?
A question on behalf of my web hosting provider . are there any limitations in installing MS SQLServer2000 with the web edition of Win2003? He says he has heard there are issues but hasn't heard details.Has anyone done it? Cheers, Michael Kear Windsor, NSW, Australia AFP Webworks. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: SQLServer2000 and Win2003? any issues?
It may or may not work but I don't think that the web edition license allows for it. Regards, Howie - Original Message - From: Mike Kear To: CF-Talk Sent: Wednesday, October 08, 2003 8:57 AM Subject: OT: SQLServer2000 and Win2003? any issues? A question on behalf of my web hosting provider . are there any limitations in installing MS SQLServer2000 with the web edition of Win2003? He says he has heard there are issues but hasn't heard details.Has anyone done it? Cheers, Michael Kear Windsor, NSW, Australia AFP Webworks. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: SQLServer2000 and Win2003? any issues?
AFAIK, the web edition will not allow you to install SQLServer onto it... -Original Message- From: Mike Kear [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 8, 2003 13:58 To: CF-Talk Subject: OT: SQLServer2000 and Win2003? any issues? A question on behalf of my web hosting provider . are there any limitations in installing MS SQLServer2000 with the web edition of Win2003? He says he has heard there are issues but hasn't heard details.Has anyone done it? Cheers, Michael Kear Windsor, NSW, Australia AFP Webworks. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: OT Macromedia.com - What Content Management System does it us e ?
I think they used the atomz search engine but have replaced it with google recently. Philipp Cielen -- cielen.com From: S. Isaac Dealey [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 07, 2003 5:21 PM To: CF-Talk I believe there's some atomz in there too: http://www.atomz.com/ It uses a few.Spectra, RIA apps, ColdFusion custom built, Broadvision... [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: SQLServer2000 and Win2003? any issues?
I understand it will not even install on web addition, the licence deffinatley doesn't allow for it either, Howie is correct. -Original Message- From: Howie Hamlin [mailto:[EMAIL PROTECTED] Sent: 08 October 2003 14:04 To: CF-Talk Subject: Re: SQLServer2000 and Win2003? any issues? It may or may not work but I don't think that the web edition license allows for it. Regards, Howie - Original Message - From: Mike Kear To: CF-Talk Sent: Wednesday, October 08, 2003 8:57 AM Subject: OT: SQLServer2000 and Win2003? any issues? A question on behalf of my web hosting provider . are there any limitations in installing MS SQLServer2000 with the web edition of Win2003? He says he has heard there are issues but hasn't heard details.Has anyone done it? Cheers, Michael Kear Windsor, NSW, Australia AFP Webworks. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFHTTP Posts with Bluedragon free
Hi Craig, I've forwarded your issue to the BlueDragon Product Interest List. You may want to join the list for more direct interaction with our engineers: http://www.newatlanta.com/products/bluedragon/self_help/arch ive_search/index.cfm Regards, Dan Daniel Ganter New Atlanta Communications www.newatlanta.com -Original Message- From: Craig Dudley [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 08, 2003 8:37 AM To: CF-Talk Subject: RE: CFHTTP Posts with Bluedragon free Yer, tried all of those. If I post formfield 'test' with a value of 'test' it still doesn't work. I've tried all sorts of timeout values also. And every combination of CFHTTP settings I can think of. I've pretty much come to the conclusion that CFHTTP posts are just broken in BD server 3.02, unfortunatley. The only thing I can think of is that it's not working because I'm using the BD internal Java Web Server, though I'm not sure that should make any difference and can't test it from IIS anyway right now. Thanks for the suggestions. -Original Message- From: Kola Oyedeji [mailto:[EMAIL PROTECTED] Sent: 08 October 2003 13:13 To: CF-Talk Subject: RE: CFHTTP Posts with Bluedragon free Craig could it perhaps be something to do with the size? I noticed you said the packets are quite large. Does it work with smaller packets? Does it work for non XML calls? Also have you tried adjusting the timeout to a larger value? Kola -- [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: SQLServer2000 and Win2003? any issues?
I'm pretty sure that this was recently raised on this list so you may find it in the archives, IRC I think its been reported that the web edition of Win2003 does not support SQlserver2000. (it may support MSDE though). Kola -Original Message- From: Howie Hamlin [mailto:[EMAIL PROTECTED] Sent: 08 October 2003 14:04 To: CF-Talk Subject: Re: SQLServer2000 and Win2003? any issues? It may or may not work but I don't think that the web edition license allows for it. Regards, Howie - Original Message - From: Mike Kear To: CF-Talk Sent: Wednesday, October 08, 2003 8:57 AM Subject: OT: SQLServer2000 and Win2003? any issues? A question on behalf of my web hosting provider . are there any limitations in installing MS SQLServer2000 with the web edition of Win2003? He says he has heard there are issues but hasn't heard details.Has anyone done it? Cheers, Michael Kear Windsor, NSW, Australia AFP Webworks. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Licensing for applications developed in CF
Hi all, We've been approached by a couple of other Universities who are interested in using one of our applications developed in CF. We would be providing them, for free, with a non-encrypted copy of our CF code and database schema script, so they would be able to develop the application and adapt it for their own needs. So we'd be providing them with an as-much-as-a-cf-app-can-be open source application. Our little problem has been tracking down a licensing agreement which we could provide the other universities with, which covers the above distribution model. We haven't, as yet, formally decided whether they would be able to distribute the modified code, but I think the decision is going to allow them to distribute any modified code. I've had a look through the GNU General Public License and it mainly seems to fit the bill, but I'm unsure of whether the fact that the app requires CF to run would invalidate the license. Can anyone point me in the right direction or have any experience/advice they can provide? Any help would be much appreciated, Alex Little [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: SQLServer2000 and Win2003? any issues?
The provider will need to upgrade to Win 2003 Enterprise, or as an alternative, run the SQL2k server on a separate box on Win2k. The web edition of Win2003 is not a suitable package for a provider, as it is much more suited for supporting a local single web site, or sites limited to static html. == Stop spam on your domain, use our gateway! For hosting solutions http://www.clickdoug.com Featuring Win2003 Enterprise, RedHat Linux, CFMX 6.1 and all databases. ISP rated: http://www.forta.com/cf/isp/isp.cfm?isp_id=772 Suggested corporate Anti-virus policy: http://www.dshield.org/antivirus.pdf == If you are not satisfied with my service, my job isn't done! - Original Message - From: Mike Townend [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, October 08, 2003 8:07 AM Subject: RE: SQLServer2000 and Win2003? any issues? | AFAIK, the web edition will not allow you to install SQLServer onto it... | | | | -Original Message- | From: Mike Kear [mailto:[EMAIL PROTECTED] | Sent: Wednesday, October 8, 2003 13:58 | To: CF-Talk | Subject: OT: SQLServer2000 and Win2003? any issues? | | | A question on behalf of my web hosting provider . are there any limitations | in installing MS SQLServer2000 with the web edition of Win2003? | | He says he has heard there are issues but hasn't heard details.Has anyone | done it? | | | | Cheers, | | Michael Kear | | Windsor, NSW, Australia | | AFP Webworks. | | | | | |_ | | | [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Licensing for applications developed in CF
On Wednesday 08 Oct 2003 14:23 pm, A.Little wrote: I've had a look through the GNU General Public License and it mainly seems to fit the bill, but I'm unsure of whether the fact that the app requires CF to run would invalidate the license. IANAL, but the GPL covers the source code / compiled version, not the execution enviroment, so you'll be fine. Otherwise, you wouldn't be able to have Win32 GPL apps :-) -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFHTTP Posts with Bluedragon free
Cheers Daniel, I have subscribed. -Original Message- From: Daniel Ganter [mailto:[EMAIL PROTECTED] Sent: 08 October 2003 14:13 To: CF-Talk Subject: RE: CFHTTP Posts with Bluedragon free Hi Craig, I've forwarded your issue to the BlueDragon Product Interest List. You may want to join the list for more direct interaction with our engineers: http://www.newatlanta.com/products/bluedragon/self_help/arch ive_search/index.cfm Regards, Dan Daniel Ganter New Atlanta Communications www.newatlanta.com -Original Message- From: Craig Dudley [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 08, 2003 8:37 AM To: CF-Talk Subject: RE: CFHTTP Posts with Bluedragon free Yer, tried all of those. If I post formfield 'test' with a value of 'test' it still doesn't work. I've tried all sorts of timeout values also. And every combination of CFHTTP settings I can think of. I've pretty much come to the conclusion that CFHTTP posts are just broken in BD server 3.02, unfortunatley. The only thing I can think of is that it's not working because I'm using the BD internal Java Web Server, though I'm not sure that should make any difference and can't test it from IIS anyway right now. Thanks for the suggestions. -Original Message- From: Kola Oyedeji [mailto:[EMAIL PROTECTED] Sent: 08 October 2003 13:13 To: CF-Talk Subject: RE: CFHTTP Posts with Bluedragon free Craig could it perhaps be something to do with the size? I noticed you said the packets are quite large. Does it work with smaller packets? Does it work for non XML calls? Also have you tried adjusting the timeout to a larger value? Kola -- _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re:Looping through a list, setting each listItem to a column
Have tried but can't crack it. Can you please show me how to do it if you don't mind, thanks in advance. Yes a regular _expression_ (regex) , what you would want is a regex that finds any commas that are between quotation marks and either escapes them or replaces them. I'm no regex expert and that would take me quite a while to figure out, maybe later if youre still stuck. Good luck. -Original Message- From: ColdFusion Programmer [mailto:[EMAIL PROTECTED] Sent: 08 October 2003 12:55 To: CF-Talk Subject: Re:Looping through a list, setting each listItem to a column thanks Craig, you've really been of great help. I have another question for you, what I've noticed is a couple of rows are not displayed because the document column has a documnet name with a comma in it. Here is an example. 2003/09/09 14:49:05, TestUser1, /Doc/News/Budgeting,Forecasting Reporting.doc, OK As you can see the document name /Doc/News/Budgeting,Forecasting Reporting.doc has a comma in it. And because our delimeter is , the list finds 4 items. Can you think of any way of getting round this problem. Cheers Allan Had a proper look at it, you actualy only need 1 loop. cfset qTmp = QueryNew(DateTime,User,Document,Status) cfloop list=#fOutput# index=fileLine delimiters=#Chr(10)# cfif listLen(fileLine) eq 4 cfset tmp = QueryAddRow(qTmp,1) cfscript tmp=QuerySetCell(qTmp,DateTime, listGetAt(fileLine,1)); tmp=QuerySetCell(qTmp,User, listGetAt(fileLine,2)); tmp=QuerySetCell(qTmp,Document, listGetAt(fileLine,3)); tmp=QuerySetCell(qTmp,Status, listGetAt(fileLine,4)); /cfscript /cfif /cfloop That should ignore any invalid lines too. -Original Message- From: ColdFusion Programmer [mailto:[EMAIL PROTECTED] Sent: 08 October 2003 11:52 To: CF-Talk Subject: Re:Looping through a list, setting each listItem to a column Yes it does work now, thanks a ton for your speedy help. Cheers This works... cfset qTmp=QueryNew(DateTime,User,Document,Status) cfloop list=#fOutput# index=lIndex delimiters=#Chr(10)# cfset tmp=QueryAddRow(qTmp,1) cfloop list=#lIndex# index=i cfscript tmp=QuerySetCell(qTmp,DateTime, listGetAt(lIndex,1)); tmp=QuerySetCell(qTmp,User, listGetAt(lIndex,2)); tmp=QuerySetCell(qTmp,Document, listGetAt(lIndex,3)); tmp=QuerySetCell(qTmp,Status, listGetAt(lIndex,4)); /cfscript /cfloop /cfloop -Original Message- From: ColdFusion Programmer [mailto:[EMAIL PROTECTED] Sent: 08 October 2003 11:32 To: CF-Talk Subject: Re:Looping through a list, setting each listItem to a column Craig, I tried running your code and get this error, Invalid list index 2. In function ListGetAt(list, index [, delimiters]), the value of index, 2, is not a valid as the first argument (this list has 1 elements). Valid indexes are in the range 1 through the number of elements in the list. Any ideas? Try this.. cfset qTmp=QueryNew(DateTime,User,Document,Status) cfloop list=#fOutput# index=lIndex delimiters=#Chr(10)# cfset i = 0 cfset tmpstart=listLen(lIndex,',') cfset tmp=QueryAddRow(qTmp,listLen(lIndex,',')) cfloop list=#lIndex# index=innerList delimiters=, cfscript tmp=QuerySetCell(qTmp,DateTime, listGetAt(innerList,1)); tmp=QuerySetCell(qTmp,User, listGetAt(innerList,2)); tmp=QuerySetCell(qTmp,Document, listGetAt(innerList,3)); tmp=QuerySetCell(qTmp,Status, listGetAt(innerList,4)); /cfscript cfset i = i + 1 /cfloop /cfloop The listgetat function inside your inner loop is the only change i've made -Original Message- From: Allan Clarke [mailto:[EMAIL PROTECTED] Sent: 08 October 2003 11:16 To: CF-Talk Subject: Looping through a list, setting each listItem to a column Hello Everybody, I am trying to read a log file and display the results on a webpage. Here is what the log file looks. DateTime User Webpage Visited Status 2003/09/01 11:52:15, User\testUser1, /wwwroot/code/article_1.shtml, OK 2003/09/01 11:53:35, User\testUser2, /wwwroot/code/article_2.shtml, OK 2003/09/01 12:04:55, User\testUser3, /wwwroot/code/article_3.shtml, OK 2003/09/01 12:04:58, User\testUser4, /wwwroot/code/article_4.shtml, OK 2003/09/01 12:05:11, User\testUser5, /wwwroot/code/article_5.shtml, OK Here is the code to read the log file cffile action=""> file=C:\myLogFile.log variable=fOutput Take a look at the code below. As you can see I am looping through the list, finding the Carriage Return character. This is all fine, what I want to be able to do is loop through each individual row which is again a comma seprated list (2003/09/01 11:52:15, User\testUser1, /wwwroot/code/article_1.shtml, OK) append each list item in a temp table column.
RE: Checking input, Cont'd thread from yesterday
I reexamined your code and you are using the method get on your form. Normally, this wouldn't matter because you are using cfform (it will change it to post), but try using post anyway. Also, you can turn on debug info to see what form and url vars exist (or just dump them in your code, remember: the form and url struct always exist). The code I sent absolutely works, I've used it many times. -Oorspronkelijk bericht- Van: Bushy [mailto:[EMAIL PROTECTED] Verzonden: wo 8/10/2003 14:03 Aan: CF-Talk CC: Onderwerp: RE: Checking input, Cont'd thread from yesterday I just tried the below and all it returns is Do Nothing. See below: cfif IsDefined(form.redirect) AND Len(Trim(form.redirect)) Run Query cfelse Do nothing /cfif Is there something wrong with my input syntax? It looks like something is getting clobbered. --Original Message Text--- From: Pascal Peters Date: Wed, 8 Oct 2003 13:43:44 +0200 cfif IsDefined(form.redirect) AND Len(Trim(form.redirect)) !--- run query --- /cfif Pascal -Oorspronkelijk bericht- Van: Bushy [mailto:[EMAIL PROTECTED] Verzonden: wo 8/10/2003 13:37 Aan: CF-Talk CC: Onderwerp: re: Checking input, Cont'd thread from yesterday Hi all, I've used all the suggestions from this list but I still can't get it to work. I've included my code. I've also left in the code that I'm using to test. Basically what I want to happen is this. The file is loaded but the cfquery I don't want to run unless some text is entered in the input box and the Jump button is clicked. The file reloads itself but this time runs the cfquery. The cfquery get run ONLY if text is entered in the input and ONLY then. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: SQLServer2000 and Win2003? any issues?
SQL 2000 simply won't install to 2003 Web Edition - neither will exchange for that matter. Jim Davis -Original Message- From: Mike Kear [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 08, 2003 8:58 AM To: CF-Talk Subject: OT: SQLServer2000 and Win2003? any issues? A question on behalf of my web hosting provider . are there any limitations in installing MS SQLServer2000 with the web edition of Win2003? He says he has heard there are issues but hasn't heard details.Has anyone done it? Cheers, Michael Kear Windsor, NSW, Australia AFP Webworks. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: SQLServer2000 and Win2003? any issues?
So Doug are you saying that you wouldn't recommend using Win2003 as a OS for CFMX either? Cheers, Michael Kear Windsor, NSW, Australia AFP Webworks. -Original Message- From: Doug White [mailto:[EMAIL PROTECTED] Sent: Wednesday, 8 October 2003 11:24 PM To: CF-Talk Subject: Re: SQLServer2000 and Win2003? any issues? The provider will need to upgrade to Win 2003 Enterprise, or as an alternative, run the SQL2k server on a separate box on Win2k. The web edition of Win2003 is not a suitable package for a provider, as it is much more suited for supporting a local single web site, or sites limited to static html. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
problems with recursion in cfmx
I don't know if this is a possible bug (or maybe i am doing something wrong), but when using recursion with a query in the function scope it is overwritten on the next call of the function.i did find a workaround, but want to know is what is intended. I have this function which orders sibilings from a result set that is a hierarchacl tree of nodes with ids and parentids.(btw i know in oracle 9i this functino exists, but we are running 8i) the query looks like this: cfquery name=getStandardRet datasource=test SELECT upper(name) as uppername, name,level as depth,frameid,description,parentid FROM sn_standard START WITH frameid = '#arguments.key#' CONNECT BY PRIOR frameid = parentid /cfquery I call the orderbysibling function by passing the the parent of the tree. cfset startid = getStandardRet[frameid][1] / cfset orderedQuery = QueryNew(frameid,parentid,depth,name,description) / cfset QueryAddRow(orderedQuery) / cfset QuerySetCell(orderedQuery,frameid,getStandardRet[frameid][1]) cfset QuerySetCell(orderedQuery,depth,getStandardRet[depth][1]) cfset QuerySetCell(orderedQuery,name,getStandardRet[name][1]) cfset QuerySetCell(orderedQuery,description,getStandardRet[description][1]) cfset QuerySetCell(orderedQuery,parentid,getStandardRet[parentid][1]) cfset orderbySibling(startid) / ---orderbySibling function cffunction name=orderbySibling cfargument name=nodeid required=true / cfquery name=qsiblings dbtype=query select frameid,depth,name,description,parentid from getStandardRet where parentid = '#nodeid#' order by uppername /cfquery cfloop query=qsiblings cfset QueryAddRow(orderedQuery) / cfset QuerySetCell(orderedQuery,frameid,qsiblings.frameid) cfset QuerySetCell(orderedQuery,depth,qsiblings.depth) cfset QuerySetCell(orderedQuery,name,qsiblings.name) cfset QuerySetCell(orderedQuery,description,qsiblings.description) cfset QuerySetCell(orderedQuery,parentid,qsiblings.parentid) cfset orderbySibling(qsiblings.frameid) / /cfloop /cffunction --- this is the workaround cffunction name=orderbySibling cfargument name=nodeid required=true / cfargument name=foo required=false / cfquery name=qsiblings dbtype=query select frameid,depth,name,description,parentid from getStandardRet where parentid = '#nodeid#' order by uppername /cfquery cfset arguments.foo = qsiblings / cfloop query=arguments.foo cfset QueryAddRow(orderedQuery) / cfset QuerySetCell(orderedQuery,frameid,arguments.foo.frameid) cfset QuerySetCell(orderedQuery,depth,arguments.foo.depth) cfset QuerySetCell(orderedQuery,name,arguments.foo.name) cfset QuerySetCell(orderedQuery,description,arguments.foo.description) cfset QuerySetCell(orderedQuery,parentid,arguments.foo.parentid) cfset orderbySibling(arguments.foo.frameid) / /cfloop /cffunction To me it seems that the query(all variables of the function) should be pushed onto the stack at each time the function is called.the workaround is a hack that forces the query qsiblings to take a different scope so that the data will be preserved as it comes up out of the recursive calls.i have also noticed that if you use a varialbe in the original calling scope that it is seen as a global variable in the recursive function and not local to the scope of the original calling function. Does anyone know of a good document that it explains all of the scopes in cfmx and their relationships? tia, jason __ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Checking input, Cont'd thread from yesterday
Hi Pascal, I tried changing the GET to POST and changed the cfform to just form but it still won't work. I have no doubt that it works for you. There MUST be something in my code thats cloberring it. Ths code below is being pulled in with a cfinclude along with other files. Must be something in those files then? --Original Message Text--- From: Pascal Peters Date: Wed, 8 Oct 2003 15:54:25 +0200 I reexamined your code and you are using the method get on your form. Normally, this wouldn't matter because you are using cfform (it will change it to post), but try using post anyway. Also, you can turn on debug info to see what form and url vars exist (or just dump them in your code, remember: the form and url struct always exist). The code I sent absolutely works, I've used it many times. -Oorspronkelijk bericht- Van: Bushy [mailto:[EMAIL PROTECTED] Verzonden: wo 8/10/2003 14:03 Aan: CF-Talk CC: Onderwerp: RE: Checking input, Cont'd thread from yesterday I just tried the below and all it returns is Do Nothing. See below: cfif IsDefined(form.redirect) AND Len(Trim(form.redirect)) Run Query cfelse Do nothing /cfif Is there something wrong with my input syntax? It looks like something is getting clobbered. --Original Message Text--- From: Pascal Peters Date: Wed, 8 Oct 2003 13:43:44 +0200 cfif IsDefined(form.redirect) AND Len(Trim(form.redirect)) !--- run query --- /cfif Pascal -Oorspronkelijk bericht- Van: Bushy [mailto:[EMAIL PROTECTED] Verzonden: wo 8/10/2003 13:37 Aan: CF-Talk CC: Onderwerp: re: Checking input, Cont'd thread from yesterday Hi all, I've used all the suggestions from this list but I still can't get it to work. I've included my code. I've also left in the code that I'm using to test. Basically what I want to happen is this. The file is loaded but the cfquery I don't want to run unless some text is entered in the input box and the Jump button is clicked. The file reloads itself but this time runs the cfquery. The cfquery get run ONLY if text is entered in the input and ONLY then. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: problems with recursion in cfmx
In your query put cfset var getStandardRet = / That may help. Ade -Original Message- From: Jason Wagstaff [mailto:[EMAIL PROTECTED] Sent: 08 October 2003 15:04 To: CF-Talk Subject: problems with recursion in cfmx I don't know if this is a possible bug (or maybe i am doing something wrong), but when using recursion with a query in the function scope it is overwritten on the next call of the function.i did find a workaround, but want to know is what is intended. I have this function which orders sibilings from a result set that is a hierarchacl tree of nodes with ids and parentids.(btw i know in oracle 9i this functino exists, but we are running 8i) the query looks like this: cfquery name=getStandardRet datasource=test SELECT upper(name) as uppername, name,level as depth,frameid,description,parentid FROM sn_standard START WITH frameid = '#arguments.key#' CONNECT BY PRIOR frameid = parentid /cfquery I call the orderbysibling function by passing the the parent of the tree. cfset startid = getStandardRet[frameid][1] / cfset orderedQuery = QueryNew(frameid,parentid,depth,name,description) / cfset QueryAddRow(orderedQuery) / cfset QuerySetCell(orderedQuery,frameid,getStandardRet[frameid][1]) cfset QuerySetCell(orderedQuery,depth,getStandardRet[depth][1]) cfset QuerySetCell(orderedQuery,name,getStandardRet[name][1]) cfset QuerySetCell(orderedQuery,description,getStandardRet[description][1]) cfset QuerySetCell(orderedQuery,parentid,getStandardRet[parentid][1]) cfset orderbySibling(startid) / ---orderbySibling function cffunction name=orderbySibling cfargument name=nodeid required=true / cfquery name=qsiblings dbtype=query select frameid,depth,name,description,parentid from getStandardRet where parentid = '#nodeid#' order by uppername /cfquery cfloop query=qsiblings cfset QueryAddRow(orderedQuery) / cfset QuerySetCell(orderedQuery,frameid,qsiblings.frameid) cfset QuerySetCell(orderedQuery,depth,qsiblings.depth) cfset QuerySetCell(orderedQuery,name,qsiblings.name) cfset QuerySetCell(orderedQuery,description,qsiblings.description) cfset QuerySetCell(orderedQuery,parentid,qsiblings.parentid) cfset orderbySibling(qsiblings.frameid) / /cfloop /cffunction --- this is the workaround cffunction name=orderbySibling cfargument name=nodeid required=true / cfargument name=foo required=false / cfquery name=qsiblings dbtype=query select frameid,depth,name,description,parentid from getStandardRet where parentid = '#nodeid#' order by uppername /cfquery cfset arguments.foo = qsiblings / cfloop query=arguments.foo cfset QueryAddRow(orderedQuery) / cfset QuerySetCell(orderedQuery,frameid,arguments.foo.frameid) cfset QuerySetCell(orderedQuery,depth,arguments.foo.depth) cfset QuerySetCell(orderedQuery,name,arguments.foo.name) cfset QuerySetCell(orderedQuery,description,arguments.foo.description) cfset QuerySetCell(orderedQuery,parentid,arguments.foo.parentid) cfset orderbySibling(arguments.foo.frameid) / /cfloop /cffunction To me it seems that the query(all variables of the function) should be pushed onto the stack at each time the function is called.the workaround is a hack that forces the query qsiblings to take a different scope so that the data will be preserved as it comes up out of the recursive calls.i have also noticed that if you use a varialbe in the original calling scope that it is seen as a global variable in the recursive function and not local to the scope of the original calling function. Does anyone know of a good document that it explains all of the scopes in cfmx and their relationships? tia, jason __ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com http://shopping.yahoo.com _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Help with Regular Expressions
I want to use a regular _expression_ that finds any commas that are between quotation marks and either escapes them or replaces them Here is an my string. 2003/09/09 14:49:05, TestUser1, /Doc/News/Budgeting,Forecasting Reporting.doc, OK As you can see /Doc/News/Budgeting,Forecasting Reporting.doc has a comma in it. The example above is a list with 4 items: 2003/09/09 14:49:05 TestUser1 /Doc/News/Budgeting,Forecasting Reporting.doc OK But because the string (/Doc/News/Budgeting,Forecasting Reporting.doc) has a comma the list len comes back with 5 items which is wrong. Can you show me how to get around this? Many Thanks __ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Checking input, Cont'd thread from yesterday
Can I use cfdump to output the form variables? --Original Message Text--- From: Pascal Peters Date: Wed, 8 Oct 2003 15:54:25 +0200 I reexamined your code and you are using the method get on your form. Normally, this wouldn't matter because you are using cfform (it will change it to post), but try using post anyway. Also, you can turn on debug info to see what form and url vars exist (or just dump them in your code, remember: the form and url struct always exist). The code I sent absolutely works, I've used it many times. -Oorspronkelijk bericht- Van: Bushy [mailto:[EMAIL PROTECTED] Verzonden: wo 8/10/2003 14:03 Aan: CF-Talk CC: Onderwerp: RE: Checking input, Cont'd thread from yesterday I just tried the below and all it returns is Do Nothing. See below: cfif IsDefined(form.redirect) AND Len(Trim(form.redirect)) Run Query cfelse Do nothing /cfif Is there something wrong with my input syntax? It looks like something is getting clobbered. --Original Message Text--- From: Pascal Peters Date: Wed, 8 Oct 2003 13:43:44 +0200 cfif IsDefined(form.redirect) AND Len(Trim(form.redirect)) !--- run query --- /cfif Pascal -Oorspronkelijk bericht- Van: Bushy [mailto:[EMAIL PROTECTED] Verzonden: wo 8/10/2003 13:37 Aan: CF-Talk CC: Onderwerp: re: Checking input, Cont'd thread from yesterday Hi all, I've used all the suggestions from this list but I still can't get it to work. I've included my code. I've also left in the code that I'm using to test. Basically what I want to happen is this. The file is loaded but the cfquery I don't want to run unless some text is entered in the input box and the Jump button is clicked. The file reloads itself but this time runs the cfquery. The cfquery get run ONLY if text is entered in the input and ONLY then. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: problems with recursion in cfmx
Ignore that. I meant to say, in the recursive functions, locally scope your queries. cfset var yourQuery = / should do it. Ade -Original Message- From: Adrian Lynch [mailto:[EMAIL PROTECTED] Sent: 08 October 2003 15:08 To: CF-Talk Subject: RE: problems with recursion in cfmx In your query put cfset var getStandardRet = / That may help. Ade -Original Message- From: Jason Wagstaff [mailto:[EMAIL PROTECTED] Sent: 08 October 2003 15:04 To: CF-Talk Subject: problems with recursion in cfmx I don't know if this is a possible bug (or maybe i am doing something wrong), but when using recursion with a query in the function scope it is overwritten on the next call of the function.i did find a workaround, but want to know is what is intended. I have this function which orders sibilings from a result set that is a hierarchacl tree of nodes with ids and parentids.(btw i know in oracle 9i this functino exists, but we are running 8i) the query looks like this: cfquery name=getStandardRet datasource=test SELECT upper(name) as uppername, name,level as depth,frameid,description,parentid FROM sn_standard START WITH frameid = '#arguments.key#' CONNECT BY PRIOR frameid = parentid /cfquery I call the orderbysibling function by passing the the parent of the tree. cfset startid = getStandardRet[frameid][1] / cfset orderedQuery = QueryNew(frameid,parentid,depth,name,description) / cfset QueryAddRow(orderedQuery) / cfset QuerySetCell(orderedQuery,frameid,getStandardRet[frameid][1]) cfset QuerySetCell(orderedQuery,depth,getStandardRet[depth][1]) cfset QuerySetCell(orderedQuery,name,getStandardRet[name][1]) cfset QuerySetCell(orderedQuery,description,getStandardRet[description][1]) cfset QuerySetCell(orderedQuery,parentid,getStandardRet[parentid][1]) cfset orderbySibling(startid) / ---orderbySibling function cffunction name=orderbySibling cfargument name=nodeid required=true / cfquery name=qsiblings dbtype=query select frameid,depth,name,description,parentid from getStandardRet where parentid = '#nodeid#' order by uppername /cfquery cfloop query=qsiblings cfset QueryAddRow(orderedQuery) / cfset QuerySetCell(orderedQuery,frameid,qsiblings.frameid) cfset QuerySetCell(orderedQuery,depth,qsiblings.depth) cfset QuerySetCell(orderedQuery,name,qsiblings.name) cfset QuerySetCell(orderedQuery,description,qsiblings.description) cfset QuerySetCell(orderedQuery,parentid,qsiblings.parentid) cfset orderbySibling(qsiblings.frameid) / /cfloop /cffunction --- this is the workaround cffunction name=orderbySibling cfargument name=nodeid required=true / cfargument name=foo required=false / cfquery name=qsiblings dbtype=query select frameid,depth,name,description,parentid from getStandardRet where parentid = '#nodeid#' order by uppername /cfquery cfset arguments.foo = qsiblings / cfloop query=arguments.foo cfset QueryAddRow(orderedQuery) / cfset QuerySetCell(orderedQuery,frameid,arguments.foo.frameid) cfset QuerySetCell(orderedQuery,depth,arguments.foo.depth) cfset QuerySetCell(orderedQuery,name,arguments.foo.name) cfset QuerySetCell(orderedQuery,description,arguments.foo.description) cfset QuerySetCell(orderedQuery,parentid,arguments.foo.parentid) cfset orderbySibling(arguments.foo.frameid) / /cfloop /cffunction To me it seems that the query(all variables of the function) should be pushed onto the stack at each time the function is called.the workaround is a hack that forces the query qsiblings to take a different scope so that the data will be preserved as it comes up out of the recursive calls.i have also noticed that if you use a varialbe in the original calling scope that it is seen as a global variable in the recursive function and not local to the scope of the original calling function. Does anyone know of a good document that it explains all of the scopes in cfmx and their relationships? tia, jason __ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com http://shopping.yahoo.com http://shopping.yahoo.com _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Help with Regular Expressions
The problem is in defining between quotation marks because technically in testuser1,testuser2 the comma *is* between quotation marks.I can see how you could loop over the string and keep the pairs consistent that way, but I can't off the top of my head think of a way to do it with a single regex. Here's another way to look at it: you have a quotation-mark-delimited list with throwaway members that just contain commas. I don't know if that will be the right way to go about it, but it might be worth considering. If not, I would use a find() to locate all the quotes and work with them in pairs that way, removing/replacing commas between them. HTH. --Ben Doom Allan Clarke wrote: I want to use a regular _expression_ that finds any commas that are between quotation marks and either escapes them or replaces them Here is an my string. 2003/09/09 14:49:05, TestUser1, /Doc/News/Budgeting,Forecasting Reporting.doc, OK As you can see /Doc/News/Budgeting,Forecasting Reporting.doc has a comma in it. The example above is a list with 4 items: 2003/09/09 14:49:05 TestUser1 /Doc/News/Budgeting,Forecasting Reporting.doc OK But because the string (/Doc/News/Budgeting,Forecasting Reporting.doc) has a comma the list len comes back with 5 items which is wrong. Can you show me how to get around this? Many Thanks __ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
OT: .bak files in Dreamweaver
I had a user ask today How come everytime I save a file a .bak file is also created...Wheere is the option to turn that off? I can't seem to find it. Any ideas? Thanks! - Alex [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re:Help with Regular Expressions
Hi Ben Actually if you take a look at this thread you will get a better idea of what I'm trying to do. I'll appreciate your help http://www.houseoffusion.com/cf_lists/index.cfm/method=messagesthreadid=27743forumid=4 Thanks The problem is in defining between quotation marks because technically in testuser1,testuser2 the comma *is* between quotation marks.I can see how you could loop over the string and keep the pairs consistent that way, but I can't off the top of my head think of a way to do it with a single regex. Here's another way to look at it: you have a quotation-mark-delimited list with throwaway members that just contain commas. I don't know if that will be the right way to go about it, but it might be worth considering. If not, I would use a find() to locate all the quotes and work with them in pairs that way, removing/replacing commas between them. HTH. --Ben Doom Allan Clarke wrote: I want to use a regular _expression_ that finds any commas that are between quotation marks and either escapes them or replaces them Here is an my string. 2003/09/09 14:49:05, TestUser1, /Doc/News/Budgeting,Forecasting Reporting.doc, OK As you can see /Doc/News/Budgeting,Forecasting Reporting.doc has a comma in it. The example above is a list with 4 items: 2003/09/09 14:49:05 TestUser1 /Doc/News/Budgeting,Forecasting Reporting.doc OK But because the string (/Doc/News/Budgeting,Forecasting Reporting.doc) has a comma the list len comes back with 5 items which is wrong. Can you show me how to get around this? Many Thanks __ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: SQLServer2000 and Win2003? any issues?
Not the Web Edition - I personally have Win2003 Enterprise deployed, with CFMX 6.1 and a separate box dedicated to the SQL2k server. It is working great. Of course, I also have servers running Wn2k, and RedHat Linux -All of them support CFMX 6.1It is for the customer to choose which platform they prefer. As a side note, since I am running several O/S side by side, the Win2003 Enterprise seems to have the most rock solid performance, and requires the least attention form the Teckkies. In fact I am hosting the Victoria User group:http://www.muvclub.asn.auSeems to be less hops from Victoria to Texas, than there is from Victoria to Sydney! Go figure. == Stop spam on your domain, use our gateway! For hosting solutions http://www.clickdoug.com Featuring Win2003 Enterprise, RedHat Linux, CFMX 6.1 and all databases. ISP rated: http://www.forta.com/cf/isp/isp.cfm?isp_id=772 Suggested corporate Anti-virus policy: http://www.dshield.org/antivirus.pdf == If you are not satisfied with my service, my job isn't done! - Original Message - From: Mike Kear [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, October 08, 2003 9:01 AM Subject: RE: SQLServer2000 and Win2003? any issues? | So Doug are you saying that you wouldn't recommend using Win2003 as a OS for | CFMX either? | | | | | | | | Cheers, | | Michael Kear | | Windsor, NSW, Australia | | AFP Webworks. | | | | | | | | | | -Original Message- | From: Doug White [mailto:[EMAIL PROTECTED] | Sent: Wednesday, 8 October 2003 11:24 PM | To: CF-Talk | Subject: Re: SQLServer2000 and Win2003? any issues? | | | | The provider will need to upgrade to Win 2003 Enterprise, or as an | alternative, | run the SQL2k server on a separate box on Win2k. | | The web edition of Win2003 is not a suitable package for a provider, as it | is | much more suited for supporting a local single web site, or sites limited to | static html. | | | | | | | [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Looping through a list, setting each listItem to a column
This should do it in CF using regexp. There are probably custom tags that will read logs more efficiently though. cfscript columns = DateTime,User,Document,Status; qTmp = QueryNew(columns); pattern = '^[[:space:]]*([^,]*|([^]|)*)[[:space:]]*(,|$)'; matchStruct = structNew(); for(i=2;i LE ListLen(fOutput,chr(10));i=i+1){ QueryAddRow(qTmp,1); line = ListGetAt(fOutput,i,chr(10)); exit = false; j = 1; while(NOT exit){ // find matching pattern matchStruct = REFindNoCase(pattern,line,1,true); if(matchStruct.pos[1] AND j LE ListLen(columns)){ field = Mid(line,matchStruct.pos[2],matchStruct.len[2]); QuerySetCell(qTmp,ListGetAt(columns,j),field); if(matchStruct.len[1]) line = RemoveChars(line,1,matchStruct.len[1]); j = j + 1; } else exit = true; } } /cfscript -Oorspronkelijk bericht- Van: ColdFusion Programmer [mailto:[EMAIL PROTECTED] Verzonden: wo 8/10/2003 15:53 Aan: CF-Talk CC: Onderwerp: Re:Looping through a list, setting each listItem to a column Have tried but can't crack it. Can you please show me how to do it if you don't mind, thanks in advance. Yes a regular _expression_ (regex) , what you would want is a regex that finds any commas that are between quotation marks and either escapes them or replaces them. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Checking input, Cont'd thread from yesterday
Yes -Oorspronkelijk bericht- Van: Bushy [mailto:[EMAIL PROTECTED] Verzonden: wo 8/10/2003 16:26 Aan: CF-Talk CC: Onderwerp: RE: Checking input, Cont'd thread from yesterday Can I use cfdump to output the form variables? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: problems with recursion in cfmx
--- Adrian Lynch [EMAIL PROTECTED] wrote: Ignore that. I meant to say, in the recursive functions, locally scope your queries. that is essentially what i do with using the arguments.foo and it solved the problem.but is this what is supppose to happen/intended? it seems to me that the the query should be scoped to the local function automatically.why is it global? why can the other recursive function calls see it?Are all variables global? I would prefer to have an understanding of why and how instead of (imo) a workaround. jason -Original Message- From: Adrian Lynch [mailto:[EMAIL PROTECTED] Sent: 08 October 2003 15:08 To: CF-Talk Subject: RE: problems with recursion in cfmx In your query put cfset var getStandardRet = / That may help. Ade -Original Message- From: Jason Wagstaff [mailto:[EMAIL PROTECTED] Sent: 08 October 2003 15:04 To: CF-Talk Subject: problems with recursion in cfmx I don't know if this is a possible bug (or maybe i am doing something wrong), but when using recursion with a query in the function scope it is overwritten on the next call of the function.i did find a workaround, but want to know is what is intended. I have this function which orders sibilings from a result set that is a hierarchacl tree of nodes with ids and parentids.(btw i know in oracle 9i this functino exists, but we are running 8i) the query looks like this: cfquery name=getStandardRet datasource=test SELECT upper(name) as uppername, name,level as depth,frameid,description,parentid FROM sn_standard START WITH frameid = '#arguments.key#' CONNECT BY PRIOR frameid = parentid /cfquery I call the orderbysibling function by passing the the parent of the tree. cfset startid = getStandardRet[frameid][1] / cfset orderedQuery = QueryNew(frameid,parentid,depth,name,description) / cfset QueryAddRow(orderedQuery) / cfset QuerySetCell(orderedQuery,frameid,getStandardRet[frameid][1]) cfset QuerySetCell(orderedQuery,depth,getStandardRet[depth][1]) cfset QuerySetCell(orderedQuery,name,getStandardRet[name][1]) cfset QuerySetCell(orderedQuery,description,getStandardRet[description][1]) cfset QuerySetCell(orderedQuery,parentid,getStandardRet[parentid][1]) cfset orderbySibling(startid) / ---orderbySibling function cffunction name=orderbySibling cfargument name=nodeid required=true / cfquery name=qsiblings dbtype=query select frameid,depth,name,description,parentid from getStandardRet where parentid = '#nodeid#' order by uppername /cfquery cfloop query=qsiblings cfset QueryAddRow(orderedQuery) / cfset QuerySetCell(orderedQuery,frameid,qsiblings.frameid) cfset QuerySetCell(orderedQuery,depth,qsiblings.depth) cfset QuerySetCell(orderedQuery,name,qsiblings.name) cfset QuerySetCell(orderedQuery,description,qsiblings.description) cfset QuerySetCell(orderedQuery,parentid,qsiblings.parentid) cfset orderbySibling(qsiblings.frameid) / /cfloop /cffunction --- this is the workaround cffunction name=orderbySibling cfargument name=nodeid required=true / cfargument name=foo required=false / cfquery name=qsiblings dbtype=query select frameid,depth,name,description,parentid from getStandardRet where parentid = '#nodeid#' order by uppername /cfquery cfset arguments.foo = qsiblings / cfloop query=arguments.foo cfset QueryAddRow(orderedQuery) / cfset QuerySetCell(orderedQuery,frameid,arguments.foo.frameid) cfset QuerySetCell(orderedQuery,depth,arguments.foo.depth) cfset QuerySetCell(orderedQuery,name,arguments.foo.name) cfset QuerySetCell(orderedQuery,description,arguments.foo.description) cfset QuerySetCell(orderedQuery,parentid,arguments.foo.parentid) cfset orderbySibling(arguments.foo.frameid) / /cfloop /cffunction To me it seems that the query(all variables of the function) should be pushed onto the stack at each time the function is called.the workaround is a hack that forces the query qsiblings to take a different scope so that the data will be preserved as it comes up out of the recursive calls.i have also noticed that if you use a varialbe in the original calling scope that it is seen as a global variable in the recursive function and not local to the scope of the original calling function. Does anyone know of a good document that it explains all of the scopes in cfmx and their relationships? tia, jason __ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com http://shopping.yahoo.com http://shopping.yahoo.com _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Web Stats software
Dan Phillips (CFXHosting.com) wrote: Can anyone tell me what Stats software out there can handle a URL like http://domain.com/sub.cfm?page=article7news_id=1234 http://domain.com/sub.cfm?page=article7news_id=1234 I've tried LiveStats by DeepMetrix and it does not seem to track it at all. Dan, Try FunnelWeb by Quest Software, (http://www.quest.com/funnel_web/analyzer/) It can handle URL parameters quite easily. You need to set a couple of parameters in the setup but it works quite well. I've used it with fused sites with no problems. Moreover if you don't mind downloading a copy every three months or so, its free. Another alternative is Secret Agent.com's Fusebox Log Analyzer for $50. See http://www.secretagents.com/index.cfm?fuseaction=tools.fuseboxlogs. I haven't used this tool but it looks like it can do the job. regards, larry [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Checking input, Cont'd thread from yesterday
Hmm...my app is one sick puppy. I get nothing returned. cfdump var=#form# --Original Message Text--- From: Pascal Peters Date: Wed, 8 Oct 2003 16:53:58 +0200 Yes -Oorspronkelijk bericht- Van: Bushy [mailto:[EMAIL PROTECTED] Verzonden: wo 8/10/2003 16:26 Aan: CF-Talk CC: Onderwerp: RE: Checking input, Cont'd thread from yesterday Can I use cfdump to output the form variables? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: problems with recursion in cfmx
I hope someone will correct me if I'm wrong on this, but... When you don't scope a variable, including a query, in a function, it defaults to the variables scope, which means it can be seen outside of the function. To make it local to the function you var scope it, this is what cfset var queryName = / does. This kind of makes sense to me, annoying to have to use cfset for a query though. Are all variables global? No, only if you make them so, or in this case, don't tell them overwise. Do a dump of the variables scope to see what's in there, you might be surprised. cfdump var=#VARIABLES# / Also, does anyone know a similar way to see all var scoped variables? Dumping var doesn't work. Ade -Original Message- From: Jason Wagstaff [mailto:[EMAIL PROTECTED] Sent: 08 October 2003 15:54 To: CF-Talk Subject: RE: problems with recursion in cfmx --- Adrian Lynch [EMAIL PROTECTED] wrote: Ignore that. I meant to say, in the recursive functions, locally scope your queries. that is essentially what i do with using the arguments.foo and it solved the problem.but is this what is supppose to happen/intended? it seems to me that the the query should be scoped to the local function automatically.why is it global? why can the other recursive function calls see it?Are all variables global? I would prefer to have an understanding of why and how instead of (imo) a workaround. jason [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: problems with recursion in cfmx
but is this what is supppose to happen/intended? Yes. Any unscoped variable that is created in a function body is automatically placed in the variables scope, which is global and not localised to the function, hence future iterations of the same function can read/overwrite that value.To localise a variable to the function, prefix it with var: cffunction name=foo cfset bar = !--- global (in the variables scope) --- cfset var bar2 = !--- localised to the function --- /cffunction Further info on scopes is in the livedocs: http://short.badpen.com/?3LL2SK61 HTH, Tim. --- OUR NEW SITE IS NOW LIVE Visit our new website at http://www.rawnet.com/ and race around the beautiful Bracknell streets at http://xmas.rawnet.com/ --- Tim Blair Web Application Engineer, Rawnet Limited Direct Phone : +44 (0) 1344 393 441 Switchboard : +44 (0) 1344 393 040 --- This message may contain information which is legally privileged and/or confidential.If you are not the intended recipient, you are hereby notified that any unauthorised disclosure, copying, distribution or use of this information is strictly prohibited. Such notification notwithstanding, any comments, opinions, information or conclusions expressed in this message are those of the originator, not of rawnet limited, unless otherwise explicitly and independently indicated by an authorised representative of rawnet limited. --- [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: problems with recursion in cfmx
Also, does anyone know a similar way to see all var scoped variables? Dumping var doesn't work. You can't - however - if you need to, simply do: cfset var local = structNew() and place all your crap in local, then you can inspect it at will. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Help with Regular Expressions
Try this: cfset string = '11/12/2003, bob, this is a ,comma,list,end' cfscript string = string ,; first = find('', string); second = find('', string, first + 1); while(first and second) { string = left(string, first) replace(mid(string, first + 1, second-first), ',', '~', all) right(string, len(string) - second); first = find('', string, second + 1); second = find('', string, first + 1); } /cfscript You'll notice that I append a comma to the end of the list.This is so that a double-quote can't be the last character.Sine CF ignores empty list entries, this shouldn't affect the rest of your code.If it does, just strip the last character at the end of the script. HTH. --Ben Doom [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: .bak files in Dreamweaver
Are you using Contribute? - Calvin - Original Message - From: Demarco, Alex To: CF-Talk Sent: Wednesday, October 08, 2003 10:38 AM Subject: OT: .bak files in Dreamweaver I had a user ask today How come everytime I save a file a .bak file is also created...Wheere is the option to turn that off? I can't seem to find it. Any ideas? Thanks! - Alex [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: SQLServer2000 and Win2003? any issues?
The web edition of Win2003 is not a suitable package for a provider, as it is much more suited for supporting a local single web site, or sites limited to static html. I would disagree with this, with the caveat that it has memory and processor limitations that'll keep you from putting too many sites on one box. If you're not going to exceed those limitations, it is extremely suitable for any web server use. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re:Looping through a list, setting each listItem to a column
I've tried that and it does not work. Here is my code cfscript myList = '2003/09/09 14:49:05, TestUser1, /Doc/News/Budgeting,Forecasting Reporting.doc, OK'; myList = REReplace(myList, '^[[:space:]]*([^,]*|([^]|)*)[[:space:]]*(,|$)',''); /cfscript cfoutput#myList#/cfoutput This should do it in CF using regexp. There are probably custom tags that will read logs more efficiently though. cfscript columns = DateTime,User,Document,Status; qTmp = QueryNew(columns); pattern = '^[[:space:]]*([^,]*|([^]|)*)[[:space:]]*(,|$)'; matchStruct = structNew(); for(i=2;i LE ListLen(fOutput,chr(10));i=i+1){ QueryAddRow(qTmp,1); line = ListGetAt(fOutput,i,chr(10)); exit = false; j = 1; while(NOT exit){ // find matching pattern matchStruct = REFindNoCase(pattern,line,1,true); if(matchStruct.pos[1] AND j LE ListLen(columns)){ field = Mid(line,matchStruct.pos[2],matchStruct.len[2]); QuerySetCell(qTmp,ListGetAt(columns,j),field); if(matchStruct.len[1]) line = RemoveChars(line,1,matchStruct.len[1]); j = j + 1; } else exit = true; } } /cfscript -Oorspronkelijk bericht- Van: ColdFusion Programmer [mailto:[EMAIL PROTECTED] Verzonden: wo 8/10/2003 15:53 Aan: CF-Talk CC: Onderwerp: Re:Looping through a list, setting each listItem to a column Have tried but can't crack it. Can you please show me how to do it if you don't mind, thanks in advance. Yes a regular _expression_ (regex) , what you would want is a regex that finds any commas that are between quotation marks and either escapes them or replaces them. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: problems with recursion in cfmx
--- Tim Blair [EMAIL PROTECTED] wrote: but is this what is supppose to happen/intended? Yes. Any unscoped variable that is created in a function body is automatically placed in the variables scope, which is global and not localised to the function, hence future iterations of the same function can read/overwrite that value.To localise a variable to the function, prefix it with var: thanks for the link. that is exactly what i needed.to me, this is counter-intuitive.i would think that variables declared in a function would be local to that functionunless i specifically put them into another scope.(hence the problem i had)but that is me. thanks to everyone for the information. jason __ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
re Using cfdump
Why does this work cfdump var=#session# expand=yes and this doesn't... cfdump var=#form# expand=yes It retuns nothing from my cfform or if I change the cfform to formsame thing. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: re Using cfdump
Does your form scope actually have anything in it? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re:Help with Regular Expressions
Thanks Ben, the problem with that script is that because I'm reading a log file with 300 plus rows of data, the execution time suffers. Is there a way to only run your code if somewhere in the string there is a comma inside double quotes? Try this: cfset string = '11/12/2003, bob, this is a ,comma,list,end' cfscript string = string ,; first = find('', string); second = find('', string, first + 1); while(first and second) { string = left(string, first) replace(mid(string, first + 1, second-first), ',', '~', all) right(string, len(string) - second); first = find('', string, second + 1); second = find('', string, first + 1); } /cfscript You'll notice that I append a comma to the end of the list.This is so that a double-quote can't be the last character.Sine CF ignores empty list entries, this shouldn't affect the rest of your code.If it does, just strip the last character at the end of the script. HTH. --Ben Doom [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: re Using cfdump
On Wednesday 08 Oct 2003 16:40 pm, Bushy wrote: cfdump var=#form# expand=yes It retuns nothing from my cfform or if I change the cfform to formsame thing. Is your form post'ed to the page with that cfdump on ? -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
HELP!!! How do I debug server hogging code.
I've got some code that recently started hanging and tying up the server when it is run.It does not throw any errors, but it also never returns any results.It is effecting the entire server box when it does this. Can anybody provide some easy to follow steps on how I could get a better picture on what is happening on the server when this code runs. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Checking input, Cont'd thread from yesterday
This means the struct is empty -Oorspronkelijk bericht- Van: Bushy [mailto:[EMAIL PROTECTED] Verzonden: wo 8/10/2003 17:08 Aan: CF-Talk CC: Onderwerp: RE: Checking input, Cont'd thread from yesterday Hmm...my app is one sick puppy. I get nothing returned. cfdump var=#form# --Original Message Text--- From: Pascal Peters Date: Wed, 8 Oct 2003 16:53:58 +0200 Yes -Oorspronkelijk bericht- Van: Bushy [mailto:[EMAIL PROTECTED] Verzonden: wo 8/10/2003 16:26 Aan: CF-Talk CC: Onderwerp: RE: Checking input, Cont'd thread from yesterday Can I use cfdump to output the form variables? _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: CFMAIL Odd Results
Yes, I have seen this, if you make the message one big long line in between the cfmail tags with html br to break the line, it should send as long as it is not over 1000 characters... Many email servers will not receive messages with a line longer than 1000 characters they either throw it out all together or just deliver the first 1000 characters which I am having a problem with. Regards, Drew Harris On 10/7/03 11:33, Marc Lippman - Director, Information Technology [EMAIL PROTECTED] wrote: I'm trying to send a simple text message and getting very odd results. If I send a 1 line text message, it works fine. If I add a 2nd line of text, I do not receive the email. I have tried using HTML and / or text based, same odd results. I have sent more complex emails before with no problems. Do I need to manually put in a line-break perhaps? CF Logs it as going out fine, but it doesn't come to my mailbox. I can not figure out a pattern as to why, or why not this is happening. Has anyone run across this? I do not believe this has anything to do with connectivity issues, as if I just send a blank email, Or 1 line of text it goes though.. Anyone run across this before? Thanks. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Looping through a list, setting each listItem to a column
The script wasn't meant to give you a regexp to replace the commas. It does the entire job of creating the query and takes the as a qualifier into consideration. Replace your script by mine and it should work. -Oorspronkelijk bericht- Van: ColdFusion Programmer [mailto:[EMAIL PROTECTED] Verzonden: wo 8/10/2003 17:32 Aan: CF-Talk CC: Onderwerp: Re:Looping through a list, setting each listItem to a column I've tried that and it does not work. Here is my code cfscript myList = '2003/09/09 14:49:05, TestUser1, /Doc/News/Budgeting,Forecasting Reporting.doc, OK'; myList = REReplace(myList, '^[[:space:]]*([^,]*|([^]|)*)[[:space:]]*(,|$)',''); /cfscript cfoutput#myList#/cfoutput This should do it in CF using regexp. There are probably custom tags that will read logs more efficiently though. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
CFTRANSACTION and PostgreSQL/mySQL
Hey All, I've seen many posts out there about PostgreSQL and mySQL and rollbacks.I want to know if they will properly rollback (not commit) if a query(s) fail inside a CFTRANSACTION block? TIA Cheers Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Help with Regular Expressions
You could run it on any line that has too many list elements.That is, if listlen(5) then run the script on it (define it as a UDF and call it). HTH. --Ben ColdFusion Programmer wrote: Thanks Ben, the problem with that script is that because I'm reading a log file with 300 plus rows of data, the execution time suffers. Is there a way to only run your code if somewhere in the string there is a comma inside double quotes? Try this: cfset string = '11/12/2003, bob, this is a ,comma,list,end' cfscript string = string ,; first = find('', string); second = find('', string, first + 1); while(first and second) { string = left(string, first) replace(mid(string, first + 1, second-first), ',', '~', all) right(string, len(string) - second); first = find('', string, second + 1); second = find('', string, first + 1); } /cfscript You'll notice that I append a comma to the end of the list.This is so that a double-quote can't be the last character.Sine CF ignores empty list entries, this shouldn't affect the rest of your code.If it does, just strip the last character at the end of the script. HTH. --Ben Doom [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: CFMAIL Odd Results
FYI - by RFC a line of text in an email message must be 1000 characters or less including the required CRLF pair.It is common for mail servers to reject non compliant mail because there is a lot of SPAM mail that is non-compliant. Regards, -- Howie Hamlin - inFusion Project Manager On-Line Data Solutions, Inc. - www.CoolFusion.com inFusion Mail Server (iMS) - The Award-winning, Intelligent Mail Server ((())) PrismAV is Coming ((())) Please vote for iMS here: http://www.sys-con.com/coldfusion/readerschoice2003/index.cfm Find out how iMS Stacks up to the competition: http://www.coolfusion.com/imssecomparison.cfm - Original Message - From: Drew Harris To: CF-Talk Sent: Wednesday, October 08, 2003 11:56 AM Subject: Re: CFMAIL Odd Results Yes, I have seen this, if you make the message one big long line in between the cfmail tags with html br to break the line, it should send as long as it is not over 1000 characters... Many email servers will not receive messages with a line longer than 1000 characters they either throw it out all together or just deliver the first 1000 characters which I am having a problem with. Regards, Drew Harris [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: returning an image via cfhttp
John McCosker wrote: CFHTTP METHOD=GET URL="" PROTECTED]/GetMap.asp CFHTTPPARAM TYPE=FORMFIELD VALUE=#XML_DOC# NAME=xmlparams /CFHTTP CFCONTENT TYPE=image/gifCFOUTPUT#toString(CFHTTP.FileContent)#/cfoutput/CFCONT ENT Try this: CFHTTP METHOD=GET URL="" PROTECTED]/GetMap.asp CFHTTPPARAM TYPE=FORMFIELD VALUE=#XML_DOC# NAME=xmlparams /CFHTTP CFCONTENT TYPE=image/gifCFOUTPUT#toBinary(toString(CFHTTP.FileContent))#/cfoutput But you should seriously consider using a download to your own server and storing it on the filesystem, it will allow you to cache the file. Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
query output question
This is probably basic, but I've not run into it before... I have the following select area in a form: select name=category2 size=3 multiple option value=10Accounting/Auditing/option option value=20Agriculture, Forestry, Fishing/option option value=30Architecture Engineering/option option value=40Arts Entertainment/option option value=50Administrative/Clerical/option /select When I submit multiple selects to the next page, I attempt to match up the category2 values (ie 10, 20 etc) using the following query cfquery datasource=test_data name=cat_name SELECT category, category_no FROM job_categories Where category_no=#category2# /cfquery but I get the following error, that I can't figure out how to get around: ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC Microsoft Access Driver] Syntax error (comma) in query _expression_ 'category_no=10,30'. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
OT:Bots / spiders finding unlinked pages... How?
One of our clients' IS department just got NetTracker/6.0 Enterprise and has set it loose on the site.It has found several pages that are not linked from any where.I do not have directory browsing turned on and I know these pages are not linked from any page.. How is it possible that it found these unlinked pages? Can other Bots / spiders also find unlinked pages? Thanks Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: re Using cfdump
That should work on the form processing page, if your method is set to POST. - Calvin - Original Message - From: Bushy To: CF-Talk Sent: Wednesday, October 08, 2003 11:40 AM Subject: re Using cfdump Why does this work cfdump var=#session# expand=yes and this doesn't... cfdump var=#form# expand=yes It retuns nothing from my cfform or if I change the cfform to formsame thing. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
CFContent and PDF problems
We're using a CFContent to push files to a client page (after they've clicked on an appropriate link of course).Things are working for image files, but we are getting odd behaviour when we try to view PDF documents. Here's the code in question: !--- Set the name of the download file in the HTTP header --- CFHEADER NAME=Content-Disposition VALUE=filename=#oFTS.OriginalName# !--- Send the file (using the physical path to it) --- cfcontent type=#sMimeType# file=#sSourcePath# deletefile=no and the supporting variables are: Mime TYpe: application/pdf File Name: 2003100809073301noisereport.pdf Path and File: C:\inetpub\wwwroot\caa\ctreg_web\fts_files\2003100809073301noisereport.pdf What's happening is that the PDF file is getting dumped as raw text to the page, or we see a prompt to save our action page (getfile.cfm).However, this is a near exact copy of an existing routine from another application we did.In the other application, the PDF plug-in kicks in and we view the file in Adobe Acrobat.It would appear that in the process of copying and modifying the code, something minor was changed to result in this new behaviour.However, we've now had 3 people look at the code and we don't see anyting that should be causing this issue. Does anyone see anything wrong or have any suggestions?My thoughts are that we have missed something stupid... Thanks in advance. Shawn [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: HELP!!! How do I debug server hogging code.
Ian, what version of ColdFusion are you running on what operating system? Kind Regards - Mike Brunt Original Message --- I've got some code that recently started hanging and tying up the server when it is run.It does not throw any errors, but it also never returns any results.It is effecting the entire server box when it does this. Can anybody provide some easy to follow steps on how I could get a better picture on what is happening on the server when this code runs. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: HELP!!! How do I debug server hogging code.
Sounds like a seamless loop.Try outputting things as you go down the page.Wherever the last number ends on the output is where your problem is at. xENo - Original Message - From: Ian Skinner To: CF-Talk Sent: Wednesday, October 08, 2003 11:50 AM Subject: HELP!!! How do I debug server hogging code. I've got some code that recently started hanging and tying up the server when it is run.It does not throw any errors, but it also never returns any results.It is effecting the entire server box when it does this. Can anybody provide some easy to follow steps on how I could get a better picture on what is happening on the server when this code runs. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: PayPal Buy Now?
Kay, When you say premium site access, the first thing that pops into my head is adult content. This may or may not be the case with your client, but if it is you cannot use paypal. Adult sites are excluded in their terms and conditions. If you are working on an adult site and need advice about processing payments drop me a note off list and I will point you in the right direction. Good Luck, [EMAIL PROTECTED] -Original Message- Subject: PayPal Buy Now? From: Eric Dawson [EMAIL PROTECTED] Date: Wed, 8 Oct 2003 05:10:40 - Thread: http://www.houseoffusion.com/cf_lists/index.cfm?method=messagesthreadid=277 39forumid=4#139850 you can configure paypal to send a post back from pay pal to confirm form values. http://tutorial23.easycfm.com/ Eric - Original Message - From: Kay Smoljak To: CF-Talk Sent: Wednesday, October 08, 2003 02:31 Subject: PayPal Buy Now? Has anyone used PayPal to set up an online store? I have a customer who wants to use it for payment for premium site access, as the initial outlay is cheaper than Camtech or Verisign... problem is, with the Buy Now buttons, the amount gets passed in the form post or URL, so anyone could change it. Now, I thought I could just check that the returned amount was correct and disallow access to anyone who tampered with the amount. Except as far as I can see, PayPal doesn't send the amount back to you after the transaction, although they seem to send a lot of other stuff back to you. Anyone have any experience with this? Thanks, Kay. __ Kay SmoljakWeb DeveloperPerthWeb Pty Ltd Level 9/105 St George's Tc - Perth - Western Australia Ph: (08) 9226 1366 Fax: (08) 9226 1375 www.perthweb.com.audeveloper.perthweb.com.au [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: query output question
you are passing a list this way so you need to use the IN operator...and while your at ti best to use cfqueryparam here. ...this 'should' work cfquery datasource=test_data name=cat_name SELECT category, category_no FROM job_categories Where category_no IN ( cfqueryparam cfsqltype=CF_SQL_VARCHAR list=Yes value=#form.category2# / ) /cfquery Doug -Original Message- From: Tim Laureska [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 08, 2003 12:43 PM To: CF-Talk Subject: query output question This is probably basic, but I've not run into it before... I have the following select area in a form: select name=category2 size=3 multiple option value=10Accounting/Auditing/option option value=20Agriculture, Forestry, Fishing/option option value=30Architecture Engineering/option option value=40Arts Entertainment/option option value=50Administrative/Clerical/option /select When I submit multiple selects to the next page, I attempt to match up the category2 values (ie 10, 20 etc) using the following query cfquery datasource=test_data name=cat_name SELECT category, category_no FROM job_categories Where category_no=#category2# /cfquery but I get the following error, that I can't figure out how to get around: ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC Microsoft Access Driver] Syntax error (comma) in query _expression_ 'category_no=10,30'. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: query output question
Tim, On 10/8/2003 at 12:42, you wrote: TL Where category_no=#category2# Use: Where category_no in (#category2#) ~ Ubqtous ~ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: HELP!!! How do I debug server hogging code.
One thing I do at times is use GetTickCount() and cfflush combo. Top of the page, set a variable (let's call it StartTick) as GetTickCount(). Then at strategic parts of your code, set a variable NowTick as GetTickCount() - StartTick. Output it, and do a cfflush. This will be the no. of milliseconds since the page started. Stick some other text in there as well, so you know what's going on. It could be you've got an unending loop going on somewhere... this will probably help find it. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Problem with select list on Mac OS9 + NS4
We're having a problem with select lists not scrolling on a Mac OS9 w/ NS4. I tested this on all three of our OS9 computers with same results. See these screen shots: http://www.blinex.com/~sam/No_Scroll_Option_List.jpg http://www.blinex.com/~sam/With_Scroll_Option_List.jpg What can cause this?The two pages are exactly identical, just one is CFM and the other is HTML (the HTML is saved from the CFM). Here's the code.I removed most of the options but they're all consistent. I've tried with and without whitespace between options and the problem persists (of course that shouldn't matter, but I'm desparate). form action="" method=post select name=upn_list option value=Click here to select an FY04 UPN (NOTE: Only the digits are required in the UPN field)/optionoption value=251AST-251/optionoption value=252AST-252/optionoption value=302AST-302/optionoption value=319AST-319/option /select /form Thanks, Sam [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: .bak files in Dreamweaver
That would be my suspiction too, Calvin. Using DWMX 2004 and CT 2 (if you've indeed got your site configured to use Contribute) I'm pretty sure you can find/set this option via: - Site Manage Sites - Highlight the site in question, click Edit to open the site defs window - Select the Contribute category - Click 'Administer site in Contribute' - (Contribute 2 launches) - click the 'Sitewide Settings' button - uncheck 'Enable Rollbacks' HTH! -Scott -Original Message- From: Calvin Ward [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 08, 2003 7:48 AM To: CF-Talk Subject: Re: .bak files in Dreamweaver Are you using Contribute? - Calvin - Original Message - From: Demarco, Alex To: CF-Talk Sent: Wednesday, October 08, 2003 10:38 AM Subject: OT: .bak files in Dreamweaver I had a user ask today How come everytime I save a file a .bak file is also created...Wheere is the option to turn that off? I can't seem to find it. Any ideas? Thanks! - Alex _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Clearing CGI variables
For many years our site has used the CGI.AUTH_USER variable to determine if someone is logged in.This has become a problem because we want to provide a logout option...but there seems to be no way to clear the CGI variables programmatically.We are running Deerfield's (previously O'Reilly's) Website webserver software on a win2k box.Any ideas on how we can tell the webserver to log the user out from CF5 (and thus clear the CGI variables) without forcing them to close their browser? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Clearing CGI variables
CGI variables are provided by the web server, based on what information the client sends to it.To get what you want, you have to tell the browser to stop remembering the credentials for the realm they are currently logged into, which will cause the client to stop sending the auth-user header.I don't think you can do that. barneyb -Original Message- From: Corey Menscher [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 08, 2003 10:52 AM To: CF-Talk Subject: Clearing CGI variables For many years our site has used the CGI.AUTH_USER variable to determine if someone is logged in.This has become a problem because we want to provide a logout option...but there seems to be no way to clear the CGI variables programmatically.We are running Deerfield's (previously O'Reilly's) Website webserver software on a win2k box.Any ideas on how we can tell the webserver to log the user out from CF5 (and thus clear the CGI variables) without forcing them to close their browser? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
OT: Legal?
Ok, a client of mine has gone nuts. He is an agent for a few celebrities, and I had offered to create a site for one of his clients free-of-charge provided I was the one running the site. He has now decided to go to another designer, and wants me to give him the site, which as I said he has not paid for. Now, there is no written contract saying that I would do it for him free-of-charge, so I guess he has me there. But at the same time, since there is no contract saying I would do it free-of-charge, since he hasn't paid me, he is not entitled to the site. I told him if he wanted to pay me for the work, I would give it to him, but he keeps threatening me of legal action. Am I wrong here or is he really entitled to the site? Anyone know anything about the law in this case? Cedric [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: CFTRANSACTION and PostgreSQL/mySQL
Bryan Stevenson wrote: I've seen many posts out there about PostgreSQL and mySQL and rollbacks.I want to know if they will properly rollback (not commit) if a query(s) fail inside a CFTRANSACTION block? PostgreSQL: yes MySQL: only if you take the provisions described in the MySQL manual Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Legal?
I'm not a lawyer but who is listed as owning the domain? If it is under his name then he may win if he took legal action. If it is in your name and there was no written agreement between the 2 of you then I don't think there is much he can do. Ben -Original Message- From: Cedric Villat [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 08, 2003 2:01 PM To: CF-Talk Subject: OT: Legal? Ok, a client of mine has gone nuts. He is an agent for a few celebrities, and I had offered to create a site for one of his clients free-of-charge provided I was the one running the site. He has now decided to go to another designer, and wants me to give him the site, which as I said he has not paid for. Now, there is no written contract saying that I would do it for him free-of-charge, so I guess he has me there. But at the same time, since there is no contract saying I would do it free-of-charge, since he hasn't paid me, he is not entitled to the site. I told him if he wanted to pay me for the work, I would give it to him, but he keeps threatening me of legal action. Am I wrong here or is he really entitled to the site? Anyone know anything about the law in this case? Cedric _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: OT: Legal?
Cedric - Had the same thing happen to me.The code is your intellectual property until YOU release it to the customer.My customer threaten legal action as well, when he didn't want to pay for.I responded by offering to have everything deleted from the server, and then he could go on his merry way.He then decided he would pay for. Not sure where you are, but legally, in the absence of a contract, he shouldn't have a legal basis to stand on.cfinsert check with a lawyer David Groth,Analyst/Programmer III Health Sciences Library Informatics Center MSC09 5100 1 University of New Mexico Albuquerque, New Mexico 87131-0001 Phone: 505.272.8406 / Fax: 505.272.5350 [EMAIL PROTECTED] 10/8/2003 12:01:07 PM Ok, a client of mine has gone nuts. He is an agent for a few celebrities, and I had offered to create a site for one of his clients free-of-charge provided I was the one running the site. He has now decided to go to another designer, and wants me to give him the site, which as I said he has not paid for. Now, there is no written contract saying that I would do it for him free-of-charge, so I guess he has me there. But at the same time, since there is no contract saying I would do it free-of-charge, since he hasn't paid me, he is not entitled to the site. I told him if he wanted to pay me for the work, I would give it to him, but he keeps threatening me of legal action. Am I wrong here or is he really entitled to the site? Anyone know anything about the law in this case? Cedric [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Legal?
if you made the code. its yours, regardless of influence from a prospective buyer. im no lawyer, but I would say unless you are under the confines of employment by someone,or some entity, the code is yours, it intellectual property, and it seems by your involvment with this code, that's its your intellect that created it?correct? ...tony tony weeg senior web applications architect navtrak, inc. www.navtrak.net [EMAIL PROTECTED] 410.548.2337 -Original Message- From: Cedric Villat [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 08, 2003 2:01 PM To: CF-Talk Subject: OT: Legal? Ok, a client of mine has gone nuts. He is an agent for a few celebrities, and I had offered to create a site for one of his clients free-of-charge provided I was the one running the site. He has now decided to go to another designer, and wants me to give him the site, which as I said he has not paid for. Now, there is no written contract saying that I would do it for him free-of-charge, so I guess he has me there. But at the same time, since there is no contract saying I would do it free-of-charge, since he hasn't paid me, he is not entitled to the site. I told him if he wanted to pay me for the work, I would give it to him, but he keeps threatening me of legal action. Am I wrong here or is he really entitled to the site? Anyone know anything about the law in this case? Cedric [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Legal?
not necessarily sound legal advice oops!i hit the wrong key and deleted all of the files on the server. i may have a recent backup somewhere...if only i were motivated enough to look for it... / not necessarily sound legal advice - Original Message - From: Cedric Villat To: CF-Talk Sent: Wednesday, October 08, 2003 11:01 AM Subject: OT: Legal? Ok, a client of mine has gone nuts. He is an agent for a few celebrities, and I had offered to create a site for one of his clients free-of-charge provided I was the one running the site. He has now decided to go to another designer, and wants me to give him the site, which as I said he has not paid for. Now, there is no written contract saying that I would do it for him free-of-charge, so I guess he has me there. But at the same time, since there is no contract saying I would do it free-of-charge, since he hasn't paid me, he is not entitled to the site. I told him if he wanted to pay me for the work, I would give it to him, but he keeps threatening me of legal action. Am I wrong here or is he really entitled to the site? Anyone know anything about the law in this case? Cedric [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
thanks- query output question
Thanks to all for the quick replay -Original Message- From: Ubqtous [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 08, 2003 1:34 PM To: CF-Talk Subject: Re: query output question Tim, On 10/8/2003 at 12:42, you wrote: TL Where category_no=#category2# Use: Where category_no in (#category2#) ~ Ubqtous ~ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Legal?
You really need to talk to a lawyer to get real legal advice. However, my understanding of copyright law is that it depends on if it's freelance or work-for-hire. If you are working freelance then you own the material you create. When it's done and the client receives it (it's put into production for the client), whether they fully own it or not is determined by the contract. Without a contract signing over ownership, I think you retain it. Now, if you were doing it as a work for hire situation, then they own the material. But either way they can likely still take you to court and you could still have to defend that copyright ownership, so you will probably need a lawyer. -Kevin - Original Message - From: Cedric Villat [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, October 08, 2003 1:01 PM Subject: OT: Legal? Ok, a client of mine has gone nuts. He is an agent for a few celebrities, and I had offered to create a site for one of his clients free-of-charge provided I was the one running the site. He has now decided to go to another designer, and wants me to give him the site, which as I said he has not paid for. Now, there is no written contract saying that I would do it for him free-of-charge, so I guess he has me there. But at the same time, since there is no contract saying I would do it free-of-charge, since he hasn't paid me, he is not entitled to the site. I told him if he wanted to pay me for the work, I would give it to him, but he keeps threatening me of legal action. Am I wrong here or is he really entitled to the site? Anyone know anything about the law in this case? Cedric [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: HELP!!! How do I debug server hogging code.
Sorry that would probably be useful information wouldn't it. CFMX 6.0 Win 2000 server Oracle 9i database -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA -Original Message- From: Mike Brunt [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 08, 2003 10:21 AM To: CF-Talk Subject: RE: HELP!!! How do I debug server hogging code. Ian, what version of ColdFusion are you running on what operating system? Kind Regards - Mike Brunt Original Message --- I've got some code that recently started hanging and tying up the server when it is run.It does not throw any errors, but it also never returns any results.It is effecting the entire server box when it does this. Can anybody provide some easy to follow steps on how I could get a better picture on what is happening on the server when this code runs. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
CF Chatroom Scripts
Looking for a CF chat script must be CF 5.0 or older Please contact [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]