I looked up 3010 online and it said: 3010
Table *<name>* already exists. Is "Users" a reserved word in Access? On Jan 23, 2008 1:50 PM, Nick Ross <[EMAIL PROTECTED]> wrote: > I tried your suggestion. Changed the DB column name and the code and this > is the error I received: > > Error Executing Database Query. > [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft > Access Driver] Too few parameters. Expected 2. > > The error occurred in > C:\Inetpub\wwwroot\RickRossiter\NLR\Templates\loginCheck.cfm: line 19 > Called from C:\Inetpub\wwwroot\RickRossiter\NLR\Templates\loginForm.cfm: > line 206 > Called from > C:\Inetpub\wwwroot\RickRossiter\NLR\PrivateAccess\Application.cfm: line 17 > Called from C:\Inetpub\wwwroot\RickRossiter\NLR\Templates\loginCheck.cfm: > line 19 > Called from C:\Inetpub\wwwroot\RickRossiter\NLR\Templates\loginForm.cfm: > line 206 > Called from > C:\Inetpub\wwwroot\RickRossiter\NLR\PrivateAccess\Application.cfm: line 17 > > 17 : SELECT * > 18 : FROM Users > 19 : WHERE UserLogin = '#Form.UserLogin#' AND UserPwd = > '#Form.UserPwd#' > 20 : </cfquery> > 21 : > > SQL SELECT * FROM Users WHERE UserLogin = 'paulw' AND UserPwd = > 'ppmill' > DATASOURCE RickRossiter > VENDORERRORCODE -3010 > SQLSTATE 07002 > Resources: > > >On Jan 23, 2008 9:36 AM, Nick Ross <[EMAIL PROTECTED]> wrote: > > > >i believe 'password' is a reserved word in Access. either change the > >column name (maybe userPassword?) or enclose it in square brackets: > >WHERE... [Password] = '#form.password#' > > > >oh, and cfqueryparam is your friend (or should be) :) > > > > > >-- > >"Scientists tell us that the fastest animal on earth, with a top speed > >of 120 feet per second, is a cow that has been dropped out of a > >helicopter." - Dave Barry > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297236 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
