----- Original Message -----
From: "Homer Simpson" <[EMAIL PROTECTED]>
Newsgroups: cf-talk
Sent: Friday, September 29, 2000 1:38 PM
Subject: RE: AutoNumbers and INSERTS
> You could try adding the data with a <CFQUERY ....>INSER.... and then
> immediately after do a
>
> <CFQUERY....>
> SELECT ID
> FROM My_Table
> WHERE blah = whatwasjustadded
> AND blah2 = whatwasalsoadded
> </CFQUERY>
>
> including as much info as possible so that you only get one record
returned
> and then output the ID as you would normally
Yeah, that's what I thought - it just seemed a bit messy doing it that way
:o)
Cheers
Will
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
