One more thing... I'm going to assume, since the error references the Microsoft Jet Engine, that this an Access DB.. You can enclose user in square brackets ie: [user], and that will get you around any reserved work issue.
You really want to use cfqueryparams with this.Especially with the rash of SQL Injection attacks that have happened recently. kevin pieto wrote: > We moved our site over to a new hosting company (godaddy) and are now > receiving an error on admin login. It worked fine with the previous host be > now has an error with godaddy. Any suggestions? > > error shown here > > http://www.frontierstravel.com/pic10.jpg > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311185 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
