RE: jump menu
select name= id= onchange=document.location.href=this.valuevalue=http://www.domain.co ma domain/value/select This is stuff everyone could have found with 5 sec. of Google. Micha Schopman Project Manager Modern Media, Databankweg 12 M, 3821 AL Amersfoort Tel 033-4535377, Fax 033-4535388 KvK Amersfoort 39081679, Rabo 39.48.05.380 - Modern Media, Making You Interact Smarter. Onze oplossingen verbeteren de interactie met uw doelgroep. Wilt u meer omzet, lagere kosten of een beter service niveau? Voor meer informatie zie www.modernmedia.nl - -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: maandag 4 april 2005 5:28 To: CF-Talk Subject: Re: jump menu some sort of javascript enabled drop down box that jumps you to a page? nuttin but a stab in the dark. :) tw On Apr 4, 2005 12:14 AM, Ewok [EMAIL PROTECTED] wrote: Maybe... What's a jump menu -Original Message- From: dave [mailto:[EMAIL PROTECTED] Sent: Saturday, April 02, 2005 10:50 PM To: CF-Talk Subject: jump menu anyone got a good dynamic jump menu? thanks ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201320 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: jump menu
Or a few clicks in DreamWeaver ;-) -Original Message- From: Micha Schopman [mailto:[EMAIL PROTECTED] Sent: Monday, 4 April 2005 2:37 To: CF-Talk Subject: RE: jump menu select name= id= onchange=document.location.href=this.valuevalue=http://www.domain.co ma domain/value/select This is stuff everyone could have found with 5 sec. of Google. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201321 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Page time out problem
Hi, We are using a bulk mailing service, which takes about 5-6 hours to complete. At that time the page will display page cannot be found because of the browser time out. is there a way to display spooled messages(email id) at a regular time interval so that I can avoid time out? Thanks ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201322 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Page time out problem
What about doing them in groups and pushing a status to the screen with CFFlush? -Original Message- From: simmyana a [mailto:[EMAIL PROTECTED] Sent: Sunday, April 03, 2005 11:46 PM To: CF-Talk Subject: Page time out problem Hi, We are using a bulk mailing service, which takes about 5-6 hours to complete. At that time the page will display page cannot be found because of the browser time out. is there a way to display spooled messages(email id) at a regular time interval so that I can avoid time out? Thanks ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201323 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Graphic Manipulation in Coldfusion question.
This offers less features compared to Alagad, but it may worth a check since it's free: http://www.olimpo.ch/tmt/cfc/tmt_img Massimo Foti DW tools: http://www.massimocorner.com CF tools: http://www.olimpo.ch/tmt/ ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201324 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: jump menu
It was googled and an acceptable solution wasn't found so it was asked, sorry to pin your panties to your forehead... From: Micha Schopman [EMAIL PROTECTED] Sent: Monday, April 04, 2005 2:41 AM To: CF-Talk cf-talk@houseoffusion.com Subject: RE: jump menu This is stuff everyone could have found with 5 sec. of Google. Micha Schopman Project Manager Modern Media, Databankweg 12 M, 3821 AL Amersfoort Tel 033-4535377, Fax 033-4535388 KvK Amersfoort 39081679, Rabo 39.48.05.380 - Modern Media, Making You Interact Smarter. Onze oplossingen verbeteren de interactie met uw doelgroep. Wilt u meer omzet, lagere kosten of een beter service niveau? Voor meer informatie zie www.modernmedia.nl - -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: maandag 4 april 2005 5:28 To: CF-Talk Subject: Re: jump menu some sort of javascript enabled drop down box that jumps you to a page? nuttin but a stab in the dark. :) tw On Apr 4, 2005 12:14 AM, Ewok wrote: Maybe... What's a jump menu -Original Message- From: dave [mailto:[EMAIL PROTECTED] Sent: Saturday, April 02, 2005 10:50 PM To: CF-Talk Subject: jump menu anyone got a good dynamic jump menu? thanks ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201325 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: jump menu
dw doesn't give it up dynamically,a menu yes a jump menu no, neither does any of the available extensions, especially not from a cfc and the ones I did get to work seemed to choke for some damn reason when you tried to style them as some of us like to do ;) From: James Holmes [EMAIL PROTECTED] Sent: Monday, April 04, 2005 2:44 AM To: CF-Talk cf-talk@houseoffusion.com Subject: RE: jump menu Or a few clicks in DreamWeaver ;-) -Original Message- From: Micha Schopman [mailto:[EMAIL PROTECTED] Sent: Monday, 4 April 2005 2:37 To: CF-Talk Subject: RE: jump menu This is stuff everyone could have found with 5 sec. of Google. ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201326 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: ColdFusion MX 7 slow?
On Friday 01 Apr 2005 18:46 pm, Dave Watts wrote: generally works well, it is directly supported by the OS vendor, it is scriptable, it includes several application server technologies, and so on. Sounds like Apache... :-) -- Tom Chiverton Advanced ColdFusion Programmer ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201327 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Web Based Mail Merge? (not email!)
a potential command line option - triggered by CF, but only watched not executed. [EMAIL PROTECTED] [ 9:39:34 AM ] Const ForReading = 1 Const ForWriting = 2 Set objFSO = CreateObject(Scripting.FileSystemObject) Set objFile = objFSO.OpenTextFile(C:\Scripts\Text.txt, ForReading) strText = objFile.ReadAll objFile.Close strNewText = Replace(strText, Jim , James ) Set objFile = objFSO.OpenTextFile(C:\Scripts\Text.txt, ForWriting) objFile.WriteLine strNewText objFile.Close [EMAIL PROTECTED] [ 9:48:58 AM ] http://www.rimrocksoftware.com/rsedit.html From: Andy Mcshane [EMAIL PROTECTED] Reply-To: cf-talk@houseoffusion.com To: CF-Talk cf-talk@houseoffusion.com Subject: RE: Web Based Mail Merge? (not email!) Date: Sun, 3 Apr 2005 10:48:04 +0100 I did something like this some time ago, I created the word document, put place holders in for my data, saved it as an rtf file. I then had to copy the RTF text into a .cfm page, process my place holders to put my text in and then save the RTF text back out to another file. This worked well. This was fine when I could control content of the document. Where this requirement now differs is that I want the user to create their own RTF documents and then upload them to our web server into a template directory. Let me run this idea by you, If I provide the user with a list of pre-defined merge field codes, i.e. the coldfusion code that maps to a required peice of data in the database, so that they can create their very own RTF documents, let them upload the document to the template directory on the server, I could then read the RTF file line by line to replace the merge fields with data and write out completed letters to another file. Does anybody see any problems with this idea? Are text file read writes much of an overhead for the server? I envisage that anywhere between 1 - 300+ letters may need to be produced at any one time. you could generate RTF files on the files. add mailmerge fields to a word document - save as RTF and us CF to generate RTF and make available for download. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201328 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
CFMX7 clustering and load balance
Hi CFMX7 WITH JRUN4 -- MULTISERVER INSTALLATION I am having a problem in configuration of clustering... the following steps I done cfusion2 + cfusion3 + remote instance (cfusion4 + cfusion5) Added into cfmx-cluster by using Jrun Admin interface. Reconfigured the IIS6 connector as cfmx-cluster , restart machine. I can see only cfusion2 (local) instance response back. If cfusion2 instance is stopped i have Jrun error on the page. IIS6 connector have a file [ jrunserver.store ] where ip-address:port for cluster servers, I added all IPS restart servers it change back to only one ip address. If there is no remote instance in a cluster then jrunserver.store file hold all ips of local instances. I have read all related docs but still I could not find out the solution. I would appreciate your help. Regards Sana ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201329 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: ColdFusion MX 7 slow?
generally works well, it is directly supported by the OS vendor, it is scriptable, it includes several application server technologies, and so on. Sounds like Apache... :-) Apache has a scripting API? Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201330 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
What are optimal GC/JVM settings?
I run cfmx 6.1 on a dual 1ghz proc machine with 1g of RAM.
What are the best settings for garbage collection and other JVM params.
Here's what I have now:
-server -Dsun.io.useCanonCaches=false
-Xbootclasspath/a:{application.home}/../lib/webchartsJava2D.jar
-XX:MaxPermSize=128m -XX:+UseParallelGC
-Djavax.xml.parsers.SAXParserFactory=com.macromedia.crimson.jaxp.SAXPars
erFactoryImpl
-Djavax.xml.parsers.DocumentBuilderFactory=com.macromedia.crimson.jaxp.D
ocumentBuilderFactoryImpl
Thanks
-Dov
NOTICE: If received in error, please destroy and notify sender. Sender does
not waive confidentiality or privilege, and use is prohibited.
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201331
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Dreaded cfform.js Error
Actually, I'm pretty sure that cfform.js is used by the html forms for JavaScript validation. In CF 5, the JavaScript was embedded in the header, in CFMX 6.1+, the JS is linked to from the header, and that default path is /cfide/scripts/cfform.js (note: wddx JavaScript functions are handled the same way.). One of the possible fixes is to place a copy of the scripts directory on your site under CFIDE. Another solution is to change the src attribute of cfform to point to wherever the file is. And another is to change the default location of the js (in the CF Admin, may be CFMX 7 only). If you do one of these fixes and it still doesn't seem to work, try creating a brandnew form in another file just to test outside of your existing code. - Calvin -Original Message- From: dave [mailto:[EMAIL PROTECTED] Sent: Sunday, April 03, 2005 10:37 PM To: CF-Talk Subject: RE: Dreaded cfform.js Error flash forms are pretty sensitive to errors. I was gunna run it on my machine and see what happens and if I get the same error. If you want feel free to send it to me off line and I will give it a try. From: Russ Unger [EMAIL PROTECTED] Sent: Sunday, April 03, 2005 10:32 PM To: CF-Talk cf-talk@houseoffusion.com Subject: RE: Dreaded cfform.js Error code? It's a couple hundred lines; I was hoping that the behavior might trigger something. It's a bit involved and I'd be happy to share, but I don't want to bog down the list with my sloppy coding. Russ ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201332 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: What are optimal GC/JVM settings?
They all depend on your application and its memory consumptionHave you
ran something like VisualGC to get how much application your system uses?
I would probably tweak yours to be:
java.args=-server -DJINTEGRA_NATIVE_MODE -DJINTEGRA_PREFETCH_ENUMS -Xms768m
-Xmx768m -Dsun.io.useCanonCaches=false
-Xbootclasspath/a:{application.home}/../lib/webchartsJava2D.jar
-Djavax.xml.parsers.SAXParserFactory=com.macromedia.crimson.jaxp.SAXParserFa
ctoryImpl
-Djavax.xml.parsers.DocumentBuilderFactory=com.macromedia.crimson.jaxp.Docum
entBuilderFactoryImpl -XX:MaxPermSize=64m -XX:PermSize=48m -XX:NewSize=256m
But, again I would check the mem consumption first.
-Original Message-
From: Katz, Dov B (IT) [mailto:[EMAIL PROTECTED]
Sent: 04 April 2005 12:24
To: CF-Talk
Subject: What are optimal GC/JVM settings?
I run cfmx 6.1 on a dual 1ghz proc machine with 1g of RAM.
What are the best settings for garbage collection and other JVM params.
Here's what I have now:
-server -Dsun.io.useCanonCaches=false
-Xbootclasspath/a:{application.home}/../lib/webchartsJava2D.jar
-XX:MaxPermSize=128m -XX:+UseParallelGC
-Djavax.xml.parsers.SAXParserFactory=com.macromedia.crimson.jaxp.SAXPars
erFactoryImpl
-Djavax.xml.parsers.DocumentBuilderFactory=com.macromedia.crimson.jaxp.D
ocumentBuilderFactoryImpl
Thanks
-Dov
NOTICE: If received in error, please destroy and notify sender. Sender does
not waive confidentiality or privilege, and use is prohibited.
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201333
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: What are optimal GC/JVM settings?
There are some fairly detailed instructions on performance tuning the JVM
for CFMX on Sarge's blog.
http://www.sargeway.com/sarge/index.cfm?mode=entryentry=27
HTH,
Jeff Garza
-Original Message-
From: Katz, Dov B (IT) [mailto:[EMAIL PROTECTED]
Sent: Monday, April 04, 2005 4:24 AM
To: CF-Talk
Subject: What are optimal GC/JVM settings?
I run cfmx 6.1 on a dual 1ghz proc machine with 1g of RAM.
What are the best settings for garbage collection and other JVM params.
Here's what I have now:
-server -Dsun.io.useCanonCaches=false
-Xbootclasspath/a:{application.home}/../lib/webchartsJava2D.jar
-XX:MaxPermSize=128m -XX:+UseParallelGC
-Djavax.xml.parsers.SAXParserFactory=com.macromedia.crimson.jaxp.SAXPars
erFactoryImpl
-Djavax.xml.parsers.DocumentBuilderFactory=com.macromedia.crimson.jaxp.D
ocumentBuilderFactoryImpl
Thanks
-Dov
NOTICE: If received in error, please destroy and notify sender. Sender does
not waive confidentiality or privilege, and use is prohibited.
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201334
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: ColdFusion MX 7 slow?
Web applications are written in high-level languages such as Java, Perl, C# and so on and Apache has several modules that integrate them with the server. In many cases the modules expose the Apache API so entire Apache modules can be written in those languages. (From http://www.faqs.org/docs/Linux-HOWTO/Apache-Overview-HOWTO.html#ss2.6) The 1.3 API in brief: http://httpd.apache.org/dev/apidoc/ -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Monday, 4 April 2005 7:13 To: CF-Talk Subject: RE: ColdFusion MX 7 slow? generally works well, it is directly supported by the OS vendor, it is scriptable, it includes several application server technologies, and so on. Sounds like Apache... :-) Apache has a scripting API? ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201335 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: ColdFusion MX 7 slow?
Web applications are written in high-level languages such as Java, Perl, C# and so on and Apache has several modules that integrate them with the server. In many cases the modules expose the Apache API so entire Apache modules can be written in those languages. That's not what I meant at all. I'm not talking about writing web applications, but rather being able to script the web server's own operation. For example, with IIS you can write a command-line script to create virtual directories, or virtual web servers, or do practically anything else you can do through the management GUI. IIS has a scripting API. If I recall correctly, Apache has a C API. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201336 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: ColdFusion MX 7 slow?
Ah, I see. It would be straightforward enough to do all of that in any given language by writing to the Apache conf files. -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Monday, 4 April 2005 8:56 To: CF-Talk Subject: RE: ColdFusion MX 7 slow? Web applications are written in high-level languages such as Java, Perl, C# and so on and Apache has several modules that integrate them with the server. In many cases the modules expose the Apache API so entire Apache modules can be written in those languages. That's not what I meant at all. I'm not talking about writing web applications, but rather being able to script the web server's own operation. For example, with IIS you can write a command-line script to create virtual directories, or virtual web servers, or do practically anything else you can do through the management GUI. IIS has a scripting API. If I recall correctly, Apache has a C API. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201337 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: What are optimal GC/JVM settings?
http://www.robisen.com/
robis sen has some good info too. Also be sure to check out Pete Frietag's
blog
http://www.petefreitag.com/
D
On Apr 4, 2005 7:53 AM, Jeff Garza [EMAIL PROTECTED] wrote:
There are some fairly detailed instructions on performance tuning the JVM
for CFMX on Sarge's blog.
http://www.sargeway.com/sarge/index.cfm?mode=entryentry=27
HTH,
Jeff Garza
-Original Message-
From: Katz, Dov B (IT) [mailto:[EMAIL PROTECTED]
Sent: Monday, April 04, 2005 4:24 AM
To: CF-Talk
Subject: What are optimal GC/JVM settings?
I run cfmx 6.1 on a dual 1ghz proc machine with 1g of RAM.
What are the best settings for garbage collection and other JVM params.
Here's what I have now:
-server -Dsun.io.useCanonCaches=false
-Xbootclasspath/a:{application.home}/../lib/webchartsJava2D.jar
-XX:MaxPermSize=128m -XX:+UseParallelGC
-Djavax.xml.parsers.SAXParserFactory=com.macromedia.crimson.jaxp.SAXPars
erFactoryImpl
-Djavax.xml.parsers.DocumentBuilderFactory=com.macromedia.crimson.jaxp.D
ocumentBuilderFactoryImpl
Thanks
-Dov
NOTICE: If received in error, please destroy and notify sender. Sender
does
not waive confidentiality or privilege, and use is prohibited.
~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble
Ticket application
http://www.houseoffusion.com/banners/view.cfm?bannerid=48
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201338
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: ColdFusion MX 7 slow?
Ah, I see. It would be straightforward enough to do all of that in any given language by writing to the Apache conf files. Well, yeah, except that you'd also have to kick the server to have it reread the conf files. You can do that with IIS 6 too, if you want to - the metabase is just a big XML file. But the point of a scripting API is that you don't have to do that work. You can just call the appropriate method and the work happens automatically. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201339 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: ColdFusion MX 7 slow?
Dave, Do you know of a good scripting API for creating sites and such in IIS? I'm trying to find a good reliable way of creating sites in IIS6 using CF. John Burns Certified Advanced ColdFusion MX Developer Wyle Laboratories, Inc. | Web Developer -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Monday, April 04, 2005 9:18 AM To: CF-Talk Subject: RE: ColdFusion MX 7 slow? Ah, I see. It would be straightforward enough to do all of that in any given language by writing to the Apache conf files. Well, yeah, except that you'd also have to kick the server to have it reread the conf files. You can do that with IIS 6 too, if you want to - the metabase is just a big XML file. But the point of a scripting API is that you don't have to do that work. You can just call the appropriate method and the work happens automatically. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201340 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: ColdFusion MX 7 slow?
Keyboard and mouse ;-) -Original Message- From: Burns, John D [mailto:[EMAIL PROTECTED] Sent: 04 April 2005 14:34 To: CF-Talk Subject: RE: ColdFusion MX 7 slow? Dave, Do you know of a good scripting API for creating sites and such in IIS? I'm trying to find a good reliable way of creating sites in IIS6 using CF. John Burns Certified Advanced ColdFusion MX Developer Wyle Laboratories, Inc. | Web Developer -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Monday, April 04, 2005 9:18 AM To: CF-Talk Subject: RE: ColdFusion MX 7 slow? Ah, I see. It would be straightforward enough to do all of that in any given language by writing to the Apache conf files. Well, yeah, except that you'd also have to kick the server to have it reread the conf files. You can do that with IIS 6 too, if you want to - the metabase is just a big XML file. But the point of a scripting API is that you don't have to do that work. You can just call the appropriate method and the work happens automatically. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201341 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: ColdFusion MX 7 slow?
I used some vbscript and the Windows Scripting Host to create virtual
directories that web-enable our users' home directories.
I'm not sure if you can do this with CF, but it's worth a try. Search
for ADSI, IIS and some other related terms on Microsoft's dev site.
Here is my code to create the virtuals. It might give you some more
keywords on which to search:
PhysPath = d:\users\
Set oIIS = GetObject (IIS://localhost/W3SVC/1)
Set IISRoot = oIIS.GetObject(IIsWebVirtualDir, Root)
Set fso = CreateObject(Scripting.FileSystemObject)
Set rootFldr = fso.GetFolder(PhysPath)
Set subFldrs = rootFldr.SubFolders
Set oRE = New RegExp
oRE.IgnoreCase = True
oRE.Pattern = ^[a-z]{2}[0-9]{1,5}$
On Error Resume Next
For Each subFldr In subFldrs
If (oRE.Test(subFldr.Name) = True) Then
WScript.Echo subFldr.Path
Set oVirtDir = IISRoot.Create(IIsWebVirtualDir,
subFldr.Name)
oVirtDir.AccessRead = true
oVirtDir.AccessWrite = true
oVirtDir.EnableDirBrowsing = true
oVirtDir.AuthAnonymous = false
oVirtDir.AuthNTLM = true
oVirtDir.Path = subFldr.Path
oVirtDir.SetInfo
ovirtDir.AppCreate2(2)
oVirtDir.AppFriendlyName = subFldr.Name
oVirtDir.SetInfo
Set oVirtDir = Nothing
End If
Set oVirtDir = Nothing
Next
Thanks
M!ke
-Original Message-
From: Burns, John D [mailto:[EMAIL PROTECTED]
Sent: Monday, April 04, 2005 8:34 AM
To: CF-Talk
Subject: RE: ColdFusion MX 7 slow?
Dave,
Do you know of a good scripting API for creating sites and such in IIS?
I'm trying to find a good reliable way of creating sites in IIS6 using
CF.
John Burns
Certified Advanced ColdFusion MX Developer Wyle Laboratories, Inc. | Web
Developer
~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble
Ticket application
http://www.houseoffusion.com/banners/view.cfm?bannerid=48
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201342
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CFMX7 clustering and load balance
Sana, I replied to your post on CF-DEV. Did you look into multicasting? -Adam On Apr 4, 2005 6:34 AM, Sana Ullah [EMAIL PROTECTED] wrote: Hi CFMX7 WITH JRUN4 -- MULTISERVER INSTALLATION I am having a problem in configuration of clustering... the following steps I done cfusion2 + cfusion3 + remote instance (cfusion4 + cfusion5) Added into cfmx-cluster by using Jrun Admin interface. Reconfigured the IIS6 connector as cfmx-cluster , restart machine. I can see only cfusion2 (local) instance response back. If cfusion2 instance is stopped i have Jrun error on the page. IIS6 connector have a file [ jrunserver.store ] where ip-address:port for cluster servers, I added all IPS restart servers it change back to only one ip address. If there is no remote instance in a cluster then jrunserver.store file hold all ips of local instances. I have read all related docs but still I could not find out the solution. I would appreciate your help. Regards Sana ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201343 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: ColdFusion MX 7 slow?
Here is the code to *delete* virtuals, just in case: ' Note: This script must be run numerous times until ' all virtuals have been removed. IIS can't keep ' up with the quick delete operations. Set oIIS = GetObject (IIS://localhost/W3SVC/1) Set IISRoot = oIIS.GetObject(IIsWebVirtualDir, Root) For Each ChildObject In IISRoot WScript.Echo ChildObject.Name Next For Each ChildObject In IISRoot IISRoot.Delete IISWebVirtualDir, / ChildObject.Name Next Set IISRoot = Nothing Set oIIS = Nothing ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201344 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Web Based Mail Merge? (not email!)
It would be great if you could point to an online data source in Word. Tell Word that your CSV file is at http://mysite.com/data.csv. Everyone would have a copy of the Word file. Then just schedule CF to update your CSV. Maybe some VBScript or .NET? Anyone know if that's possible? -Brad -Original Message- From: Andy Mcshane [mailto:[EMAIL PROTECTED] Sent: Sunday, April 03, 2005 5:48 AM To: CF-Talk Subject: RE: Web Based Mail Merge? (not email!) I did something like this some time ago, I created the word document, put place holders in for my data, saved it as an rtf file. I then had to copy the RTF text into a .cfm page, process my place holders to put my text in and then save the RTF text back out to another file. This worked well. This was fine when I could control content of the document. Where this requirement now differs is that I want the user to create their own RTF documents and then upload them to our web server into a template directory. Let me run this idea by you, If I provide the user with a list of pre-defined merge field codes, i.e. the coldfusion code that maps to a required peice of data in the database, so that they can create their very own RTF documents, let them upload the document to the template directory on the server, I could then read the RTF file line by line to replace the merge fields with data and write out completed letters to another file. Does anybody see any problems with this idea? Are text file read writes much of an overhead for the server? I envisage that anywhere between 1 - 300+ letters may need to be produced at any one time. you could generate RTF files on the files. add mailmerge fields to a word document - save as RTF and us CF to generate RTF and make available for download. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201345 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: ColdFusion MX 7 slow?
Michael, Thanks for the useful info. I will definitely check this out. If anyone else has resources for this type of functionality, specifically creating new sites and retrieving site info (by name if possible) that would be great. Thanks! John Burns Certified Advanced ColdFusion MX Developer Wyle Laboratories, Inc. | Web Developer -Original Message- From: Dawson, Michael [mailto:[EMAIL PROTECTED] Sent: Monday, April 04, 2005 9:47 AM To: CF-Talk Subject: RE: ColdFusion MX 7 slow? Here is the code to *delete* virtuals, just in case: ' Note: This script must be run numerous times until ' all virtuals have been removed. IIS can't keep ' up with the quick delete operations. Set oIIS = GetObject (IIS://localhost/W3SVC/1) Set IISRoot = oIIS.GetObject(IIsWebVirtualDir, Root) For Each ChildObject In IISRoot WScript.Echo ChildObject.Name Next For Each ChildObject In IISRoot IISRoot.Delete IISWebVirtualDir, / ChildObject.Name Next Set IISRoot = Nothing Set oIIS = Nothing ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201346 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: What are optimal GC/JVM settings?
On my machines, with 2GB RAM and dual Xeons of various speeds, I have mine
JVM setting as follows:
MAX HEAP SIZE: 1024
MAX PERM SIZE: 512
These are the only two changes I had to make for my settings.
-Original Message-
From: Katz, Dov B (IT) [mailto:[EMAIL PROTECTED]
Sent: Monday, April 04, 2005 4:24 AM
To: CF-Talk
Subject: What are optimal GC/JVM settings?
I run cfmx 6.1 on a dual 1ghz proc machine with 1g of RAM.
What are the best settings for garbage collection and other JVM params.
Here's what I have now:
-server -Dsun.io.useCanonCaches=false
-Xbootclasspath/a:{application.home}/../lib/webchartsJava2D.jar
-XX:MaxPermSize=128m -XX:+UseParallelGC
-Djavax.xml.parsers.SAXParserFactory=com.macromedia.crimson.jaxp.SAXPars
erFactoryImpl
-Djavax.xml.parsers.DocumentBuilderFactory=com.macromedia.crimson.jaxp.D
ocumentBuilderFactoryImpl
Thanks
-Dov
NOTICE: If received in error, please destroy and notify sender. Sender does
not waive confidentiality or privilege, and use is prohibited.
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201347
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: ColdFusion MX 7 slow?
Do you know of a good scripting API for creating sites and such in IIS? I'm trying to find a good reliable way of creating sites in IIS6 using CF. When you install IIS, by default, you get a bunch of WSH scripts that will do most of what you want. Look in your \Inetpub\Adminscripts folder. You might also check out http://www.iisfaq.com/. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201348 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: What are optimal GC/JVM settings?
Forgot one thing...
Check your CF error logs. When you start to see Out of Memory errors, you
need to increase it.
-Original Message-
From: Jacob [mailto:[EMAIL PROTECTED]
Sent: Monday, April 04, 2005 7:06 AM
To: CF-Talk
Subject: RE: What are optimal GC/JVM settings?
On my machines, with 2GB RAM and dual Xeons of various speeds, I have mine
JVM setting as follows:
MAX HEAP SIZE: 1024
MAX PERM SIZE: 512
These are the only two changes I had to make for my settings.
-Original Message-
From: Katz, Dov B (IT) [mailto:[EMAIL PROTECTED]
Sent: Monday, April 04, 2005 4:24 AM
To: CF-Talk
Subject: What are optimal GC/JVM settings?
I run cfmx 6.1 on a dual 1ghz proc machine with 1g of RAM.
What are the best settings for garbage collection and other JVM params.
Here's what I have now:
-server -Dsun.io.useCanonCaches=false
-Xbootclasspath/a:{application.home}/../lib/webchartsJava2D.jar
-XX:MaxPermSize=128m -XX:+UseParallelGC
-Djavax.xml.parsers.SAXParserFactory=com.macromedia.crimson.jaxp.SAXPars
erFactoryImpl
-Djavax.xml.parsers.DocumentBuilderFactory=com.macromedia.crimson.jaxp.D
ocumentBuilderFactoryImpl
Thanks
-Dov
NOTICE: If received in error, please destroy and notify sender. Sender does
not waive confidentiality or privilege, and use is prohibited.
~|
Find out how CFTicket can increase your company's customer support
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201349
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations Support: http://www.houseoffusion.com/tiny.cfm/54
CSV file and com.Ostermiller.util.ExcelCSVParser
I am using com.Ostermiller.util.ExcelCSVParser with great succes to parse csv files. There is only one small problem that I can't figure out.If there are any empty columns in the file they are not picked up and as a result the parsing process is failing. The work around is to open the file in excel and run a replace all (for empty string with a space). Unfortunately this is used by end users and for some reason they don't do it ... Is any way to do it programmatically? Thanks Victor ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201350 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: CSV file and com.Ostermiller.util.ExcelCSVParser
this will probably be because CF ignores empty list elements. there might be some kind of a split function on cflib.org -Original Message- From: Victor Moore [mailto:[EMAIL PROTECTED] Sent: 04 April 2005 15:14 To: CF-Talk Subject: CSV file and com.Ostermiller.util.ExcelCSVParser I am using com.Ostermiller.util.ExcelCSVParser with great succes to parse csv files. There is only one small problem that I can't figure out.If there are any empty columns in the file they are not picked up and as a result the parsing process is failing. The work around is to open the file in excel and run a replace all (for empty string with a space). Unfortunately this is used by end users and for some reason they don't do it ... Is any way to do it programmatically? Thanks Victor ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201351 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
OT kind of (xml layout)
I am creating an xml string to be used by XMLHTTP via javascript. the page that creates the xml string I am using cfoutput?xml version=1.0?rootelem/elemelem2/elem2..so on/root/cfoutput Being on one straight line it is very hard to read. But if I use cfsavecontent var=test ?xml version=1.0? root elem/elem elem2/elem2 ..so on /root /cfsavecontent XMLHTTP has an error. How can I use the savecontent method but output the xml like the first example? Thanks David ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201352 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: OT kind of (xml layout)
I am creating an xml string to be used by XMLHTTP via javascript. the page that creates the xml string I am using cfoutput?xml version=1.0?rootelem/elemelem2/elem2..so on/root/cfoutput Being on one straight line it is very hard to read. But if I use cfsavecontent var=test ?xml version=1.0? root elem/elem elem2/elem2 ..so on /root /cfsavecontent XMLHTTP has an error. How can I use the savecontent method but output the xml like the first example? If you're using CFMX, you might want to use CFXML instead of CFSAVECONTENT. But honestly, does it really matter if it's hard to read? You can just save it with a .xml extension, then open it in any browser and the browser will make a nice readable tree for you. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201353 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
recordsets return by stored procedures?
Hi, Is there a way to find out how many recordsets return by a stored procedure? Or is there a way to merge all the recordsets in a stored procedure so that it would only return 1 recordset? I have a stored procedure that would return an unknown number of recordsets depending on how many records we have in the database, but each recordset will have the same number of columns and column names. I need to know the number of recorsets it will return so I can do a loop for the cfprocresult. Johnny ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201354 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Search engine question
I've not found that the domain NAME really matters so much as long as it is usable and memorable to PEOPLE. What I have found is that it's very easy to get a page ranked very highly for a specific set of terms. That being the case, I did that for several different sites on the same terms with the same products managed from the same back-end. The end result has been a tremendously successful growth in sales by occupying so many positions high in the rankings that all appear to be competitors. On my top 3 search words/phrases, 5 of my sites take up 12 of the top rankings. --Ferg -Original Message- From: Rick Faircloth [mailto:[EMAIL PROTECTED] Sent: Friday, April 01, 2005 12:14 PM To: CF-Talk Subject: RE: Search engine question I'm sure the domain names play into the rankings, but they can be used deceptively so easily, I don't know how much weight the actual domain name carries...? Rick -Original Message- From: Nick Baker [mailto:[EMAIL PROTECTED] Sent: Friday, April 01, 2005 2:34 AM To: CF-Talk Subject: Re: Search engine question Search engines try to keep their methodologies close to the vest, but I have read some past talk about how search engines weight the relevant words in the domain name itself. That makes sense simply because one needs to keep the domain name within the realm of relevancy. Ken mentioned early on in the thread about the concept of spreading one's business over several sites, based on subcategories of products. Then inter-linking the sites. That is a good marketing strategy in itself simply because it is less noise to the site visitor. Domain names are inexpensive. That old idea of having a short domain name just doesn't fit anymore. For less than $30 bucks a year. Johndoestennisshop.com Johndoestennisballs.com Johndoestennisrackets.com Johndoestennisshoes.com Seems to offer advantages over something like the below Johndoestennisshop.com/rackets Johndoestennisshop.com/balls Johndoestennisshop.com/shoes Plus this gives more home pages to work with. Another 2 cents, Nick ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201355 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Verity Style Files
Does anyone know if it is possible to populate the CF custom fields with the properties fields (title, keywords, comments, etc) from Word documents automatically when Verity indexes by changing the Verity style files? I am able to populate the native fields for these properties in Verity by modifying style.sfl and I am able to add them to the search by modifying style.dft but I have not found away to return the values using Cold Fusion 7. -Kore ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201356 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
ms-sql ( if statements )
I dont see why my if ..else statements are causing errors when performing a query against an ms-sql database CODE: if #form.what# = 1 select * from candidate where else select * from advertiser where if #form.by# = 1 if #form.what# eq 1 first_name like '%#form.dastring#%' or last_name like '%#form.dastring#%' else company_name like '%#form.dastring#%' else if #form.by# = 2 if #form.what# eq 1 email like '%#form.dastring#%' else contact_email like '%#form.dastring#%' else id = '#form.dastring#' ERROR: Error Executing Database Query. [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near the keyword 'else'. The error occurred in C:\Inetpub\wwwroot\executivesontheweb\admin\usermanagement\search.cfm: line 78 76 :contact_email like '%#form.dastring#%' 77 :else 78 :id = '#form.dastring#' 79 : 80 :/cfquery SQLif 1 = 1 select * from candidate where else select * from advertiser where if 2 = 1 if 1 eq 1 first_name like '%mystring%' or last_name like '%mystring%' else company_name like '%mystring%' else if 2 = 2 if 1 eq 1 email like '%mystring%' else contact_email like '%mystring%' else id = 'mystring' ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201357 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: recordsets return by stored procedures?
If they have the same set of column names you could do a union of the results creating a single recordset adding your own custom column to identify which set of results you are looking at: SELECT f_name, l_name, 'contact' as myGrouping FROM contacts UNION SELECT f_name, l_name, 'clients' as myGrouping FROM clients etc... But the bigger question is - why is your stored proc returning an unknown number of recordsets? This type of question usually can be answered by revisiting the stored proc to get it to generate a single recordset in the first place. If it just gets too complex a different answer would be to put the results into a temp table and return that recordset: SELECT f_name, l_name, 'contact' as myGrouping INTO #myTempTable FROM contacts INSERT INTO #myTempTable SELECT f_name, l_name, 'clients' as myGrouping FROM clients HTH, Adam Howitt On Apr 4, 2005 10:06 AM, Johnny Le [EMAIL PROTECTED] wrote: Hi, Is there a way to find out how many recordsets return by a stored procedure? Or is there a way to merge all the recordsets in a stored procedure so that it would only return 1 recordset? I have a stored procedure that would return an unknown number of recordsets depending on how many records we have in the database, but each recordset will have the same number of columns and column names. I need to know the number of recorsets it will return so I can do a loop for the cfprocresult. Johnny ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201358 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: recordsets return by stored procedures?
And unknown amount..can't you just return empty sets if now records exist (unless you are using god awful dynamic SQL within the SP! ) -Original Message- From: Johnny Le [mailto:[EMAIL PROTECTED] Sent: 04 April 2005 16:07 To: CF-Talk Subject: recordsets return by stored procedures? Hi, Is there a way to find out how many recordsets return by a stored procedure? Or is there a way to merge all the recordsets in a stored procedure so that it would only return 1 recordset? I have a stored procedure that would return an unknown number of recordsets depending on how many records we have in the database, but each recordset will have the same number of columns and column names. I need to know the number of recorsets it will return so I can do a loop for the cfprocresult. Johnny ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201359 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: jump menu
I must be missing something. A basic one would be rather simple.
cfset locations = index.cfm,index1.cfm,index2.cfm /
cfoutput
select size=1 onChange=if (this.value !=
''){document.location=this.value};
option- - - - - - - - - - - - - - - - - - - - - - /option
cfloop list=#locations# index=I
option value=#i##i#/option
/cfloop
/select
/cfoutput
What else do you want from it? The overall style would be handled from a
style sheet. Individual option styles could be handled with a different
formatted list (or array)
cfset loc = arraynew(1) /
cfset arrayappend(loc, index.cfm,cc) /
cfset arrayappend(loc, index2.cfm,ececec) /
cfset arrayappend(loc, index3.cfm,ff) /
cfoutput
select size=1 onChange=if (this.value !=
''){document.location=this.value};
option- - - - - - - - - - - - - - - - - - - - - - /option
cfloop from=1 to=#arraylen(loc)# index=i
option value=#listfirst(loc[i])#
style=background-color:#listlast(loc[i])# #listfirst(loc[i])#/option
/cfloop
/select
/cfoutput
Guess I'm just not sure what more you want (or could get) out of a drop down
menu...
I searched google for What is dave wanting in this drop down but no
results :)
-Original Message-
From: dave [mailto:[EMAIL PROTECTED]
Sent: Monday, April 04, 2005 5:18 AM
To: CF-Talk
Subject: RE: jump menu
dw doesn't give it up dynamically,a menu yes a jump menu no, neither does
any of the available extensions, especially not from a cfc and the ones I
did get to work seemed to choke for some damn reason when you tried to style
them as some of us like to do ;)
From: James Holmes [EMAIL PROTECTED]
Sent: Monday, April 04, 2005 2:44 AM
To: CF-Talk cf-talk@houseoffusion.com
Subject: RE: jump menu
Or a few clicks in DreamWeaver ;-)
-Original Message-
From: Micha Schopman [mailto:[EMAIL PROTECTED]
Sent: Monday, 4 April 2005 2:37
To: CF-Talk
Subject: RE: jump menu
This is stuff everyone could have found with 5 sec. of Google.
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201360
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: recordsets return by stored procedures?
Assuming that each recordset you're returning has something that could uniquely identify it (eg a productID), I would probably return just 1 recordset, with all the data that you were returning via multiple recordsets combined - just add the ID number. Then when you're outputting or processing, just use the group attribute of cfoutput, or use QoQ. HTH, Alex -Original Message- From: Johnny Le [mailto:[EMAIL PROTECTED] Sent: 04 April 2005 16:07 To: CF-Talk Subject: recordsets return by stored procedures? Hi, Is there a way to find out how many recordsets return by a stored procedure? Or is there a way to merge all the recordsets in a stored procedure so that it would only return 1 recordset? I have a stored procedure that would return an unknown number of recordsets depending on how many records we have in the database, but each recordset will have the same number of columns and column names. I need to know the number of recorsets it will return so I can do a loop for the cfprocresult. Johnny ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201361 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: recordsets return by stored procedures?
Hi, Is there a way to find out how many recordsets return by a stored procedure? Or is there a way to merge all the recordsets in a stored procedure so that it would only return 1 recordset? I have a stored procedure that would return an unknown number of recordsets depending on how many records we have in the database, but each recordset will have the same number of columns and column names. I need to know the number of recorsets it will return so I can do a loop for the cfprocresult. Johnny JDBC may privde some reporting of this information... I don't remember off the top of my head, but the onTap framework has a tag designed to execute stored procedures with named parameters (uses a structure, i.e. the form scope for instance). I know it's designed to allow multiple result sets, although unfortunately I don't remember offhand if the automation is driven by the code or by meta-data returned from the database. If you're interested in going that route, check out my JDBC article in the ColdFusion Developer's Journal. http://www.sys-con.com/story/?storyid=45569de=1 Otherwise, if you have control over the stored procedure, I'd recommend rewriting it so that all of the recordsets are returned (regardless of conditions) with any unneeded recordsets simply being empty (a select statement which returns records where the table's primary key is null is an easy way to achieve this). If you need to distinguish these results from results which would otherwise return an empty recordset, you can return an output parameter from the procedure with an integer indicating the number of relevant recordsets. hth s. isaac dealey 954.522.6080 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://macromedia.breezecentral.com/p49777853/ http://www.sys-con.com/author/?id=4806 http://www.fusiontap.com ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201362 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: OT kind of (xml layout)
Thanks again Dave for the reply. You are correct I just wanted to know if there was a way. BTW on the webservice question that you answered yesterday. changing the name from com to cfcs did not fix the problem. I created a mapping to cfcs and I can still read the wsdl, but get an error when trying to invoke the webservice. - Original Message - From: Dave Watts [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Monday, April 04, 2005 10:54 AM Subject: RE: OT kind of (xml layout) If you're using CFMX, you might want to use CFXML instead of CFSAVECONTENT. But honestly, does it really matter if it's hard to read? You can just save it with a .xml extension, then open it in any browser and the browser will make a nice readable tree for you. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201363 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: OT kind of (xml layout)
You might try trimming the cfsavecontent variable -- a lot of xml parsers (stupidly) won't trim whitespace from the beginning of a file and produce an error if there's white space before the doctype. Dave's suggestion of using cfxml isn't a bad idea either -- though it may not be as efficient -- though I wouldn't expect efficiency of that scale to be significant unless it's a rather large xml packet receiving inordinately large amounts of uncached traffic. I am creating an xml string to be used by XMLHTTP via javascript. the page that creates the xml string I am using cfoutput?xml version=1.0?rootelem/elemelem2/elem2..so on/root/cfoutput Being on one straight line it is very hard to read. But if I use cfsavecontent var=test ?xml version=1.0? root elem/elem elem2/elem2 ..so on /root /cfsavecontent XMLHTTP has an error. How can I use the savecontent method but output the xml like the first example? Thanks David s. isaac dealey 954.522.6080 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://macromedia.breezecentral.com/p49777853/ http://www.sys-con.com/author/?id=4806 http://www.fusiontap.com ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201364 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: ms-sql ( if statements )
If you want to do this kind of dynamic query, I believe you need to be using the CASE WHEN THEN ELSE END format for ms-sql, but that will be a beast to create. If you want to do this with CF creating a dynamic query, you'd do something like this: cfquery cfif form.what = 1 select * from candidate where cfelse select * from advertiser where /cfif cfif form.by = 1 cfif form.what eq 1 first_name like '%#form.dastring#%' or last_name like '%#form.dastring#%' cfelse company_name like '%#form.dastring#%' /cfif cfelse cfif form.by = 2 cfif form.what eq 1 email like '%#form.dastring#%' cfelse contact_email like '%#form.dastring#%' /cfif cfelse id = '#form.dastring#' /cfif On Apr 4, 2005 10:15 AM, Protoculture [EMAIL PROTECTED] wrote: I dont see why my if ..else statements are causing errors when performing a query against an ms-sql database CODE: if #form.what# = 1 select * from candidate where else select * from advertiser where if #form.by# = 1 if #form.what# eq 1 first_name like '%#form.dastring#%' or last_name like '%#form.dastring#%' else company_name like '%#form.dastring#%' else if #form.by# = 2 if #form.what# eq 1 email like '%#form.dastring#%' else contact_email like '%#form.dastring#%' else id = '#form.dastring#' ERROR: Error Executing Database Query. [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near the keyword 'else'. The error occurred in C:\Inetpub\wwwroot\executivesontheweb\admin\usermanagement\search.cfm: line 78 76 :contact_email like '%#form.dastring#%' 77 :else 78 :id = '#form.dastring#' 79 : 80 :/cfquery SQLif 1 = 1 select * from candidate where else select * from advertiser where if 2 = 1 if 1 eq 1 first_name like '%mystring%' or last_name like '%mystring%' else company_name like '%mystring%' else if 2 = 2 if 1 eq 1 email like '%mystring%' else contact_email like '%mystring%' else id = 'mystring' ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201365 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: ms-sql ( if statements )
If you look at the SQL statement as it was parsed you can see that it isn't valid sql immediately. select * from candidate where else select * from advertiser where if 2 = 1 if 1 eq 1 first_name like '%mystring%' or last_name like '%mystring%' else company_name like '%mystring%' else if 2 = 2 if 1 eq 1 email like '%mystring%' else contact_email like '%mystring%' else id = 'mystring' Also the if else construct in MSSQL Server can't be used inline. In this case you can use the CASE WHEN construct but judging by the dynamic nature of the full query you should replace your if then statements with CFIF CFELSE statements and send a complete query: cfif form.what eq 1 select * from candidate where cfelse select * from advertiser where /cfif cfif form.by eq 1 etc ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201366 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Dreaded cfform.js Error
Make sure you have the /cfide directory mapped as a virtual directory on your web server. On Apr 4, 2005 7:31 AM, Calvin Ward [EMAIL PROTECTED] wrote: Actually, I'm pretty sure that cfform.js is used by the html forms for JavaScript validation. In CF 5, the JavaScript was embedded in the header, in CFMX 6.1+, the JS is linked to from the header, and that default path is /cfide/scripts/cfform.js (note: wddx JavaScript functions are handled the same way.). One of the possible fixes is to place a copy of the scripts directory on your site under CFIDE. Another solution is to change the src attribute of cfform to point to wherever the file is. And another is to change the default location of the js (in the CF Admin, may be CFMX 7 only). If you do one of these fixes and it still doesn't seem to work, try creating a brandnew form in another file just to test outside of your existing code. - Calvin -Original Message- From: dave [mailto:[EMAIL PROTECTED] Sent: Sunday, April 03, 2005 10:37 PM To: CF-Talk Subject: RE: Dreaded cfform.js Error flash forms are pretty sensitive to errors. I was gunna run it on my machine and see what happens and if I get the same error. If you want feel free to send it to me off line and I will give it a try. From: Russ Unger [EMAIL PROTECTED] Sent: Sunday, April 03, 2005 10:32 PM To: CF-Talk cf-talk@houseoffusion.com Subject: RE: Dreaded cfform.js Error code? It's a couple hundred lines; I was hoping that the behavior might trigger something. It's a bit involved and I'd be happy to share, but I don't want to bog down the list with my sloppy coding. Russ ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201367 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: What are optimal GC/JVM settings?
Douglas Knudsen wrote: http://www.robisen.com/ robis sen has some good info too. Also be sure to check out Pete Frietag's blog http://www.petefreitag.com/ You can try using the new tag feature I have added to my blog, and look under the jvm tag: http://www.petefreitag.com/tag/jvm I haven't tagged all of my posts yet however. -- Pete Freitag work: http://www.cfdev.com/ blog: http://www.petefreitag.com/ shop: http://www.dealazon.com/ ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201368 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
rookie: link table
Dear list, My task management app gets a list of tasks, like so: -- CFQUERY name=get_tasks datasource=taskomatic SELECT tasks.task_id, tasks.name AS taskname, tasks.deadline, tasks.project_id, tasks.importance_id, tasks.owner_id, tasks.lead_time, tasks.status_id, projects.project_id, projects.name AS projectname, projects.colour, projects.company_id, people.person_id, people.name AS ownername, importance.importance_id, importance.importance AS importancename, FROM tasks JOIN projects ON tasks.project_id = projects.project_id JOIN people ON tasks.owner_id = people.person_id JOIN importance ON tasks.importance_id = importance.importance_id WHERE tasks.status_id = 1 CFIF Session.company_id neq 0 !--- this is the bit i need help with--- /CFIF ORDER BY #order# /CFQUERY -- What I'd like to happen is that: if the session variable company_id is not 0, it only gets TASKS that belong to the PROJECT that the PERSON is cleared for. My link table is called PEOPLE_PROJECT and it has two columns: -- person_id | project_id -- There is a tasks.project_id and of course a project.project_id (and a people.person_id if that's relevant). How do I do this? I can't seem to get my head around it. Many thanks! CK. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201369 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Conditional Select Boxes
With the advent of the new and improved cfform- is there a better way to do relational select lists- ie if I select choice 2 from list 1, list 2 is now different... In the past I have done this with javascript. --Bob -- Need Web Hosting or Internet Services? Visit http://www.jaguNET.com/ ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201370 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Anything wrong with this statement?
Is there anything wrong with this statement in an of itself? CFSET Photos=Photos+1 Rick ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201371 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Anything wrong with this statement?
Yes, photos should be var scoped and I like to place parins around my calcs. -Original Message- From: Rick Faircloth [mailto:[EMAIL PROTECTED] Sent: Monday, April 04, 2005 12:06 PM To: CF-Talk Subject: Anything wrong with this statement? Is there anything wrong with this statement in an of itself? CFSET Photos=Photos+1 Rick ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201372 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Anything wrong with this statement?
No, not really...I would just variable type it.. Say cfset variables.photos = variables.photos + 1 You will have to ensure photos is numeric. -Original Message- From: Rick Faircloth [mailto:[EMAIL PROTECTED] Sent: 04 April 2005 17:06 To: CF-Talk Subject: Anything wrong with this statement? Is there anything wrong with this statement in an of itself? CFSET Photos=Photos+1 Rick ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201373 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Conditional Select Boxes
I saw on a blog not too long ago that someone was working on a XSL file to integrate qForms which maybe could lead to an interesting approach to doing n-selects. If you are using the flash forms feature there are a few examples floating around on the net on how to do two selects related boxes, I believe one of those can be found on www.cfform.com On 4 Apr 2005 16:01:55 -, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: With the advent of the new and improved cfform- is there a better way to do relational select lists- ie if I select choice 2 from list 1, list 2 is now different... In the past I have done this with javascript. --Bob -- Need Web Hosting or Internet Services? Visit http://www.jaguNET.com/ ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201374 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Anything wrong with this statement?
no. of course, curious as to why you ask... :) On Apr 4, 2005 12:05 PM, Rick Faircloth [EMAIL PROTECTED] wrote: Is there anything wrong with this statement in an of itself? CFSET Photos=Photos+1 Rick ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201375 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: recordsets return by stored procedures?
Hi, Here is my stored procedure: CREATE PROCEDURE dbo.sp_organizations @parent_id int AS DECLARE @Name varchar(500) DECLARE @Parent int DECLARE cur_Level CURSOR LOCAL FOR SELECT Organization_id AS ID, Organization_nm, Parent_organization_id FROM Organization WHERE Parent_organization_id = @parent_id ORDER BY Organization_nm OPEN cur_Level FETCH NEXT FROM cur_Level INTO @parent_id, @Name, @Parent WHILE @@FETCH_STATUS = 0 BEGIN SELECT @parent_id AS ID, @Name AS Name, @Parent AS Parent EXEC sp_organizations @parent_id FETCH NEXT FROM cur_Level INTO @parent_id, @Name, @Parent END CLOSE cur_Level DEALLOCATE cur_Level GO Basically I have one table called organization and it has three columns: id, name, and parent_id. The parent_id will tell which organization is the parent of that organization. It goes into unlimited levels of parent-child relationships. I want to get all the children organizations that belongs to a specified parent_id. I am using MS SQL Server 2000 and CFMX. If you could help me to rewrite my stored procedure so that it would return just one recordset, I would greatly appreciate it. My experience with stored procedure is limited. So I have no ideas how to put these recordsets into a temp table. Thanks. Johnny ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201376 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Anything wrong with this statement?
yes, but what you like to do (placing parens around calculations) doesn't mean there's anything wrong with the original statement in and of itself... On Apr 4, 2005 12:07 PM, Bryan F. Hogan [EMAIL PROTECTED] wrote: Yes, photos should be var scoped and I like to place parins around my calcs. -Original Message- From: Rick Faircloth [mailto:[EMAIL PROTECTED] Sent: Monday, April 04, 2005 12:06 PM To: CF-Talk Subject: Anything wrong with this statement? Is there anything wrong with this statement in an of itself? CFSET Photos=Photos+1 Rick ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201377 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: OT rookie: link table
people.person_id hahahahahhahahhahhhaahaha.ah. sigh. sorry Chris, back to the topic. it only gets TASKS that belong to the PROJECT that the PERSON is cleared for Im not sure how you are defining cleared for, but it should just be a couple more Inner Joins? -Original Message- From: Chris Kavanagh [mailto:[EMAIL PROTECTED] Sent: 04 April 2005 16:56 To: CF-Talk Subject: rookie: link table Dear list, My task management app gets a list of tasks, like so: -- CFQUERY name=get_tasks datasource=taskomatic SELECT tasks.task_id, tasks.name AS taskname, tasks.deadline, tasks.project_id, tasks.importance_id, tasks.owner_id, tasks.lead_time, tasks.status_id, projects.project_id, projects.name AS projectname, projects.colour, projects.company_id, people.person_id, people.name AS ownername, importance.importance_id, importance.importance AS importancename, FROM tasks JOIN projects ON tasks.project_id = projects.project_id JOIN people ON tasks.owner_id = people.person_id JOIN importance ON tasks.importance_id = importance.importance_id WHERE tasks.status_id = 1 CFIF Session.company_id neq 0 !--- this is the bit i need help with--- /CFIF ORDER BY #order# /CFQUERY -- What I'd like to happen is that: if the session variable company_id is not 0, it only gets TASKS that belong to the PROJECT that the PERSON is cleared for. My link table is called PEOPLE_PROJECT and it has two columns: -- person_id | project_id -- There is a tasks.project_id and of course a project.project_id (and a people.person_id if that's relevant). How do I do this? I can't seem to get my head around it. Many thanks! CK. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201378 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Anything wrong with this statement?
Your right, but they should be var scoped. I assumed people would realize when I said I like they would understand what I meant. I assumed wrong. :-) -Original Message- From: Charlie Griefer [mailto:[EMAIL PROTECTED] Sent: Monday, April 04, 2005 12:12 PM To: CF-Talk Subject: Re: Anything wrong with this statement? yes, but what you like to do (placing parens around calculations) doesn't mean there's anything wrong with the original statement in and of itself... On Apr 4, 2005 12:07 PM, Bryan F. Hogan [EMAIL PROTECTED] wrote: Yes, photos should be var scoped and I like to place parins around my calcs. -Original Message- From: Rick Faircloth [mailto:[EMAIL PROTECTED] Sent: Monday, April 04, 2005 12:06 PM To: CF-Talk Subject: Anything wrong with this statement? Is there anything wrong with this statement in an of itself? CFSET Photos=Photos+1 Rick ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201379 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
efflare - CFX_gfont
Hey guys, Anyone out there using the CFX_gfont extension by efflare.com with ColdFusion 7 on Window Server 2003? I been using this for the past year and it works great, but since I have upgraded to CF7 I cant seem to get it to create the font images anymore. Would any one have any ideas on this? I tried sending an email to efflare.com but have not heard any thing back. Thanks... Neal Bailey ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201380 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Anything wrong with this statement?
Rick Faircloth wrote: Is there anything wrong with this statement in an of itself? CFSET Photos=Photos+1 wrong? it assumes a value for Photos already exists? ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201381 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: OT rookie: link table
people.person_id hahahahahhahahhahhhaahaha.ah. sigh. sorry Chris, back to the topic. :| uh? I love it when I'm funny but it's a bit disconcerting when I don't know why. it only gets TASKS that belong to the PROJECT that the PERSON is cleared for Im not sure how you are defining cleared for, but it should just be a couple more Inner Joins? Well i have a Session.person_id. I should be able to compare that somehow with the table people_project (which is a combination of person_id and project_id), and thereby find out which project(_id)(s) match which the logged in person(_id), right? Thanks! CK. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201382 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: recordsets return by stored procedures?
You may want to check out Joe Celco's nested set model (no refs but google should find it) for a neat way to handle this type of hierarchical information storage. In the meantime you could keep the cursor but insert the resulting recordsets into a working table before returning the complete resultset. You would create the working table if @depth = 1 (set a local variable and pass it to subsequent calls and drop it after the last call) or permanently create it which would give you better performance and the ability to use indexes. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201383 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Conditional Select Boxes
Yeah, there is one example, but 1. Its IE only 2. Its a little flaky --Bob I saw on a blog not too long ago that someone was working on a XSL file to integrate qForms which maybe could lead to an interesting approach to doing n-selects. If you are using the flash forms feature there are a few examples floating around on the net on how to do two selects related boxes, I believe one of those can be found on www.cfform.com On 4 Apr 2005 16:01:55 -, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201384 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Anything wrong with this statement?
Thanks for the replies, everyone... I've ensured the value / variable exists by preceding it with CFPARAM Name=Photos Default=0 As to scoping it with variables., as in variables.photos, why is that important? Charlie...why do I ask? Well, I'm trying to increment the value, and so far, it's not working...something must be wrong in my other code somewhere...I didn't think there was anything wrong with it in and of itself, but wanted to be sure... I'll tinker with the code some more and see what I can dig up... Rick -Original Message- From: Paul Hastings [mailto:[EMAIL PROTECTED] Sent: Monday, April 04, 2005 12:32 PM To: CF-Talk Subject: Re: Anything wrong with this statement? Rick Faircloth wrote: Is there anything wrong with this statement in an of itself? CFSET Photos=Photos+1 wrong? it assumes a value for Photos already exists? ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201385 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Conditional Select Boxes
The example of flash forms or the example of XSL? I have messed with the flash one, saw no flakeyness but honestly do not think I tried it in something other than IE. On Apr 4, 2005 11:34 AM, Bob Clingan [EMAIL PROTECTED] wrote: Yeah, there is one example, but 1. Its IE only 2. Its a little flaky --Bob I saw on a blog not too long ago that someone was working on a XSL file to integrate qForms which maybe could lead to an interesting approach to doing n-selects. If you are using the flash forms feature there are a few examples floating around on the net on how to do two selects related boxes, I believe one of those can be found on www.cfform.com On 4 Apr 2005 16:01:55 -, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201386 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Anything wrong with this statement?
I'd think importance would be subjective as to who was looking at it. I personally try to always do it like this: cfset Photos = Variables.Photos + 1 / But I got into the habbit of putting in Variables due to working with inherited code that lacks much of any scoping. So I'd maybe come across a page with references to Photos but have no idea if they were expecting it to come in via the URL, FORM, or whatever. In some really rare cases they might have had: cfparam name=Photos default=0 / But I'd still not have any idea where they were expecting it to come from with that. All your CFPARAM is doing before the set is making Photos if it did not already exist and setting it to 0. What happens if it is passed in with a non-numeric value ... On Apr 4, 2005 11:43 AM, Rick Faircloth [EMAIL PROTECTED] wrote: As to scoping it with variables., as in variables.photos, why is that important? ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201387 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: OT rookie: link table
bit disconcerting there was a massive thread recently about singular/plural table names i have a Session.person_id well, if another join doesnt work for you then you could do a subselect: WHERE tasks.status_id = 1 CFIF Session.company_id neq 0 !--- this is the bit i need help with--- AND project_id IN (select project_id from person_project where person_id = #session.person_id#) /CFIF -Original Message- From: Chris Kavanagh [mailto:[EMAIL PROTECTED] Sent: 04 April 2005 17:29 To: CF-Talk Subject: Re: OT rookie: link table people.person_id hahahahahhahahhahhhaahaha.ah. sigh. sorry Chris, back to the topic. :| uh? I love it when I'm funny but it's a bit disconcerting when I don't know why. it only gets TASKS that belong to the PROJECT that the PERSON is cleared for Im not sure how you are defining cleared for, but it should just be a couple more Inner Joins? Well i have a Session.person_id. I should be able to compare that somehow with the table people_project (which is a combination of person_id and project_id), and thereby find out which project(_id)(s) match which the logged in person(_id), right? Thanks! CK. ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201388 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: OT rookie: link table
Chris Kavanagh wrote: people.person_id hahahahahhahahhahhhaahaha.ah. sigh. sorry Chris, back to the topic. :| uh? I love it when I'm funny but it's a bit disconcerting when I don't know why. Kerry's just stirring the crap. It's to do with the pluralisation of table names thread that went on for an inordinate length of time a while back. Don't bite. it only gets TASKS that belong to the PROJECT that the PERSON is cleared for Im not sure how you are defining cleared for, but it should just be a couple more Inner Joins? Well i have a Session.person_id. I should be able to compare that somehow with the table people_project (which is a combination of person_id and project_id), and thereby find out which project(_id)(s) match which the logged in person(_id), right? My understanding is this: cfquery name=tasks datasource=taskomatic SELECT TK.task_id, TK.name AS task, TK.deadline, TK.owner_id, TK.lead_time TK.status_id PJ.project_id, PJ.name AS project, PJ.colour, PJ.company_id, TK.owner_id, PN.name AS owner, IM.importance_id, IM.importance FROMtasks TK JOINprojects PJ ON PJ.project_id= TK.project_id JOINpeople PN ON PN.person_id = TK.owner_id JOINimportance IM ON IM.importance_id = TK.importance_id cfif SESSION.company_id neq 0 JOINpeople_project PP ON TK.project_id= PP.project_id /cfif WHERE tasks.status_id = 1 cfif SESSION.company_id neq 0 AND PP.person_id = cfqueryparam cfsqltype=CF_SQL_INTEGER value=#SESSION.person_id# /cfif /cfquery Run that and cfdump it to check if it's what you're looking for. Don't be scared by the cfqueryparam: it's just for creating prepared statements, which are safer than just dumping values directly from variables into the statement, and allow the DBMS to cache the query, which makes it faster on subsequent runs. K. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201389 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Anything wrong with this statement?
Rick: It's generally easier to get an answer if you are as descriptive as possible about your issue (if an error, what error...if not, what was unexpected). Makes it much easier to troubleshoot and offer up suggestions than just being shown a line of code. While there was nothing wrong with your code in and of itself (personal preference and 'best practices' regarding scoping aside), there could have been other issues (like 'photos' not being created as a variable, the variable not being numeric, etc). Cuts down on the guess work to know what the issue is :) On Apr 4, 2005 12:43 PM, Rick Faircloth [EMAIL PROTECTED] wrote: Thanks for the replies, everyone... I've ensured the value / variable exists by preceding it with CFPARAM Name=Photos Default=0 As to scoping it with variables., as in variables.photos, why is that important? Charlie...why do I ask? Well, I'm trying to increment the value, and so far, it's not working...something must be wrong in my other code somewhere...I didn't think there was anything wrong with it in and of itself, but wanted to be sure... I'll tinker with the code some more and see what I can dig up... Rick -Original Message- From: Paul Hastings [mailto:[EMAIL PROTECTED] Sent: Monday, April 04, 2005 12:32 PM To: CF-Talk Subject: Re: Anything wrong with this statement? Rick Faircloth wrote: Is there anything wrong with this statement in an of itself? CFSET Photos=Photos+1 wrong? it assumes a value for Photos already exists? ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201390 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: recordsets return by stored procedures?
Oh hell, that's hideously simple... CREATE PROCEDURE dbo.sp_organizations @parent_id int AS DECLARE @Name varchar(500) DECLARE @Parent int DECLARE cur_Level CURSOR LOCAL FOR SELECT Organization_id AS ID, Organization_nm, Parent_organization_id FROM Organization WHERE Parent_organization_id = @parent_id ORDER BY Organization_nm CREATE TABLE #child (id int, name nvarchar(500), parent int) OPEN cur_Level FETCH NEXT FROM cur_Level INTO @parent_id, @Name, @Parent WHILE @@FETCH_STATUS = 0 BEGIN INSERT INTO #child (id, name, parent) VALUES (@parent_id, @name, @parent) EXEC sp_organizations @parent_id FETCH NEXT FROM cur_Level INTO @parent_id, @Name, @Parent END CLOSE cur_Level DEALLOCATE cur_Level SELECT * FROM #child DROP TABLE #child GO The # tells SQL Server to create a temp-table. As a matter of fact, I'd eliminate the cursor too -- insert the first record into the temp table manually, then use this loop to insert all the child organizations: WHILE EXISTS (select * from organization where Parent_organization_id in (select id from #child) and organization_id not in (select id from #child)) BEGIN INSERT INTO #child (id, name, parent) SELECT organization_id, organization_nm, Parent_organization_id FROM organization where Parent_organization_id in (select id from #child) and organization_id not in (select id from #child) END (really #child is a bad name for a table but then, so are id and name bad names for columns). hth s. isaac dealey 954.522.6080 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://macromedia.breezecentral.com/p49777853/ http://www.sys-con.com/author/?id=4806 http://www.fusiontap.com ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201391 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Joe Celko and Nested Sets; was Re: recordsets return by stored procedures?
Adam Howitt wrote: You may want to check out Joe Celco's nested set model (no refs but google should find it) for a neat way to handle this type of hierarchical information storage. In the meantime you could keep the cursor but insert the resulting recordsets into a working table before returning the complete resultset. You would create the working table if @depth = 1 (set a local variable and pass it to subsequent calls and drop it after the last call) or permanently create it which would give you better performance and the ability to use indexes. I highly recommend his book, SQL for Smarties[1]. Here's a few links that should help: 1. http://www.intelligententerprise.com/001020/celko.jhtml 2. http://www.dbmsmag.com/9604d06.html and http://www.dbmsmag.com/9603d06.html 3. http://troels.arvin.dk/db/rdbms/links/ 4. http://www.onlamp.com/pub/a/onlamp/2004/08/05/hierarchical_sql.html 5. http://dbazine.com/tropashko4.shtml 6. http://www.sitepoint.com/article/hierarchical-data-database He also wrote a whole book on trees and hierarchies[2]. K. [1] http://www.amazon.co.uk/exec/obidos/ASIN/1558605762/ [2] http://www.amazon.co.uk/exec/obidos/ASIN/1558609202/ ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201392 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: recordsets return by stored procedures?
Is there a way to find out how many recordsets return by a stored procedure? Or is there a way to merge all the recordsets in a stored procedure so that it would only return 1 recordset? I have a stored procedure that would return an unknown number of recordsets depending on how many records we have in the database, but each recordset will have the same number of columns and column names. I need to know the number of recorsets it will return so I can do a loop for the cfprocresult. Why not just write the stored procedure so that it returns what you want it to return? In this case, for example, your stored procedure could create a temp table, select all the records you want into that temp table, then select from the temp table to return a single recordset. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201393 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Anything wrong with this statement?
What happens if it is passed in with a non-numeric value ... Wouldn't happen...the variable is used only on a page which is submitting back to itself. No other pages are utilizing it. Its default is set to 0, the formula runs, adding 1 to the value, and then it gets incremented up 1 if the Add Another Photo button is clicked... Trying to work out a CF solution to allowing a user to add more CFFILE fields to a page when they click a button. When the page is submitted back to itself, the variable is upped 1, and a CFLOOP is run creating the amount of CFFILE fields specified by the variable, Photos. Seems simple...but so far it's not working. I'm just missing something at this point... Rick -Original Message- From: Aaron Rouse [mailto:[EMAIL PROTECTED] Sent: Monday, April 04, 2005 12:48 PM To: CF-Talk Subject: Re: Anything wrong with this statement? I'd think importance would be subjective as to who was looking at it. I personally try to always do it like this: cfset Photos = Variables.Photos + 1 / But I got into the habbit of putting in Variables due to working with inherited code that lacks much of any scoping. So I'd maybe come across a page with references to Photos but have no idea if they were expecting it to come in via the URL, FORM, or whatever. In some really rare cases they might have had: cfparam name=Photos default=0 / But I'd still not have any idea where they were expecting it to come from with that. All your CFPARAM is doing before the set is making Photos if it did not already exist and setting it to 0. What happens if it is passed in with a non-numeric value ... On Apr 4, 2005 11:43 AM, Rick Faircloth [EMAIL PROTECTED] wrote: As to scoping it with variables., as in variables.photos, why is that important? ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201394 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Submit Once
Gang, I am occasionally getting duplicate records in my database. I think it is coming from people hitting “Submit” twice when the server is slow. How do you guys prevent this? I tried some JavaScript code to disable the button, which did gray-out the button, but then did not pass the Button info along to Cold Fusion. Thanks for you help, Jeff ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201395 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Anything wrong with this statement?
the Photos variable isn't persistent (not a session, cookie, application or whatever variable) so it's being redefined as 0 by the cfparam with every request to the page. My suggestion (quick and dirty) would be to put it in a hidden form field or pass it in the url. /t -Original Message- From: Rick Faircloth [mailto:[EMAIL PROTECTED] Sent: Monday, April 04, 2005 7:07 PM To: CF-Talk Subject: RE: Anything wrong with this statement? What happens if it is passed in with a non-numeric value ... Wouldn't happen...the variable is used only on a page which is submitting back to itself. No other pages are utilizing it. Its default is set to 0, the formula runs, adding 1 to the value, and then it gets incremented up 1 if the Add Another Photo button is clicked... Trying to work out a CF solution to allowing a user to add more CFFILE fields to a page when they click a button. When the page is submitted back to itself, the variable is upped 1, and a CFLOOP is run creating the amount of CFFILE fields specified by the variable, Photos. Seems simple...but so far it's not working. I'm just missing something at this point... Rick -Original Message- From: Aaron Rouse [mailto:[EMAIL PROTECTED] Sent: Monday, April 04, 2005 12:48 PM To: CF-Talk Subject: Re: Anything wrong with this statement? I'd think importance would be subjective as to who was looking at it. I personally try to always do it like this: cfset Photos = Variables.Photos + 1 / But I got into the habbit of putting in Variables due to working with inherited code that lacks much of any scoping. So I'd maybe come across a page with references to Photos but have no idea if they were expecting it to come in via the URL, FORM, or whatever. In some really rare cases they might have had: cfparam name=Photos default=0 / But I'd still not have any idea where they were expecting it to come from with that. All your CFPARAM is doing before the set is making Photos if it did not already exist and setting it to 0. What happens if it is passed in with a non-numeric value ... On Apr 4, 2005 11:43 AM, Rick Faircloth [EMAIL PROTECTED] wrote: As to scoping it with variables., as in variables.photos, why is that important? ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201396 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Anything wrong with this statement?
I know...but it's a lot more work to explain everything up front than to ask specific questions...I'll get more detailed (as you'll see I did in a later response) about the code as I have to... I should be able to find the problem...I was just checking that statement... Sorry if that's kind of annoying... Rick -Original Message- From: Charlie Griefer [mailto:[EMAIL PROTECTED] Sent: Monday, April 04, 2005 12:58 PM To: CF-Talk Subject: Re: Anything wrong with this statement? Rick: It's generally easier to get an answer if you are as descriptive as possible about your issue (if an error, what error...if not, what was unexpected). Makes it much easier to troubleshoot and offer up suggestions than just being shown a line of code. While there was nothing wrong with your code in and of itself (personal preference and 'best practices' regarding scoping aside), there could have been other issues (like 'photos' not being created as a variable, the variable not being numeric, etc). Cuts down on the guess work to know what the issue is :) On Apr 4, 2005 12:43 PM, Rick Faircloth [EMAIL PROTECTED] wrote: Thanks for the replies, everyone... I've ensured the value / variable exists by preceding it with CFPARAM Name=Photos Default=0 As to scoping it with variables., as in variables.photos, why is that important? Charlie...why do I ask? Well, I'm trying to increment the value, and so far, it's not working...something must be wrong in my other code somewhere...I didn't think there was anything wrong with it in and of itself, but wanted to be sure... I'll tinker with the code some more and see what I can dig up... Rick -Original Message- From: Paul Hastings [mailto:[EMAIL PROTECTED] Sent: Monday, April 04, 2005 12:32 PM To: CF-Talk Subject: Re: Anything wrong with this statement? Rick Faircloth wrote: Is there anything wrong with this statement in an of itself? CFSET Photos=Photos+1 wrong? it assumes a value for Photos already exists? ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201397 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Submit Once
i don't know of an easy way. but one thing you could do is to compare the data with what is already in the DB and if it matches then don't do the second input. It will really depend on the type of data being input and if there are any unique fields you can compare to (like email address's etc). jonese On Apr 4, 2005 1:09 PM, Jeffrey Pratte [EMAIL PROTECTED] wrote: Gang, I am occasionally getting duplicate records in my database. I think it is coming from people hitting “Submit†twice when the server is slow. How do you guys prevent this? I tried some JavaScript code to disable the button, which did gray-out the button, but then did not pass the Button info along to Cold Fusion. Thanks for you help, Jeff ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201398 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Submit Once
Jeffrey Pratte wrote: Gang, I am occasionally getting duplicate records in my database. I think it is coming from people hitting “Submit” twice when the server is slow. How do you guys prevent this? I tried some JavaScript code to disable the button, which did gray-out the button, but then did not pass the Button info along to Cold Fusion. Thanks for you help, Jeff There's a few ways. The simplest I can think of is to create a data structure (a database table would be sufficent) to keep track of your forms where you want to prevent multiple submissions. The schema of a table to do this would be something like the following: CREATE TABLE forms (uuid CHAR(35) NOT NULL PRIMARY KEY); Before you generate a form, do the following: cfset uuid = CreateUUID() cfquery name=foo datasource=bar INSERT INTO forms ( uuid ) VALUES ( cfqueryparam cfsqltype=CF_SQL_CHAR value=#uuid# ) /cfquery And then embed the uuid in a hidden field in the form you want to protect. Just before you process the form, check to see if the uuid is in the table. If it is, it's the first time the form has been processed, otherwise it's a resubmit. cfquery name=checkUUID datasource=bar SELECT COUNT(*) AS isPresent FROMforms WHERE uuid = cfqueryparam cfsqltype=CF_SQL_CHAR value=#FORM.uuid# /cfquery cfif checkUUID.isPresent cfquery name=foo datasource=bar DELETE FROM forms WHERE uuid = cfqueryparam cfsqltype=CF_SQL_CHAR value=#FORM.uuid# /cfquery !--- Process as normal --- cfelse !--- It's a resubmit --- /cfif Now, where is a chance of a race condition in the code above where, if the user was quick enough on the resubmit (and they'd have to be *really* quick), the code to check if the form was present might be ran in one of the requests before the first one managed to delete it. To prevent this, you'd have to serialise access to the forms tables somehow, be it through a transaction or an exclusive table lock. But the principle is sound and should work for you. K. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201399 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Submit Once
Gang,
I am occasionally getting duplicate records in my
database. I think it is coming from people hitting
“Submit” twice when the server is slow. How do you
guys prevent this?
I tried some JavaScript code to disable the button, which
did gray-out the button, but then did not pass the Button
info along to Cold Fusion.
Thanks for you help, Jeff
Well the simplest solution looks like this:
script language=JavaScript
function submitForm(frm) {
if (typeof frm._submitted == undefined)
{ frm._submitted = true; return true; }
else { return false; }
}
/script
form onsubmit=return submitForm(this);
qForms and the onTap framework both have some more sophisticated
solutions which ultimately use the same technique.
hth
s. isaac dealey 954.522.6080
new epoch : isn't it time for a change?
add features without fixtures with
the onTap open source framework
http://macromedia.breezecentral.com/p49777853/
http://www.sys-con.com/author/?id=4806
http://www.fusiontap.com
~|
Find out how CFTicket can increase your company's customer support
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201400
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations Support: http://www.houseoffusion.com/tiny.cfm/54
[SOLVED] Re: OT rookie: link table
Many thanks, guys, that now works perfectly. Kind regards, CK. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201401 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
CFMX 6.1 + JRun SP5
Anyone had experience upgrading Jrun For CFMX 6.1 to JRun SP5? Any issues? Thx, Stace ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201402 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Submit Once
Also, you might be interested in this post on Mark Nottingham's site: http://www.mnot.net/blog/2003/09/13/click_submit_only_once K. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201403 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Submit Once
Keith Gaughan wrote: But the principle is sound and should work for you. This also has the advantage that it ensure that the form works without the browser needing to have JavaScript enabled. K. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201404 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Submit Once
Jeffrey Pratte wrote: Gang, I am occasionally getting duplicate records in my database. I think it is coming from people hitting “Submit” twice when the server is slow. How do you guys prevent this? I tried some JavaScript code to disable the button, which did gray-out the button, but then did not pass the Button info along to Cold Fusion. Thanks for you help, Jeff There's a few ways. The simplest I can think of is to create a data structure (a database table would be sufficent) to keep track of your forms where you want to prevent multiple submissions. That's actually a pretty complicated solution -- although if you need a solution that works server-side without the aid of javascript you're reather limited to something like that... I wonder if visually impaired users double-click form submit buttons the same as some sighted users... I wouldn't expect it, though it could happen. In general I wouldn't expect users who have javascript-disabled (either due to visual impairment or otherwise) to produce those impatient double-submits. s. isaac dealey 954.522.6080 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://macromedia.breezecentral.com/p49777853/ http://www.sys-con.com/author/?id=4806 http://www.fusiontap.com ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201405 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Anything wrong with this statement?
Heck, in this particular case, it could be scoping that is tripping you up... - Calvin -Original Message- From: Rick Faircloth [mailto:[EMAIL PROTECTED] Sent: Monday, April 04, 2005 1:13 PM To: CF-Talk Subject: RE: Anything wrong with this statement? I know...but it's a lot more work to explain everything up front than to ask specific questions...I'll get more detailed (as you'll see I did in a later response) about the code as I have to... I should be able to find the problem...I was just checking that statement... Sorry if that's kind of annoying... Rick -Original Message- From: Charlie Griefer [mailto:[EMAIL PROTECTED] Sent: Monday, April 04, 2005 12:58 PM To: CF-Talk Subject: Re: Anything wrong with this statement? Rick: It's generally easier to get an answer if you are as descriptive as possible about your issue (if an error, what error...if not, what was unexpected). Makes it much easier to troubleshoot and offer up suggestions than just being shown a line of code. While there was nothing wrong with your code in and of itself (personal preference and 'best practices' regarding scoping aside), there could have been other issues (like 'photos' not being created as a variable, the variable not being numeric, etc). Cuts down on the guess work to know what the issue is :) On Apr 4, 2005 12:43 PM, Rick Faircloth [EMAIL PROTECTED] wrote: Thanks for the replies, everyone... I've ensured the value / variable exists by preceding it with CFPARAM Name=Photos Default=0 As to scoping it with variables., as in variables.photos, why is that important? Charlie...why do I ask? Well, I'm trying to increment the value, and so far, it's not working...something must be wrong in my other code somewhere...I didn't think there was anything wrong with it in and of itself, but wanted to be sure... I'll tinker with the code some more and see what I can dig up... Rick -Original Message- From: Paul Hastings [mailto:[EMAIL PROTECTED] Sent: Monday, April 04, 2005 12:32 PM To: CF-Talk Subject: Re: Anything wrong with this statement? Rick Faircloth wrote: Is there anything wrong with this statement in an of itself? CFSET Photos=Photos+1 wrong? it assumes a value for Photos already exists? ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201406 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
re: Submit Once
If you are using cfmx 7 and cfform you can add validate=submitonce to your submit button. (see below) cfinput name=submit value=Submit type=submit label=Submit validate=submitonce / From: Jeffrey Pratte [EMAIL PROTECTED] Sent: Monday, April 04, 2005 1:11 PM To: CF-Talk cf-talk@houseoffusion.com Subject: Submit Once Gang, I am occasionally getting duplicate records in my database. I think it is coming from people hitting â?oSubmitâ? twice when the server is slow. How do you guys prevent this? I tried some JavaScript code to disable the button, which did gray-out the button, but then did not pass the Button info along to Cold Fusion. Thanks for you help, Jeff ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201407 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: What are optimal GC/JVM settings?
On Apr 4, 2005 6:06 AM, Jacob [EMAIL PROTECTED] wrote: On my machines, with 2GB RAM and dual Xeons of various speeds, I have mine JVM setting as follows: MAX HEAP SIZE: 1024 MAX PERM SIZE: 512 Did you actually *need* to set max perm size that high? That's an enormous number for the perm space. Most people manage with 128Mb and only under fairly extreme situations do you need to raise it. The perm space holds class definitions so unless you have a phenomenal number of templates and / or CFC methods, you shouldn't hit 128Mb... -- Sean A Corfield -- http://corfield.org/ Team Fusebox -- http://fusebox.org/ Got Gmail? -- I have 50, yes 50, invites to give away! If you're not annoying somebody, you're not really alive. -- Margaret Atwood ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201408 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Submit Once
S.Isaac Dealey wrote: That's actually a pretty complicated solution -- although if you need a solution that works server-side without the aid of javascript you're reather limited to something like that... If you looking for a server-side only solution, it's the simplest. Mind you, if you don't mind using JS, then there are, of course, simpler ways. But I'd taken from his post--and I might be mistaken--that those weren't what he was looking for. No matter though. I wonder if visually impaired users double-click form submit buttons the same as some sighted users... I wouldn't expect it, though it could happen. In general I wouldn't expect users who have javascript-disabled (either due to visual impairment or otherwise) to produce those impatient double-submits. I'm not even thinking of them! I was just presenting a server-side only solution. BTW, you could also use a struct stored in some persistent scope such as SESSION or APPLICATION as a set and you'd get the same effect. I do this in a replacement for cfform I wrote that uses more modern validation and has a few extra features. K. ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201409 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CFMX 6.1 + JRun SP5
On Apr 4, 2005 1:35 PM, Stacy Young [EMAIL PROTECTED] wrote: Anyone had experience upgrading Jrun For CFMX 6.1 to JRun SP5? Any issues? We're still testing our staging environment (2-server cluster on Solaris), but so far no issues. One tip that could save you time: If you have to manually re-compile your web server connector, make sure to use the new -apxs switch for the wsconfig utility (see the Release Notes for more on that). I was using the old ApacheModule.zip directions and was throwing seg faults left and right when restarting Apache. Once I noticed the new switch (which auto-compiles the connector from source), I was good to go. It's a very sweet new feature. Regards, Dave. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201410 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
CFMX7 Now casts query columns as datetime?
Has anyone else noticed that CFMX7 now casts a date column as date time in queries? Or is it just a Monday and I have not recovered from the weekend? When I run a query to get one record cfquery name=getbuilds datasource=#database# SELECTStartDate, RecordId, RecordDate FROM BuildsData where recordid = 1 /cfquery The query returns #getbuilds.StartDate# = 2005-01-26 00:00:00.0 cfset foo = querysetcell(getbuilds,'StartDate',DateFormat(getbuilds.StartDate, mm/dd/)) Even after the querysetcell #getbuilds.StartDate# = 2005-01-26 00:00:00.0 Can anyone tell me how / if I can make CFMX7 return non typed columns? The funny thing is, this was a feature I was hoping MM would add. I just did not know it would cause problems with my legacy code. MB Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com http://www.vividmedia.com/ 608.270.9770 ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201411 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Running exe file from browser
We have a shared file server that runs an application. All users have the same drive letter mapped, etc. The application is as follows: G:\applications\Program.exe I would like to place what amounts to a shortcut on my web page that allows all end users to run Program.exe from that link. My understanding is that CFEXECUTE runs a process ON THE SERVER and therefore is not appropriate for what I am trying to do. When I simply place an href link on my page, I get the security warning about the risks of opening executables, etc. I understand WHY that message appears, but is there a way to avoid that message? Also, when I follow the link from the cfm page, I get a FoxPro (the exe is a FoxPro application) that says File Security.exe does not exist. But if I go to the command line or follow a shortcut that is placed on my desktop, I never get that error message. I have played around with writing batch files and putting them on the server, etc but to no avail. Finally, what are the chances that I can execute a process that places a shortcut on the end users desktop when they click a button on my website? Something like Click here to add a shortcut to g:\applications\program.exe onto your desktop... TIA, Tim ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please delete it from your system. This footnote also confirms that this email message has been swept for the presence of computer viruses. Thank You, Viahealth ** ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201412 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CFMX7 Now casts query columns as datetime?
cast it as a non-date column, varchar? then it will come to cf as a varchar and not a date. not sure why this would be a problem either way? tw On Apr 4, 2005 2:21 PM, Mark W. Breneman [EMAIL PROTECTED] wrote: Has anyone else noticed that CFMX7 now casts a date column as date time in queries? Or is it just a Monday and I have not recovered from the weekend? When I run a query to get one record cfquery name=getbuilds datasource=#database# SELECTStartDate, RecordId, RecordDate FROM BuildsData where recordid = 1 /cfquery The query returns #getbuilds.StartDate# = 2005-01-26 00:00:00.0 cfset foo = querysetcell(getbuilds,'StartDate',DateFormat(getbuilds.StartDate, mm/dd/)) Even after the querysetcell #getbuilds.StartDate# = 2005-01-26 00:00:00.0 Can anyone tell me how / if I can make CFMX7 return non typed columns? The funny thing is, this was a feature I was hoping MM would add. I just did not know it would cause problems with my legacy code. MB Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com http://www.vividmedia.com/ 608.270.9770 ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201413 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Running exe file from browser
We have a shared file server that runs an application. All users have the same drive letter mapped, etc. The application is as follows: My understanding is that CFEXECUTE runs a process ON THE SERVER and therefore is not appropriate for what I am trying to do. Exactly right. When I simply place an href link on my page, I get the security warning about the risks of opening executables, etc. I understand WHY that message appears, but is there a way to avoid that message? In IE, at least, you can really only avoid this message by adding your site to the Trusted zone (and even then I'm not sure if it'll do it with SP2 installed). Also, when I follow the link from the cfm page, I get a FoxPro (the exe is a FoxPro application) that says File Security.exe does not exist. What is the link you're using? It should look something like this: file://c:/shareddrive/program.exe Finally, what are the chances that I can execute a process that places a shortcut on the end users desktop when they click a button on my website? Something like Click here to add a shortcut to g:\applications\program.exe onto your desktop... Very good - if you are willing to get another security message. You can use Windows Scripting Host to do this (either via an HTA application or a JS/VBS script - but the HTA might be simpler). Do a search on MSDN.microsoft.com for HTA or WSH. Jim Davis ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201414 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CFMX7 Now casts query columns as datetime?
Has anyone else noticed that CFMX7 now casts a date column as date time in queries? Or is it just a Monday and I have not recovered from the weekend? I'm not positive, but I would guess that's how your database driver is returning them, not CF. Perhaps it was a change in drivers between 6.1 and 7 but CF itself doesn't really have anything to do with this (although I could be wrong). Jim Davis ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201415 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Any news from MM on the broken IIS6 connector on stand alone installs???
Like the title says, any news on this being fixed for the standalone CFMX install on IIS 6??? http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=238944b1 When can we expect to be able to apply this patch? Paul ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201416 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CSV file and com.Ostermiller.util.ExcelCSVParser
Actually it's a little bit more complicated than this. The com.Ostermiller.util.ExcelCSVParser utility returns a Java array which is has a Vector type and not the coldfusion array type. Unfortunately (and something that I cannot explain) some lines that have empty fields are not pick up. I need something to dynamically resize the java array (the java array doesn't have a resize feature to force ) or cast it to a cf array type. thanks Victor On Apr 4, 2005 10:36 AM, Kerry [EMAIL PROTECTED] wrote: this will probably be because CF ignores empty list elements. there might be some kind of a split function on cflib.org -Original Message- From: Victor Moore [mailto:[EMAIL PROTECTED] Sent: 04 April 2005 15:14 To: CF-Talk Subject: CSV file and com.Ostermiller.util.ExcelCSVParser I am using com.Ostermiller.util.ExcelCSVParser with great succes to parse csv files. There is only one small problem that I can't figure out.If there are any empty columns in the file they are not picked up and as a result the parsing process is failing. The work around is to open the file in excel and run a replace all (for empty string with a space). Unfortunately this is used by end users and for some reason they don't do it ... Is any way to do it programmatically? Thanks Victor ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201417 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Any news from MM on the broken IIS6 connector on stand alone installs???
i read on one of my many many many blogs that they are working on another cf7 update which should fix a lot of these issues. no idea if this one in particular will be or not. maybe one of the MM insiders will have more data. jonese On Apr 4, 2005 2:56 PM, Paul Vernon [EMAIL PROTECTED] wrote: Like the title says, any news on this being fixed for the standalone CFMX install on IIS 6??? http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=238944b1 When can we expect to be able to apply this patch? Paul ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201418 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: CFMX 6.1 + JRun SP5
Awesome, same setup here...thx for tip! Stace -Original Message- From: Dave Carabetta [mailto:[EMAIL PROTECTED] Sent: Monday, April 04, 2005 2:03 PM To: CF-Talk Subject: Re: CFMX 6.1 + JRun SP5 On Apr 4, 2005 1:35 PM, Stacy Young [EMAIL PROTECTED] wrote: Anyone had experience upgrading Jrun For CFMX 6.1 to JRun SP5? Any issues? We're still testing our staging environment (2-server cluster on Solaris), but so far no issues. One tip that could save you time: If you have to manually re-compile your web server connector, make sure to use the new -apxs switch for the wsconfig utility (see the Release Notes for more on that). I was using the old ApacheModule.zip directions and was throwing seg faults left and right when restarting Apache. Once I noticed the new switch (which auto-compiles the connector from source), I was good to go. It's a very sweet new feature. Regards, Dave. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201419 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
