On 6/25/06, Ben Doom <[EMAIL PROTECTED]> wrote: > > I know I can use > select LAST_INSERT_ID() as id; > in MySQL to get the generated ID, but I've not figured out how to avoid > throwing an error by including both an INSERT and a SELECT in the same > CFQUERY.
I think there is a datasource setting "allow multiple queries" or some such... here's a link: *http://tinyurl.com/hjbke* So, is there an equivalent to the NOCOUNT setting for MySQL? Should I > use two queries in a CFTRANSACTION? Is there some better third option > I've not thought of? In the meantime, I'll just trust that no one else > is trying to update my non-published page while I am. :-) You can also use JDBC 3 or whatever that is directly, which will return the # of records deleted if it was a delete statement, the new auto-inc number if it was an insert, etc.... I posted a link to how to do that a while ago, I'm sure google can find it. :d ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:244752 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54