There is a way to get multiple queries to run within one cfquery if you are using the jdbc drivers. There is a setting that you put in the connection string for your ds in cfadmin - check out Pete Freitags blog:
http://www.petefreitag.com/item/357.cfm HTH Dave Barney Boisvert wrote: > Isaac is correct, MySQL does not allow multiple statements in a single > query like SQL Server does. > > cheers, > barneyb > > On 8/1/05, Les Mizzell <[EMAIL PROTECTED]> wrote: > >>Taco Fleur (@DataBroker) wrote: >> >>>Why not put both statements in one cfquery tag? >>> >>><cfquery name="whatever" ...> >>> INSERT INTO .... >>> SELECT LAST_INSERT_ID() AS `id` >>></cfquery> >> >> >>I was trying to avoid two queries. But, the above, which is what I was >>tyring to accomplish, isn't working, or at least there's a syntax issue. >> >>So, it looks like two queries... >> >> >>-- >>----------- >>Les Mizzell > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:213583 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
