Syntax error (missing operator) in query expression

Syntax error (missing operator) in query expression '(getUser.UserLogin = 'paulw') AND (getUser.Password' = '2324986')'. Getting this error message on a simple login application. App starts in the application.cfm as soon as the user enters the section of site that requires login. !---If user

CF MX8: This is driving me nuts!!!

Syntax error (missing operator) in query expression '(getUser.UserLogin = 'paulw') AND (getUser.Password' = '2324986')'. Getting this error message on a simple login application. App starts in the application.cfm as soon as the user enters the section of site that requires login. !---If user

Re: CF MX8: This is driving me nuts!!!

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

Too Few Parameters, expected 1

ENTERED AN EARLIER POST ON THIS SAME QUERY PROBLEM. ORIGINALLY IT WAS A SYNTAX PROBLEM. HOWEVER, NOW I AM GETTING THE FOLLOWING ERROR. THIS IS A SIMPLE LOGIN APPLICATION. Error Executing Database Query. [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver]

Re: CF MX8: This is driving me nuts!!!

*. 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

Re: CF MX8: This is driving me nuts!!!

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

Re: CF MX8: This is driving me nuts!!!

: /cfquery 21 : SQLSELECT * FROM Users WHERE UserLogin = 'paulw' AND UserPwd = 'ppmill' DATASOURCERickRossiter VENDORERRORCODE -3010 SQLSTATE 07002 Resources: On Jan 23, 2008 9:36 AM, Nick Ross [EMAIL PROTECTED] wrote: i believe 'password' is a reserved word

ODBC Error CFQuery

ENTERED AN EARLIER POST ON THIS SAME QUERY PROBLEM. ORIGINALLY IT WAS A SYNTAX PROBLEM. HOWEVER, NOW I AM GETTING THE FOLLOWING ERROR. THIS IS A SIMPLE LOGIN APPLICATION. Error Executing Database Query. [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver]

Re: CF MX8: This is driving me nuts!!!

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

Re: Too Few Parameters, expected 1

Yes I did and thank you very much. However, it did not work. See my latest post. I decided to try something real simple and got a different error message: Element ACCESSCODE is undefined in FORM. The error occurred in C:\Inetpub\wwwroot\RickRossiter\NLR\Templates\loginForm.cfm: line 215 213

Re: CF MX8: This is driving me nuts!!!

Hey not a problem. Thanks for the help. I still have not solved the problem. Like I said, it is driving me crazy. Nick On 1/23/08, Brian Kotek [EMAIL PROTECTED] wrote: Yes this is the real problem. You're referencing the table by the wrong name in the where clause. good catch Brian.