Depending on your DBMS, the syntax "INSERT table_name" can be valid. I know it works for MSSQL.
What if you put the table name in brackets? [table_name] ~Brad -----Original Message----- From: Dave Francis [mailto:[EMAIL PROTECTED] Sent: Wednesday, December 05, 2007 6:08 PM To: CF-Talk Subject: RE: Problem with SQL Insert I know better than to argue with you Bobby, but I really think the INTO is optional - can't find a reference for that right now - anyway it made no diff; neither did specifying db.owner.table. If I populate the table via Enterprise Mgr, the SELECT returns what it should. I'm stumped. -----Original Message----- From: Bobby Hartsfield [mailto:[EMAIL PROTECTED] Sent: Wednesday, December 05, 2007 4:19 PM To: CF-Talk Subject: RE: Problem with SQL Insert Insert INTO ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Check out the new features and enhancements in the latest product release - download the "What's New PDF" now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:294271 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
