[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