ah but you can do that in a transaction block using @@identity?? would this do the trick? ----- Original Message ----- From: "Stephen Moretti" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, June 04, 2003 12:14 PM Subject: Re: [ cf-dev ] OT: SQL: copying text columns
> > > > Heh, nah, we covered all this a while back, and INSERT INTO was discussed > > but discarded for some reason. > > > > As we've seen already this morning, I'm a bit foggy so I can't remember > the > > reason. I'm assuming it must have been a good one but it seems that the > > Mail Archive is currently down. > > > > Was it not to do with getting the ID after inserting the record?? > (He guesses whilst flicking through the 24000+ email from the dev list) > > > > > -- > ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
