>>doesn't access prefer double quotes?
(getUser.UserLogin = "paulw") AND (getUser.Password = "2324986")
It can take both.
Anyway, this is one of the task of the ODBC OR JDBC driver to translate
SQL command
into local db dialect.
For instance, Access needs #...# around dates, but you don't have t
On Jan 23, 2008 12:24 PM, Rick Root <[EMAIL PROTECTED]> wrote:
> It's another reason I hate MS Access. Retarded error messages. And
> that's an insult to retarded people everywhere.
hey i'm offended!
--
Evelyn the dog, having undergone further modification pondered the
significance of short-pe
let's take it one step at a time...
On Jan 23, 2008 12:20 PM, Nick Ross <[EMAIL PROTECTED]> wrote:
>
> SELECT Password, FirstName, userID
> FROM Users
> WHERE ("#form.accessCode#" = password)
>
>
> method="post">
>
> style="{height:24px; font-size:10px; font-weight:bold; color
Is "Users" a reserved word in Access, or is it just "user"?
-Original Message-
From: Nick Ross [mailto:[EMAIL PROTECTED]
Sent: Wednesday, January 23, 2008 2:02 PM
To: CF-Talk
Subject: Re: CF MX8: This is driving me nuts!!!
Thanks fo rthe reply. No the DB fields
I looked up 3010 online and it said:
3010
Table ** already exists.
Is "Users" a reserved word in Access?
On Jan 23, 2008 1:50 PM, Nick Ross <[EMAIL PROTECTED]> wrote:
> I tried your suggestion. Changed the DB column name and the code and this
> is the error I received:
>
> Error Executing Dat
Couldn't agree more Rick. The day I moved away from Access was a great day.
-Original Message-
From: Rick Root [mailto:[EMAIL PROTECTED]
Sent: 23 January 2008 20:24
To: CF-Talk
Subject: Re: CF MX8: This is driving me nuts!!!
On 1/23/08, Nick Ross <[EMAIL PROTECTED]> wrote:
>
> 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. We're like home inspects.. find one bug and point
> it out and we've done our job =)
I'd just like to point ou
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
On 1/23/08, Nick Ross <[EMAIL PROTECTED]> wrote:
> 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:
>
> Error Executing Database Query.
> [Macromedia][SequeLink JDBC Driver][ODBC Soc
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:
> 01.22.08 9:44 AM
>
> THANKS EVERYONE. YES, I FOUND THE SINGLE QUOTE BUT IT MADE NOT D
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] =
AND [Password] =
I suspect 'password' or 'users' may be the name of an access function that
requires parameters.
Dominic
On 23/01/
doesn't access prefer double quotes?
(getUser.UserLogin = "paulw") AND (getUser.Password = "2324986").
On Jan 23, 2008 12:11 PM, Rick Root <[EMAIL PROTECTED]> wrote:
> On 1/23/08, Nick Ross <[EMAIL PROTECTED]> wrote:
> > Syntax error (missing operator) in query expression '(getUser.UserLogin =
>
Yes this is the real problem. You're referencing the table by the wrong name
in the where clause.
On Jan 23, 2008 12:42 PM, Dominic Watson <[EMAIL PROTECTED]>
wrote:
> >
> >
> >SELECT *
> >FROM Users
> >WHERE (getUser.UserLogin = '#Form.UserLogin#')
> > AND (getUser.Password' =
Really man, thanks for the help. I decided to go real simple and change
everything to test it. Here is what I did.
SELECT Password, FirstName, userID
FROM Users
WHERE ("#form.accessCode#" = password)
--->
Once this form is executed it uses the following code to re-direct the
On Jan 23, 2008 9:36 AM, Nick Ross <[EMAIL PROTECTED]> wrote:
> 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][
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 t
I tried your suggestion. Changed the DB column name and the code and this is
the error I received:
Error Executing Database Query.
[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft
Access Driver] Too few parameters. Expected 2.
The error occurred in
C:\Inetpub\wwwroo
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
>
> THANKS EVERYONE. YES, I FOUND THE SINGLE QUOTE BUT IT MADE NOT DIFFERENCE.
> NOW I AM GETTING THIS ERROR MESSAGE:
Well it did make a difference then didn't it :p
I can't answer the question about the error but are you absolutely tied to
using access for the database? If you have the option,
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. We're like home inspects.. find one bug and point
it out and we've done our job =)
(*NEVER* fix things like leaky faucets and
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
>
>
>SELECT *
>FROM Users
>WHERE (getUser.UserLogin = '#Form.UserLogin#')
> AND (getUser.Password' = '#Form.Password#')
>
A few things:
1. The parenthesis are unneccessary
2. getUser is not a database object referred to in the query. This should be
replaced with 'Users', the t
Subject: 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
On 1/23/08, Nick Ross <[EMAIL PROTECTED]> wrote:
> Syntax error (missing operator) in query expression '(getUser.UserLogin =
> 'paulw') AND (getUser.Password' = '2324986')'.
You have an extra ' after "Password"
probably should be
AND (getUser.Password = '2324986')
> Error Executing Database
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
o:[EMAIL PROTECTED]
Sent: Wednesday, January 23, 2008 12:04 PM
To: CF-Talk
Subject: CF MX8: This is driving me nuts!!!
Syntax error (missing operator) in query expression '(getUser.UserLogin
= 'paulw') AND (getUser.Password' = '2324986')'.
Getting this er
On Jan 23, 2008 9:04 AM, Nick Ross <[EMAIL PROTECTED]> wrote:
> Syntax error (missing operator) in query expression '(getUser.UserLogin =
> 'paulw') AND (getUser.Password' = '2324986')'.
there's a single quote after getUser.Password.
--
"Scientists tell us that the fastest animal on earth, with
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.
28 matches
Mail list logo