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 a
Looks to me like you have an extra quote/apostrophe here (after
getUser.Password):
cfquery name=getUser datasource=#dsn#
SELECT *
FROM Users
WHERE (getUser.UserLogin = '#Form.UserLogin#')
AND (getUser.Password' = '#Form.Password#') /cfquery
-Original Message-
From:
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
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 Query.
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
cfquery name=getUser datasource=#dsn#
SELECT *
FROM Users
WHERE (getUser.UserLogin = '#Form.UserLogin#')
AND (getUser.Password' = '#Form.Password#')
/cfquery
A few things:
1. The parenthesis are unneccessary
2. getUser is not a database object referred to in the query. This
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
cfparam name=Form.UserPwd type=string
cfquery name=getUsers datasource=#dsn#
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 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, I
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
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
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
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][ODBC
Really man, thanks for the help. I decided to go real simple and change
everything to test it. Here is what I did.
cfquery name=getUser datasource=#dsn#
SELECT Password, FirstName, userID
FROM Users
WHERE (#form.accessCode# = password)
/cfquery
cfform name=siteAccess
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:
cfquery name=getUser datasource=#dsn#
SELECT *
FROM Users
WHERE (getUser.UserLogin = '#Form.UserLogin#')
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 =
'paulw')
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
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
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
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.
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 out that I
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:
Thanks fo
I looked up 3010 online and it said:
3010
Table *name* 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
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 are UserLogin and UserPwd. I
let's take it one step at a time...
On Jan 23, 2008 12:20 PM, Nick Ross [EMAIL PROTECTED] wrote:
cfquery name=getUser datasource=#dsn#
SELECT Password, FirstName, userID
FROM Users
WHERE (#form.accessCode# = password)
/cfquery
cfform name=siteAccess
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
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 to
27 matches
Mail list logo