Okay, thanks a million. I tried your suggestion and got this error code:
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 : <!---
SOURCE 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>
>Pondering it further, try escaping your SQL object names, i.e. use square
>braces around the column and table names. So:
>
>SELECT *
>FROM [Users]
>WHERE [UserLogin] = <cfqueryparam cfsqltype="cf_sql_varchar"
>value="#Form.UserLogin#">
>AND [Password] = <cfqueryparam cfsqltype="cf_sql_varchar"
>value="#Form.Password#">
>
>I suspect 'password' or 'users' may be the name of an access function that
>requires parameters.
>
>Dominic
>
>
>
>
>
>
>--
>Blog it up: http://fusion.dominicwatson.co.uk
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:297188
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
