I learned a few tricks in MS-SQL that made my life easier In MS-SQL, I could use SET NOCOUNT=ON; to suppress the information returned by an insert, allowing me to use SELECT @@identity as id; to return the ID created by the insert.
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. 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. :-) TIA. --Ben ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:244748 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
