[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [Omaha.pm] Help with parsing HTML

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