On Fri, May 23, 2008 at 1:14 PM, Patrick Hedgepath [EMAIL PROTECTED] wrote:
Can anybody see the syntax error that CF8 keeps giving me for this query? The
query was made by DW CS3 and worked until I added a new field by hand
(Location). I can't see any reason it would not work.
,
I actually want that field to be a 0 if no data was entered on the form.
-Original Message-
From: Charlie Griefer [mailto:[EMAIL PROTECTED]
Sent: Friday, May 23, 2008 4:22 PM
To: CF-Talk
Subject: Re: Syntax Error In Update Statement
On Fri, May 23, 2008 at 1:14 PM, Patrick Hedgepath
What error does CF give?
On Fri, May 23, 2008 at 3:14 PM, Patrick Hedgepath [EMAIL PROTECTED] wrote:
Can anybody see the syntax error that CF8 keeps giving me for this query? The
query was made by DW CS3 and worked until I added a new field by hand
(Location). I can't see any reason it would
) , Phone= (param 11) , Fax= '' WHERE ID=
(param 12)
VENDORERRORCODE 3092
-Original Message-
From: Greg Morphis [mailto:[EMAIL PROTECTED]
Sent: Friday, May 23, 2008 4:25 PM
To: CF-Talk
Subject: Re: Syntax Error In Update Statement
What error does CF give?
On Fri, May 23, 2008
:22 PM
To: CF-Talk
Subject: Re: Syntax Error In Update Statement
On Fri, May 23, 2008 at 1:14 PM, Patrick Hedgepath
[EMAIL PROTECTED] wrote:
Can anybody see the syntax error that CF8 keeps giving me for this
query? The query was made by DW CS3 and worked until I added a new field
by hand
[mailto:[EMAIL PROTECTED]
Sent: Friday, May 23, 2008 4:22 PM
To: CF-Talk
Subject: Re: Syntax Error In Update Statement
On Fri, May 23, 2008 at 1:14 PM, Patrick Hedgepath
[EMAIL PROTECTED] wrote:
Can anybody see the syntax error that CF8 keeps giving me for this
query? The query was made
PROTECTED]
Sent: Friday, May 23, 2008 4:30 PM
To: CF-Talk
Subject: Re: Syntax Error In Update Statement
On Fri, May 23, 2008 at 1:25 PM, [EMAIL PROTECTED] wrote:
I actually want that field to be a 0 if no data was entered on the
form.
then the 0 value should be surrounded by single quotes
) , Phone= (param 11) , Fax= '' WHERE ID=
(param 12)
VENDORERRORCODE 3092
-Original Message-
From: Greg Morphis [mailto:[EMAIL PROTECTED]
Sent: Friday, May 23, 2008 4:25 PM
To: CF-Talk
Subject: Re: Syntax Error In Update Statement
What error does CF give?
On Fri, May 23, 2008
: Friday, May 23, 2008 4:30 PM
To: CF-Talk
Subject: Re: Syntax Error In Update Statement
Also.. what is location?
Do yow know what a CLOB is? That's a HUGE character field.. can that
not be a varchar?
On Fri, May 23, 2008 at 3:25 PM, [EMAIL PROTECTED] wrote:
I actually want that field to be a 0
The query you posted (UPDATE HomeCareCompany) is not the query reporting the
error ( UPDATE Physician )
On Fri, May 23, 2008 at 3:28 PM, [EMAIL PROTECTED] wrote:
One that is not very helpful :(
Error Executing Database Query.
Syntax error in UPDATE statement.
The error occurred in
: Re: Syntax Error In Update Statement
Is this the same query?
The query you posted was using a different table
cfquery datasource=#DSN# name=UpdateCompany
UPDATE HomeCareCompany
SET Active=cfif IsDefined(FORM.Active)
The query below uses Physician
On Fri, May 23, 2008 at 3:28 PM, [EMAIL
On Fri, May 23, 2008 at 1:32 PM, [EMAIL PROTECTED] wrote:
Even if it is a numeric field in the database? I have tried removing the
entire statement from the update query and it still gives an error.
the cfsqltype you specified is CLOB.
--
A byte walks into a bar and orders a pint. Bartender
If it's numeric in the DB it should NOT be cf_sql_clob
On Fri, May 23, 2008 at 3:34 PM, morgan l [EMAIL PROTECTED] wrote:
The query you posted (UPDATE HomeCareCompany) is not the query reporting the
error ( UPDATE Physician )
On Fri, May 23, 2008 at 3:28 PM, [EMAIL PROTECTED] wrote:
One
-
From: Greg Morphis [mailto:[EMAIL PROTECTED]
Sent: Friday, May 23, 2008 4:37 PM
To: CF-Talk
Subject: Re: Syntax Error In Update Statement
If it's numeric in the DB it should NOT be cf_sql_clob
On Fri, May 23, 2008 at 3:34 PM, morgan l [EMAIL PROTECTED] wrote:
The query you posted (UPDATE
On Fri, May 23, 2008 at 1:58 PM, [EMAIL PROTECTED] wrote:
When I change it to CF_SQL_NUMERIC the error persists. Even if I remove
the entire statement
, Location=cfif IsDefined(FORM.Location) AND #FORM.Location# NEQ
cfqueryparam value=#FORM.Location# cfsqltype=CF_SQL_NUMERIC
maxlength=15
-Original Message-
From: Charlie Griefer [mailto:[EMAIL PROTECTED]
Sent: Friday, May 23, 2008 5:06 PM
To: CF-Talk
Subject: Re: Syntax Error In Update Statement
On Fri, May 23, 2008 at 1:58 PM, [EMAIL PROTECTED] wrote:
When I change it to CF_SQL_NUMERIC the error persists. Even if I
remove
: Re: Syntax Error In Update Statement
On Fri, May 23, 2008 at 1:58 PM, [EMAIL PROTECTED] wrote:
When I change it to CF_SQL_NUMERIC the error persists. Even if I
remove
the entire statement
, Location=cfif IsDefined(FORM.Location) AND #FORM.Location# NEQ
cfqueryparam value=#FORM.Location
Subject: Re: Syntax Error In Update Statement
On Fri, May 23, 2008 at 1:58 PM, [EMAIL PROTECTED] wrote:
When I change it to CF_SQL_NUMERIC the error persists. Even if I
remove
the entire statement
, Location=cfif IsDefined(FORM.Location) AND #FORM.Location# NEQ
cfqueryparam value
added the additional field like I mentioned earlier. Then even
removing the field does not help now.
-Original Message-
From: Greg Morphis [mailto:[EMAIL PROTECTED]
Sent: Friday, May 23, 2008 5:26 PM
To: CF-Talk
Subject: Re: Syntax Error In Update Statement
Holy F!?!?!?! .. surely you
I would assume it is because it is a keyword used in SQL or Database
syntax. Again Dream Weaver wrote the code.
-Original Message-
From: Charlie Griefer [mailto:[EMAIL PROTECTED]
Sent: Friday, May 23, 2008 5:30 PM
To: CF-Talk
Subject: Re: Syntax Error In Update Statement
why
.
-Original Message-
From: Charlie Griefer [mailto:[EMAIL PROTECTED]
Sent: Friday, May 23, 2008 5:30 PM
To: CF-Talk
Subject: Re: Syntax Error In Update Statement
why is the column State in double quotes?
On Fri, May 23, 2008 at 2:18 PM, [EMAIL PROTECTED] wrote:
It is a number field
. This query was working
until I added the additional field like I mentioned earlier. Then even
removing the field does not help now.
-Original Message-
From: Greg Morphis [mailto:[EMAIL PROTECTED]
Sent: Friday, May 23, 2008 5:26 PM
To: CF-Talk
Subject: Re: Syntax Error In Update Statement
22 matches
Mail list logo
