Re: ADO/ODBC question

2001-07-30 Thread Bob Hall
On Mon, Jul 30, 2001 at 12:18:02PM +0100, Christopher Thorpe wrote: > Hi all quick question > > if I use a query such as the one below > > INSERT INTO usq (usq_id,usq_querystring) VALUES(NULL,'test'); > SELECT LAST_INSERT_ID(); > > how do I push this two part query through an ADO command object

ADO/ODBC question

2001-07-30 Thread Christopher Thorpe
Hi all quick question if I use a query such as the one below INSERT INTO usq (usq_id,usq_querystring) VALUES(NULL,'test'); SELECT LAST_INSERT_ID(); how do I push this two part query through an ADO command object and how do I get the variable back from the select part of the query... alternative