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