Copy link to clipboard
Copied
This question was posted in response to the following article: http://help.adobe.com/en_US/ColdFusion/9.0/CFMLRef/WSc3ff6d0ea77859461172e0811cbec22c24-7fae.html
Copy link to clipboard
Copied
Please add that the use of tabs in a <cfquery> of type "hql" returns an error: "Not supported for select queries".
Copy link to clipboard
Copied
What do you mean by ' the use of tabs in a <cfquery> of type "hql" '?
Copy link to clipboard
Copied
Either BKBK is a man of few words or something is wrong with this thread. I see him identified as the latest poster, but I don't see what he wrote.
Copy link to clipboard
Copied
Dan Bracuk wrote:
Either BKBK is a man of few words or something is wrong with this thread. I see him identified as the latest poster, but I don't see what he wrote.
Dan, is it possible we were both on the wire at the same time?
Copy link to clipboard
Copied
Contrary to the indication in the documentation above, the name attribute is not required. As far as usage goes, you'll certainly want to use it for SELECT queries since the point of those is to obtain a recordset; however, for INSERT, DELETE, and UPDATE queries that don't return recordsets, you may not want to use the name attribute.
Copy link to clipboard
Copied
Could someone please add a reference to the "genratedKey" property (without an underscore) that contains the unified identity value?
http://cookbooks.adobe.com/post_Generated_key__Get_the_ID_of_the_inserted_record-16593.html