On Tue, 2010-10-26 at 15:10 -0500, Matt Quackenbush wrote: > @ Bryan- > > The SELECT INTO insert query will work perfectly fine *as long as you're not > also trying to grab the newly inserted ID*.
I 100% got that and understand it....that is why your query doesn't work...because you are trying to grab the newly inserted ID > As I stated previously, if the > SELECT INTO clause returns more than one record, the database will throw an > exception. If the SELECT INTO would not work, then it would not exist in > the SQL specification. :-) LOL...you seem to think that because something is in the SQL spec that it will in fact have been implemented or implemented properly ;-) ....and which "SQL specification" are you referring to? T-SQL or PL-SQL or something else? Regardless...your issue seems to be the new ID stuff...so you seem to be sorted. Cheers > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338593 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
