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 ...:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion 8 - Build next generation apps today, with easy PDF and Ajax features - download now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:294270 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
