It was never missing from the real code. Again, I posted pseudo code in order to save everyone from having to read 100 lines of superfluous code, but to show the basic concepts of the query in question. And, again, as stated previously, the issue is caused by a bug in CF8.0.1 in relation to SELECT INTO rather than a standard VALUES insert.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:338578 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

