Is "Users" a reserved word in Access, or is it just "user"?
-----Original Message----- From: Nick Ross [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 23, 2008 2:02 PM To: CF-Talk Subject: Re: CF MX8: This is driving me nuts!!! Thanks fo rthe reply. No the DB fields are "UserLogin" and "UserPwd". I changed the code based on another members suggestion and this is the error I received: SOOURCE CODE: cfparam name="Form.UserLogin" type="string"> <cfparam name="Form.UserPwd" type="string"> <cfquery name="getUsers" datasource="#dsn#"> SELECT * FROM [Users] WHERE [UserLogin] = <cfqueryparam cfsqltype="cf_sql_varchar" value="#Form.UserLogin#"> AND [UserPwd] = <cfqueryparam cfsqltype="cf_sql_varchar" value="#Form.UserPwd#"> </cfquery> ERROR: Error Executing Database Query. [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 4. 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 : FROM [Users] 18 : WHERE [UserLogin] = <cfqueryparam cfsqltype="cf_sql_varchar" value="#Form.UserLogin#"> 19 : AND [UserPwd] = <cfqueryparam cfsqltype="cf_sql_varchar" value="#Form.UserPwd#"> 20 : </cfquery> 21 : <!--- >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: ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:297256 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
