@ Bryan- The SELECT INTO insert query will work perfectly fine *as long as you're not also 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. :-)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:338592 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
