You sure it is an issue with the CF version and not the SQL version? It seems odd that CF would treat SQL differently since it just passes it through. Typically when an obviously defined CF variable shows up undefined it is b/c something in Java is returning a NULL.
Adam On Tue, Oct 26, 2010 at 4:10 PM, Matt Quackenbush <[email protected]>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*. 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:338594 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
