Re: XML POST with Coldfusion
i can i and that is what i use but i am still having hitches splitting my list of 5000 numbers into batches of 100. Sincerely, Chuka I.W. Anene Chief Software Eng./CEO Quorium Solutions www.quorium.org 07029609185,07032696113 From: Ramon Ecung succ...@ramonecung.com To: cf-talk cf-talk@houseoffusion.com Sent: Tue, October 27, 2009 3:07:46 AM Subject: 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:327743 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
well i guess to make things easy, i may just need a loop that can split a list
of 5000 numbers into batches of 100 each. so i can send via http post. The one
i am using splits and does not validate how many numbers are left, so i get a
-1 error message.
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: Tue, October 27, 2009 12:11:50 AM
Subject: 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!
Re: can't access cf administrator
What Os are you ysing? Check your webroot (usually a folder called htdocs if using apache) and see if it contains a cfide directory. You may have installed CF in another location without noticing. BTW I set up CF9 on OSX on top of MAMP yesterday, if anyone needs any pointers come and see me... it took hours to get going. In fact, I should probably blog it. Cheers Stefan On 27 Oct 2009, at 01:30, Matthew Smith wrote: 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:327745 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
SOTR London
Just wondering: anyone on this list going to Scotch on the Road in London on Thursday (I guess most of you are US based though)? I'll probably pop down. Cheers 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:327746 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Intro
Apologies for the bad etiquette, I haven't really introduced myself yet. Some of you may know me (I certainly know some of you in a 'I've seen your blog and emailed you before' kind of way) but in any case here are some vital stats: Stefan Richter, 36 years of age, resident in the UK since 1999, originally from Germany, self taught web developer dealing mainly with Flex and ActionScript. Also heavily involved with flash Media Server which I use mainly for its collaborative/real-time features. ColdFusion is my backend technology of choice and I have been using it since CF4. Surprising how little I've learnt in that time :-) My blog is at http://www.flashcomguru.com and my company is at http://www.muchosmedia.com Hi all! 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:327747 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: SOTR London
Hello Stefan - I'll be going. Looking forward to it. Will -Original Message- From: Stefan Richter [mailto:ste...@flashcomguru.com] Sent: 27 October 2009 09:05 To: cf-talk Subject: SOTR London Just wondering: anyone on this list going to Scotch on the Road in London on Thursday (I guess most of you are US based though)? I'll probably pop down. Cheers 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:327748 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: SOTR London
I'll be there, though we have work drinks the night before so I may only be there in body :| Dominic 2009/10/27 Stefan Richter ste...@flashcomguru.com Just wondering: anyone on this list going to Scotch on the Road in London on Thursday (I guess most of you are US based though)? I'll probably pop down. Cheers 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:327749 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: SOTR London
At least till the beers at lunchtime! -Original Message- From: Dominic Watson [mailto:watson.domi...@googlemail.com] Sent: 27 October 2009 10:52 To: cf-talk Subject: Re: SOTR London I'll be there, though we have work drinks the night before so I may only be there in body :| Dominic 2009/10/27 Stefan Richter ste...@flashcomguru.com Just wondering: anyone on this list going to Scotch on the Road in London on Thursday (I guess most of you are US based though)? I'll probably pop down. Cheers 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:327750 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: SOTR London
:o We have to wait until lunch for beers :-/ 2009/10/27 Will Swain w...@hothorse.com: At least till the beers at lunchtime! -Original Message- From: Dominic Watson [mailto:watson.domi...@googlemail.com] Sent: 27 October 2009 10:52 To: cf-talk Subject: Re: SOTR London I'll be there, though we have work drinks the night before so I may only be there in body :| Dominic 2009/10/27 Stefan Richter ste...@flashcomguru.com Just wondering: anyone on this list going to Scotch on the Road in London on Thursday (I guess most of you are US based though)? I'll probably pop down. Cheers 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:327751 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: -Re: Education
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. But if you read any biography of Einstein, you'll find that he had no trouble communicating with lots of people. So perhaps he's not as good a candidate for their research as they'd like; the BBC article you posted indicates that this diagnosis is far from universally accepted. 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:327752 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Invalid precision value
have you looked at the docs to see how dateFormat() is used? it's quite clear you haven't... take 5 secs and it will be VERY evident amigo tw Sent from my iPhone... don't hate On Oct 27, 2009, at 12:10 AM, Matthew Smith chedders...@gmail.com wrote: 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 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:327753 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
Problem with that is when you are dealing with timing in less than a second that can go wrong... For example assume before you start an insert the max_id = 1. Then 2 people go to make an insert at the same time... Insert A - max_id increments to 2. Insert B - max_id increments to 3 (this insert slipped in before the next step for A). Select MAX_ID for A. Returns 3. Select MAX_ID for B. Returns 3. Because of the timing ColdFusion would work as if both of them were 3. It is for reasons such as this that there are multiple ways in MS SQL to get the last record id and they all have little nuances. SCOPE_IDENTITY, @@IDENTITY, etc. Steve -Original Message- From: Timothy Laureska [mailto:tlaure...@dhmh.state.md.us] Sent: Monday, October 26, 2009 3:18 PM To: cf-talk Subject: 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:327754 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. I don't think there's any danger of phantom reads occurring in this case. Phantom reads occur when a single transaction reads the same set twice and gets different values each time due to changes between the first and second queries. http://en.wikipedia.org/wiki/Isolation_%28database_systems%29#Repeatable_reads_.28phantom_reads.29 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:327755 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
test
Testing resubscribe after vacation. Robert B. Harrison Director of Interactive Services Austin Williams 125 Kennedy Drive, Suite 100 Hauppauge NY 11788 P : 631.231.6600 Ext. 119 F : 631.434.7022 http://www.austin-williams.com/ http://www.austin-williams.com Great advertising can't be either/or. It must be . Plug in to our blog: AW Unplugged http://www.austin-williams.com/unplugged http://www.austin-williams.com/unplugged ~| 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:327756 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Intro
Hello, Stefan, and welcome! Rick -Original Message- From: Stefan Richter [mailto:ste...@flashcomguru.com] Sent: Tuesday, October 27, 2009 5:10 AM To: cf-talk Subject: Intro Apologies for the bad etiquette, I haven't really introduced myself yet. Some of you may know me (I certainly know some of you in a 'I've seen your blog and emailed you before' kind of way) but in any case here are some vital stats: Stefan Richter, 36 years of age, resident in the UK since 1999, originally from Germany, self taught web developer dealing mainly with Flex and ActionScript. Also heavily involved with flash Media Server which I use mainly for its collaborative/real-time features. ColdFusion is my backend technology of choice and I have been using it since CF4. Surprising how little I've learnt in that time :-) My blog is at http://www.flashcomguru.com and my company is at http://www.muchosmedia.com Hi all! 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:327757 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
-Original Message- From: s. isaac dealey [mailto:i...@turnkey.to] Sent: Tuesday, October 27, 2009 1:30 AM To: cf-talk Subject: -Re: Education Totally off topic but... Is Simon Baron-Cohen related to Sasha Baron-Cohen (AKA Borat)? It would be a very interesting dichotomy if they were.. 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:327758 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Invalid precision value
Getting this on a query. Define Getting. Where are these values displayed? ~| 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:327759 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Invalid precision value
wrap dateformat() around the dateadd() function. NO. createOdbcDate expects a date value as a parameter. One should never submit a formated date to this function, the date will be de-formated anyway, with the risk that the format is not compatible (ie: european date format). ~| 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:327760 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Invalid precision value
Right, my understanding is that cfqueryparam will take care of making sure the db gets the date as it expects it. If I'm not wrong, you should just ditch the CreateObdcDateTime call. Dominic 2009/10/27 Claude Schneegans schneeg...@internetique.com wrap dateformat() around the dateadd() function. NO. createOdbcDate expects a date value as a parameter. One should never submit a formated date to this function, the date will be de-formated anyway, with the risk that the format is not compatible (ie: european date format). ~| 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:327761 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
However without a serializable transaction (assuming read committed is therefore the isolation level used), another query could insert a new row and commit before the commit in this transaction; this would result in an incorrect ID. mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ 2009/10/27 Dave Watts: 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. I don't think there's any danger of phantom reads occurring in this case. Phantom reads occur when a single transaction reads the same set twice and gets different values each time due to changes between the first and second queries. http://en.wikipedia.org/wiki/Isolation_%28database_systems%29#Repeatable_reads_.28phantom_reads.29 ~| 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:327762 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
Exactly. On Tue, Oct 27, 2009 at 10:32 AM, James Holmes james.hol...@gmail.comwrote: However without a serializable transaction (assuming read committed is therefore the isolation level used), another query could insert a new row and commit before the commit in this transaction; this would result in an incorrect ID. mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ 2009/10/27 Dave Watts: 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. I don't think there's any danger of phantom reads occurring in this case. Phantom reads occur when a single transaction reads the same set twice and gets different values each time due to changes between the first and second queries. http://en.wikipedia.org/wiki/Isolation_%28database_systems%29#Repeatable_reads_.28phantom_reads.29 ~| 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:327763 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: bind to a cfselect problem
Hi Will, You might want to check the following website for a possible solution. Put the function provided into an application.cfc file to cancel the onRequest() which may be causing the problem. http://www.scratty.com/coldfusion-8-cfselect-bind-ajax/ ~| 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:327764 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
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? As others have said, MXUnit now rules the roost. It has an active team, an active mailing list (on Google Groups - where most frameworks live these days) and it's very sophisticated and feature-rich. cfSpec is a great BDD framework (as opposed to TDD). There are a few mocking frameworks out there too but MXUnit and cfSpec are both including mocking so there's not much interest in separate frameworks. ColdBox users have built-in support for testing for MXUnit and mocking within the CB framework itself. -- Sean A Corfield -- (904) 302-SEAN Railo Technologies US -- http://getrailo.com/ An Architect's View -- http://corfield.org/ If you're not annoying somebody, you're not really alive. -- Margaret Atwood ~| 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:327765 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
SQL Join help needed
I think I should be doing an outer join. I have a set of data (passport_registration) and I want to add a field from passport_attendance. passport_registration is a total set because it's the people that registered for the event. passport_attendance is a subset of those that attended the event. I want passport_registration to have the passport_attendance field passport_attendance_id. Here's my latest attempt: CFQUERY NAME=passport_registration2 DATASOURCE=dpch SELECT a.passport_listing_id, a.passport_registration_id, a.email_sent_attendance,a.s_uid, a.student_id, a.people_id,d.passport_attendance_id FROM passport_registration a,passport_attendance d WHERE a.s_uid (+) = d.s_uid AND d.passport_listing_id = #url.passport_listing_id# ORDER BY s_uid ASC /CFQUERY It's actually much more complicated, but this is the simplified query. Just for grins, here's the whole query that I started with and am trying to add the passport_attendance_id to (this works fine until I try to add passport_attendance_id: CFQUERY NAME=passport_registration DATASOURCE=dpch SELECT a.passport_listing_id,a.passport_registration_id,a.email_sent_attendance,a.s_uid,a.student_id,a.people_id, CASE WHEN a.student_id is not null THEN b.fname ELSE c.fname END fname, CASE WHEN a.student_id is not null THEN b.lname ELSE c.lname END lname, CASE WHEN a.student_id is not null THEN b.email ELSE c.email END email FROM passport_registration a, students b, people c WHERE a.student_id = b.student_id (+) AND a.people_id = c.id (+) AND a.passport_listing_id = #url.passport_listing_id# /CFQUERY thanks for any assistance. daniel ~| 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:327766 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: SQL Join help needed
This code isn't using inner/outer join notation, but the old style. Is there a reason for this? I would change the code to this: CFQUERY NAME=passport_registration DATASOURCE=dpch SELECT a.passport_listing_id ,a.passport_registration_id ,a.email_sent_attendance ,a.s_uid ,a.student_id ,a.people_id ,coalesce(b.fname, c.fname) fname ,coalesce(b.lname, c.lname) lname ,coalesce(b.email, c.email) email FROM passport_registration a Left outer join students b On a.student_id = b.student_id Left outer join people c On a.people_id = c.id WHERE a.passport_listing_id = #url.passport_listing_id# /CFQUERY Steve ~| 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:327767 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: SQL Join help needed
I meant to say - this is Oracle. thanks! ~| 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:327768 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Generating Documentation CF9
I have quite a few new cfc's that I have written in cf9's new script style. Prior to publishing code, I used to generate documentation with cfdocs revamped. Since this application is no longer supported I am on the hunt for a new Javadocs style generator that will create my api documentation based on the cfc's and interfaces I provide it. Anyone know if there is a tool out there yet that can parse the new script style cfc's? ~| 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:327769 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: SQL Join help needed
If it's a version newer than oracle 8 I believe it can use either notation but the newer form is suggested. I don't remember which version they added this notation. I believe it falls under the SQL92 standards. Steve -Original Message- From: daniel kessler [mailto:dani...@umd.edu] Sent: Tuesday, October 27, 2009 1:54 PM To: cf-talk Subject: Re: SQL Join help needed I meant to say - this is Oracle. thanks! ~| 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:327770 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: SQL Join help needed
This code isn't using inner/outer join notation, but the old style. Is there a reason for this? It's the way that I learned to do it. I've read your notation; it's certainly more explicit. Further though, the assistance that I needed was adding the field 'passport_attendance_id' from the 'passport_attendance' table. I don't see that in there and I am having difficulties adding it. any help on that, please? Here is the structure of passport_attendance: passport_attendance_id NUMBER Primary Key, date_added date, person_scanning VARCHAR2(100), passport_listing_id NUMBER REFERENCES passport_listing(passport_listing_id), student_id NUMBER REFERENCES students(student_id), people_id NUMBER REFERENCES people(id), s_uid VARCHAR2(50), approved VARCHAR2(20) thanks! ~| 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:327771 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: SQL Join help needed
Sorry about that... Try this... CFQUERY NAME=passport_registration DATASOURCE=dpch SELECT a.passport_listing_id ,a.passport_registration_id ,a.email_sent_attendance ,a.s_uid ,a.student_id ,a.people_id ,coalesce(b.fname, c.fname) fname ,coalesce(b.lname, c.lname) lname ,coalesce(b.email, c.email) email ,passport_attendance_id -- Will return null if there isn't a value. FROM passport_registration a Left outer join students b On a.student_id = b.student_id Left outer join people c On a.people_id = c.id Left outer join passport_attendance d On a.student_id = d.student_id WHERE a.passport_listing_id = #url.passport_listing_id# /CFQUERY -Original Message- From: daniel kessler [mailto:dani...@umd.edu] Sent: Tuesday, October 27, 2009 2:51 PM To: cf-talk Subject: Re: SQL Join help needed This code isn't using inner/outer join notation, but the old style. Is there a reason for this? It's the way that I learned to do it. I've read your notation; it's certainly more explicit. Further though, the assistance that I needed was adding the field 'passport_attendance_id' from the 'passport_attendance' table. I don't see that in there and I am having difficulties adding it. any help on that, please? Here is the structure of passport_attendance: passport_attendance_id NUMBER Primary Key, date_added date, person_scanning VARCHAR2(100), passport_listing_id NUMBER REFERENCES passport_listing(passport_listing_id), student_id NUMBER REFERENCES students(student_id), people_id NUMBER REFERENCES people(id), s_uid VARCHAR2(50), approved VARCHAR2(20) thanks! ~| 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:327772 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: SQL Join help needed
OPPS... Change the on a.student_id = d.student_id to on a.passport_listing_id = d.passport_listing_id Steve -Original Message- From: DURETTE, STEVEN J (ATTASIAIT) Sent: Tuesday, October 27, 2009 3:11 PM To: cf-talk Subject: RE: SQL Join help needed Sorry about that... Try this... CFQUERY NAME=passport_registration DATASOURCE=dpch SELECT a.passport_listing_id ,a.passport_registration_id ,a.email_sent_attendance ,a.s_uid ,a.student_id ,a.people_id ,coalesce(b.fname, c.fname) fname ,coalesce(b.lname, c.lname) lname ,coalesce(b.email, c.email) email ,passport_attendance_id -- Will return null if there isn't a value. FROM passport_registration a Left outer join students b On a.student_id = b.student_id Left outer join people c On a.people_id = c.id Left outer join passport_attendance d On a.student_id = d.student_id WHERE a.passport_listing_id = #url.passport_listing_id# /CFQUERY -Original Message- From: daniel kessler [mailto:dani...@umd.edu] Sent: Tuesday, October 27, 2009 2:51 PM To: cf-talk Subject: Re: SQL Join help needed This code isn't using inner/outer join notation, but the old style. Is there a reason for this? It's the way that I learned to do it. I've read your notation; it's certainly more explicit. Further though, the assistance that I needed was adding the field 'passport_attendance_id' from the 'passport_attendance' table. I don't see that in there and I am having difficulties adding it. any help on that, please? Here is the structure of passport_attendance: passport_attendance_id NUMBER Primary Key, date_added date, person_scanning VARCHAR2(100), passport_listing_id NUMBER REFERENCES passport_listing(passport_listing_id), student_id NUMBER REFERENCES students(student_id), people_id NUMBER REFERENCES people(id), s_uid VARCHAR2(50), approved VARCHAR2(20) thanks! ~| 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:327773 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
ColdFusion cfftp and a secure (SFTP) server.
Can ColdFusion communicate with a SFTP server with it's cfftp... tag? If so is there any settings or configurations I should be aware of, before I start trying to do so? ~| 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:327774 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Generating Documentation CF9
Javadocs after the first patch? http://www.danvega.org/blog/index.cfm/2009/8/24/ColdFusion-9-setting-attributes-in-cfscript-using-javadoc-syntax ~| 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:327775 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Generating Documentation CF9
Try ColdDoc, it works with CF9, although you will have to grab the SVN version (I've been really slack about releasing a new version). If works off MetaData, so it doesn't matter *how* you write your CFCs. http://colddoc.riaforge.org/ Mark On Wed, Oct 28, 2009 at 8:23 AM, Tony Bentley t...@tonybentley.com wrote: Javadocs after the first patch? http://www.danvega.org/blog/index.cfm/2009/8/24/ColdFusion-9-setting-attributes-in-cfscript-using-javadoc-syntax ~| 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:327776 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Generating Documentation CF9
Wicked awesome, thanks Mark. ~| 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:32 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Generating Documentation CF9
Looks like I may have spoken a bit too soon Mark. I am not sure if this issue is related to my directorystructure or if I set something wrong in the run.cfm. Does your tool recursively look at the directories underneath the base directory? Right now my directorystructure looks like this: com model vo cfc1.cfc cfc2.cfc cfc3.cfc dao cfc1.cfc cfc2.cfc cfc3.cfc etc ~| 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:327778 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 couldnn't agree more. Sure a CS undergrad or Masters won't make you proficient in any language but it should give a good grounding in basic constructs and generalized best practices that would be applicable in many programming languages. I do think this is one area where many cf developers could use a little extra experience. I have learned a great deal from my masters program. It has focused on good basics in systems analysis and design etc and I still have a year left to go. I am also looking forward to the database design and network design courses. But I'm getting frustrated when I try and come back to other cf programmers at work (I have been doing cf for 10 years now myself). They have no idea what I mean when I try and discuss functional decomposition or object cohesion and coupling, or the differences between relational databases and object oriented ones for example. I know its expensive and time consuming but I still feel a good number of developers would do better if they could step back from the language and get a handle on some sound good programming concepts. Elizabeth Alger HITSS contract -Original Message- From: Dave Watts [mailto:dwa...@figleaf.com] Sent: Monday, October 26, 2009 5:09 PM To: cf-talk Subject: 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:327779 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Child Threads
Quick question: does the CF Enterprise edition allow child threads? Also is there a limit of threads with that edition? Cheers 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:327780 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Child Threads
No limit to threads on Enterprise Edition, but no CF edition allows child threads. Total buzzkill. Fortunately, with native threads can be leveraged with Groovy or JavaLoader's CFC-based dynamic proxies. Neither one is particularly elegant, but at least you can do it, since CF itself doesn't provide the tooling. cheers, barneyb On Tue, Oct 27, 2009 at 3:43 PM, Stefan Richter ste...@flashcomguru.com wrote: Quick question: does the CF Enterprise edition allow child threads? Also is there a limit of threads with that edition? Cheers 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:327781 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Generating Documentation CF9
Yep it does. Should be fine. I use ColdDoc to generate the documentation for Transfer: http://docs.transfer-orm.com/html/transferapi/ And I am also using it when developing Narwhal (ColdSpring 2.0) And I've used it on a CF9 project. Mark On Wed, Oct 28, 2009 at 9:12 AM, Jeremy Rottman rottm...@gmail.com wrote: Looks like I may have spoken a bit too soon Mark. I am not sure if this issue is related to my directorystructure or if I set something wrong in the run.cfm. Does your tool recursively look at the directories underneath the base directory? Right now my directorystructure looks like this: com model vo cfc1.cfc cfc2.cfc cfc3.cfc dao cfc1.cfc cfc2.cfc cfc3.cfc etc ~| 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:327782 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
