Ok, so now you've got me in troubleshoot mode. First, does the query run outside of CF? I just noticed the *[ODBC Microsoft Access Driver]* part; I'm not a db guy, maybe this would change the syntax, even slightly?
Second, are the DB fields both type 'varchar'? The cfqueryparam being used marks them as both, so CF is trying to bind them as such. If they are something else in the db, it may fail, though I wouldn't expect the message you're getting from that. Third, does the query work in CF but without the variables? Hard-code it for a quick test (I'd do it without the cfqueryparam even...as bare as possible, just to make sure it's working). That's all I can think of for now. If I come up with something else, I'll throw it out there. On Jan 23, 2008 1:00 PM, Nick Ross <[EMAIL PROTECTED]> wrote: > 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 : <!--- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:297202 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
