RE: Grouping Output Query Display
You will also need an order by in your query for the grouping to work correctly. There was none in your original code, but maybe you didn't send your original code: cfquery datasource=#request.dsn# name=meetingAgenda SELECT meeting_ID,month,date,time,year,comment,agenda FROM meeting_agenda ORDER BY month, date /cfquery Pascal -Original Message- From: Mark Henderson [mailto:[EMAIL PROTECTED] Sent: 28 September 2004 04:49 To: CF-Talk Subject: [Spam?] RE: Grouping Output Query Display Perfect I'd actually simplified it down and had it working (outside of using tables for layout) like so.. cfoutput query=meetingAgenda group=month h2#month#/h2 cfoutput group=date h3#date#/h3 cfoutput #time# - #agenda#br / /cfoutput br /br / /cfoutput /cfoutput but you've kept it in tables for me with the correct display. The alternating colours are no big deal, and I've sorted that one out already. And lastly, thank you. adieu MarkH [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Possible Bug with Dates
Hi Paul. I fixed it by simply removing the day comma part, but that is not really the point as it is meant to accept it. I will report it to MM. Andrew. - Original Message - From: Paul Vernon [EMAIL PROTECTED] Date: Mon, 27 Sep 2004 16:36:46 +0100 Subject: RE: Possible Bug with Dates To: CF-Talk [EMAIL PROTECTED] CFMX6.1 Updater on Windows 2k. I get exactly the same as you describe using your code. Tuesday, Wednesday and Thursday all blow up... Interestingly though, if I set the day to Tues everything works... Wed breaks but Wedn works... Thur works... Interesting... I guess a Left(dayname, 4) should fix it for you :) Paul [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Java 1.4.2_05
Any one have any issues with performance/JRun connection errors since upgrading to Sun Java 1.4.2_05?We are thinking about downgrading from this as it would seem that it's not a happy JVM when it comes to load and CF... ? This e-mail is from Reed Exhibitions (Oriel House, 26 The Quadrant, Richmond, Surrey, TW9 1DL, United Kingdom), a division of Reed Business, Registered in England, Number 678540.It contains information which is confidential and may also be privileged.It is for the exclusive use of the intended recipient(s).If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful.If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910.The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions. Visit our website at http://www.reedexpo.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
vCard
Is anyone aware of any vCard parser / generators ? -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: vCard
We just created our own - it was easier! _ From: Thomas Chiverton [mailto:[EMAIL PROTECTED] Sent: 28 September 2004 09:26 To: CF-Talk Subject: vCard Is anyone aware of any vCard parser / generators ? -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: RE: vCard
I believe Steve Drucker, CEO Fig Leaf Software, gave a CFUG presentation on generating VCards sevral years ago.Not sure whether or not the code is still around but you might want to check both the old and new figleaf site for that. ~Simon We just created our own - it was easier! _ From: Thomas Chiverton [mailto:[EMAIL PROTECTED] Sent: 28 September 2004 09:26 To: CF-Talk Subject: vCard Is anyone aware of any vCard parser / generators ? -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Uploading large audio files
I have a webform that allows users to upload large audio files to the server (40MB upwards) However I am now starting to realise that CFFILE is probably not the best way to go about it as it takes over and hour to get a file uploaded to the server. I have looked into using CFFTP but cant see a way in which I can manage the tag like I can with CFFILE For example I need to be able to do the following: Grab the name of the uploaded file Make Unique if file exists. Can this be done in CFFTP and would this be any quicker for uploading large files? Does anyone have any other sugestions as to how I can create and easy system for uploading such big files via a web form?? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
How do I close the pop-up window - kindly help
Hi Guys, I'm hoping someone can help me. I've tried everything but can't quiet nail this problem. I have this page that has a hyper-link. Clicking on the hyper-link opens up a pop-up window. The url looks something like this: window.open('attachment.cfm?promptUser=trueid=12345filename=testfile', 'Attachment', 'top=10,left=10,height=315,width=600,resizable=Yes,scrollbars=Yes'); You may have noticed I'm passing a url variable 'promptUser' with a default value of 'true'. Here is the code in the pop-up window. script language=_javascript_ function openAttachment(){ window.location = cfoutput#cgi.SCRIPT_NAME#?FILENAME=#url.FILENAME#ID=#url.id#promptUser=false/cfoutput; } function cancelAttachment(){ window.close(); } /script !--- if the url variable promptUser is true, display few instructions to help the user to decide what he must be doing --- cfif isDefined(url.promptUser) and promptUser eq true table width=100% border=0 cellspacing=0 cellpadding=5 tr td If you intend to modify an existing attachment, you must follow the below steps: br blah blah blah /td /tr tr td valign=top align=center img src="" id=okbutt name=okbutt border=0 alt=open attachment > br /td td valign=top align=center img src="" id=cancelbutt name=cancelbutt border=0 alt=close > br /td /tr /table !--- if it is false, just open the attachment in its own application --- cfelseif url.promptUser eq false cfset fName = url.filename !--- Generates custom HTTP response headers to return to the client. --- CFHEADER NAME=Content-Type VALUE=application/unknown CFHEADER NAME=Content-Disposition VALUE=attachment; filename=#fName# CFCONTENT TYPE=application/unknown FILE=UploadFolder\#fName# deletefile=no /cfif I hope the above code is self-explainatory. If you notice, I'm setting 'promptUser' url variable to 'false' in the 'openAttachment' function. This opens up the file open/save dialog box. Now then, this is where I'm stuck. I want to close the pop-up window when the 'promptUser' value is 'false', in other words when the user clicks on the 'okbutt' button. Can someone show me how to do this. I would really appreciate your help Best regards, cfcoder [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Uploading large audio files
On Tuesday 28 Sep 2004 12:18 pm, luke freeman wrote: Can this be done in CFFTP and would this be any quicker for uploading I'd suggest a system where users can enter their ftp details, and you have a scheduled task that picks up all the new ones and fires off another request to ftp them to your host. -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
JRE server folder
OK, here is one which I have searched on but haven't found a true answer. When you upgrade your JRE from the vanilla CFusionMX JRE there is no server folder in the bin folder of the system (Sun Java).I have read that you copy the existing server folder from the CFusioMX install to your new JRE - why is this?What is this folder really for?If it is not included in new java installs why is CF explicitly looking for it? It also contains exactly the same files as the bin\client folder but the jvm.dll is half the size than the CFusionMX\runtime\jre\bin\server\ JVM.dll Also, why is CF also looking for a folder called JRE when out of the box a new Java install does not include one? Any help here mucho appreciato. N This e-mail is from Reed Exhibitions (Oriel House, 26 The Quadrant, Richmond, Surrey, TW9 1DL, United Kingdom), a division of Reed Business, Registered in England, Number 678540.It contains information which is confidential and may also be privileged.It is for the exclusive use of the intended recipient(s).If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful.If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910.The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions. Visit our website at http://www.reedexpo.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: How do I close the pop-up window - kindly help
Not that easy to do, because once you changed the header, you can't close the window in JS anymore. You could do one of the following, but neither are perfect and you may have problems with security settings in the browser. function openAttachment(){ window.open(cfoutput#cgi.SCRIPT_NAME#?FILENAME=#url.FILENAME#ID=#url .id#promptUser=false/cfoutput,'Download','top=10,left=10,height=0,wi dth=0,resizable=1,scrollbars=0'); window.close(); } function openAttachment(){ opener.location = cfoutput#cgi.SCRIPT_NAME#?FILENAME=#url.FILENAME#ID=#url.id#promptU ser=false/cfoutput; window.close(); } Pascal -Original Message- From: cf coder [mailto:[EMAIL PROTECTED] Sent: 28 September 2004 14:03 To: CF-Talk Subject: How do I close the pop-up window - kindly help Hi Guys, I'm hoping someone can help me. I've tried everything but can't quiet nail this problem. I have this page that has a hyper-link. Clicking on the hyper-link opens up a pop-up window. The url looks something like this: window.open('attachment.cfm?promptUser=trueid=12345filename=testfile', 'Attachment', 'top=10,left=10,height=315,width=600,resizable=Yes,scrollbars=Yes'); You may have noticed I'm passing a url variable 'promptUser' with a default value of 'true'. Here is the code in the pop-up window. script language=_javascript_ function openAttachment(){ window.location = cfoutput#cgi.SCRIPT_NAME#?FILENAME=#url.FILENAME#ID=#url.id#promptU se r=false/cfoutput; } function cancelAttachment(){ window.close(); } /script !--- if the url variable promptUser is true, display few instructions to help the user to decide what he must be doing --- cfif isDefined(url.promptUser) and promptUser eq true table width=100% border=0 cellspacing=0 cellpadding=5 tr td If you intend to modify an existing attachment, you must follow the below steps: br blah blah blah /td /tr tr td valign=top align=center img src="" id=okbutt name=okbutt border=0 alt=open attachment > br /td td valign=top align=center img src="" id=cancelbutt name=cancelbutt border=0 alt=close > br /td /tr /table !--- if it is false, just open the attachment in its own application --- cfelseif url.promptUser eq false cfset fName = url.filename !--- Generates custom HTTP response headers to return to the client. --- CFHEADER NAME=Content-Type VALUE=application/unknown CFHEADER NAME=Content-Disposition VALUE=attachment; filename=#fName# CFCONTENT TYPE=application/unknown FILE=UploadFolder\#fName# deletefile=no /cfif I hope the above code is self-explainatory. If you notice, I'm setting 'promptUser' url variable to 'false' in the 'openAttachment' function. This opens up the file open/save dialog box. Now then, this is where I'm stuck. I want to close the pop-up window when the 'promptUser' value is 'false', in other words when the user clicks on the 'okbutt' button. Can someone show me how to do this. I would really appreciate your help Best regards, cfcoder [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: How do I close the pop-up window - kindly help
thanks Pascal. I went with the second option: function openAttachment(){ opener.location = cfoutput#cgi.SCRIPT_NAME#?FILENAME=#url.FILENAME#ID=#url.id#promptU ser=false/cfoutput; window.close(); } It works just fine, many thanks Pascal, you are a genius Regards, cfcoder [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: How do I close the pop-up window - kindly help
Be aware that with XP SP2, the file will not open by default. Pascal -Original Message- From: cf coder [mailto:[EMAIL PROTECTED] Sent: 28 September 2004 15:11 To: CF-Talk Subject: Re: How do I close the pop-up window - kindly help thanks Pascal. I went with the second option: function openAttachment(){ opener.location = cfoutput#cgi.SCRIPT_NAME#?FILENAME=#url.FILENAME#ID=#url.id#promptU ser=false/cfoutput; window.close(); } It works just fine, many thanks Pascal, you are a genius Regards, cfcoder [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Database Management Tool
Ah, I hadn't thought of that.While I don't know if we have php, probably not, it's an innovative solution. Thanks and thanks for the link too. I've never used this particular application, but if you also have PHP support in your web instance, you may be able to use a PHP program to manage your Oracle DB for use with CF. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
ms to no longer supporting msjvm
http://www.microsoft.com/mscorp/java/ this has ABSOLUTELY no adverse affect on us right? -- tony Tony Weeg macromedia certified cold fusion developer email: tonyweeg [at] gmail [dot] com blog: http://www.revolutionwebdesign.com/blog/ cool tool: http://www.antiwrap.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Database Management Tool
Sorry, let me be a bit more helpful. You should get a new host because it seems like they are keeping you out of the database for security issues. I appreciate your sentiment and while I agree with the sentiment, it's not doable.It's the Universities hosting service and we're supposed to use it. Any CF tool you can get to manage an oracle database will need to run on an account that has mad permissions. They are more likely to give you access via TOAD than to grant you DBA privs so a web based tool will work. I see.That's a more depressing thought.What are mad permissions? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
CF_FTP Error
Hi Folks, I am trying to establish an ftp connection using CF_FTP and I get this error message: 500 Illegal PORT Command Has anyone seen this before? Thanks for your help Chris __ Christian BOUDOT Intrasoft International 89-91 route de Thionville L-2611 Luxembourg Tel: +352 44 10 12 21 05 Fax: +352 44 10 12 23 59 Email: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: ms to no longer supporting msjvm
No.. Micha Schopman Software Engineer Modern Media, Databankweg 12 M, 3821 ALAmersfoort Tel 033-4535377, Fax 033-4535388 KvK Amersfoort 39081679, Rabo 39.48.05.380 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: ms to no longer supporting msjvm
No its doesn't have an effect or ... No, it does have an effect -Original Message- From: Micha Schopman [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 28, 2004 9:29 AM To: CF-Talk Subject: RE: ms to no longer supporting msjvm No.. Micha Schopman Software Engineer Modern Media, Databankweg 12 M, 3821 ALAmersfoort Tel 033-4535377, Fax 033-4535388 KvK Amersfoort 39081679, Rabo 39.48.05.380 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: CF_FTP Error
Is your CF server behind a firewall and using NAT?If so, it may be issuing a PORT command to the remote server with a non-routable IP address. Just a thought. Regards, -- Howie Hamlin - inFusion Project Manager On-Line Data Solutions, Inc. - www.CoolFusion.com inFusion Mail Server (iMS) - The Award-winning, Intelligent Mail Server PrismAV - Virus scanning for ColdFusion applications Find out how iMS Stacks up to the competition: http://www.coolfusion.com/imssecomparison.cfm - Original Message - From: BOUDOT Christian To: CF-Talk Sent: Tuesday, September 28, 2004 9:29 AM Subject: CF_FTP Error Hi Folks, I am trying to establish an ftp connection using CF_FTP and I get this error message: 500 Illegal PORT Command Has anyone seen this before? Thanks for your help Chris __ Christian BOUDOT Intrasoft International 89-91 route de Thionville L-2611 Luxembourg Tel: +352 44 10 12 21 05 Fax: +352 44 10 12 23 59 Email: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: ms to no longer supporting msjvm
No it doesn't have an effect. Unless you are running ColdFusion on a MSJVM, but that is a bit uncommon Micha Schopman Software Engineer Modern Media, Databankweg 12 M, 3821 ALAmersfoort Tel 033-4535377, Fax 033-4535388 KvK Amersfoort 39081679, Rabo 39.48.05.380 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Database Management Tool
At 09:28 AM 9/28/2004, you wrote: What are mad permissions? http://www.urbandictionary.com/define.php?term=madr=f Anders +===+ |Anders GreenEmail: [EMAIL PROTECTED] | |Home: 919.303.0218| |Off Road Rally Racing Team: http://linaracing.com/ | +===+ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: ms to no longer supporting msjvm
just wanted to make sure. i was almost positive of this, but, you never know... measure twice cut once. tw On Tue, 28 Sep 2004 15:36:54 +0200, Micha Schopman [EMAIL PROTECTED] wrote: No it doesn't have an effect. Unless you are running ColdFusion on a MSJVM, but that is a bit uncommon Micha Schopman Software Engineer Modern Media, Databankweg 12 M, 3821 ALAmersfoort Tel 033-4535377, Fax 033-4535388 KvK Amersfoort 39081679, Rabo 39.48.05.380 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: oracle timestamp java objects in query results,,, wtf?!
Isaac, We've found that you we can't use the latest drivers with our Oracle 8i DB. We had to stick with the 3.1 drivers. The 3.3 drivers will cause a pile up of open connections and cause the CF server to hang. But, the 3.1 drivers are stable. Thanks Deanna, I may give that a shot. :) s. isaac dealey954.927.5117 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.sys-con.com/story/?storyid=44477DE=1 http://www.sys-con.com/story/?storyid=45569DE=1 http://www.fusiontap.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: oracle timestamp java objects in query results,,, wtf?!
On Monday 27 Sep 2004 13:15 pm, S. Isaac Dealey wrote: The MM Oracle driver seems to be much better -- although on my development server it's still not stable enough for me to want to use it for production. Oddness. We're using the MM drivers against 9i fine here (the roll-up updater is only in testing/staging atm), in a J2EE set-up. This is 9i on Win2K server with the latest SP and patches, also running CFMX Enterprise stand-alone (6.1 w/ updater) on the same machine, so it's connecting to Oracle at ip address 127.0.0.1 ... downloaded the latest drivers from the MM site separately from the red sky updater also... Still getting frequent connection reset and no more data errors, though they're infrequent enough for me to refresh the browser and continue testing when they do occur. During CF testing Oracle also tends to grab hold of 99% of system resources and hang onto them while slowly consuming more memory (I just restart the Oracle service in Windows). Fortunately this server doesn't need to be production-stable as the code goes off to other servers in parts unknown where the Oracle connection is stable. s. isaac dealey954.927.5117 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.sys-con.com/story/?storyid=44477DE=1 http://www.sys-con.com/story/?storyid=45569DE=1 http://www.fusiontap.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: CF_FTP Error
My server is behind a firewall. I just tried the connection with the passive option and it works now. Thanks for your help Cheers Chris _ From: Howie Hamlin [mailto:[EMAIL PROTECTED] Sent: mardi 28 septembre 2004 15:34 To: CF-Talk Subject: Re: CF_FTP Error Is your CF server behind a firewall and using NAT?If so, it may be issuing a PORT command to the remote server with a non-routable IP address. Just a thought. Regards, -- Howie Hamlin - inFusion Project Manager On-Line Data Solutions, Inc. - www.CoolFusion.com inFusion Mail Server (iMS) - The Award-winning, Intelligent Mail Server PrismAV - Virus scanning for ColdFusion applications Find out how iMS Stacks up to the competition: http://www.coolfusion.com/imssecomparison.cfm - Original Message - From: BOUDOT Christian To: CF-Talk Sent: Tuesday, September 28, 2004 9:29 AM Subject: CF_FTP Error Hi Folks, I am trying to establish an ftp connection using CF_FTP and I get this error message: 500 Illegal PORT Command Has anyone seen this before? Thanks for your help Chris __ Christian BOUDOT Intrasoft International 89-91 route de Thionville L-2611 Luxembourg Tel: +352 44 10 12 21 05 Fax: +352 44 10 12 23 59 Email: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: translating java to CF
Did that, compiled the jar file now I'm able to create the objects . . . now I have other problems. Is there a list where I can discuss create and update issues? for sforce I keep getting this error: Web service operation create with parameters [EMAIL PROTECTED] could not be found. The error occurred in sfproducts.cfc: line 44 42 : cfelse 43 : cfset sObjects[1] = updateProduct 44 : cfset update_result = this.sfdc.create(sObjects) 45 : /cfif 46 : cfreturn update_result - -Joshua O'Connor-Rose -All is Good --- Sean Corfield [EMAIL PROTECTED] wrote: On Mon, 27 Sep 2004 13:58:46 -0700 (PDT), Joshua OConnor-Rose [EMAIL PROTECTED] wrote: We have not. I have a bunch of generated .java files from the sforce web site and I am suggesting that we just use those. Is that the direction I should take with this? You would need to compile those and put them in CFMX's classpath. Doesn't sforce.com have a precompiled JAR of the objects? Easier to put that on the classpath. Either way, CFMX needs to be able to load the sforce.com objects in order for you to be able to create those objects... -- Sean A Corfield -- http://www.corfield.org/ Team Fusebox -- http://www.fusebox.org/ If you're not annoying somebody, you're not really alive. -- Margaret Atwood ___ Do you Yahoo!? Declare Yourself - Register online to vote today! http://vote.yahoo.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
CF Application Design
I am interested in getting some feedback from people on the following: Once you have gotten your requirements for a new application and the modeling/architecture process ensues, what tools do you use to link requirements to screens, processes, etc? I have been evaluating Adalon as a tool to introduce into our development process for the purpose of linking requirements to processes and screens but I assume other tools and methods exist. In addition, how do you handle new requirements, updating your models, etc? We currently have an ad-hoc approach and I am looking into formalizing the process as this is an area where we waste a lot of time... well not waste, but sure as hell are not as efficient as we could be. For instance, we have many documents floating in numerous folders that outline original requirements, new requirements, bugs, processes, data dictionary, etc etc but to me, all these documents floating around with next to no naming conventions is a waste. What tools would you recommend looking into to help organize all the aspects of the development process from requirements gathering and analysis to ongoing maintenance and future development. Thanks! Mike [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Randomising a query
Is there any way to randomise a query result set?I was thinking of adding... SELECT rand() AS RandomColumn, OtherQueryFields, ... FROM ... WHERE ... ORDER BY RandomColumn to the query but am not sure if this will produce a good randomisation, it doesn't need to be perfect, just good. I am selecting about 800-900 records of which 400-800 will be used (don't ask!) and I need to make sure that (on average) they are all used. -- James Smith [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Database Management Tool
Are you at least allowed ssh shell access (likely the same name/password as your ftp account)?If so you could use portforwarding,this would allow you to access this database from your local computer using one of the DB tools.I prefer DBVisualizer http://www.minq.se/products/dbvis/ and it works well with anything that has a jdbc connection. If you are using windows and do not have a SSH client, I suggest putty http://www.chiark.greenend.org.uk/~sgtatham/putty/download.html.If you are using OSX or linux it is built in. jw - Original Message - From: daniel kessler [EMAIL PROTECTED] Date: Tue, 28 Sep 2004 09:28:35 -0400 Subject: Re: Database Management Tool To: CF-Talk [EMAIL PROTECTED] Sorry, let me be a bit more helpful. You should get a new host because it seems like they are keeping you out of the database for security issues. I appreciate your sentiment and while I agree with the sentiment, it's not doable.It's the Universities hosting service and we're supposed to use it. Any CF tool you can get to manage an oracle database will need to run on an account that has mad permissions. They are more likely to give you access via TOAD than to grant you DBA privs so a web based tool will work. I see.That's a more depressing thought.What are mad permissions? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Database Management Tool
What are mad permissions? Database management requires complete authority over the databases to be managed. You typically wouldn't want your web server to have those permissions for security reasons - if your web server is compromised, it would have complete control over the databases in question. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Randomising a query
you can always use... select * from myTable order by newid() that will select everything from that table (not recommended, but for this purpose it will work) the order by newid() will create a new UUID for each row, and of course, but doing so, will make it a random result set as those are VERY unique values.they wont too random, as far as their value, since they are made as a combo of the servers mac address and the time of day and some sort of algorith like that, but at least it will work to give some random sets. now about making sure all are used at least some of the time, thats a whole 'notha topic. tw On Tue, 28 Sep 2004 15:15:55 +0100, James Smith [EMAIL PROTECTED] wrote: Is there any way to randomise a query result set?I was thinking of adding... SELECT rand() AS RandomColumn, OtherQueryFields, ... FROM ... WHERE ... ORDER BY RandomColumn to the query but am not sure if this will produce a good randomisation, it doesn't need to be perfect, just good. I am selecting about 800-900 records of which 400-800 will be used (don't ask!) and I need to make sure that (on average) they are all used. -- James Smith [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Database Management Tool
We use TOAD with the same account used in CF (nowhere near DBA privs); this would allow the same SQL in a web-based tool that is used in TOAD (and I've been meaning to write one in CF for quite some time). -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Tuesday, 28 September 2004 10:25 To: CF-Talk Subject: RE: Database Management Tool What are mad permissions? Database management requires complete authority over the databases to be managed. You typically wouldn't want your web server to have those permissions for security reasons - if your web server is compromised, it would have complete control over the databases in question. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Database Management Tool
My sentiment exactly. Although I'm curious as to what they are really concerned about. They should be able to give you an account to create your own objects without giving you permissions to alter anything outside of your own schema. -Adam - Original Message - From: Dave Watts [EMAIL PROTECTED] Date: Tue, 28 Sep 2004 10:25:10 -0400 Subject: RE: Database Management Tool To: CF-Talk [EMAIL PROTECTED] What are mad permissions? Database management requires complete authority over the databases to be managed. You typically wouldn't want your web server to have those permissions for security reasons - if your web server is compromised, it would have complete control over the databases in question. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Server JRUN/CFMX
I have a pretty new (few weeks old) CFMX server 6.1 freshly downloaded from Macromedia setup on our new server.I am getting complaints just about every day that the people are getting the error message below. Also, I noticed yesterday that CFMail just stopped sending out mail .. in the spool directory there were a number of messages ... To fix both problems, I just have to do a start/stop of the application service and all is better, the websites come up and the mail gets sent. Anyone know what can be done about this?Does this make any sense? Here is the ERROR: Server Error The server encountered an internal error and was unable to complete your request. Could not connect to JRun Server. Paul Giesenhagen QuillDesign 417-885-1375 http://www.quilldesign.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Server JRUN/CFMX
Welcome to JRun. IMHO that is the generic JRun error that is thrown when anything wrong happens. Look into your JRun logs to see if you can find any clues. -Adam - Original Message - From: Paul Giesenhagen [EMAIL PROTECTED] Date: Tue, 28 Sep 2004 09:43:02 -0500 Subject: Server JRUN/CFMX To: CF-Talk [EMAIL PROTECTED] I have a pretty new (few weeks old) CFMX server 6.1 freshly downloaded from Macromedia setup on our new server.I am getting complaints just about every day that the people are getting the error message below. Also, I noticed yesterday that CFMail just stopped sending out mail .. in the spool directory there were a number of messages ... To fix both problems, I just have to do a start/stop of the application service and all is better, the websites come up and the mail gets sent. Anyone know what can be done about this?Does this make any sense? Here is the ERROR: Server Error The server encountered an internal error and was unable to complete your request. Could not connect to JRun Server. Paul Giesenhagen QuillDesign 417-885-1375 http://www.quilldesign.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Server JRUN/CFMX
What platform are you running on? Windows, *nix etc... If its Win2k3, we had a thread a couple of weeks ago about CF stability. Where JRun was not a happy camper... It seems to be solved by going through the MS best practices docs and turning off all the uneccessary services... The conversation went off list as we discussed specific configuration details but as I recall in the end, teh problems people were experiencing were fixed by following the procedures in the articles below... Hardening Windows 2003 Server for IIS http://www.microsoft.com/technet/security/guidance/secmod124.mspx http://www.microsoft.com/technet/security/guidance/secmod124.mspx Checklists to harden several aspects of Windows... http://msdn.microsoft.com/library/default.asp?url=""> tml/CL_Index_Of.asp http://msdn.microsoft.com/library/default.asp?url=""> ml/CL_Index_Of.asp Hardening the Windows TCP/IP stack (Win2k and 2003) http://msdn.microsoft.com/library/default.asp?url=""> tml/HTHardTCP.asp http://msdn.microsoft.com/library/default.asp?url=""> ml/HTHardTCP.asp Paul _ From: Paul Giesenhagen [mailto:[EMAIL PROTECTED] Sent: Tuesday, 28 September 2004 15:43 To: CF-Talk Subject: Server JRUN/CFMX I have a pretty new (few weeks old) CFMX server 6.1 freshly downloaded from Macromedia setup on our new server.I am getting complaints just about every day that the people are getting the error message below. Also, I noticed yesterday that CFMail just stopped sending out mail .. in the spool directory there were a number of messages ... To fix both problems, I just have to do a start/stop of the application service and all is better, the websites come up and the mail gets sent. Anyone know what can be done about this?Does this make any sense? Here is the ERROR: Server Error The server encountered an internal error and was unable to complete your request. Could not connect to JRun Server. Paul Giesenhagen QuillDesign 417-885-1375 http://www.quilldesign.com _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
OT: Best Windows FTP Server with Text Based Config File?
I've got a CF application with tons of users. Each of the users is supposed to have their own FTP account and their own directory on the server. The CF application creates the users and the ftp home directories. Are there any Windows based FTP servers that use a text based config file like Apache's conf file to set up the users and home directories??? Thanks, Jon [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Web Service on CFMX 6.1/JRun suddenly not working
I recently swithced from a hosting company to a dedicated server which I am sharing with some co-workers. I have a simple web sevice that resides in the root of my web site. On the old sever, it worked fine (over 1,000,000 hits for the year so far).However, after we switched servers, I would get the following error when I try to browse to the WSDL: AXIS error Sorry, something seems to have gone wrong... here are the details: Fault - [java.lang.ClassNotFoundException : threat][; nested exception is: coldfusion.xml.rpc.CFCInvocationException: [java.lang.ClassNotFoundException : threat][ AxisFault faultCode: {http://schemas.xmlsoap.org/soap/envelope/}Server.generalException faultSubcode: faultString: [java.lang.ClassNotFoundException : threat][; nested exception is: coldfusion.xml.rpc.CFCInvocationException: [java.lang.ClassNotFoundException : threat][ faultActor: faultNode: faultDetail: The only difference is that the new server is running on JRun, I don't think the old server was.I have seen that others have had the same problem, but I could not find any information on how to fix it. -- Scott Stroz Boyzoid.com ___ Some days you are the dog, Some days you are the tree. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Server JRUN/CFMX
Any idea where that checklist is?We have some JVM issue which are becoming increasingly annoying. _ From: Paul Vernon [mailto:[EMAIL PROTECTED] Sent: 28 September 2004 16:03 To: CF-Talk Subject: RE: Server JRUN/CFMX What platform are you running on? Windows, *nix etc... If its Win2k3, we had a thread a couple of weeks ago about CF stability. Where JRun was not a happy camper... It seems to be solved by going through the MS best practices docs and turning off all the uneccessary services... The conversation went off list as we discussed specific configuration details but as I recall in the end, teh problems people were experiencing were fixed by following the procedures in the articles below... Hardening Windows 2003 Server for IIS http://www.microsoft.com/technet/security/guidance/secmod124.mspx http://www.microsoft.com/technet/security/guidance/secmod124.mspx Checklists to harden several aspects of Windows... http://msdn.microsoft.com/library/default.asp?url=""> tml/CL_Index_Of.asp http://msdn.microsoft.com/library/default.asp?url=""> ml/CL_Index_Of.asp Hardening the Windows TCP/IP stack (Win2k and 2003) http://msdn.microsoft.com/library/default.asp?url=""> tml/HTHardTCP.asp http://msdn.microsoft.com/library/default.asp?url=""> ml/HTHardTCP.asp Paul _ From: Paul Giesenhagen [mailto:[EMAIL PROTECTED] Sent: Tuesday, 28 September 2004 15:43 To: CF-Talk Subject: Server JRUN/CFMX I have a pretty new (few weeks old) CFMX server 6.1 freshly downloaded from Macromedia setup on our new server.I am getting complaints just about every day that the people are getting the error message below. Also, I noticed yesterday that CFMail just stopped sending out mail .. in the spool directory there were a number of messages ... To fix both problems, I just have to do a start/stop of the application service and all is better, the websites come up and the mail gets sent. Anyone know what can be done about this?Does this make any sense? Here is the ERROR: Server Error The server encountered an internal error and was unable to complete your request. Could not connect to JRun Server. Paul Giesenhagen QuillDesign 417-885-1375 http://www.quilldesign.com _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Best Windows FTP Server with Text Based Config File?
This one is very good: http://www.serv-u.com/ Regards, -- Howie Hamlin - inFusion Project Manager On-Line Data Solutions, Inc. - www.CoolFusion.com inFusion Mail Server (iMS) - The Award-winning, Intelligent Mail Server PrismAV - Virus scanning for ColdFusion applications Find out how iMS Stacks up to the competition: http://www.coolfusion.com/imssecomparison.cfm - Original Message - From: Jon Block To: CF-Talk Sent: Tuesday, September 28, 2004 11:04 AM Subject: OT: Best Windows FTP Server with Text Based Config File? I've got a CF application with tons of users. Each of the users is supposed to have their own FTP account and their own directory on the server. The CF application creates the users and the ftp home directories. Are there any Windows based FTP servers that use a text based config file like Apache's conf file to set up the users and home directories??? Thanks, Jon [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
cfservlet with cfmx
Hi I'm migrating from cf 5 + jrun 3 to cfmx and am trying to get the jrun that cfmx is running to host a servlet. I was able to do that by adding the servlet to default-web.xml... the servlet starts.Now I'm tring to connect to that servlet using the cfservlet tag but it doesn't work.Turns out, cfservlet is deprecated in cfmx, although it can still connect to jrun3-hosted servlets no problem. I see in the cfmx docs that they recommend using GetPageContext().include() to invoke the servlet, but it doesn't describe how to handle lots of cfservletparam type attributes. (Are you really just supposed to build a big url out of it?) Better yet, does anybody know how to add jcpservices (jcp.endpoint.* stuff) in to jrun 4/cfmx?It feels like the jrun.xml ProxyService is sort of the same thing but it doesn't seem to work with cfservlet. Are there some tweaks to make it work? Any help appreciated. Thanks Mark [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: ms to no longer supporting msjvm
No, it doesn't, since both CFMX and the Java editions of BlueDragon run on Java VMs provided by Sun. It does raise an interesting point, however: Java is basically a foreign technology layered on top Windows and developed by a third-party (Sun) who hasn't always been on the friendliest of terms with Microsoft. Put another way, both CFMX and the Java versions of BlueDragon rely on Sun's Java VM as their technology platform. Java is not supported or endorsed by Microsoft in any way--in fact, Microsoft has been actively antagonistic to Java and Sun. Worse, the use of Java as a technology platform for CFMX requires reliance on other third parties for crucial pieces of technology--such as the DataDirect JDBC drivers and the JIntegra software for COM support. Think about it: when deploying CFMX, you're relying first on Sun for the Java VM, then on DataDirect for the JDBC drivers, and then on JIntegra for COM support (if you need it), and only finally on Macromedia for the CFMX application server. All of these are good companies with good technology, but there are several layers of complexity here, none of which is supported or endorsed by Microsoft. Contrast this with BlueDragon.NET, which relies on the Microsoft .NET Framework as it's underlying technology. The .NET Framework, of course, is developed by Microsoft and is tightly integrated with Windows. Database access (ADO.NET) and COM support are built-in natively to the .NET Framework, so no need for additional third party software. So instead of the Java-DataDirect-JIntegra-CFMX stack (none developed, endorsed or supported by Microsoft!), you've got a much simpler .NET-BlueDragon stack on top of which to run your CFML applications. The best part is that BlueDragon.NET is certified and endorsed by Microsoft, so you've got an entire stack that is either developed, supported, or certified by the platform vendor: http://www.microsoft.com/resources/casestudies/CaseStudy.asp?CaseStudyID=158 64 The point of all of this is: if you're running on Windows, using .NET makes a lot more sense than using Java, which means that using BlueDragon.NET makes a lot more sense than using CFMX (or the Java editions of BlueDragon). The only reason to use Java on Windows is if you want your applications to be portable to Linux, UNIX, or Mac OS X. If you only intend to deploy on Windows, then you should use .NET instead of Java. Vince Bonfanti New Atlanta Communications, LLC http://www.newatlanta.com From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 28, 2004 9:25 AM To: CF-Talk Subject: ms to no longer supporting msjvm http://www.microsoft.com/mscorp/java/ this has ABSOLUTELY no adverse affect on us right? -- tony Tony Weeg macromedia certified cold fusion developer email: tonyweeg [at] gmail [dot] com blog: http://www.revolutionwebdesign.com/blog/ cool tool: http://www.antiwrap.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
OT: type ahead select lists
All, Anybody know of a script that replicates type-ahead select lists (like in Gmail or offline VB applications)? TIA, George [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Randomising a query
SELECT TOP 900 * FROM Table WHERE foo=bar ORDER BY NEWID() From: James Smith [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 28, 2004 10:16 AM To: CF-Talk Subject: Randomising a query Is there any way to randomise a query result set?I was thinking of adding... SELECT rand() AS RandomColumn, OtherQueryFields, ... FROM ... WHERE ... ORDER BY RandomColumn to the query but am not sure if this will produce a good randomisation, it doesn't need to be perfect, just good. I am selecting about 800-900 records of which 400-800 will be used (don't ask!) and I need to make sure that (on average) they are all used. -- James Smith [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Select Box / LIKE operator
I need to come up with a search function that will return a list of matches for a given input. The fields in question are FirstName and LastName. I am not averse to having the search work simply on the last name. For our purposes this is sufficient. The backend database is Access, so I would like to know what my SQL would look like in order to be most useful. If the end user just enters e in the search box, I am not so sure that I want every name that contains an 'e' to be returned Or do I??? What is the consensus on how to make something like this work best? TIA, Tim [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: ms to no longer supporting msjvm
On Tuesday 28 Sep 2004 16:23 pm, Vince Bonfanti wrote: The only reason to use Java on Windows is if you want your applications to be portable And that alone should be worth any potential issues with a 'complex' stack of technology. -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: oracle timestamp java objects in query results,,, wtf?!
On Tuesday 28 Sep 2004 14:51 pm, S. Isaac Dealey wrote: the browser and continue testing when they do occur. During CF testing Oracle also tends to grab hold of 99% of system resources and hang onto them while slowly consuming more memory (I just restart the Is your Oracle up to date ? There was certainly a resource leak in the intelligent agent fixed in .4 (iric we're on .5 now). -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: OT: type ahead select lists
never used it, so can't vouch for quality/cross-browser/etc... http://www.oreillynet.com/pub/a/_javascript_/2003/09/03/dannygoodman.html On Tue, 28 Sep 2004 11:34:54 -0400, George Abraham [EMAIL PROTECTED] wrote: All, Anybody know of a script that replicates type-ahead select lists (like in Gmail or offline VB applications)? TIA, George [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Determining the size of a remote image
I know this message is a bit late, but look for the upcoming version of the Alagad Image Component. This will add the ability to work with images via urls just exactly as requested. Thanks, Doug Hughes [EMAIL PROTECTED] On Thu, 16 Sep 2004 21:37:24 -0400, Rick Root [EMAIL PROTECTED] wrote: Barney Boisvert wrote: You can load an image into a BufferedImage (the Java class that undoubtedly backs the image.cfc you mentioned) from an arbitrary URL. Not sure the exact syntax, but a glimpse inside image.cfc and a browser with javadocs should get you started. Barney, Thanks for the suggestion.With a little research, I found you were right, and one of the read methods takes a URL object.It was very simple to modify the image.cfc to work with both URL and files... - Rick [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Select Box / LIKE operator
- Original Message - From: Claremont, Timothy Date: Tue, 28 Sep 2004 11:46:52 -0400 If the end user just enters e in the search box, I am not so sure that I want every name that contains an 'e' to be returned Or do I??? Typically, I expect searches like that to have at least the first letter in there, so I only do wildcards at the end of the string. For example: WHERE firstname like '#searchString#%' (of course, you'd use cfqueryparam for this :) ) I've only had one app where the clients wanted a full wildcard search ('%#searchstring#%'), but they changed their minds after seeing it in action (apparently they didn't believe me when I said it could return far too many results). Scott -- - Scott Brady http://www.scottbrady.net/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Web Service on CFMX 6.1/JRun suddenly not working
I was able to correct this issue, and since others seem to havehad a similar issue, I thought I would post my solution. When I migrated the site to the new server, I wanted to keep it as similar as it was (cause everything was working).On the old server, I had a mapping to the root of my web directory for the site www.boyzoid.com.On the new server, I created a mapping and pointed it to the root directory for the iste. When I tried to get the WSDL by going to http://www.boyzoid.com/threat.cfc?wsdl, I would get the Axis Error described earlier.The problem lied in the CF Mapping.There were several posts (I think on CF-Talk, as well as th MM forums) that discussed issues with CFMX/JRun issues when using web services and CF mappings. My solution was to change the mapping to the web root from '/mapping name' to just' /' .This cleared up the issue with the web service, and now the WSDL appears as it should. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: ms to no longer supporting msjvm
Put another way, for some people, portability across operating systems is an overriding concern. For other people, platform integration, support, reliability, performance, and scalability are overriding concerns, for which they're willing to sacrifice portability. I wouldn't argue that either .NET or Java is the right solution for all people in all situations. You need to figure out what's important to you and make your decisions accordingly. For some people, the right decision will be Java, for others it'll be .NET. Vince Bonfanti New Atlanta Communications, LLC http://www.newatlanta.com From: Thomas Chiverton [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 28, 2004 11:48 AM To: CF-Talk Subject: Re: ms to no longer supporting msjvm On Tuesday 28 Sep 2004 16:23 pm, Vince Bonfanti wrote: The only reason to use Java on Windows is if you want your applications to be portable And that alone should be worth any potential issues with a 'complex' stack of technology. -- Tom Chiverton Advanced ColdFusion Programmer [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: ms to no longer supporting msjvm
For some (many?) people that's true. But there are some (many?) who have only ever deployed on Windows, and who only ever intend to deploy on Windows. For these people, portability to Linux, UNIX, or Mac OS X is not something they're interested in. Vince Bonfanti New Atlanta Communications, LLC http://www.newatlanta.com From: Thomas Chiverton [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 28, 2004 11:48 AM To: CF-Talk Subject: Re: ms to no longer supporting msjvm On Tuesday 28 Sep 2004 16:23 pm, Vince Bonfanti wrote: The only reason to use Java on Windows is if you want your applications to be portable And that alone should be worth any potential issues with a 'complex' stack of technology. -- Tom Chiverton Advanced ColdFusion Programmer [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Stupid evaluate() question
How would I go about getting rid of evaluate() in this loop?I'm having a brainlock.must have gotten up too early today. cfloop list=#form.FieldNames# index=TheFormField cfscript if (len(Evaluate(TheFormField))) { my.FieldValue=Evaluate(TheFormField); } /cfscript /cfloop -- --Matt Robertson-- MSB Designs, Inc. mysecretbase.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Stupid evaluate() question
cfloop list=#form.FieldNames# index=TheFormField cfscript if (len(form[TheFormField]) { my.FieldValue=Form[TheFormField]; } /cfscript /cfloop You can also do this with collection=#form# cf -Original Message- From: Matt Robertson [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 28, 2004 11:52 AM To: CF-Talk Subject: Stupid evaluate() question How would I go about getting rid of evaluate() in this loop?I'm having a brainlock.must have gotten up too early today. cfloop list=#form.FieldNames# index=TheFormField cfscript if (len(Evaluate(TheFormField))) { my.FieldValue=Evaluate(TheFormField); } /cfscript /cfloop -- --Matt Robertson-- MSB Designs, Inc. mysecretbase.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Stupid evaluate() question
This should do it (without testing, off the top of my head): cfloop list=#form.FieldNames# index=TheFormField cfscript if (len(FORM[TheFormField])) { my.FieldValue=FORM[TheFormField]; } /cfscript /cfloop Scott -- - Scott Brady http://www.scottbrady.net/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: ms to no longer supporting msjvm
Think about it: when deploying CFMX, you're relying first on Sun for the Java VM, then on DataDirect for the JDBC drivers, and then on JIntegra for COM support (if you need it), and only finally on Macromedia for the CFMX application server. All of these are good companies with good technology, but there are several layers of complexity here, none of which is supported or endorsed by Microsoft. I don't mean to burst your little BlueDragon pitch, but what about the problems that arise when you put all your eggs in one basket? I'd rather rely on different companies for different parts of the application, rather than just assume MS can do it better than anyone else, which is rarely the case. I think the freedom to switch core technologies like JVM and JDBCs as a positive thing. What sort of benefits are thier in giving up the freedom to move platmforms? -Adam - Original Message - From: Vince Bonfanti [EMAIL PROTECTED] Date: Tue, 28 Sep 2004 11:23:15 -0400 Subject: RE: ms to no longer supporting msjvm To: CF-Talk [EMAIL PROTECTED] No, it doesn't, since both CFMX and the Java editions of BlueDragon run on Java VMs provided by Sun. It does raise an interesting point, however: Java is basically a foreign technology layered on top Windows and developed by a third-party (Sun) who hasn't always been on the friendliest of terms with Microsoft. Put another way, both CFMX and the Java versions of BlueDragon rely on Sun's Java VM as their technology platform. Java is not supported or endorsed by Microsoft in any way--in fact, Microsoft has been actively antagonistic to Java and Sun. Worse, the use of Java as a technology platform for CFMX requires reliance on other third parties for crucial pieces of technology--such as the DataDirect JDBC drivers and the JIntegra software for COM support. Think about it: when deploying CFMX, you're relying first on Sun for the Java VM, then on DataDirect for the JDBC drivers, and then on JIntegra for COM support (if you need it), and only finally on Macromedia for the CFMX application server. All of these are good companies with good technology, but there are several layers of complexity here, none of which is supported or endorsed by Microsoft. Contrast this with BlueDragon.NET, which relies on the Microsoft .NET Framework as it's underlying technology. The .NET Framework, of course, is developed by Microsoft and is tightly integrated with Windows. Database access (ADO.NET) and COM support are built-in natively to the .NET Framework, so no need for additional third party software. So instead of the Java-DataDirect-JIntegra-CFMX stack (none developed, endorsed or supported by Microsoft!), you've got a much simpler .NET-BlueDragon stack on top of which to run your CFML applications. The best part is that BlueDragon.NET is certified and endorsed by Microsoft, so you've got an entire stack that is either developed, supported, or certified by the platform vendor: http://www.microsoft.com/resources/casestudies/CaseStudy.asp?CaseStudyID=158 64 The point of all of this is: if you're running on Windows, using .NET makes a lot more sense than using Java, which means that using BlueDragon.NET makes a lot more sense than using CFMX (or the Java editions of BlueDragon). The only reason to use Java on Windows is if you want your applications to be portable to Linux, UNIX, or Mac OS X. If you only intend to deploy on Windows, then you should use .NET instead of Java. Vince Bonfanti New Atlanta Communications, LLC http://www.newatlanta.com From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 28, 2004 9:25 AM To: CF-Talk Subject: ms to no longer supporting msjvm http://www.microsoft.com/mscorp/java/ this has ABSOLUTELY no adverse affect on us right? -- tony Tony Weeg macromedia certified cold fusion developer email: tonyweeg [at] gmail [dot] com blog: http://www.revolutionwebdesign.com/blog/ cool tool: http://www.antiwrap.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Stupid evaluate() question
my.FieldValue=Form[TheFormField]; DOH! Thanks Mark.I knew I was missing something simple. -- --Matt Robertson-- MSB Designs, Inc. mysecretbase.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Select Box / LIKE operator
Not so much a consensus as an ad hoc standard is that the 'e' would be the first letter of the search string.Just be sure to notify users of the functionality of your search engine. Please enter in the first few letters of the last name of the person you wish to find You could also provide two radio buttons to allow them to search first or last names.Anything could work as long as your UI provides enough instruction for the user to follow. SELECT p.first_name, p.last_name, p.person_id FROM person p cfif form.name_to_search eq last WHERE p.last_name LIKE '#form.last_name#%' cfleseif form.name_to_search eq first WHERE p.first_name LIKE '#form.first_name#%' /cfif ORDER BY p.last_name cfoutput query=yourQuery a href=""> #first_name#/abr /cfoutput From: Claremont, Timothy [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 28, 2004 11:47 AM To: CF-Talk Subject: Select Box / LIKE operator I need to come up with a search function that will return a list of matches for a given input. The fields in question are FirstName and LastName. I am not averse to having the search work simply on the last name. For our purposes this is sufficient. The backend database is Access, so I would like to know what my SQL would look like in order to be most useful. If the end user just enters e in the search box, I am not so sure that I want every name that contains an 'e' to be returned Or do I??? What is the consensus on how to make something like this work best? TIA, Tim [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: type ahead select lists
Anybody know of a script that replicates type-ahead select lists (like in Gmail or offline VB applications)? George, I built this using _javascript_.It's not too pretty, but it works just fine. The idea is that a global variable is the buffer in the list, to which keystrokes are added.The script is set to work on my page, but I am sure you can figure out how to adapt it. HTH, Matthieu * NOTES * 1) pkTAX is the primary key in the table listing the options for the drop-down. 2) TAX_Term is the text of that option. ** SELECT TAG LOOKS LIKE THIS ** SELECT name=pkTAX > > OPTION value=-1 selectedSelect a taxonomy term to add.../OPTION CFLOOP query=qTerms OPTION value=#qTerms.pkTAX##qTerms.TAX_Term#/OPTION /CFLOOP /SELECT *** THESE GO IN THE HEAD SECTION. *** // Declare global variables used for typeahead feature. var ta_pkTAX = ; var sn_pkTAX = ; // Handle keystrokes. function typeAhead() { // Check whether user has hit enter, requesting that the form be submitted. if (event.keyCode == 13) { // CASE: user wants to submit form. runSubmitFunction(); } else { // Set basic variables. var keyPressed = String.fromCharCode(event.keyCode).toUpperCase(); var currentlySelected = document.frmDummy.pkTAX.options.selectedIndex; var selectNew = document.frmDummy.pkTAX.options.length; var i = 1; // Add latest key pressed to global storage for this control. ta_pkTAX = ta_pkTAX + keyPressed; // alert(ta_pkTAX); // alert(sn_pkTAX); // Find closest match in list. while (i document.frmDummy.pkTAX.options.length) { selectNew = i; // Is the current entry the closest match? if (document.frmDummy.pkTAX.options[i].text.substr(0,ta_pkTAX.length) = ta_pkTAX) { // CASE: yes - end loop in place. i = document.frmDummy.pkTAX.options.length; } else { // CASE: no - increment to next value i++; } } // Set value of select box. document.frmDummy.pkTAX.options.selectedIndex = selectNew; // Set stored typeahead value for select box. sn_pkTAX = selectNew; } if (event.keyCode == 27) { //handle escape key event } } function adjustForTypeAhead() { // Is there a stored typeahead selection value for the select box? if (sn_pkTAX != ) { // CASE: yes - set select box to that value document.frmDummy.pkTAX.options.selectedIndex = sn_pkTAX; sn_pkTAX = ; } else { // CASE: no - reset typeahead storage variable. ta_pkTAX = ; } } [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Select Box / LIKE operator
If the end user just enters e in the search box, I am not so sure that I want every name that contains an 'e' to be returned Or do I??? What is the consensus on how to make something like this work best? I personally like the anywhere in the string approach, but I have found that most people expect it to be at the start of the string, as Steve mentioned.People get confused when a search for DER returns ANDERSON at the top of the list, when they were in fact looking for DEREK. HTH, Matthieu [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
webgrabber and mx wrapper
Can anyone tell me how to get this product to work w/ an intranet address? It works fine if I pass in yahoo or google address but when I pass in an intranet address.. the pdf isn't generated.It just hangs.If I use the native method with file protocol it returns a plain pdf w/ no styles.Any help would be greatly appreciated. CFOBJECT ACTION=""> TYPE=COM CLASS=APWebGrabberCF.Object NAME=WebGrabber CFOBJECT ACTION=""> TYPE=COM CLASS=APServerCF.Object NAME=APServer CFSET keywds = activePDF example CFSET APServer.PDFKeywords = keywds CFSET APServer.OutputDirectory = ExpandPath(results) CFSET WebGrabber.Prt2DiskSettings = APServer.ToString() CFSET WebGrabber.EngineToUse = 1 !--- CFSET sURL = file://e:\Inetpub\wwwroot\InSite\CFExamples\gary\reportlayout.html file://e:\Inetpub\wwwroot\InSite\CFExamples\gary\reportlayout.html --- CFSET sURL = http://indev/CFExamples/gary/reportlayout.html?pass=1 http://indev/CFExamples/gary/reportlayout.html?pass=1 CFSET WebGrabber.URL = ""> CFSET sessionResults = WebGrabber.DoPrint(127.0.0.1,64320) CFSET waitResults = WebGrabber.Wait(127.0.0.1,64320,180,) CFSET APServer.FromString(WebGrabber.Prt2DiskSettings) CFSET rCode = APServer.Wait(600) CFSET pdf = ExpandPath(results) / APServer.NewUniqueID .pdf http://www.wng.com/ Tim Do Programmer/Analyst Western National Group 949.862.6231 www.wng.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Java 1.4.2_05
I'm not having problems with 1.4.2_05. It seems more stable than previous versions even. Perhaps something in your app isn't _05 friendly? -nathan strutz http://www.dopefly.com/ Robertson-Ravo, Neil (RX) wrote: Any one have any issues with performance/JRun connection errors since upgrading to Sun Java 1.4.2_05?We are thinking about downgrading from this as it would seem that it's not a happy JVM when it comes to load and CF... ? This e-mail is from Reed Exhibitions (Oriel House, 26 The Quadrant, Richmond, Surrey, TW9 1DL, United Kingdom), a division of Reed Business, Registered in England, Number 678540.It contains information which is confidential and may also be privileged.It is for the exclusive use of the intended recipient(s).If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful.If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910.The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions. Visit our website at http://www.reedexpo.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Stupid evaluate() question
From: Matt Robertson [mailto:[EMAIL PROTECTED] How would I go about getting rid of evaluate() in this loop? I'm having a brainlock.must have gotten up too early today. cfloop list=#form.FieldNames# index=TheFormField cfscript if (len(Evaluate(TheFormField))) { my.FieldValue=Evaluate(TheFormField); } /cfscript /cfloop cfloop list=#form.FieldNames# index=TheFormField cfscript if (len(form[TheFormField])) { my.FieldValue=form[TheFormField]; } /cfscript /cfloop Mike [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Stupid evaluate() question
use form[theFormField] instead. cheers, barneyb On Tue, 28 Sep 2004 09:52:09 -0700, Matt Robertson [EMAIL PROTECTED] wrote: How would I go about getting rid of evaluate() in this loop?I'm having a brainlock.must have gotten up too early today. cfloop list=#form.FieldNames# index=TheFormField cfscript if (len(Evaluate(TheFormField))) { my.FieldValue=Evaluate(TheFormField); } /cfscript /cfloop -- --Matt Robertson-- MSB Designs, Inc. mysecretbase.com -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com I currently have 6 GMail invites for the taking [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Web Service on CFMX 6.1/JRun suddenly not working
Any chance there is a new Application.cfm file on the new server? I received that exact same error when I tried to write my first web service CFC a few weeks ago.It ended up that I was putting the cfc in my root which had an Application.cfm file that did a fair amount of processing.It turned out that the white space generated by the Application.cfm file was causing the WSDL to fail.When I moved the web service cfc to it own sub-directory with no Application.cfm file, all worked well. HTH -- Ian Skinner Web Programmer BloodSource file:///C:\Documents%20and%20Settings\iskinner\Application%20Data\Microsoft\Signatures\www.BloodSource.org www.BloodSource.org http://www.BloodSource.orgSacramento Sacramento, CA C code. C code run. Run code run. Please! - Cynthia Dunning Confidentiality Notice:This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: OT: type ahead select lists
just did this, and it works GREAT, but after like 3 letters it begins to trip out... it worked for two diff. examples i used on my backend, however, like i said, when you are in the select box, and you type more than 3 letters, it seems to trip... tw On Tue, 28 Sep 2004 08:59:23 -0700, Charlie Griefer [EMAIL PROTECTED] wrote: never used it, so can't vouch for quality/cross-browser/etc... http://www.oreillynet.com/pub/a/_javascript_/2003/09/03/dannygoodman.html On Tue, 28 Sep 2004 11:34:54 -0400, George Abraham [EMAIL PROTECTED] wrote: All, Anybody know of a script that replicates type-ahead select lists (like in Gmail or offline VB applications)? TIA, George [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: ms to no longer supporting msjvm
The major benefits to giving up portability are: platform integration and performance. (I'd argue that you'll get better reliability and scalability, but that's a bit harder to prove). Performance and integration come from a single vendor providing a single integrated solution. It's well-known that the Microsoft Java VM was easily the fastest Java VM for Windows, handily outperforming Java VMs from Sun, IBM and others. This is hardly surprising. It was the fact that Microsoft wanted tighter integration of their VM with Windows that resulted in: (1) a lawsuit with Sun; (2) Microsoft developing the .NET Framework as an alternative; and, (3) Microsoft dropping support for their Java VM (which is what started this thread). .NET will always outperform Java on Windows. There's no way that Sun or IBM, as third-parties, can produce a virtual machine that outperforms Microsoft's on Windows. For example, Windows 2003 was specifically tuned to run the .NET Framework, which runs almost twice as fast on Windows 2003 as it does on Windows 2000. You won't see any similar performance boost for Java when going from Windows 2000 to Windows 2003. The fact that .NET will provide better integration with Windows, and with other Microsoft products, such as SQL Server, should be obvious without further discussion. Do you really think a JDBC driver from DataDirect is going to provide better integration and performance with SQL Server 2005 than ADO.NET? So those are the trade-offs. You can maximize portability, or you can maximize performance and integration. You can't have both. Some people with prefer one, some people will prefer the other. Vince Bonfanti New Atlanta Communications, LLC http://www.newatlanta.com From: Adrocknaphobia [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 28, 2004 1:19 PM To: CF-Talk Subject: Re: ms to no longer supporting msjvm Think about it: when deploying CFMX, you're relying first on Sun for the Java VM, then on DataDirect for the JDBC drivers, and then on JIntegra for COM support (if you need it), and only finally on Macromedia for the CFMX application server. All of these are good companies with good technology, but there are several layers of complexity here, none of which is supported or endorsed by Microsoft. I don't mean to burst your little BlueDragon pitch, but what about the problems that arise when you put all your eggs in one basket? I'd rather rely on different companies for different parts of the application, rather than just assume MS can do it better than anyone else, which is rarely the case. I think the freedom to switch core technologies like JVM and JDBCs as a positive thing. What sort of benefits are thier in giving up the freedom to move platmforms? -Adam [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: ms to no longer supporting msjvm
Be careful where you're going with this argument. You wouldn't ever rely on a single-vendor solution--such as Allaire/Macromedia ColdFusion--would you? What about the problems that arise when you put all your eggs in one basket? With BlueDragon, you get: - The freedom to choose either Java or .NET. - The freedom to deploy on any J2EE server in a standard WAR/EAR format. - The freedom to deploy on Mac OS X as a fully supported platform. - The freedom to, well, deploy for free. If it's freedom that you're primarily interested, then I assume BlueDragon is your preferred CFML server? Vince Bonfanti New Atlanta Communications, LLC http://www.newatlanta.com From: Adrocknaphobia [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 28, 2004 1:19 PM To: CF-Talk Subject: Re: ms to no longer supporting msjvm Think about it: when deploying CFMX, you're relying first on Sun for the Java VM, then on DataDirect for the JDBC drivers, and then on JIntegra for COM support (if you need it), and only finally on Macromedia for the CFMX application server. All of these are good companies with good technology, but there are several layers of complexity here, none of which is supported or endorsed by Microsoft. I don't mean to burst your little BlueDragon pitch, but what about the problems that arise when you put all your eggs in one basket? I'd rather rely on different companies for different parts of the application, rather than just assume MS can do it better than anyone else, which is rarely the case. I think the freedom to switch core technologies like JVM and JDBCs as a positive thing. What sort of benefits are thier in giving up the freedom to move platmforms? -Adam [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
SQL Query to XML
Here's one where I'm not really sure where to start I have a SQL query that I need to run and append the results to a node in a pre-formatted XML template. The XML template is used by several other apps in the suite and carries information from different apps. I'll be doing updates and inserts to the section of the template that deals with my sub app. Thanks in advance for any input sas Scott A. Stewart, Web Application Developer Engineering Consulting Services, Ltd. (ECS) 14026 Thunderbolt Place, Suite 100 Chantilly, VA 20151 Phone: (703) 471-8400 Fax: (703) 834-5527 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: OT: type ahead select lists
George, Is this what your are looking for: http://webfx.eae.net/dhtml/combobox/combobox.htm http://webfx.eae.net/dhtml/combobox/combobox.htm I tried the other example below, but it did not type ahead. Mario -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 28, 2004 1:03 PM To: CF-Talk Subject: Re: OT: type ahead select lists just did this, and it works GREAT, but after like 3 letters it begins to trip out... it worked for two diff. examples i used on my backend, however, like i said, when you are in the select box, and you type more than 3 letters, it seems to trip... tw On Tue, 28 Sep 2004 08:59:23 -0700, Charlie Griefer [EMAIL PROTECTED] wrote: never used it, so can't vouch for quality/cross-browser/etc... http://www.oreillynet.com/pub/a/_javascript_/2003/09/03/dannygoodman.html On Tue, 28 Sep 2004 11:34:54 -0400, George Abraham [EMAIL PROTECTED] wrote: All, Anybody know of a script that replicates type-ahead select lists (like in Gmail or offline VB applications)? TIA, George _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: ms to no longer supporting msjvm
sorry but i have a hard time having the words freedom and microsoft being linked together. well at least without seriously laughing my ass off nothing to do with bd though vince -- Original Message -- From: Vince Bonfanti [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date:Tue, 28 Sep 2004 14:05:49 -0400 Be careful where you're going with this argument. You wouldn't ever rely on a single-vendor solution--such as Allaire/Macromedia ColdFusion--would you? What about the problems that arise when you put all your eggs in one basket? With BlueDragon, you get: - The freedom to choose either Java or .NET. - The freedom to deploy on any J2EE server in a standard WAR/EAR format. - The freedom to deploy on Mac OS X as a fully supported platform. - The freedom to, well, deploy for free. If it's freedom that you're primarily interested, then I assume BlueDragon is your preferred CFML server? Vince Bonfanti New Atlanta Communications, LLC http://www.newatlanta.com From: Adrocknaphobia [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 28, 2004 1:19 PM To: CF-Talk Subject: Re: ms to no longer supporting msjvm Think about it: when deploying CFMX, you're relying first on Sun for the Java VM, then on DataDirect for the JDBC drivers, and then on JIntegra for COM support (if you need it), and only finally on Macromedia for the CFMX application server. All of these are good companies with good technology, but there are several layers of complexity here, none of which is supported or endorsed by Microsoft. I don't mean to burst your little BlueDragon pitch, but what about the problems that arise when you put all your eggs in one basket? I'd rather rely on different companies for different parts of the application, rather than just assume MS can do it better than anyone else, which is rarely the case. I think the freedom to switch core technologies like JVM and JDBCs as a positive thing. What sort of benefits are thier in giving up the freedom to move platmforms? -Adam [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Web Service on CFMX 6.1/JRun suddenly not working
No chance on teh Application.cfm, I copied all the files, EXACTLY as they were on teh old server. - Original Message - From: Ian Skinner [EMAIL PROTECTED] Date: Tue, 28 Sep 2004 10:04:28 -0700 Subject: RE: Web Service on CFMX 6.1/JRun suddenly not working To: CF-Talk [EMAIL PROTECTED] Any chance there is a new Application.cfm file on the new server? I received that exact same error when I tried to write my first web service CFC a few weeks ago.It ended up that I was putting the cfc in my root which had an Application.cfm file that did a fair amount of processing.It turned out that the white space generated by the Application.cfm file was causing the WSDL to fail.When I moved the web service cfc to it own sub-directory with no Application.cfm file, all worked well. HTH -- Ian Skinner Web Programmer BloodSource file:///C:\Documents%20and%20Settings\iskinner\Application%20Data\Microsoft\Signatures\www.BloodSource.org www.BloodSource.org http://www.BloodSource.orgSacramento Sacramento, CA C code. C code run. Run code run. Please! - Cynthia Dunning Confidentiality Notice:This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: OT: type ahead select lists
Charlie, I guess I should have made myself more clear. The form element would have to be a text input (or textarea), not a select list. Mario's referring URL seems to do what I want. It does appear to have a few bugs in the demo. Matthieu's idea of using a global buffer for storing the options seems to be what they are following. If the options are stored in a select list, the browser ends up crunching a whole lot of resources if the select list has say, a 1000 options. George [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: CF Application Design
On Tue, 28 Sep 2004 10:17:39 -0400, Tangorre, Michael [EMAIL PROTECTED] wrote: Once you have gotten your requirements for a new application and the modeling/architecture process ensues, what tools do you use to link requirements to screens, processes, etc? We don't keep a formal one-to-one record of requirements to fragments of code but we use Borland's Together Control Center for much of our application modeling. That lets us create Use Case diagrams and Collaboration diagrams that have placeholders for requirement IDs. We refine those into logical and physical Class diagrams and carry over the requirement IDs. In the past, I've built some extensions to Together that support Jim Conallen's Web Extensions for UML so that we can model web pages and forms and links, again with requirement IDs attached. Like I say, we *can* do all of that. But we typically don't. We do try to version control our specs tho', either manually using in-document annotations or explicitly using CVS. It's very, very hard to formalize the requirements / analysis / design process but I will say that it's definitely very worthwhile. The more you can front-load your process, the easier the rest of the process becomes. Whilst I am not exactly a FLiP convert, I will say that it's emphasis on the front-end of the lifecycle (wireframing, prototyping, architecture and Fusedocs) means that the tail-end (coding, testing) should go much more smoothly. -- Sean A Corfield -- http://www.corfield.org/ Team Fusebox -- http://www.fusebox.org/ If you're not annoying somebody, you're not really alive. -- Margaret Atwood [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Session swapping
We have an internet application running on CFMX hosted locally.Our clients (on a Navy base) are running machines that are restricted by NMCI (Navy-Marine Corps Intranet) and they're using a NAT Proxy Server that all of the users are behind.They just recently got moved to this new system and we noticed an odd problem with this application.Two users sitting at separate machines will pull up the website and go to the login page.Once logged in, they will suddenly both be logged in as the same person and the CFID and CFTOKEN in the URL are the same.We're trying to figure out what's causing this problem and how to fix it. We're meeting with the network team in charge of the NAT Proxy but we're all expecting an it's not our problem response.Can anyone give more info on how CF assigns CFID and CFTOKEN and how we might be able to code against this?Any users with experience with NMCI issues would be especially helpful.Thanks for your time. John Burns [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
losing form on cflocation
I have a registration form that I want to insert to a DB after validation.To validate a unique name, I reload the form and query on the information.If it's a unique name, I cflocation to the INSERT page.Thing is, when I get to the insert page, the form is no longer available.I assume it's because cflocation is doing a replace().Is there a cure for this? btw, I'm validating this way so that if there's an unique registration error, the form still has it's values. thanks! -- Daniel Kessler Department of Public and Community Health University of Maryland Suite 2387 Valley Drive College Park, MD20742-2611 301-405-2545 Phone www.phi.umd.edu [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Verify an email address from a query
I've spent the last couple of hours looking at isEmail and regular _expression_ stuff, but haven't gotten anything to work for me yet. I swear somebody posted, just a few weeks ago, a good piece of working code, but for some reason I can't seem to get the archive search to work for me... Here's essentially what I'm trying to do: cfloop query=emailLIST IF THE EMAIL ADDRESS IS VALID cfmail ..blah, blah..send to #emailAddress#..blah, blah Sent: #emailAddress# !---display so I can see where it went--- cfelse !---display so I can see where it's screwed--- Bad Address - somebody fix this!: #emailAddress# /cfif cfloop Pointers please? -- Les Mizzell [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: losing form on cflocation
A cflocation sends a header back to the client that tells it to redirect to another page using the GET method therefore the form submission ends and the form scope is cleared down when the GET request is made. This is normal behaviour. Paul [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: losing form on cflocation
Daniel Kessler wrote: replace().Is there a cure for this? Do the insert on that page then cflocation to a result page. optinally you could cfinclude the insert template... as long as you're careful how you handle the end of THAT template.. I wouldn't do it this way though. - Rick [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: CF Application Design
Sean, What would your requirement ID signify. Just a tracking number to be used throughout the process to tie together the one to one record of requirements? I just looked at Together as well as the tutorial on all of the UML diagrams. Very cool product, but $3500 for the solo license. Yikes! Dan - Original Message - From: Sean Corfield [EMAIL PROTECTED] Date: Tue, 28 Sep 2004 10:55:39 -0700 Subject: Re: CF Application Design To: CF-Talk [EMAIL PROTECTED] On Tue, 28 Sep 2004 10:17:39 -0400, Tangorre, Michael [EMAIL PROTECTED] wrote: Once you have gotten your requirements for a new application and the modeling/architecture process ensues, what tools do you use to link requirements to screens, processes, etc? We don't keep a formal one-to-one record of requirements to fragments of code but we use Borland's Together Control Center for much of our application modeling. That lets us create Use Case diagrams and Collaboration diagrams that have placeholders for requirement IDs. We refine those into logical and physical Class diagrams and carry over the requirement IDs. In the past, I've built some extensions to Together that support Jim Conallen's Web Extensions for UML so that we can model web pages and forms and links, again with requirement IDs attached. Like I say, we *can* do all of that. But we typically don't. We do try to version control our specs tho', either manually using in-document annotations or explicitly using CVS. It's very, very hard to formalize the requirements / analysis / design process but I will say that it's definitely very worthwhile. The more you can front-load your process, the easier the rest of the process becomes. Whilst I am not exactly a FLiP convert, I will say that it's emphasis on the front-end of the lifecycle (wireframing, prototyping, architecture and Fusedocs) means that the tail-end (coding, testing) should go much more smoothly. -- Sean A Corfield -- http://www.corfield.org/ Team Fusebox -- http://www.fusebox.org/ If you're not annoying somebody, you're not really alive. -- Margaret Atwood [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Verify an email address from a query
Put the cfscript Function isEmail(). /cfscript In your page above the following and then do: cfloop query=emailLIST cfif isEmail('#emailAddress#') ... cfelse Bad address /cfif /cfloop John -Original Message- From: Les Mizzell [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 28, 2004 2:52 PM To: CF-Talk Subject: Verify an email address from a query I've spent the last couple of hours looking at isEmail and regular _expression_ stuff, but haven't gotten anything to work for me yet. I swear somebody posted, just a few weeks ago, a good piece of working code, but for some reason I can't seem to get the archive search to work for me... Here's essentially what I'm trying to do: cfloop query=emailLIST IF THE EMAIL ADDRESS IS VALID cfmail ..blah, blah..send to #emailAddress#..blah, blah Sent: #emailAddress# !---display so I can see where it went--- cfelse !---display so I can see where it's screwed--- Bad Address - somebody fix this!: #emailAddress# /cfif cfloop Pointers please? -- Les Mizzell [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: losing form on cflocation
On Tue, 28 Sep 2004 14:56:09 -0400, Daniel Kessler [EMAIL PROTECTED] wrote: I have a registration form that I want to insert to a DB after validation.To validate a unique name, I reload the form and query on the information.If it's a unique name, I cflocation to the INSERT page.Thing is, when I get to the insert page, the form is no longer available.I assume it's because cflocation is doing a replace().Is there a cure for this? The cure would be to insert the data after validation before doing the cflocation (and cflocation to a thank you / summary / confirmation page). -- Sean A Corfield -- http://www.corfield.org/ Team Fusebox -- http://www.fusebox.org/ If you're not annoying somebody, you're not really alive. -- Margaret Atwood [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
CF Array to Java array : more sforce questions
I'm feeling like I've got a near neighbor to a solution here but I keep getting an error. here's my code most going strait to the sforce example. _ cfset account1 = createObject(java,com.sforce.soap.enterprise.sobject.Account) cfset account2 = createObject(java,com.sforce.soap.enterprise.sobject.Account) cfset account1.setAccountNumber(002DF99ELK9) cfset account1.setBillingCity(Wichita) cfset account1.setBillingCountry(US) cfset account1.setBillingState(KA) cfset account1.setBillingStreet(4322 Haystack Boulevard) cfset account1.setBillingPostalCode(87901) cfset account2.setName(Golden Straw) cfset account2.setAccountNumber(003DF99ELK9) cfset account2.setBillingCity(Oaklanc) cfset account2.setBillingCountry(US) cfset account2.setBillingState(CA) cfset account2.setBillingStreet(666 Raiders Boulevard) cfset account2.setBillingPostalCode(97502) cfset arrObj = createobject(java, java.lang.reflect.Array) cfset jClass = createObject(java,com.sforce.soap.enterprise.sobject.Account) cfset sObjects = arrObj.newInstance(jClass.class, 2) !--- cfset sObjects[0] = account1 cfset sObjects[1] = account2 --- cfset arrObj.set(sObjects, 0, account1) cfset arrObj.set(sObjects, 1, account2) cfdump var=#sObjects# cfinvoke webservice = #this.sfdc# method = create sObjects = #sObjects# returnVariable = saveResults --- the error is --- Could not perform web service invocation create because AxisFault faultCode: {http://schemas.xmlsoap.org/soap/envelope/}Server.userException faultSubcode: faultString: common.exception.ApiException: sObject type apos;Arrayapos; is not supported. faultActor: faultNode: faultDetail: {urn:fault.enterprise.soap.sforce.com}fault: INVALID_TYPE sObject type 'Array' is not supported. - which is practically infuriating because according to the documentation Creating objects involves the following basic steps: 1. Instantiate one or more individual objects within the object. For each object, you populate its fields with the data that you want to add. 2. Construct an sObject[] array and populate that array with the objects that you want to create. All objects must be of the same object. 3. Call create, passing in the sObject[] array. 4. Process the results in the SaveResult[] object to verify whether the objects have been successfully created. Any help with this would be appreciated. Mostly looking for another set of eyes. -Joshua O'Connor-Rose -All is Good __ Do you Yahoo!? New and Improved Yahoo! Mail - 100MB free storage! http://promotions.yahoo.com/new_mail [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: losing form on cflocation
ur having a heck of a time with this form huh! ok, too do that u'd need to set the form fields as session so when u go back u can put them back in but reloading the form the way i understand it is a bit odd why are u sending it to another page? just put the code below it would it help 4 u too see some code? -- Original Message -- From: Daniel Kessler [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date:Tue, 28 Sep 2004 14:56:09 -0400 I have a registration form that I want to insert to a DB after validation.To validate a unique name, I reload the form and query on the information.If it's a unique name, I cflocation to the INSERT page.Thing is, when I get to the insert page, the form is no longer available.I assume it's because cflocation is doing a replace().Is there a cure for this? btw, I'm validating this way so that if there's an unique registration error, the form still has it's values. thanks! -- Daniel Kessler Department of Public and Community Health University of Maryland Suite 2387 Valley Drive College Park, MD20742-2611 301-405-2545 Phone www.phi.umd.edu [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Session swapping
I encountered virtualy the same issue where various PCs were ghosted from an original image. When setting up that image our site had been visited and the CFID and CFTOKEN cookies ended up being part of the image. Explicitly deleting cookies in the client browser fixed it right up. --- Burns, John D [EMAIL PROTECTED] wrote: We have an internet application running on CFMX hosted locally.Our clients (on a Navy base) are running machines that are restricted by NMCI (Navy-Marine Corps Intranet) and they're using a NAT Proxy Server that all of the users are behind.They just recently got moved to this new system and we noticed an odd problem with this application.Two users sitting at separate machines will pull up the website and go to the login page.Once logged in, they will suddenly both be logged in as the same person and the CFID and CFTOKEN in the URL are the same. We're trying to figure out what's causing this problem and how to fix it. We're meeting with the network team in charge of the NAT Proxy but we're all expecting an it's not our problem response.Can anyone give more info on how CF assigns CFID and CFTOKEN and how we might be able to code against this?Any users with experience with NMCI issues would be especially helpful.Thanks for your time. John Burns [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Session swapping
I ran into a similar issue with one of our intranets here. If you aren't already use UUID for cftoken. We were only seeing this issue in teh training labs when a bunch of people were logged in on the same part of the network and UUID seemed to prevent the SESSION steals. -Adam - Original Message - From: Burns, John D [EMAIL PROTECTED] Date: Tue, 28 Sep 2004 13:56:25 -0400 Subject: Session swapping To: CF-Talk [EMAIL PROTECTED] We have an internet application running on CFMX hosted locally.Our clients (on a Navy base) are running machines that are restricted by NMCI (Navy-Marine Corps Intranet) and they're using a NAT Proxy Server that all of the users are behind.They just recently got moved to this new system and we noticed an odd problem with this application.Two users sitting at separate machines will pull up the website and go to the login page.Once logged in, they will suddenly both be logged in as the same person and the CFID and CFTOKEN in the URL are the same.We're trying to figure out what's causing this problem and how to fix it. We're meeting with the network team in charge of the NAT Proxy but we're all expecting an it's not our problem response.Can anyone give more info on how CF assigns CFID and CFTOKEN and how we might be able to code against this?Any users with experience with NMCI issues would be especially helpful.Thanks for your time. John Burns [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Session swapping
Good point Al, the computers we saw this on were ghosted as well. Maybe switching to UUID just cleaned out the old values. -Adam On Tue, 28 Sep 2004 15:27:46 -0400, Adrocknaphobia [EMAIL PROTECTED] wrote: I ran into a similar issue with one of our intranets here. If you aren't already use UUID for cftoken. We were only seeing this issue in teh training labs when a bunch of people were logged in on the same part of the network and UUID seemed to prevent the SESSION steals. -Adam - Original Message - From: Burns, John D [EMAIL PROTECTED] Date: Tue, 28 Sep 2004 13:56:25 -0400 Subject: Session swapping To: CF-Talk [EMAIL PROTECTED] We have an internet application running on CFMX hosted locally.Our clients (on a Navy base) are running machines that are restricted by NMCI (Navy-Marine Corps Intranet) and they're using a NAT Proxy Server that all of the users are behind.They just recently got moved to this new system and we noticed an odd problem with this application.Two users sitting at separate machines will pull up the website and go to the login page.Once logged in, they will suddenly both be logged in as the same person and the CFID and CFTOKEN in the URL are the same.We're trying to figure out what's causing this problem and how to fix it. We're meeting with the network team in charge of the NAT Proxy but we're all expecting an it's not our problem response.Can anyone give more info on how CF assigns CFID and CFTOKEN and how we might be able to code against this?Any users with experience with NMCI issues would be especially helpful.Thanks for your time. John Burns [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: SQL Query to XML Addendum
I'm able to write my data to am XML Template in the proper format. now I need to be able to find the corresponding node in the parent document and overwrite it without Destroying the other nodes in the document. Halp!!! sas Scott A. Stewart, Web Application Developer Engineering Consulting Services, Ltd. (ECS) 14026 Thunderbolt Place, Suite 100 Chantilly, VA 20151 Phone: (703) 471-8400 Fax: (703) 834-5527 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 28, 2004 02:10 pm To: CF-Talk Subject: SQL Query to XML Here's one where I'm not really sure where to start I have a SQL query that I need to run and append the results to a node in a pre-formatted XML template. The XML template is used by several other apps in the suite and carries information from different apps. I'll be doing updates and inserts to the section of the template that deals with my sub app. Thanks in advance for any input sas Scott A. Stewart, Web Application Developer Engineering Consulting Services, Ltd. (ECS) 14026 Thunderbolt Place, Suite 100 Chantilly, VA 20151 Phone: (703) 471-8400 Fax: (703) 834-5527 _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Hot-fixes
Does the updater include MPSB03-06, MPSB03-07, MPSB04-01, and MPSB04-02? -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Friday, September 24, 2004 7:44 PM To: CF-Talk Subject: Re: Hot-fixes Earl, George wrote: What if you are building a new server (migrating from CF 5) - do you install CFMX 6.1 and stop there, or do you also install the recently released updater, or do you install individual hot fixes based on your knowledge and what you feel is appropriate? Everything. Jochem _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: CF Application Design
On Tue, 28 Sep 2004 15:14:55 -0400, Dan O'Keefe [EMAIL PROTECTED] wrote: Sean, What would your requirement ID signify. Just a tracking number to be used throughout the process to tie together the one to one record of requirements? I just looked at Together as well as the tutorial on all of the UML diagrams. Very cool product, but $3500 for the solo license. Yikes! Dan, I can't answer the first part, but for the pricing, Borland (who owns TogetherSoft) has released a free Community Edition of the Together product. It should suit your needs: http://www.borland.com/together/designerce/index.html Regards, Dave. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Verify an email address from a query
This regex has always worked great for me. Just drop it in your own function like so and voila .. cfscript function validemail(addr){ if(REFindNocase(^[_a-z0-9-]+(\.[_a-z0-9-]+)[EMAIL PROTECTED](\.[a-z0-9-]+)*\.(([ a-z]{2,3})|(aero|coop|info|museum|name))$, addr)) {IsValid = true;} else {IsValid = false;} return IsValid; } /cfscript cfoutput cfloop query=emailLIST cfif validemail(emailaddress) cfmail ..blah, blah..send to #emailAddress#..blah, blah Sent: #emailAddress# !---display so I can see where it went--- cfelse !---display so I can see where it's screwed--- Bad Address - somebody fix this!: #emailAddress# /cfif cfloop /cfoutput --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.767 / Virus Database: 514 - Release Date: 9/21/2004 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.767 / Virus Database: 514 - Release Date: 9/21/2004 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Stupid evaluate() question
Thanks all.Worked marvelously and I felt silly for asking, but just couldn't think it thru this morning. If I could pester the list for one more (rtfm I know, but the docs I found were sparse), cfset my.loopcounter=0 cfloop list=#my.Fields# index=FieldName input type=Text name=#FieldName# value=#Evaluate(ListGetAt(my.DefaultValue,my.LoopCounter))# cfset my.loopcounter=my.loopcounter+1 /cfloop my.defaultvalue is another list whose position I'm getting via the loopcounter and value is coming from evaluate()ing the result of the listgetat() On Tue, 28 Sep 2004 10:07:00 -0700, Barney Boisvert [EMAIL PROTECTED] wrote: use form[theFormField] instead. cheers, barneyb On Tue, 28 Sep 2004 09:52:09 -0700, Matt Robertson [EMAIL PROTECTED] wrote: How would I go about getting rid of evaluate() in this loop?I'm having a brainlock.must have gotten up too early today. cfloop list=#form.FieldNames# index=TheFormField cfscript if (len(Evaluate(TheFormField))) { my.FieldValue=Evaluate(TheFormField); } /cfscript /cfloop -- --Matt Robertson-- MSB Designs, Inc. mysecretbase.com -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com I currently have 6 GMail invites for the taking [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Stupid evaluate() question
Assuming it's in the variables scope: variables[ListGetAt(my.DefaultValue,my.LoopCounter)] If you're in a CFC method (which I suspect), that won't work, because you can't explicitly reference the local variables scope. cheers, barneyb On Tue, 28 Sep 2004 12:58:48 -0700, Matt Robertson [EMAIL PROTECTED] wrote: Thanks all.Worked marvelously and I felt silly for asking, but just couldn't think it thru this morning. If I could pester the list for one more (rtfm I know, but the docs I found were sparse), cfset my.loopcounter=0 cfloop list=#my.Fields# index=FieldName input type=Text name=#FieldName# value=#Evaluate(ListGetAt(my.DefaultValue,my.LoopCounter))# cfset my.loopcounter=my.loopcounter+1 /cfloop my.defaultvalue is another list whose position I'm getting via the loopcounter and value is coming from evaluate()ing the result of the listgetat() -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com I currently have 6 GMail invites for the taking [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Turn this into 1 query?
I have 2 queries wondering if I can accomplish this in 1. Query 1: CREATE PROCEDURE [dbo].[fa_addonqueue_inout] @date2 datetime=null, @today datetime=null AS SELECT DISTINCTb.id, b.qnum, b.firstname, b.lastname, b.ssn, c.phase, c.disbursed_date FROMfaLoans a INNER JOIN abIdentity b ON a.IdentityID = b.ID INNER JOIN Import_Cap_Status c ON b.SSN = c.SSN WHERE (c.Branch = 0001) AND (c.phase=1) AND (c.Disbursed_date between @date2 and@today) order by c.disbursed_date DESC GO Query 2: SELECT ssn FROMImport_Cap_Status WHERE (Branch = 0001) AND (phase=2) AND (ssn IN (#ValueList(addonqueue.ssn)#)) Basically w/ query 2 I am taking the results of query 1 and going back through them and pulling any records that have phase 2 as well (that means the person would have 2 records a phase 1 phase 2), these are then going to be eliminated from what we display on the page.Any suggestions on combining this query? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Turn this into 1 query?
I have 2 queries wondering if I can accomplish this in 1. Query 1: CREATE PROCEDURE [dbo].[fa_addonqueue_inout] @date2 datetime=null, @today datetime=null AS SELECT DISTINCTb.id, b.qnum, b.firstname, b.lastname, b.ssn, c.phase, c.disbursed_date FROMfaLoans a INNER JOIN abIdentity b ON a.IdentityID = b.ID INNER JOIN Import_Cap_Status c ON b.SSN = c.SSN WHERE (c.Branch = 0001) AND (c.phase=1) AND (c.Disbursed_date between @date2 and@today) order by c.disbursed_date DESC GO Query 2: SELECT ssn FROMImport_Cap_Status WHERE (Branch = 0001) AND (phase=2) AND (ssn IN (#ValueList(addonqueue.ssn)#)) Basically w/ query 2 I am taking the results of query 1 and going back through them and pulling any records that have phase 2 as well (that means the person would have 2 records a phase 1 phase 2), these are then going to be eliminated from what we display on the page.Any suggestions on combining this query? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Mailing List Software
This question is a bit off CF-TALK.It's really for the site owner.What software is being used for the forums and mailing lists?Modification to the free MM forums software, Fusetalk, or ...? TIA. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
2 Queries into one?
I have 2 queries wondering if I can accomplish this in 1. Query 1: CREATE PROCEDURE [dbo].[fa_addonqueue_inout] @date2 datetime=null, @today datetime=null AS SELECT DISTINCTb.id, b.qnum, b.firstname, b.lastname, b.ssn, c.phase, c.disbursed_date FROMfaLoans a INNER JOIN abIdentity b ON a.IdentityID = b.ID INNER JOIN Import_Cap_Status c ON b.SSN = c.SSN WHERE (c.Branch = 0001) AND (c.phase=1) AND (c.Disbursed_date between @date2 and@today) order by c.disbursed_date DESC GO Query 2: SELECT ssn FROMImport_Cap_Status WHERE (Branch = 0001) AND (phase=2) AND (ssn IN (#ValueList(addonqueue.ssn)#)) Basically w/ query 2 I am taking the results of query 1 and going back through them and pulling any records that have phase 2 as well (that means the person would have 2 records a phase 1 phase 2), these are then going to be eliminated from what we display on the page.Any suggestions on combining this query? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Display multiple columns
I want to display multiple columns of output - how do I do this? In the past I borrowed code from here and there to get it working but I'd really like to get a handle on how it works this time around and learn from it rather than just being in a mad rush to get it up running. Any help greatly appreciated. TIA, -- Donna French [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]