• Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
    Dedicated community for Japanese speakers
  • 한국 커뮤니티
    Dedicated community for Korean speakers
Exit
0

cfquery

Explorer ,
Feb 17, 2012 Feb 17, 2012

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

Views

1.2K

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Feb 17, 2012 Feb 17, 2012

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".

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
Feb 17, 2012 Feb 17, 2012

Copy link to clipboard

Copied

What do you mean by ' the use of tabs in a <cfquery> of type "hql" '?

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
LEGEND ,
Feb 17, 2012 Feb 17, 2012

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.

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
Feb 17, 2012 Feb 17, 2012

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?

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Mar 28, 2012 Mar 28, 2012

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.

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Apr 13, 2012 Apr 13, 2012

Copy link to clipboard

Copied

LATEST

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

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Resources
Documentation