Adam
There is no way of doing this with MySQL AFAIK,
not via ODBC anyway.
Maybe instead of an autonumber you could generate
a quasi-unique ID using some other info - timestamp,
user name, whatever.
Nick
-----Original Message-----
From: Adam Reynolds [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 06, 2000 11:42 AM
To: CF-Talk
Subject: RE: OT: MYSQL
Anybody have experience with this DB?
In particular I'm attempting to insert a new item into a table and
retrieve the item_id which is defined as an autonumber.
Is there a way of getting this information in MySQL. The other option is
to create a id table and create a next_id function, but as MySQL does not
support database transactions and I'm unfamiliar with the intracacies of
MySQL, I'm curious what people do. I had considered using the LOCK
command, but I'd prefer an atomic action, rather than locking of the table
in such a fashion.
Best Regards,
Adam Reynolds
ColdFusion Web Developer
ISMG Development, Unilever
London
( +44 20 7822 x5450
m: +44 7973 386620
* [EMAIL PROTECTED]
**********************************************************************
Information in this email is confidential and may be privileged.
It is intended for the addressee only. If you have received it in error,
please notify the sender immediately and delete it from your system.
You should not otherwise copy it, retransmit it or use or disclose its
contents to anyone.
Thank you for your co-operation.
**********************************************************************
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
