Are there fields in the database named "userLogin" and "password"?
Don't use select *. Specify the column names that you want. Use cfqueryparam. On Jan 23, 2008 12:36 PM, Nick Ross <[EMAIL PROTECTED]> wrote: > 01.22.08 9:44 AM > > THANKS EVERYONE. YES, I FOUND THE SINGLE QUOTE BUT IT MADE NOT DIFFERENCE. > NOW I AM GETTING THIS ERROR MESSAGE: > > Error Executing Database Query. > [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft > Access Driver] Too few parameters. Expected 1. > > 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 Password = > '#Form.Password#' > 20 : </cfquery> > 21 : > > Previous message_____________________________________________________ > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:297182 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
