XMLSearch help - xpath not working as expected
Hello, I am developing using CF9. I am fetching RSS feed from twitter but XmlSearch is unable to return array of entry elements in the xml. Please look into the following code: I can't be using CFFEED tag, since this project has to work on a CF 7 server. cfset sourceUrl = http://search.twitter.com/search.atom?lang=enq=ColdFusion+OR+%23CF+OR+CFML; / cfhttp result=feedRaw url = #sourceUrl# timeout=60 / cfset feed = XMLParse(trim(feedRaw.fileContent), false) / The above part works fine. Problem is that none of the following lines work as expected. I expect to get an array of xml elements entry. cfset items = xmlSearch(feed, //entry) / I have also tried using: 1. //feed/entry 2. /feed/entry 3. entry 4. /*/entry 5. //*/entry Nothing is helping. If you read W3C's page () you'll see various examples, all of them are failing. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327663 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: XMLSearch help - xpath not working as expected
entry is the wrong entity for an RSS feed. The entry you want is item so you'd want xmlSearch(feed,//item) hth -- s. isaac dealey :: AutLabs Creating meaningful employment for people with Autism http://www.autlabs.com ph: 817.385.0301 http://onTap.riaforge.org/blog ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327664 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: XMLSearch help - xpath not working as expected
I think this will be to do with the default namespace in the xml document. A quick google should tell you all you need to know on that, but the upshot is that you will need to use a colon (e.g. a blank namespace) before entity names, i.e.: cfset items = XmlSearch(feed, '//:entry') / HTH Dominic 2009/10/26 Sameer Gupta guptasam...@msn.com Hello, I am developing using CF9. I am fetching RSS feed from twitter but XmlSearch is unable to return array of entry elements in the xml. Please look into the following code: I can't be using CFFEED tag, since this project has to work on a CF 7 server. cfset sourceUrl = http://search.twitter.com/search.atom?lang=enq=ColdFusion+OR+%23CF+OR+CFML; / cfhttp result=feedRaw url = #sourceUrl# timeout=60 / cfset feed = XMLParse(trim(feedRaw.fileContent), false) / The above part works fine. Problem is that none of the following lines work as expected. I expect to get an array of xml elements entry. cfset items = xmlSearch(feed, //entry) / I have also tried using: 1. //feed/entry 2. /feed/entry 3. entry 4. /*/entry 5. //*/entry Nothing is helping. If you read W3C's page () you'll see various examples, all of them are failing. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327665 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Passing a variable for range to cfform text input field
Is it possible to use a variable in the range parameter in a CFinput text field? I have tried both cfinput type=Text name=test range=5,#var# required=No size=3 maxlength=3 And cfinput type=Text name=test range=5,var required=No size=3 maxlength=3 And it does not display the field in the form. Could someone please help me correct my error. Terry ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327666 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CF8 and Facebook Connect - Any guidance?
Hi, Sorry to piggy back reply on an old post - but this is exactly the guidance I'm looking for. Most sites and resources I have found concern a Facebook ap hosted on a ColdFusion server. I also want to use Facebook connect as a sort of OpenID sign in option. I don't really understand all the verifying and hashing and all that that needs to be done. Shane, did you get this app working? Yep I have seen all those, but the API documentation is different from Facebook Connect (http://developers.facebook.com/connect.php). We are building a community app where the client wants the user to be able to sign in using their Facebook account and then find other users in our system who they also have as Facebook friends. Facebook Connect has these two features built for this very purpose. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327667 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CF9/MAMP/Snow Leopard
Hello list, did anyone here manage to get CF9 running successfully on CF9 on top of MAMP? I had CF8 running with Mamp on Leopard and can't quite figure out what's happening. I did a single server install and configured CF to use the built-in apache with MAMP: Config Directory: /Applications/MAMP/conf/apache Server Binary: /Applications/MAMP/bin/apache2/bin/httpd Server Control Script: /Applications/MAMP/bin/apache2/bin/apachectl CF9 apparently stops and starts fine, but I cannot get any CFM files to run, instead I am prompted to download them. I think it's clear that the processing for CFM files is not handed back to CF properly. I'm not sure what role CF9/runtime/lib/wsconfig.jar plays but when I launch it it shows a window titled 'Web Server Configuration' which is empty - I guess that's not a good sign? :-) Any pointers? Regards, Stefan ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327668 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF9/MAMP/Snow Leopard
CF9 apparently stops and starts fine, but I cannot get any CFM files to run, instead I am prompted to download them. I think it's clear that the processing for CFM files is not handed back to CF properly. You need to run wsconfig.jar to configure Apache to talk to CF. I'm not sure what role CF9/runtime/lib/wsconfig.jar plays but when I launch it it shows a window titled 'Web Server Configuration' which is empty - I guess that's not a good sign? :-) Normally, on Windows, this would open a GUI which lets you configure your web server connection. I don't use OS X for development, so I can't say how it would work on there, but you can run it from a Terminal window using parameters to do the configuration that way. You'll need to make sure that Java is properly configured for this to work, as this will be run by you rather than by CF. On Windows, in the past, I've had to do something along these lines: /path/to/java.exe - jar /path/to/wsconfig.jar This might make the GUI work, or you might need to use parameters as mentioned above. The parameters are listed in the documentation. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327669 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF9/MAMP/Snow Leopard
I think I cracked it! I changed permissions on the wsconfig folder to 777. I then used wsconfig.jar to add the connector but still no dice - the .cfm file was still being prompted for download. But I noticed that I was trying to hit http://localhost/CFIDE/administrator/index.cfm directly so I simply tried http://localhost/CFIDE/administrator and bingo, the CF server setup wizard appeared. I completed that and now even http://localhost/CFIDE/administrator/index.cfm works fine. All sorted. Took long enough. I must have spent 4 hours on this, reinstalling multiple times... Cheers Stefan On 26 Oct 2009, at 14:36, Stefan Richter wrote: Hello list, did anyone here manage to get CF9 running successfully on CF9 on top of MAMP? I had CF8 running with Mamp on Leopard and can't quite figure out what's happening. I did a single server install and configured CF to use the built-in apache with MAMP: Config Directory: /Applications/MAMP/conf/apache Server Binary: /Applications/MAMP/bin/apache2/bin/httpd Server Control Script: /Applications/MAMP/bin/apache2/bin/apachectl CF9 apparently stops and starts fine, but I cannot get any CFM files to run, instead I am prompted to download them. I think it's clear that the processing for CFM files is not handed back to CF properly. I'm not sure what role CF9/runtime/lib/wsconfig.jar plays but when I launch it it shows a window titled 'Web Server Configuration' which is empty - I guess that's not a good sign? :-) Any pointers? Regards, Stefan ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327670 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: XMLSearch help - xpath not working as expected
Thanks for responding Isaac. I was using an Atom feed and therefore had to use entry instead of item. It worked following the other advice. Best Sam ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327671 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: XMLSearch help - xpath not working as expected
I think this will be to do with the default namespace in the xml document. A quick google should tell you all you need to know on that, but the upshot is that you will need to use a colon (e.g. a blank namespace) before entity names, i.e.: cfset items = XmlSearch(feed, '//:entry') / HTH Dominic 2009/10/26 Sameer Gupta guptasam...@msn.com Thanks. It worked with /:feed/:entry cfset items = XmlSearch(feed, /:feed/:entry) / Best Sameer ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327672 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Education
On Sat, 2009-10-24 at 15:17 -0500, s. isaac dealey wrote: In my case in particular, my skills are fairly slanted toward the technical, meaning that my people skills are rusty. LOLI think that's just a programmer trait ;-) My staff once compared me to the new toilet paper my partner bought.abrasive yet effective ;-) It's funny because it's true! Cheers - Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: br...@electricedgesystems.com web: www.electricedgesystems.com Notice: This message, including any attachments, is confidential and may contain information that is privileged or exempt from disclosure. It is intended only for the person to whom it is addressed unless expressly authorized otherwise by the sender. If you are not an authorized recipient, please notify the sender immediately and permanently destroy all copies of this message and attachments. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327673 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Working with namespaces.
Looking at the following XML fragment. S:Envelope xmlns:S=http://schemas.xmlsoap.org/soap/envelope/; S:Body VehicleInformation xmlns=urn:description6.kp.chrome.com ... a lot of nodes I am not interested in ... standards What namespace is the 'standards' node in and how would you reference it in an xpath syntax for an xmlSearch() function? I'm trying to understand namespaces betters so I am looking for a specific fully qualified reference, not just the get it work solution of using the local-name() xpath function. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327674 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF9/MAMP/Snow Leopard
Thanks Dave, as you may have seen I managed to resolve it. Your tip is right on track. What's confusing is the fact that the CF9 installer asks for the same details during install, so it seems illogical that another tool needs to be used to configure those same details yet again. Maybe it was an issue related to the permissions on that folder, who knows. But how is one to change permissions of a folder that does not exist until after the fact... Ah well, the joys of a slightly custom setup... Cheers Stefan On 26 Oct 2009, at 15:00, Dave Watts wrote: CF9 apparently stops and starts fine, but I cannot get any CFM files to run, instead I am prompted to download them. I think it's clear that the processing for CFM files is not handed back to CF properly. You need to run wsconfig.jar to configure Apache to talk to CF. I'm not sure what role CF9/runtime/lib/wsconfig.jar plays but when I launch it it shows a window titled 'Web Server Configuration' which is empty - I guess that's not a good sign? :-) Normally, on Windows, this would open a GUI which lets you configure your web server connection. I don't use OS X for development, so I can't say how it would work on there, but you can run it from a Terminal window using parameters to do the configuration that way. You'll need to make sure that Java is properly configured for this to work, as this will be run by you rather than by CF. On Windows, in the past, I've had to do something along these lines: /path/to/java.exe - jar /path/to/wsconfig.jar This might make the GUI work, or you might need to use parameters as mentioned above. The parameters are listed in the documentation. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327675 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
XML POST with Coldfusion
Okay, this should be a nut-cracker on this Blog. I need someone to develop a coldfusion script that will communicate to a server/service using XML POST. Parameters are: SMS authentification username/username password/password /authentification message sender/sender text/text /message recipients gsm messageId=âclientmsgID1â/gsm gsm messageId=âclientmsgID2â/gsm gsm messageId=âclientmsgID3â/gsm gsm messageId=âclientmsgID4â/gsm /recipients /SMS service url is:: http://www.myserver.com/AddOn/myService/XML/XMLInput.aspx ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327676 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Working with namespaces.
Looking at the following XML fragment. S:Envelope xmlns:S=http://schemas.xmlsoap.org/soap/envelope/; S:Body VehicleInformation xmlns=urn:description6.kp.chrome.com ... a lot of nodes I am not interested in ... standards What namespace is the 'standards' node in and how would you reference it in an xpath syntax for an xmlSearch() function? I'm trying to understand namespaces betters so I am looking for a specific fully qualified reference, not just the get it work solution of using the local-name() xpath function. It's in the default namespace, as defined (if it's defined at all) in the root element: xmlns=http://someNSUrl/; I'm pretty sure you'll need to use local-name to get to this, though; dealing with namespaces from CF isn't all that easy. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327677 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF9/MAMP/Snow Leopard
What's confusing is the fact that the CF9 installer asks for the same details during install, so it seems illogical that another tool needs to be used to configure those same details yet again. Maybe it was an issue related to the permissions on that folder, who knows. But how is one to change permissions of a folder that does not exist until after the fact... Ah well, the joys of a slightly custom setup... Actually, it's the same tool both times. The CF installer invokes wsconfig, and you can invoke it manually. Permissions on Unix/Linux/OS X can be problematic. In any case, what I like to do is run the initial installer without configuring any web server other than the built-in JRun web server, then run wsconfig after the fact. This lets me use both the JRun web server and an external web server, which can have some advantages. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327678 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: XMLSearch help - xpath not working as expected
Thanks for responding Isaac. I was using an Atom feed and therefore had to use entry instead of item. It worked following the other advice. Ahh, well I read RSS in your original message and had just gone and double-checked the RSS link on my own twitter profile. :) Glad you got it figured out. -- s. isaac dealey :: AutLabs Creating meaningful employment for people with Autism http://www.autlabs.com ph: 817.385.0301 http://onTap.riaforge.org/blog ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327679 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Education
On Sat, 2009-10-24 at 15:17 -0500, s. isaac dealey wrote: In my case in particular, my skills are fairly slanted toward the technical, meaning that my people skills are rusty. LOLI think that's just a programmer trait ;-) My staff once compared me to the new toilet paper my partner bought.abrasive yet effective ;-) It's funny because it's true! One of the things that tends to frustrate me about job placement ads is that they always seem to want you to be some combination of Einstein's level of technical expertise and Obama's speaking finesse. ;) Forget that Obama isn't an especially technical individual and that Einstein wasn't the most effective communicator. Much less the everpresent knowledge gap between a manager's understanding of the task at hand and the engineer's understanding of the same task, meaning that even if the manager were the world's most renowned orator, it would be impossible for him to communicate effectively about a subject matter in which he's just not well versed. /rant -- s. isaac dealey :: AutLabs Creating meaningful employment for people with Autism http://www.autlabs.com ph: 817.385.0301 http://onTap.riaforge.org/blog ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327680 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Education
Billy Cox wrote: I'm a musician as well. scary!! Rick Faircloth wrote: I think you're right, Mark. Music, especially theory, is very logical and an lot like programming...just a different medium. *raises up guitar, and keyboard and rests them on the desk by his keyboard* *officially creepy now* Allen ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327681 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Space problem with cfpdf
So the temporary pdf's are filling up the c drive. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327682 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: XML POST with Coldfusion
Okay, this should be a nut-cracker on this Blog. I need someone to develop a coldfusion script that will communicate to a server/service using XML POST. Parameters are: SMS authentification username/username password/password /authentification message sender/sender text/text /message recipients gsm messageId=âclientmsgID1â/gsm gsm messageId=âclientmsgID2â/gsm gsm messageId=âclientmsgID3â/gsm gsm messageId=âclientmsgID4â/gsm /recipients /SMS service url is:: http://www.myserver.com/AddOn/myService/XML/XMLInput. No replies yet. Okay let me step this up a little bit. $20.00 (Taxable) for anyone on cracks this one. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327683 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Education
Bryan Stevenson wrote: Speaking as a non-musician. Poppycock, you picked up my guitar when I brought it in the office and played it. Actually I think I really am onejust never had the time to keep playing ;-) I believe that that while you can phrase computer science as a science, there is much more art than science to it. There is artistry in seeing all of the parts and guiding them into the whole. It really makes sense that musicians and programmer/analysts tend to go hand in hand. Allen ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327684 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Getting last inserted record from database
I have a form of placing purchase order. Each purchase order is uniquely identified by the 'ID' column in the database table which is an Auto Increment integer field. I want to know, how can I obtain the 'ID' of an order which I just placed in the database table? Regards, Arsalan ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327685 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Getting last inserted record from database
On 27/10/2009 03:03, Arsalan Tariq Keen wrote: I have a form of placing purchase order. Each purchase order is uniquely identified by the 'ID' column in the database table which is an Auto Increment integer field. I want to know, how can I obtain the 'ID' of an order which I just placed in the database table? Regards, Arsalan ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327686 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Getting last inserted record from database
What database are you using? There a specific methods for each type. On Mon, Oct 26, 2009 at 12:06 PM, Azadi Saryev az...@sabai-dee.com wrote: On 27/10/2009 03:03, Arsalan Tariq Keen wrote: I have a form of placing purchase order. Each purchase order is uniquely identified by the 'ID' column in the database table which is an Auto Increment integer field. I want to know, how can I obtain the 'ID' of an order which I just placed in the database table? Regards, Arsalan ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327687 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Getting last inserted record from database
I am using H2. -- From: Alan Rother alan.rot...@gmail.com Sent: Tuesday, October 27, 2009 1:09 AM To: cf-talk cf-talk@houseoffusion.com Subject: Re: Getting last inserted record from database What database are you using? There a specific methods for each type. On Mon, Oct 26, 2009 at 12:06 PM, Azadi Saryev az...@sabai-dee.com wrote: On 27/10/2009 03:03, Arsalan Tariq Keen wrote: I have a form of placing purchase order. Each purchase order is uniquely identified by the 'ID' column in the database table which is an Auto Increment integer field. I want to know, how can I obtain the 'ID' of an order which I just placed in the database table? Regards, Arsalan ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327688 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: multi-database code
Ramon, I actually wrote a component set a while back to do just that: http://www.bryantwebconsulting.com/docs/datamgr/ One advantage over ColdFusion ORM is that it is written in 100% CFML, so you can open it up and see all of the code. Steve Just curious how others handle making their programs capable of being run on multiple databases. Does anyone else have experience doing something like this? ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327689 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Getting last inserted record from database
Here are the help docs for your database type. http://www.h2database.com/html/functions.html#identity http://www.h2database.com/html/functions.html#identityIn the same CFQUERY as your insert do a select and follow the syntax indicated on that help page. You also need to specify a name for your query so it can return the resulting ID. Keep in mind, in a high transaction environment, this may not always return the ID of the row you just inserted, it could return another query's ID. If you are going to have a high volume of transactions you may want to use a separate query that looks for the data you just inserted =] -- Alan Rother Adobe Certified Advanced ColdFusion MX 7 Developer Manager, Phoenix Cold Fusion User Group, AZCFUG.org ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327690 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Education
Just looking at ColdFusion alone, we've had a new major version every year for the past 4 years. Which means that if you had a 4 year college course that included CF prepared in 2006, it would be outdated by 3 major versions by this year when the students graduated. I expect a similar kind of phenomena with other languages that have been traditionally (or recently) included in Comp-Sci courses like Java or C++. Or for any of the .NET technologies that Microsoft promote. Personally I lean more in the direction of thinking that a comp-sci degree isn't very useful in software engineering, but that a cognitive science degree would help an awful lot. Again, computer science is not programming. A good CS curriculum isn't about specific technologies, it's about foundational knowledge - how computers work, algorithms, etc, etc. In my experience, not enough CF programmers understand that stuff as well as they should. I'm in that category myself - I've been reading CS books for the last decade or so, trying to catch up to that basic level of foundational knowledge. While a typical CS program will teach one or more programming languages, the languages themselves are tangential to the actual content of the course, and could easily be replaced by other languages. It doesn't really matter how current the actual language is, for that purpose. And as far as CF goes, while CF has lots of new bells and whistles every couple of years, the introductory CF course authored by Adobe changes very little, and is pretty similar to what it was when CF 3 came out. The advanced course changes quite a bit, on the other hand. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327691 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Working with namespaces.
Dave Watts wrote: I'm pretty sure you'll need to use local-name to get to this, though; dealing with namespaces from CF isn't all that easy. Is it just difficult or is it impossible? That is the point of this exercise. The teach myself how namespaces actually work. Playing with this bit of code in an xslt transformation. xsl:value-of select=local-name()/ - xsl:value-of select=namespace-uri()/ I see that the 'standards' node is part of the 'urn:description6.kp.chrome.com' namespace. Is there anyway to pass that into the ColdFusion xmlSearch() function? I was able to work with the simpler S namespace used in the root and subroot nodes. This xmlSearch() function returned the expected results. xmlSearch(xmlObj,'//S:Body') But I have not figured out any proper way to correctly reference the more complex 'urn:description6.kp.chrome.com' namespace. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327692 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Education
I'd say you're pretty accurate in your guess. I don't have it and don't want it either. For me it's as much a matter of principle as anything. I got where I am today by figuring it out on my own (as I think most CFers have) and to me that's worth WAY more than somebody who sat in a classroom and had it fed to them. No one has sat in a classroom and had it fed to them in college. That's not really what college, and CS specifically, are about. I had an interview last week and left feeling like a complete idiot because I didn't have the vocabulary they were apparently looking for. Whether or not you have a CS degree, or want one, it's important to understand the terms of art used within your trade. I don't care how good a programmer you are, if you can't communicate with other programmers using the terms of art that are mutually understood by programmers, you won't be able to do anything except work on projects by yourself. This is true in most trades that are more sophisticated than unskilled labor. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more informati ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327693 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Education
One of the things that tends to frustrate me about job placement ads is that they always seem to want you to be some combination of Einstein's level of technical expertise and Obama's speaking finesse. ;) Forget that Obama isn't an especially technical individual and that Einstein wasn't the most effective communicator. This is a bit off-topic, but Einstein was actually pretty good at communicating with people. And when it comes to programming, communication between programmers, PMs and clients is VERY IMPORTANT. I've seen more projects fail because of bad communication than anything else. Frank Lloyd Wright, the famed architect, was a bit eccentric, but he was onto something when he insisted that his students learn social skills. He saw them as essential to being a successful architect. Without those skills, it didn't matter how good you were at the act of designing structures - you wouldn't be hired in the first place, or you wouldn't be able to convey your vision to your client, or you wouldn't be able to convince your client that your design shouldn't be changed at the client's whim, etc, etc. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327694 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Education
I've seen allot of jobs require lately BA/BS and not accept experience in it's place. Experience is very difficult to quantify. Many hiring programs require some sort of easily quantifiable information as the first filter. In most places, you need the degree to get in the door, then you need experience to actually get the job. What in your estimation is the percent of coldfusion people who have these and do you have one yourself? My estimate would basically be the exact opposite of yours. That said, I don't have a degree myself. For me, I don't have any college experience and I would guess that about 5% of the coldfusion community actually have a BA/BS. Has your experience been different? Yes. The vast majority of CF developers I've met have a BA or BS, although most aren't in CS. As a CF instructor since 1997 or so, I've trained many CF developers, and most had a degree in something. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327695 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Education
In any case, there's nothing that was in my degree back in the early 1970s that's relevant to today's world. But i have been building web sites the internet first went commercial. I built my first web site using Frontpage 1 - that taught me as much about building web sites as almost anything since. In fact i have doubts about whether a degree course could possibly keep up with the changes in technology. At best a degree course would only be able to teach general principles, because the technology would have moved on by the time any graduates actually came into the work force with teh knowledge they gained at university. Computer science isn't about technology. If you got a CS degree in the 70s, almost everything you learned would still be relevant today. Basic programming hasn't actually changed that much in the last thirty years, believe it or not. We're still using the same algorithms, etc. Smalltalk, the archetypal OO language, was around in the 70s. SQL has been around even longer. Lots of details have changed, and there are lots of new languages all the time. But CS isn't about those details. http://en.wikipedia.org/wiki/The_Art_of_Computer_Programming Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more inform ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327696 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: XML POST with Coldfusion
cfsavecontent variable=myXmlString SMSauthentification username/username password/password/authentificationmessage sender/sender text/text/messagerecipients gsm messageId=âclientmsgID1â/gsm gsm messageId=âclientmsgID2â/gsm gsm messageId=âclientmsgID3â/gsm gsm messageId=âclientmsgID4â/gsm/recipients /SMS /cfsavecontent cfhttp url=http://www.myserver.com/AddOn/myService/XML/XMLInput.aspx; method=post result=servicePostBack cfhttpparam type=XML value=#myXmlString# /cfhttp -Matt ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327697 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Getting last inserted record from database
select the max id straight after the insert and wrap it all in cftransaction tags ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327698 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Getting last inserted record from database
You may also want to consider the use of sequences instead of an identity column (a la Oracle and others). I don't know if that is an option for you though. Allen Alan Rother wrote: Here are the help docs for your database type. http://www.h2database.com/html/functions.html#identity http://www.h2database.com/html/functions.html#identityIn the same CFQUERY as your insert do a select and follow the syntax indicated on that help page. You also need to specify a name for your query so it can return the resulting ID. Keep in mind, in a high transaction environment, this may not always return the ID of the row you just inserted, it could return another query's ID. If you are going to have a high volume of transactions you may want to use a separate query that looks for the data you just inserted =] ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327699 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Education
I believe that that while you can phrase computer science as a science, there is much more art than science to it. There is artistry in seeing all of the parts and guiding them into the whole. It really makes sense that musicians and programmer/analysts tend to go hand in hand. Well, no. Computer science is not programming, nor is it art. It's science. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more informatio ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327700 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Getting last inserted record from database
Be careful if you do this, oracle and some others reuse deleted IDs if you don't use sequences. Using cftransaction and querying for the data you just input would be my suggestion. Actually, if you can using a sequence would probably be best if you have access to them. --Original Message-- From: Brian McCairn To: ColdFusion Mailing List ReplyTo: ColdFusion Mailing List Subject: Re: Getting last inserted record from database Sent: Oct 26, 2009 3:09 PM select the max id straight after the insert and wrap it all in cftransaction tags ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327701 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Getting last inserted record from database
I would think you'd use a max_id scenario , where you query for the last id number using cfquery ... SELET Max (id) as max_id /cfquery Azadi Saryev az...@sabai-dee.com 10/26/2009 3:06 PM On 27/10/2009 03:03, Arsalan Tariq Keen wrote: I have a form of placing purchase order. Each purchase order is uniquely identified by the 'ID' column in the database table which is an Auto Increment integer field. I want to know, how can I obtain the 'ID' of an order which I just placed in the database table? Regards, Arsalan ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327702 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Getting last inserted record from database
Since serializable is the only isolation level that is meant to eliminate phantom reads, that means that this approach will probably only work if you set the isolation level to serializable (and, of course, that your RDBMS supports it). Which includes the performance implications that this isolation level brings. On Mon, Oct 26, 2009 at 3:09 PM, Brian McCairn brian.mcca...@medicapp.euwrote: select the max id straight after the insert and wrap it all in cftransaction tags ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327703 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: XML POST with Coldfusion
this will create a valid xml header to send along, over cfsavecontent: !---create xml--- cfxml variable=apisend SMS authentification username/username password/password /authentification message sender/sender text/text /message recipients gsm messageId=âclientmsgID1â/gsm gsm messageId=âclientmsgID2â/gsm gsm messageId=âclientmsgID3â/gsm gsm messageId=âclientmsgID4â/gsm /recipients /SMS /cfxml !---send--- cfhttp url=http://www.myserver.com/AddOn/myService/XML/XMLInput; method=POST throwOnError=Yes charset=utf-8 result=getresp cfhttpparam type=XML value=#apisend# /cfhttp !---dump the response--- cfdump var=#getresp.filecontent# Okay, this should be a nut-cracker on this Blog. I need someone to develop a coldfusion script that will communicate to a server/service using XML POST. Parameters are: SMS authentification username/username password/password /authentification message sender/sender text/text /message recipients gsm messageId=âclientmsgID1â/gsm gsm messageId=âclientmsgID2â/gsm gsm messageId=âclientmsgID3â/gsm gsm messageId=âclientmsgID4â/gsm /recipients /SMS service url is:: http://www.myserver.com/AddOn/myService/XML/XMLInput. No replies yet. Okay let me step this up a little bit. $20.00 (Taxable) for anyone on cracks this one. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327704 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Education
On Fri, Oct 23, 2009 at 4:19 PM, Mark Kruger mkru...@cfwebtools.com wrote: Rick, That is so funny I have a BA in Theology, a BA in Music and I'm just shy of a master in Sociology - and here I am working in computer development :) It's not surprising how many folks have Music as a part of their skill set who are also programmers. There's a natural synergy there I think. -Mark 1 year in Architectural Design 1 year in mechanical drafting 2 cfunited conferences 1 company coldfusion 2 or 3 day training session on-site. no degree, but I'd say a few of those courses have helped me over what I gained in High School. The rest was learning from books which worked very well. Tack on cfunited and you learn more about coldfusion than you would in any Computer Science Curriculum I've seen. I'm a DJ as well but don't see how a lot of music theory helps me, so I'm glad I didn't go that route. If the Internet was kickin it in 92' I might have gone that route starting out. A few years in call center management, where I started writing SQL got me more interested in programming, down hill ever since. Well, down hill if you call working for myself thing, out of my house... I do miss Corporate life at times. Keeping your snowboard in your office with those pow wow sessions before work were a plus at Stratton Mtn Resort, I absolutely don't miss the meetings though. My resume is great on experience but I didn't even get a call when I applied for a Skidmore College position a couple years back. That was odd but then again, I don't have a degree. Casey ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327705 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: XML POST with Coldfusion
sorry, that didnt work Sincerely, Chuka I.W. Anene Chief Software Eng./CEO Quorium Solutions www.quorium.org 07029609185,07032696113 From: Matt Williams mgw...@gmail.com To: cf-talk cf-talk@houseoffusion.com Sent: Mon, October 26, 2009 8:54:13 PM Subject: Re: XML POST with Coldfusion cfsavecontent variable=myXmlString SMSauthentification username/username password/password/authentificationmessage sender/sender text/text/messagerecipients gsm messageId=âclientmsgID1â/gsm gsm messageId=âclientmsgID2â/gsm gsm messageId=âclientmsgID3â/gsm gsm messageId=âclientmsgID4â/gsm/recipients /SMS /cfsavecontent cfhttpparam type=XML value=#myXmlString# /cfhttp -Matt ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327706 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Working with namespaces.
This may helpful: http://fusion.dominicwatson.co.uk/2008/03/xmlsearch-and-default-namespaces.html Dominic 2009/10/26 Ian Skinner h...@ilsweb.com Dave Watts wrote: I'm pretty sure you'll need to use local-name to get to this, though; dealing with namespaces from CF isn't all that easy. Is it just difficult or is it impossible? That is the point of this exercise. The teach myself how namespaces actually work. Playing with this bit of code in an xslt transformation. xsl:value-of select=local-name()/ - xsl:value-of select=namespace-uri()/ I see that the 'standards' node is part of the 'urn:description6.kp.chrome.com' namespace. Is there anyway to pass that into the ColdFusion xmlSearch() function? I was able to work with the simpler S namespace used in the root and subroot nodes. This xmlSearch() function returned the expected results. xmlSearch(xmlObj,'//S:Body') But I have not figured out any proper way to correctly reference the more complex 'urn:description6.kp.chrome.com' namespace. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327707 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: XML POST with Coldfusion
sorry, that didnt work Maybe, you should either post the error message you got (or whatever response you got) or post a public URL to the service you're trying to invoke, if possible. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327708 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: XML POST with Coldfusion
sorry, no replies from server Sincerely, Chuka I.W. Anene Chief Software Eng./CEO Quorium Solutions www.quorium.org 07029609185,07032696113 From: Jessica Kennedy police_kidnapped_your_child...@yahoo.com To: cf-talk cf-talk@houseoffusion.com Sent: Mon, October 26, 2009 10:06:59 PM Subject: Re: XML POST with Coldfusion this will create a valid xml header to send along, over cfsavecontent: !---create xml--- cfxml variable=apisend SMS authentification username/username password/password /authentification message sender/sender text/text /message recipients gsm messageId=âclientmsgID1â/gsm gsm messageId=âclientmsgID2â/gsm gsm messageId=âclientmsgID3â/gsm gsm messageId=âclientmsgID4â/gsm /recipients /SMS /cfxml !---send--- cfhttpparam type=XML value=#apisend# /cfhttp !---dump the response--- cfdump var=#getresp.filecontent# Okay, this should be a nut-cracker on this Blog. I need someone to develop a coldfusion script that will communicate to a server/service using XML POST. Parameters are: SMS authentification username/username password/password /authentification message sender/sender text/text /message recipients gsm messageId=âclientmsgID1â/gsm gsm messageId=âclientmsgID2â/gsm gsm messageId=âclientmsgID3â/gsm gsm messageId=âclientmsgID4â/gsm /recipients /SMS service url is:: http://www.myserver.com/AddOn/myService/XML/XMLInput. No replies yet. Okay let me step this up a little bit. $20.00 (Taxable) for anyone on cracks this one. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327709 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: XML POST with Coldfusion
i did not get any error message. it is an sms server. the reply is supposed to be an sms to my mobile number. Nothing came to me, so i presume the code didnt work. Sincerely, Chuka I.W. Anene Chief Software Eng./CEO Quorium Solutions www.quorium.org 07029609185,07032696113 From: Dave Watts dwa...@figleaf.com To: cf-talk cf-talk@houseoffusion.com Sent: Mon, October 26, 2009 10:38:15 PM Subject: Re: XML POST with Coldfusion sorry, that didnt work Maybe, you should either post the error message you got (or whatever response you got) or post a public URL to the service you're trying to invoke, if possible. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327710 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Feeling Noobish
Or at at least that is the way I am feeling today. Consider this piece of code,
it is contained in a CFC that a user has entered in a Search Term to look up
against the database.
cfquery name=getSearch result=DB_getSearch datasource=#DSN#
SELECT TOP #APPLICATION.MaxQueryRows# f.*
FROM field f
WHERE 0=0
AND (
f.field_logical_nm LIKE cfqueryparam cfsqltype=cf_sql_varchar
value=%#ARGUMENTS.SearchTerm#/
OR f.field_logical_nm LIKE cfqueryparam cfsqltype=cf_sql_varchar
value=%#ARGUMENTS.SearchTerm#%/
OR f.field_logical_nm LIKE cfqueryparam cfsqltype=cf_sql_varchar
value=#ARGUMENTS.SearchTerm#%/
OR f.field_physical_nm LIKE cfqueryparam cfsqltype=cf_sql_varchar
value=%#ARGUMENTS.SearchTerm#/
OR f.field_physical_nm LIKE cfqueryparam cfsqltype=cf_sql_varchar
value=%#ARGUMENTS.SearchTerm#%/
OR f.field_physical_nm LIKE cfqueryparam cfsqltype=cf_sql_varchar
value=#ARGUMENTS.SearchTerm#%/
)
AND f.field_id NOT IN (
SELECT TOP #ARGUMENTS.StartRow# f.field_ID
FROM field f
WHERE 0=0
AND (
f.field_logical_nm LIKE cfqueryparam
cfsqltype=cf_sql_varchar value=%#ARGUMENTS.SearchTerm#/
OR f.field_logical_nm LIKE cfqueryparam
cfsqltype=cf_sql_varchar value=%#ARGUMENTS.SearchTerm#%/
OR f.field_logical_nm LIKE cfqueryparam
cfsqltype=cf_sql_varchar value=#ARGUMENTS.SearchTerm#%/
OR f.field_physical_nm LIKE cfqueryparam
cfsqltype=cf_sql_varchar value=%#ARGUMENTS.SearchTerm#/
OR f.field_physical_nm LIKE cfqueryparam
cfsqltype=cf_sql_varchar value=%#ARGUMENTS.SearchTerm#%/
OR f.field_physical_nm LIKE cfqueryparam
cfsqltype=cf_sql_varchar value=#ARGUMENTS.SearchTerm#%/
)
ORDER BY f.field_logical_nm
)
ORDER BY f.field_logical_nm
/cfquery
As it stands it the user enters in the following text as the Search Term: _a_
the following results are returned:
cat
bat
bar
kat
Instead of what was really expected like this:
in_a_boat
can run_a_mile
if_a_bird flies
Ok I think you get the picture. It returns any three letter words that contain
an 'a' in the middle position instead of any phrase that contains the '_a_'
string. However this is not the behavior I would expect using cfqueryparam
with the type set to varchar, then again maybe this is a case of me just
needing to RTFM for both ColdFusion T-SQL.
But to get the expect results I had to escape any underscores in the parameter
passed from the end user form turning the code into this:
cfif isDefined('ARGUMENTS.SearchTerm')
cfset tmpSearchTerm =
ReplaceNoCase(ARGUMENTS.SearchTerm,'_','[_]','all')/
cfelseif isDefined('ARGUMENTS.FieldNameText')
cfset tmpSearchTerm =
ReplaceNoCase(ARGUMENTS.FieldNameText,'_','[_]','all')/
/cfif
cfquery name=getSearch result=DB_getSearch datasource=#DSN#
SELECT TOP #APPLICATION.MaxQueryRows# f.*
FROM field f
WHERE 0=0
AND (
f.field_logical_nm LIKE cfqueryparam cfsqltype=cf_sql_varchar
value=%#VARIABLES.tmpSearchTerm#/
OR f.field_logical_nm LIKE cfqueryparam cfsqltype=cf_sql_varchar
value=%#VARIABLES.SearchTerm#%/
OR f.field_logical_nm LIKE cfqueryparam cfsqltype=cf_sql_varchar
value=#VARIABLES.SearchTerm#%/
OR f.field_physical_nm LIKE cfqueryparam cfsqltype=cf_sql_varchar
value=%#VARIABLES.SearchTerm#/
OR f.field_physical_nm LIKE cfqueryparam cfsqltype=cf_sql_varchar
value=%#VARIABLES.SearchTerm#%/
OR f.field_physical_nm LIKE cfqueryparam cfsqltype=cf_sql_varchar
value=#VARIABLES.SearchTerm#%/
)
AND f.field_id NOT IN (
SELECT TOP #ARGUMENTS.StartRow# f.field_ID
FROM field f
WHERE 0=0
AND (
f.field_logical_nm LIKE cfqueryparam
cfsqltype=cf_sql_varchar value=%#VARIABLES.SearchTerm#/
OR f.field_logical_nm LIKE cfqueryparam
cfsqltype=cf_sql_varchar value=%#VARIABLES.SearchTerm#%/
OR f.field_logical_nm LIKE cfqueryparam
cfsqltype=cf_sql_varchar value=#VARIABLES.SearchTerm#%/
OR f.field_physical_nm LIKE cfqueryparam
cfsqltype=cf_sql_varchar value=%#VARIABLES.SearchTerm#/
OR f.field_physical_nm LIKE cfqueryparam
cfsqltype=cf_sql_varchar value=%#VARIABLES.SearchTerm#%/
OR f.field_physical_nm LIKE cfqueryparam
cfsqltype=cf_sql_varchar value=#VARIABLES.SearchTerm#%/
)
ORDER BY f.field_logical_nm
)
ORDER BY f.field_logical_nm
/cfquery
This post wasn't meant to be a tutorial, more of a 'Hey ummm this is the way I
solved this problem, but somehow it feels really really dirty like kissing my
cousin at a Sadie Hawkins dance after spiking the punch' kind of post. I would
really like to know if this is the correct way to fix the problem and is this
the way that cfqueryparam is truly suppose to work.
And for those of you wondering what this query is doing and why I would do
something this
Re: XML POST with Coldfusion
i did not get any error message. it is an sms server. the reply is supposed to be an sms to my mobile number. Nothing came to me, so i presume the code didnt work. It seems to me that there are lots of other reasons why you might not get an SMS that have nothing to do with your CF client. Perhaps you should try a simpler test that doesn't even involve CF, and see if that works. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327712 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Feeling Noobish
Hey Brett,
The only things cfqueryparam does is pretty much escape single quotes
and bind the strings as parameters, preventing injection attacks. If
you want to replace underscores with spaces you will have to do it
manually (like you did ;)).
hth
Francois Lévesque on the road
On 2009-10-26, at 18:46, Brett Davis d...@bsmuv.com wrote:
Or at at least that is the way I am feeling today. Consider this
piece of code, it is contained in a CFC that a user has entered in a
Search Term to look up against the database.
cfquery name=getSearch result=DB_getSearch datasource=#DSN#
SELECT TOP #APPLICATION.MaxQueryRows# f.*
FROM field f
WHERE 0=0
AND (
f.field_logical_nm LIKE cfqueryparam cfsqltype=cf_sql_varchar
value=%#ARGUMENTS.SearchTerm#/
OR f.field_logical_nm LIKE cfqueryparam
cfsqltype=cf_sql_varchar value=%#ARGUMENTS.SearchTerm#%/
OR f.field_logical_nm LIKE cfqueryparam
cfsqltype=cf_sql_varchar value=#ARGUMENTS.SearchTerm#%/
OR f.field_physical_nm LIKE cfqueryparam
cfsqltype=cf_sql_varchar value=%#ARGUMENTS.SearchTerm#/
OR f.field_physical_nm LIKE cfqueryparam
cfsqltype=cf_sql_varchar value=%#ARGUMENTS.SearchTerm#%/
OR f.field_physical_nm LIKE cfqueryparam
cfsqltype=cf_sql_varchar value=#ARGUMENTS.SearchTerm#%/
)
AND f.field_id NOT IN (
SELECT TOP #ARGUMENTS.StartRow# f.field_ID
FROM field f
WHERE 0=0
AND (
f.field_logical_nm LIKE cfqueryparam
cfsqltype=cf_sql_varchar value=%#ARGUMENTS.SearchTerm#/
OR f.field_logical_nm LIKE cfqueryparam
cfsqltype=cf_sql_varchar value=%#ARGUMENTS.SearchTerm#%/
OR f.field_logical_nm LIKE cfqueryparam
cfsqltype=cf_sql_varchar value=#ARGUMENTS.SearchTerm#%/
OR f.field_physical_nm LIKE cfqueryparam
cfsqltype=cf_sql_varchar value=%#ARGUMENTS.SearchTerm#/
OR f.field_physical_nm LIKE cfqueryparam
cfsqltype=cf_sql_varchar value=%#ARGUMENTS.SearchTerm#%/
OR f.field_physical_nm LIKE cfqueryparam
cfsqltype=cf_sql_varchar value=#ARGUMENTS.SearchTerm#%/
)
ORDER BY f.field_logical_nm
)
ORDER BY f.field_logical_nm
/cfquery
As it stands it the user enters in the following text as the Search
Term: _a_ the following results are returned:
cat
bat
bar
kat
Instead of what was really expected like this:
in_a_boat
can run_a_mile
if_a_bird flies
Ok I think you get the picture. It returns any three letter words
that contain an 'a' in the middle position instead of any phrase
that contains the '_a_' string. However this is not the behavior I
would expect using cfqueryparam with the type set to varchar, then
again maybe this is a case of me just needing to RTFM for both
ColdFusion T-SQL.
But to get the expect results I had to escape any underscores in the
parameter passed from the end user form turning the code into this:
cfif isDefined('ARGUMENTS.SearchTerm')
cfset tmpSearchTerm = ReplaceNoCase
(ARGUMENTS.SearchTerm,'_','[_]','all')/
cfelseif isDefined('ARGUMENTS.FieldNameText')
cfset tmpSearchTerm = ReplaceNoCase
(ARGUMENTS.FieldNameText,'_','[_]','all')/
/cfif
cfquery name=getSearch result=DB_getSearch datasource=#DSN#
SELECT TOP #APPLICATION.MaxQueryRows# f.*
FROM field f
WHERE 0=0
AND (
f.field_logical_nm LIKE cfqueryparam cfsqltype=cf_sql_varchar
value=%#VARIABLES.tmpSearchTerm#/
OR f.field_logical_nm LIKE cfqueryparam
cfsqltype=cf_sql_varchar value=%#VARIABLES.SearchTerm#%/
OR f.field_logical_nm LIKE cfqueryparam
cfsqltype=cf_sql_varchar value=#VARIABLES.SearchTerm#%/
OR f.field_physical_nm LIKE cfqueryparam
cfsqltype=cf_sql_varchar value=%#VARIABLES.SearchTerm#/
OR f.field_physical_nm LIKE cfqueryparam
cfsqltype=cf_sql_varchar value=%#VARIABLES.SearchTerm#%/
OR f.field_physical_nm LIKE cfqueryparam
cfsqltype=cf_sql_varchar value=#VARIABLES.SearchTerm#%/
)
AND f.field_id NOT IN (
SELECT TOP #ARGUMENTS.StartRow# f.field_ID
FROM field f
WHERE 0=0
AND (
f.field_logical_nm LIKE cfqueryparam
cfsqltype=cf_sql_varchar value=%#VARIABLES.SearchTerm#/
OR f.field_logical_nm LIKE cfqueryparam
cfsqltype=cf_sql_varchar value=%#VARIABLES.SearchTerm#%/
OR f.field_logical_nm LIKE cfqueryparam
cfsqltype=cf_sql_varchar value=#VARIABLES.SearchTerm#%/
OR f.field_physical_nm LIKE cfqueryparam
cfsqltype=cf_sql_varchar value=%#VARIABLES.SearchTerm#/
OR f.field_physical_nm LIKE cfqueryparam
cfsqltype=cf_sql_varchar value=%#VARIABLES.SearchTerm#%/
OR f.field_physical_nm LIKE cfqueryparam
cfsqltype=cf_sql_varchar value=#VARIABLES.SearchTerm#%/
)
ORDER BY f.field_logical_nm
)
ORDER BY f.field_logical_nm
/cfquery
This post wasn't meant to be a tutorial, more of a 'Hey ummm this is
the way I solved this problem, but somehow it feels really really
dirty like kissing my cousin at a Sadie Hawkins dance after spiking
the punch' kind of post. I would really like to know if this is the
correct way to fix the problem and is this the way that
Re: Feeling Noobish
As it stands it the user enters in the following text as the Search Term: _a_ the following results are returned: cat bat bar kat Instead of what was really expected like this: in_a_boat can run_a_mile if_a_bird flies Ok I think you get the picture. It returns any three letter words that contain an 'a' in the middle position instead of any phrase that contains the '_a_' string. However this is not the behavior I would expect using cfqueryparam with the type set to varchar, then again maybe this is a case of me just needing to RTFM for both ColdFusion T-SQL. The underscore character is a metacharacter in SQL when used within a LIKE clause - it represents any single character. A search clause WHERE field LIKE '_a_' will find any three-character value with a as the second character. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327714 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: XML POST with Coldfusion
i've done all these my brother. It works using GET METHOD, but now i want to use XML POST for it. Sincerely, Chuka I.W. Anene Chief Software Eng./CEO Quorium Solutions www.quorium.org 07029609185,07032696113 From: Dave Watts dwa...@figleaf.com To: cf-talk cf-talk@houseoffusion.com Sent: Mon, October 26, 2009 10:55:12 PM Subject: Re: XML POST with Coldfusion i did not get any error message. it is an sms server. the reply is supposed to be an sms to my mobile number. Nothing came to me, so i presume the code didnt work. It seems to me that there are lots of other reasons why you might not get an SMS that have nothing to do with your CF client. Perhaps you should try a simpler test that doesn't even involve CF, and see if that works. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327715 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: XML POST with Coldfusion
It seems to me that there are lots of other reasons why you might not get an SMS that have nothing to do with your CF client. Perhaps you should try a simpler test that doesn't even involve CF, and see if that works. i've done all these my brother. It works using GET METHOD, but now i want to use XML POST for it. So, you've confirmed that you can successfully send data via XML POST without using CF? Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327716 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: XML POST with Coldfusion
i said via HTTP GET. i havent been able to send via XML post. That is why we are having this discussion in the first place. Dont worry, the server has over 9000 clients, this means that their service works. Sincerely, Chuka I.W. Anene Chief Software Eng./CEO Quorium Solutions www.quorium.org 07029609185,07032696113 From: Dave Watts dwa...@figleaf.com To: cf-talk cf-talk@houseoffusion.com Sent: Mon, October 26, 2009 11:13:50 PM Subject: Re: XML POST with Coldfusion It seems to me that there are lots of other reasons why you might not get an SMS that have nothing to do with your CF client. Perhaps you should try a simpler test that doesn't even involve CF, and see if that works. i've done all these my brother. It works using GET METHOD, but now i want to use XML POST for it. So, you've confirmed that you can successfully send data via XML POST without using CF? Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327717 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: XML POST with Coldfusion
Does the service output anything when you use the GET method? Try dumping the http response from the code Jessica provided, ie. ... jessica's code ... cfdump var=#cfhttp.filecontent# / Dominic 2009/10/26 Anene Isioma Wealth anene.quor...@yahoo.com i've done all these my brother. It works using GET METHOD, but now i want to use XML POST for it. Sincerely, Chuka I.W. Anene Chief Software Eng./CEO Quorium Solutions www.quorium.org 07029609185,07032696113 From: Dave Watts dwa...@figleaf.com To: cf-talk cf-talk@houseoffusion.com Sent: Mon, October 26, 2009 10:55:12 PM Subject: Re: XML POST with Coldfusion i did not get any error message. it is an sms server. the reply is supposed to be an sms to my mobile number. Nothing came to me, so i presume the code didnt work. It seems to me that there are lots of other reasons why you might not get an SMS that have nothing to do with your CF client. Perhaps you should try a simpler test that doesn't even involve CF, and see if that works. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327718 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: XML POST with Coldfusion
GET and POST are both HTTP methods. XML is not a protocol. You can however send xml as string data over either HTTP GET or POST. You will need to start providing some more information if anyone is to help you efficiently / at all; e.g. how have you successfully been using the service using GET? Dominic 2009/10/26 Anene Isioma Wealth anene.quor...@yahoo.com i said via HTTP GET. i havent been able to send via XML post. That is why we are having this discussion in the first place. Dont worry, the server has over 9000 clients, this means that their service works. Sincerely, Chuka I.W. Anene Chief Software Eng./CEO Quorium Solutions www.quorium.org 07029609185,07032696113 From: Dave Watts dwa...@figleaf.com To: cf-talk cf-talk@houseoffusion.com Sent: Mon, October 26, 2009 11:13:50 PM Subject: Re: XML POST with Coldfusion It seems to me that there are lots of other reasons why you might not get an SMS that have nothing to do with your CF client. Perhaps you should try a simpler test that doesn't even involve CF, and see if that works. i've done all these my brother. It works using GET METHOD, but now i want to use XML POST for it. So, you've confirmed that you can successfully send data via XML POST without using CF? Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327719 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
cfpdfform -Prefill form fields
Hi All, I am trying to pre-fill the form fields in PDF. I can successfully fill the fields in the pdf. but when I dump the structure by using cfpdfform action=read sourceC:/abc/abc.pdf result=resultstruct, In the structure I can only see FirstName and the LastName elements. I also wanted to prefill the address in the form but I am unable to to. Can I able to prefill the form field if its not in the dump structure of pdf ? If no .. can any one help me out to solve this issue. Thanks, Ria Ragam ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327720 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: XML POST with Coldfusion
Chuka, All the SMS services I've ever used send a response code back when you try to send an SMS - a success code or an error code. If you're not gettting anything back, then I'd assume you're not sending anything - or if you are, you're not authenticating correctly on the SMS service. Dave's advice is good advice - verify that if you send an XML packet without involving CF, that it will work.That will prove that their XML service is listening, and that you are authenticating correctly. Then create your CF code to produce the same XML that you send manually. As Dave said (and I always listen to Dave Watts - he's about the most wise and experienced CF Programmer there is anywhere) there are lots of reasons why it might not work. You need to eliminate all the possible reasons one by one until you have only one left - then you know the problem you have to solve. Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month On Tue, Oct 27, 2009 at 10:18 AM, Dominic Watson watson.domi...@googlemail.com wrote: Does the service output anything when you use the GET method? Try dumping the http response from the code Jessica provided, ie. ... jessica's code ... cfdump var=#cfhttp.filecontent# / Dominic ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327721 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: XML POST with Coldfusion
Also find out how they are expecting the POST. You can send a field involving a name/value pair (like a name field in a form post) or you could have the xml be the entire body of the post. If it works via GET, then you might need to be sending the xml as the right field name. There is no way (that I am aware of) to send data in the body of a get, it is all name/value pairs in the request string. If they expect the same field name in the body of a post, you'll have to name your cfhttpparam accordingly. Judah On Mon, Oct 26, 2009 at 4:27 PM, Mike Kear afpwebwo...@gmail.com wrote: Chuka, All the SMS services I've ever used send a response code back when you try to send an SMS - a success code or an error code. If you're not gettting anything back, then I'd assume you're not sending anything - or if you are, you're not authenticating correctly on the SMS service. Dave's advice is good advice - verify that if you send an XML packet without involving CF, that it will work. That will prove that their XML service is listening, and that you are authenticating correctly. Then create your CF code to produce the same XML that you send manually. As Dave said (and I always listen to Dave Watts - he's about the most wise and experienced CF Programmer there is anywhere) there are lots of reasons why it might not work. You need to eliminate all the possible reasons one by one until you have only one left - then you know the problem you have to solve. Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month On Tue, Oct 27, 2009 at 10:18 AM, Dominic Watson watson.domi...@googlemail.com wrote: Does the service output anything when you use the GET method? Try dumping the http response from the code Jessica provided, ie. ... jessica's code ... cfdump var=#cfhttp.filecontent# / Dominic ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327722 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: XML POST with Coldfusion
i said via HTTP GET. i havent been able to send via XML post. That is why we are having this discussion in the first place. Dont worry, the server has over 9000 clients, this means that their service works. I think you missed my point. If you're not sure whether you're building your POST correctly in CF, you can test sending an HTTP POST directly using any number of HTTP test tools, or using telnet, and see what kind of response you get. That will let you determine whether (a) the service even accepts HTTP POST, (b) your XML is malformed or not what the service expects, or (c) you're having a specific issue with CF sending the data, as opposed to the format of the data itself. But in any case, you will need to learn how to help yourself. You simply aren't providing enough information for anyone else to help you. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327723 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: XML POST with Coldfusion
There is no way (that I am aware of) to send data in the body of a get, it is all name/value pairs in the request string. This is correct, there's no request body at all with GET. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327724 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfpdfform -Prefill form fields
I am trying to pre-fill the form fields in PDF. I can successfully fill the fields in the pdf. but when I dump the structure by using cfpdfform action=read sourceC:/abc/abc.pdf result=resultstruct, In the structure I can only see FirstName and the LastName elements. I also wanted to prefill the address in the form but I am unable to to. Can I able to prefill the form field if its not in the dump structure of pdf ? If no .. can any one help me out to solve this issue. If you can't see the fields when you dump the PDF form structure, you can't write to them. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327725 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: XML POST with Coldfusion
ok, let me be very explicit.
I presently have a form with the following fields for clients to submit data:
1. mobile numbers (either single or bulk. ie uploading a text file.
numbers are separated by ,)
2. Sender's Name
3. SMS message
then i send with the following cfhttp code:
cfhttpparam type=body value=This is a URL variable
/cfhttp
this works perfectly.
But i noticed that if i send to more that 100 numbers, the SMS is not
delivered. Maybe something about amount of characters the address bar can hold.
So, i was asked to submit via XML POST formatted like this:
SMS
authentification
username/username
password/password
/authentification
message
sender/sender
text/text
/message
recipients
gsm messageId=âclientmsgID1â/gsm
gsm messageId=âclientmsgID2â/gsm
gsm messageId=âclientmsgID3â/gsm
gsm messageId=âclientmsgID4â/gsm
/recipients
/SMS
Now this is the huddle i need to scale. Someone gave me a cURL code, but its in
PHP.:
?php
// Saint Tosins version of Curl for infobip
// for your own sms gateway copy, call 08035898361
$request = ; //initialize the request variable
$param[user] = $username;
$param[password] = $password;
$param[SMSText] = $message; //this is the message that we want to send
$param[GSM] = $numbers; //these are the recipients of the message
$param[sender] = $sender; //this is our sender
$param[IsFlash] = 0; //we want to send the message via global route
$param[type] = LongSMS; //message type is plain text
foreach($param as $key=$val) //traverse through each member of the param array
{
$request.= $key.=.urlencode($val); //we have to urlencode the values
$request.= ''; //append the ampersand () sign after each paramter/value pair
}
$len = strlen($request)-1;
$request = substr($request, 0, $len); //remove the final ampersand sign from
the request
$url = http://www.infobip.com/Addon/SMSService/SendSMS.aspx;;
$ch = curl_init(); //initialize curl handle
curl_setopt($ch, CURLOPT_URL, $url); //set the url
curl_setopt($ch, CURLOPT_HEADER, 0); //header param
curl_setopt($ch, CURLOPT_RETURNTRANSFER,1); //return as a variable
curl_setopt($ch, CURLOPT_POST, 1); //set POST method
curl_setopt($ch, CURLOPT_POSTFIELDS, $request); //set the POST variables
$response = curl_exec($ch); //run the whole process and return the response
curl_close($ch); //close the curl handle
?
Well all these codes have managed to mess up my head. So i called for instant
help and will not mind giving $20 to the guide that will make it work.
Happy Hunting!
Sincerely,
Chuka I.W. Anene
Chief Software Eng./CEO
Quorium Solutions
www.quorium.org
07029609185,07032696113
From: Dave Watts dwa...@figleaf.com
To: cf-talk cf-talk@houseoffusion.com
Sent: Mon, October 26, 2009 11:33:07 PM
Subject: Re: XML POST with Coldfusion
i said via HTTP GET. i havent been able to send via XML post. That is why we
are having this discussion in the first place. Dont
worry, the server has over 9000 clients, this means that their service works.
I think you missed my point. If you're not sure whether you're
building your POST correctly in CF, you can test sending an HTTP POST
directly using any number of HTTP test tools, or using telnet, and see
what kind of response you get. That will let you determine whether (a)
the service even accepts HTTP POST, (b) your XML is malformed or not
what the service expects, or (c) you're having a specific issue with
CF sending the data, as opposed to the format of the data itself.
But in any case, you will need to learn how to help yourself. You
simply aren't providing enough information for anyone else to help
you.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
Fig Leaf Software provides the highest caliber vendor-authorized
instruction at our training centers in Washington DC, Atlanta,
Chicago, Baltimore, Northern Virginia, or on-site at your location.
Visit http://training.figleaf.com/ for more information!
~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing lists
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327726
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfpdfform -Prefill form fields
Thanks alot. I will try to create a required PDF. Ria On Mon, Oct 26, 2009 at 7:35 PM, Dave Watts dwa...@figleaf.com wrote: I am trying to pre-fill the form fields in PDF. I can successfully fill the fields in the pdf. but when I dump the structure by using cfpdfform action=read sourceC:/abc/abc.pdf result=resultstruct, In the structure I can only see FirstName and the LastName elements. I also wanted to prefill the address in the form but I am unable to to. Can I able to prefill the form field if its not in the dump structure of pdf ? If no .. can any one help me out to solve this issue. If you can't see the fields when you dump the PDF form structure, you can't write to them. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327727 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: XML POST with Coldfusion
I'm reading this on my phone, so I could be wrong about this, but it
appears to me that the PHP code you posted doesn't appear to create an
XML document.
Dave Watts, CTO, Fig Leaf Software
On 2009-10-26, Anene Isioma Wealth anene.quor...@yahoo.com wrote:
ok, let me be very explicit.
I presently have a form with the following fields for clients to submit
data:
1. mobile numbers (either single or bulk. ie uploading a text file.
numbers
are separated by ,)
2. Sender's Name
3. SMS message
then i send with the following cfhttp code:
cfhttpparam type=body value=This is a URL variable
/cfhttp
this works perfectly.
But i noticed that if i send to more that 100 numbers, the SMS is not
delivered. Maybe something about amount of characters the address bar can
hold.
So, i was asked to submit via XML POST formatted like this:
SMS
authentification
username/username
password/password
/authentification
message
sender/sender
text/text
/message
recipients
gsm messageId=clientmsgID1/gsm
gsm messageId=clientmsgID2/gsm
gsm messageId=clientmsgID3/gsm
gsm messageId=clientmsgID4/gsm
/recipients
/SMS
Now this is the huddle i need to scale. Someone gave me a cURL code, but its
in PHP.:
?php
// Saint Tosins version of Curl for infobip
// for your own sms gateway copy, call 08035898361
$request = ; //initialize the request variable
$param[user] = $username;
$param[password] = $password;
$param[SMSText] = $message; //this is the message that we want to send
$param[GSM] = $numbers; //these are the recipients of the message
$param[sender] = $sender; //this is our sender
$param[IsFlash] = 0; //we want to send the message via global route
$param[type] = LongSMS; //message type is plain text
foreach($param as $key=$val) //traverse through each member of the param
array
{
$request.= $key.=.urlencode($val); //we have to urlencode the values
$request.= ''; //append the ampersand () sign after each paramter/value
pair
}
$len = strlen($request)-1;
$request = substr($request, 0, $len); //remove the final ampersand sign
from the request
$url = http://www.infobip.com/Addon/SMSService/SendSMS.aspx;;
$ch = curl_init(); //initialize curl handle
curl_setopt($ch, CURLOPT_URL, $url); //set the url
curl_setopt($ch, CURLOPT_HEADER, 0); //header param
curl_setopt($ch, CURLOPT_RETURNTRANSFER,1); //return as a variable
curl_setopt($ch, CURLOPT_POST, 1); //set POST method
curl_setopt($ch, CURLOPT_POSTFIELDS, $request); //set the POST variables
$response = curl_exec($ch); //run the whole process and return the
response
curl_close($ch); //close the curl handle
?
Well all these codes have managed to mess up my head. So i called for
instant help and will not mind giving $20 to the guide that will make it
work.
Happy Hunting!
Sincerely,
Chuka I.W. Anene
Chief Software Eng./CEO
Quorium Solutions
www.quorium.org
07029609185,07032696113
From: Dave Watts dwa...@figleaf.com
To: cf-talk cf-talk@houseoffusion.com
Sent: Mon, October 26, 2009 11:33:07 PM
Subject: Re: XML POST with Coldfusion
i said via HTTP GET. i havent been able to send via XML post. That is why
we are having this discussion in the first place. Dont
worry, the server has over 9000 clients, this means that their service
works.
I think you missed my point. If you're not sure whether you're
building your POST correctly in CF, you can test sending an HTTP POST
directly using any number of HTTP test tools, or using telnet, and see
what kind of response you get. That will let you determine whether (a)
the service even accepts HTTP POST, (b) your XML is malformed or not
what the service expects, or (c) you're having a specific issue with
CF sending the data, as opposed to the format of the data itself.
But in any case, you will need to learn how to help yourself. You
simply aren't providing enough information for anyone else to help
you.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
Fig Leaf Software provides the highest caliber vendor-authorized
instruction at our training centers in Washington DC, Atlanta,
Chicago, Baltimore, Northern Virginia, or on-site at your location.
Visit http://training.figleaf.com/ for more information!
~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing lists
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327728
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Education
One of the things that tends to frustrate me about job placement ads is that they always seem to want you to be some combination of Einstein's level of technical expertise and Obama's speaking finesse. ;) Forget that Obama isn't an especially technical individual and that Einstein wasn't the most effective communicator. This is a bit off-topic, but Einstein was actually pretty good at communicating with people. http://news.bbc.co.uk/2/hi/health/2988647.stm Highlight: He was also a notoriously confusing lecturer. Does not say to me pretty good at communicating with people, but of course, you can interpret it how you like. -- s. isaac dealey :: AutLabs Creating meaningful employment for people with Autism http://www.autlabs.com ph: 817.385.0301 http://onTap.riaforge.org/blog ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327729 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
can't access cf administrator
I have just done a fresh install of apache and cf 8. I cannot access the cf admin. I am trying this: http://localhost/cfide/administrator/ I am getting a 404 error. What am I doing wrong? ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327730 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: can't access cf administrator
Try http://localhost:8500/CFIDE/administrator/index.cfm Or http://127.0.0.1:8500/CFIDE/administrator/index.cfm On Mon, Oct 26, 2009 at 9:30 PM, Matthew Smith chedders...@gmail.comwrote: I have just done a fresh install of apache and cf 8. I cannot access the cf admin. I am trying this: http://localhost/cfide/administrator/ I am getting a 404 error. What am I doing wrong? ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327731 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: XML POST with Coldfusion
I need someone to develop a coldfusion script that will communicate to a server/service using XML POST. Sorry if it's a silly question, but can you just do post's to their server in a loop? -Ramon Ecung II, BS, ACHDS, MCP ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327732 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: XML POST with Coldfusion
Sorry, I copy pasted the wrong line (the emai didnt send from my phone)... It actually looks like that PHP code just creates a curl (http post) message to their server. Sorry if it's a silly question, but can you just do post's to their server in a loop? -Ramon Ecung II, BS, ACHDS, MCP ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327733 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Education
http://news.bbc.co.uk/2/hi/health/2988647.stm Highlight: He was also a notoriously confusing lecturer. Does not say to me pretty good at communicating with people, but of course, you can interpret it how you like. I think that you're reading way too much into a single pullquote. Perhaps his lectures simply covered notoriously confusing topics? And if ten percent of these quotes attributed to Einstein are actually his, he's almost certainly a better communicator than either of us: http://www.brainyquote.com/quotes/authors/a/albert_einstein.html Two things are infinite: the universe and human stupidity; and I'm not sure about the universe. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327734 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Invalid precision value
Getting this on a query.
Parameters:
nextthursday = {ts '2009-10-29 00:00:00'}
lastthursday = 2009-10-22 00:00:00.000
cffunction access=public name=qry_contestthisweek_get output=false
returntype=query
cfargument name=lastthursday type=string default=
cfset nextthursday = dateadd(d, 7, arguments.lastthursday)
cfquery
name=qry_contestthisweek_get
datasource=#variables.datasource#
select *
from#variables.sqlobjectprefix#contest
where 1 = 1
and addeddate between cfqueryparam
value=#createodbcdatetime(arguments.lastthursday)#
cfsqltype=CF_SQL_TIMESTAMP and cfqueryparam
value=#createodbcdatetime(nextthursday)# cfsqltype=CF_SQL_TIMESTAMP
order by score, age
/cfquery
cfreturn qry_contestthisweek_get
/cffunction
~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing lists
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327735
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Invalid precision value
wrap dateformat() around the dateadd() function.
tw
Sent from my iPhone... don't hate
On Oct 27, 2009, at 12:02 AM, Matthew Smith chedders...@gmail.com
wrote:
Getting this on a query.
Parameters:
nextthursday = {ts '2009-10-29 00:00:00'}
lastthursday = 2009-10-22 00:00:00.000
cffunction access=public name=qry_contestthisweek_get
output=false returntype=query
cfargument name=lastthursday type=string default=
cfset nextthursday = dateadd(d, 7, arguments.lastthursday)
cfquery
name=qry_contestthisweek_get
datasource=#variables.datasource#
select*
from#variables.sqlobjectprefix#contest
where1 = 1
and addeddate between cfqueryparam
value=#createodbcdatetime(arguments.lastthursday)#
cfsqltype=CF_SQL_TIMESTAMP and cfqueryparam
value=#createodbcdatetime(nextthursday)#
cfsqltype=CF_SQL_TIMESTAMP
order by score, age
/cfquery
cfreturn qry_contestthisweek_get
/cffunction
~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing lists
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327736
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Invalid precision value
wrap dateformat() around the dateadd() function. tw Sent from my iPhone... don't hate On Oct 27, 2009, at 12:02 AM, Matthew Smith chedders...@gmail.com wrote: Still the same: cffunction access=public name=qry_contestthisweek_get output=false returntype=query cfargument name=lastthursday type=string default= cfset nextthursday = dateformat(dateadd(d, 7, arguments.lastthursday)) cfquery name=qry_contestthisweek_get datasource=#variables.datasource# select * from#variables.sqlobjectprefix#contest where 1 = 1 and addeddate between cfqueryparam value=#createodbcdatetime(arguments.lastthursday)# cfsqltype=CF_SQL_TIMESTAMP and cfqueryparam value=#createodbcdatetime(nextthursday)# cfsqltype=CF_SQL_TIMESTAMP order by score, age /cfquery cfreturn qry_contestthisweek_get /cffunction ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327737 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Unit Testing Frameworks
From what I can see, the last thing posted on the CFCUnit website is dated 2006. Is CFCUnit still a going concern? What Unit-Testing Frameworks are people using in the CF community? Judith ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327738 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Unit Testing Frameworks
Yes, CFCUnit has not been update for some time. CFer's have moved to unit testing frameworks such as MXUnit ( http://www.mxunit.org/) for back end testing and have started to use cfSpec (http://github.com/adelphus/cfspec/) for behavioral front end testing. I'm sure there are others out there, but these are now mentioned more often in the community. -Pat (patweb99) On Mon, Oct 26, 2009 at 9:15 PM, Judith Dinowitz jdino...@houseoffusion.com wrote: From what I can see, the last thing posted on the CFCUnit website is dated 2006. Is CFCUnit still a going concern? What Unit-Testing Frameworks are people using in the CF community? Judith ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327739 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Unit Testing Frameworks
there is also RocketUnit: A Simple Unit Testing Framework for ColdFusion http://www.rocketboots.com/blog/index.cfm?mode=entryentry=E565633C-E081-51EF-A7F883614F752942 2009/10/27 Patrick Santora patwe...@gmail.com Yes, CFCUnit has not been update for some time. CFer's have moved to unit testing frameworks such as MXUnit ( http://www.mxunit.org/) for back end testing and have started to use cfSpec (http://github.com/adelphus/cfspec/) for behavioral front end testing. I'm sure there are others out there, but these are now mentioned more often in the community. -Pat (patweb99) On Mon, Oct 26, 2009 at 9:15 PM, Judith Dinowitz jdino...@houseoffusion.com wrote: From what I can see, the last thing posted on the CFCUnit website is dated 2006. Is CFCUnit still a going concern? What Unit-Testing Frameworks are people using in the CF community? Judith ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327740 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Unit Testing Frameworks
MXUnit pretty much superceded CFCUnit. CFCUnit is still viable, of course, but MXUnit is certainly seeing a lot more activity, and is pretty much the de facto standard for unit testing of CF apps. cheers, barneyb On Mon, Oct 26, 2009 at 9:15 PM, Judith Dinowitz jdino...@houseoffusion.com wrote: From what I can see, the last thing posted on the CFCUnit website is dated 2006. Is CFCUnit still a going concern? What Unit-Testing Frameworks are people using in the CF community? Judith ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327741 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
-Re: Education
http://news.bbc.co.uk/2/hi/health/2988647.stm Highlight: He was also a notoriously confusing lecturer. Does not say to me pretty good at communicating with people, but of course, you can interpret it how you like. I think that you're reading way too much into a single pullquote. Perhaps his lectures simply covered notoriously confusing topics? Well the quote was just a highlight. But if you want the real in-depth thought process behind this... The most respected minds in the health / psychology community regarding Autism (Simon Baron-Cohen in particular) are citing similarities between Einstein and people with Asperger Syndrome (which wasn't added to the books in the US until the mid 90's despite the fact that early research started in the mid 40's). Challenges with communication are one of the most salient features of Asperger Syndrome and other Autism Spectrum Disorders (ASD). In fact, they are a diagnostic requirement. So it's unlikely imo that they would be including Einstein in their research as an example of someone who may have had the condition unless they were finding significant examples of communication difficulty in their research. The fact that his lectures were notoriously confusing is just a convenient highlight for the BBC article on the subject. I don't think I'm reading too much into the quote, no. Here's the video of Nobel Laureatte (economics) Vernon Smith who has Asperger Syndrome. I suspect this is rather similar to what the researchers are finding in their study of Einstein. http://today.msnbc.msn.com/id/26184891/vp/7030737#7030737 -- s. isaac dealey :: AutLabs Creating meaningful employment for people with Autism http://www.autlabs.com ph: 817.385.0301 http://onTap.riaforge.org/blog ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327742 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
