[Omaha.pm] Help with parsing HTML

Ryan Stille rps at willcomminc.com
Wed Sep 28 13:31:15 PDT 2005


> You didn't really even have transactions here, did you?  If
> it wasn't in a <CFTRANSACTION> tag?

No. I will be using cftransaction now, to get the ID of the last
inserted record (see below).  Previously I did not need to, I think the
group of statements was treated as a transaction when they were all
inside a single cfquery block.

<cftransaction>
  <cfquery>
  INSERT INTO table (id, name) VALUES (NULL, foo)
  </cfquery>

  <cfquery>
  SELECT LAST_INSERT_ID() as lastid
  </cfquery>
</cftransaction>


More information about the Omaha-pm mailing list