> but all I get is "Syntax error in INSERT INTO statement".. Usually that means the query is using a reserved word. The reserved words seem to be different between the odbc and unicode drivers. IIRC, "password" is one example. It works under odbc, but fails under the unicode driver. I have seen that one a lot on the adobe forums.
What are the actual column names in the insert? -Le ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:348683 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
