Skip navigation
Currently Being Moderated

cfquery

Feb 17, 2012 8:31 AM

 
Replies
  • Currently Being Moderated
    Feb 17, 2012 8:32 AM   in reply to Community Help

    Please add that the use of tabs in a <cfquery> of type "hql" returns an error: "Not supported for select queries".

     
    |
    Mark as:
  • Currently Being Moderated
    Feb 17, 2012 12:19 PM   in reply to CF_User33

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

     
    |
    Mark as:
  • Currently Being Moderated
    Feb 17, 2012 12:23 PM   in reply to CF_User33

    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.

     
    |
    Mark as:
  • Currently Being Moderated
    Feb 17, 2012 3:46 PM   in reply to Dan Bracuk

    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?

     
    |
    Mark as:
  • Currently Being Moderated
    Mar 28, 2012 10:47 AM   in reply to Community Help

    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.

     
    |
    Mark as:
  • Currently Being Moderated
    Apr 13, 2012 12:39 AM   in reply to Community Help

    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_inser ted_record-16593.html

     
    |
    Mark as:

More Like This

  • Retrieving data ...

Bookmarked By (0)

Answers + Points = Status

  • 10 points awarded for Correct Answers
  • 5 points awarded for Helpful Answers
  • 10,000+ points
  • 1,001-10,000 points
  • 501-1,000 points
  • 5-500 points