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... alternatively
should I do it as a recordset update?
code samples and/or advice would be gratefully received... cheers all and
thanks for a lovely stable database Monty and the team
Chris
Dr Christopher Thorpe
Information Architect
GenomeBiology - biology for the post-genomic era
w http://www.genomebiology.com
t +44 (0) 20 7631 9184 (direct)
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
