on 6/12/00 10:24 PM, DeVoil, Nick at [EMAIL PROTECTED] wrote:
> 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.
I have used this method before, using CreateUUID(). Pretty hefty for an ID
but it works.
I have also done a SELECT back on the table using the exact criteria I have
just INSERTed. Obviously this will not work in all cases.
Unfortunately the only alternative is to lock tables which is bad bad bad.
--
Rob Keniger
big bang solutions
<mailto:[EMAIL PROTECTED]>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
