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

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!!!

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:

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!!!

rm.UserPwd#' 20 : 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]> wro

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 C:\Inetpub\wwwroot\RickRossiter\NLR\Template

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"> SELECT * FROM [Users] WHERE [UserLogin] = AND [UserP

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] To

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 error

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.

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.