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:297183 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
