RE: Syntax Error In Update Statement
You should really write it yourself so you know what it's doing and why ..:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com http://cf4em.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, May 23, 2008 10:06 PM To: CF-Talk Subject: RE: Syntax Error In Update Statement Well first off this was code generated by Dream Weaver using the testing server environment so yell at Adobe. Can I write it from scratch myself sure but I was trying to save time. All it appears to have done is waste time. Why would this give you a heart attack. 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 Holy F!?!?!?! .. surely you don't have the password, phone number, fax number, email and company name. I think this email just gave every DB person on this list a heart attack. Clob is for storing GIGS of data. Those are varchar's if not numeric.. Fix your query first and then let us know if you still have problems. On Fri, May 23, 2008 at 4:18 PM, <[EMAIL PROTECTED]> wrote: > It is a number field in an Access DB. Below is the entire query. > > "form1"> > >UPDATE HomeCareCompany > SET Active= > 1 > > 0 > > , Location= > maxlength="15"> > > 0 > > , CompanyName= NEQ ""> > maxlength="85"> > > '' > > , Email= > maxlength="75"> > > '' > > , Password= > maxlength="15"> > > '' > > , FirstName= ""> > maxlength="40"> > > '' > > , LastName= > maxlength="40"> > > '' > > , Address= > maxlength="200"> > > '' > > , City= > maxlength="85"> > > '' > > , "State"= > maxlength="2"> > > '' > > , Zip= > > > '' > > , Phone= > maxlength="15"> > > '' > > , Fax= > > > '' > > WHERE ID= > > > > > -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 >> the entire statement >> >> , Location= ""> >> > maxlength="15"> >> >> 0 >> >> >> The error still persists. > > is it numeric or is it integer? > > if the error persists without that line, can you paste the query as > you currently have it? > > -- > A byte walks into a bar and orders a pint. Bartender asks him "What's > wrong?" Byte says "Parity error." Bartender nods and says "Yeah, I > thought you looked a bit off." > > > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306002 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Syntax Error In Update Statement
i'm confused about so many things... 1) you're using Access, right? does Access even support a CLOB datatype? what are the datatypes in the database? 2) i don't think 'State' is a reserved word in Access (again, i'm assuming this is Access as I seem to recall somewhere in this thread that it was mentioned... please confirm). Try without the double quotes. 3) was this ever working before you put the 'location' conditional? 4) wasting way too much time shooting in the dark. whittle the statement down to a single statement using as few variables as possible. get rid of the cfqueryparam. just make it work. then add the other columns/conditionals 1 at a time. then add the cfqueryparams 1 at a time. On Fri, May 23, 2008 at 7:06 PM, <[EMAIL PROTECTED]> wrote: > 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 is the column State in double quotes? > > On Fri, May 23, 2008 at 2:18 PM, <[EMAIL PROTECTED]> wrote: >> It is a number field in an Access DB. Below is the entire query. >> >> > "form1"> >> >>UPDATE HomeCareCompany >> SET Active= >> 1 >> >> 0 >> >> , Location= ""> >> > maxlength="15"> >> >> 0 >> >> , CompanyName= #FORM.CompanyName# >> NEQ ""> >> > maxlength="85"> >> >> '' >> >> , Email= >> > maxlength="75"> >> >> '' >> >> , Password= ""> >> > maxlength="15"> >> >> '' >> >> , FirstName=> ""> >> > maxlength="40"> >> >> '' >> >> , LastName= ""> >> > maxlength="40"> >> >> '' >> >> , Address= >> > maxlength="200"> >> >> '' >> >> , City= >> > maxlength="85"> >> >> '' >> >> , "State"= >> > maxlength="2"> >> >> '' >> >> , Zip= >> maxlength="10"> >> >> '' >> >> , Phone= >> > maxlength="15"> >> >> '' >> >> , Fax= >> maxlength="15"> >> >> '' >> >> WHERE ID= >> >> >> >> >> -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 >>> the entire statement >>> >>> , Location=> ""> >>> >> maxlength="15"> >>> >>> 0 >>> >>> >>> The error still persists. >> >> is it numeric or is it integer? >> >> if the error persists without that line, can you paste the query as >> you currently have it? >> >> -- >> A byte walks into a bar and orders a pint. Bartender asks him "What's >> wrong?" Byte says "Parity error." Bartender nods and says "Yeah, I >> thought you looked a bit off." >> >> >> >> > > > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305999 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Syntax Error In Update Statement
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 is the column State in double quotes? On Fri, May 23, 2008 at 2:18 PM, <[EMAIL PROTECTED]> wrote: > It is a number field in an Access DB. Below is the entire query. > > "form1"> > >UPDATE HomeCareCompany > SET Active= > 1 > > 0 > > , Location= > maxlength="15"> > > 0 > > , CompanyName= NEQ ""> > maxlength="85"> > > '' > > , Email= > maxlength="75"> > > '' > > , Password= > maxlength="15"> > > '' > > , FirstName= ""> > maxlength="40"> > > '' > > , LastName= > maxlength="40"> > > '' > > , Address= > maxlength="200"> > > '' > > , City= > maxlength="85"> > > '' > > , "State"= > maxlength="2"> > > '' > > , Zip= > > > '' > > , Phone= > maxlength="15"> > > '' > > , Fax= > > > '' > > WHERE ID= > > > > > -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 >> the entire statement >> >> , Location= ""> >> > maxlength="15"> >> >> 0 >> >> >> The error still persists. > > is it numeric or is it integer? > > if the error persists without that line, can you paste the query as > you currently have it? > > -- > A byte walks into a bar and orders a pint. Bartender asks him "What's > wrong?" Byte says "Parity error." Bartender nods and says "Yeah, I > thought you looked a bit off." > > > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305997 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Syntax Error In Update Statement
Well first off this was code generated by Dream Weaver using the testing server environment so yell at Adobe. Can I write it from scratch myself sure but I was trying to save time. All it appears to have done is waste time. Why would this give you a heart attack. 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 Holy F!?!?!?! .. surely you don't have the password, phone number, fax number, email and company name. I think this email just gave every DB person on this list a heart attack. Clob is for storing GIGS of data. Those are varchar's if not numeric.. Fix your query first and then let us know if you still have problems. On Fri, May 23, 2008 at 4:18 PM, <[EMAIL PROTECTED]> wrote: > It is a number field in an Access DB. Below is the entire query. > > "form1"> > >UPDATE HomeCareCompany > SET Active= > 1 > > 0 > > , Location= > maxlength="15"> > > 0 > > , CompanyName= NEQ ""> > maxlength="85"> > > '' > > , Email= > maxlength="75"> > > '' > > , Password= > maxlength="15"> > > '' > > , FirstName= ""> > maxlength="40"> > > '' > > , LastName= > maxlength="40"> > > '' > > , Address= > maxlength="200"> > > '' > > , City= > maxlength="85"> > > '' > > , "State"= > maxlength="2"> > > '' > > , Zip= > > > '' > > , Phone= > maxlength="15"> > > '' > > , Fax= > > > '' > > WHERE ID= > > > > > -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 >> the entire statement >> >> , Location= ""> >> > maxlength="15"> >> >> 0 >> >> >> The error still persists. > > is it numeric or is it integer? > > if the error persists without that line, can you paste the query as > you currently have it? > > -- > A byte walks into a bar and orders a pint. Bartender asks him "What's > wrong?" Byte says "Parity error." Bartender nods and says "Yeah, I > thought you looked a bit off." > > > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305996 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
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 in an Access DB. Below is the entire query. > > "form1"> > >UPDATE HomeCareCompany > SET Active= > 1 > > 0 > > , Location= > maxlength="15"> > > 0 > > , CompanyName= NEQ ""> > maxlength="85"> > > '' > > , Email= > maxlength="75"> > > '' > > , Password= > maxlength="15"> > > '' > > , FirstName= ""> > maxlength="40"> > > '' > > , LastName= > maxlength="40"> > > '' > > , Address= > maxlength="200"> > > '' > > , City= > maxlength="85"> > > '' > > , "State"= > maxlength="2"> > > '' > > , Zip= > > > '' > > , Phone= > maxlength="15"> > > '' > > , Fax= > > > '' > > WHERE ID= > > > > > -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 >> the entire statement >> >> , Location= ""> >> > maxlength="15"> >> >> 0 >> >> >> The error still persists. > > is it numeric or is it integer? > > if the error persists without that line, can you paste the query as > you currently have it? > > -- > A byte walks into a bar and orders a pint. Bartender asks him "What's > wrong?" Byte says "Parity error." Bartender nods and says "Yeah, I > thought you looked a bit off." > > > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305981 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Syntax Error In Update Statement
Holy F!?!?!?! .. surely you don't have the password, phone number, fax number, email and company name. I think this email just gave every DB person on this list a heart attack. Clob is for storing GIGS of data. Those are varchar's if not numeric.. Fix your query first and then let us know if you still have problems. On Fri, May 23, 2008 at 4:18 PM, <[EMAIL PROTECTED]> wrote: > It is a number field in an Access DB. Below is the entire query. > > "form1"> > >UPDATE HomeCareCompany > SET Active= > 1 > > 0 > > , Location= > maxlength="15"> > > 0 > > , CompanyName= NEQ ""> > maxlength="85"> > > '' > > , Email= > maxlength="75"> > > '' > > , Password= > maxlength="15"> > > '' > > , FirstName= ""> > maxlength="40"> > > '' > > , LastName= > maxlength="40"> > > '' > > , Address= > maxlength="200"> > > '' > > , City= > maxlength="85"> > > '' > > , "State"= > maxlength="2"> > > '' > > , Zip= > > > '' > > , Phone= > maxlength="15"> > > '' > > , Fax= > > > '' > > WHERE ID= > > > > > -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 >> the entire statement >> >> , Location= ""> >> > maxlength="15"> >> >> 0 >> >> >> The error still persists. > > is it numeric or is it integer? > > if the error persists without that line, can you paste the query as > you currently have it? > > -- > A byte walks into a bar and orders a pint. Bartender asks him "What's > wrong?" Byte says "Parity error." Bartender nods and says "Yeah, I > thought you looked a bit off." > > > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305980 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Syntax Error In Update Statement
It is a number field in an Access DB. Below is the entire query. UPDATE HomeCareCompany SET Active= 1 0 , Location= 0 , CompanyName= '' , Email= '' , Password= '' , FirstName= '' , LastName= '' , Address= '' , City= '' , "State"= '' , Zip= '' , Phone= '' , Fax= '' WHERE ID= -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 > the entire statement > > , Location= > maxlength="15"> > > 0 > > > The error still persists. is it numeric or is it integer? if the error persists without that line, can you paste the query as you currently have it? -- A byte walks into a bar and orders a pint. Bartender asks him "What's wrong?" Byte says "Parity error." Bartender nods and says "Yeah, I thought you looked a bit off." ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305979 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
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= > maxlength="15"> > > 0 > > > The error still persists. is it numeric or is it integer? if the error persists without that line, can you paste the query as you currently have it? -- A byte walks into a bar and orders a pint. Bartender asks him "What's wrong?" Byte says "Parity error." Bartender nods and says "Yeah, I thought you looked a bit off." ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305978 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Syntax Error In Update Statement
When I change it to CF_SQL_NUMERIC the error persists. Even if I remove the entire statement , Location= 0 The error still persists. -Original Message- 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 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 >> C:\users\respiratorydiagnosticsllc.com\www\admin\EditPhysician.cfm: line >> 71 >> >> 69 : '' >> 70 : >> 71 : WHERE ID=http://form.id/#>" >> cfsqltype="cf_sql_numeric"> >> 72 : >> 73 : >> >> SQLSTATE >> SQLUPDATE Physician SET Active= 1 , NPI= (param 1) , FirstName= >> (param 2) , LastName= (param 3) , Suffix= (param 4) , Email= (param 5) , >> Password= (param 6) , Address= (param 7) , City= (param 8) , "State"= >> (param 9) , Zip= (param 10) , Phone= (param 11) , Fax= '' WHERE ID= >> (param 12) >> VENDORERRORCODE 3092 >> >> > > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305977 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
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 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 >> C:\users\respiratorydiagnosticsllc.com\www\admin\EditPhysician.cfm: line >> 71 >> >> 69 : '' >> 70 : >> 71 : WHERE ID=http://form.id/#>" >> cfsqltype="cf_sql_numeric"> >> 72 : >> 73 : >> >> SQLSTATE >> SQLUPDATE Physician SET Active= 1 , NPI= (param 1) , FirstName= >> (param 2) , LastName= (param 3) , Suffix= (param 4) , Email= (param 5) , >> Password= (param 6) , Address= (param 7) , City= (param 8) , "State"= >> (param 9) , Zip= (param 10) , Phone= (param 11) , Fax= '' WHERE ID= >> (param 12) >> VENDORERRORCODE 3092 >> >> > > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305976 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Syntax Error In Update Statement
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 asks him "What's wrong?" Byte says "Parity error." Bartender nods and says "Yeah, I thought you looked a bit off." ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305975 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Syntax Error In Update Statement
Ack sorry :( Having the same problem with another DW created query on another page. Here is the correct error. Error Executing Database Query. Syntax error in UPDATE statement. The error occurred in C:\users\respiratorydiagnosticsllc.com\www\admin\EditCompany.cfm: line 71 69 : '' 70 : 71 : WHERE ID= 72 : 73 : SQLSTATE SQLUPDATE HomeCareCompany SET Active= 1 , Location= (param 1) , CompanyName= (param 2) , Email= (param 3) , Password= '' , FirstName= (param 4) , LastName= (param 5) , Address= (param 6) , City= (param 7) , "State"= (param 8) , Zip= (param 9) , Phone= (param 10) , Fax= '' WHERE ID= (param 11) VENDORERRORCODE 3092 -Original Message- From: Greg Morphis [mailto:[EMAIL PROTECTED] Sent: Friday, May 23, 2008 4:33 PM To: CF-Talk Subject: Re: Syntax Error In Update Statement Is this the same query? The query you posted was using a different table UPDATE HomeCareCompany SET Active= The query below uses "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 > C:\users\respiratorydiagnosticsllc.com\www\admin\EditPhysician.cfm: line > 71 > > 69 : '' > 70 : > 71 : WHERE ID= cfsqltype="cf_sql_numeric"> > 72 : > 73 : > > SQLSTATE > SQLUPDATE Physician SET Active= 1 , NPI= (param 1) , FirstName= > (param 2) , LastName= (param 3) , Suffix= (param 4) , Email= (param 5) , > Password= (param 6) , Address= (param 7) , City= (param 8) , "State"= > (param 9) , Zip= (param 10) , 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 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 not work. >> >> >>UPDATE HomeCareCompany >> SET Active= >> 1 >> >> 0 >> >> , Location= ""> >> maxlength="15"> >> >> 0 >> >> , CompanyName= #FORM.CompanyName# NEQ ""> >> maxlength="85"> >> >> '' >> >> , Email= >> maxlength="75"> >> >> '' >> >> , Password= ""> >> maxlength="15"> >> >> '' >> >> , FirstName= ""> >> maxlength="40"> >> >> '' >> >> , LastName= ""> >> maxlength="40"> >> >> '' >> >> , Address= >> maxlength="200"> >> >> '' >> >> , City= >> maxlength="85"> >> >> '' >> >> , "State"= >> maxlength="2"> >> >> '' >> >> , Zip= >> maxlength="10"> >> >> '' >> >> , Phone= >> maxlength="15"> >> >> '' >> >> , Fax= >> maxlength="15"> >> >> '' >> >> WHERE ID= >> >> >> > > > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305974 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Syntax Error In Update Statement
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 > C:\users\respiratorydiagnosticsllc.com\www\admin\EditPhysician.cfm: line > 71 > > 69 : '' > 70 : > 71 : WHERE ID=http://form.id/#>" > cfsqltype="cf_sql_numeric"> > 72 : > 73 : > > SQLSTATE > SQLUPDATE Physician SET Active= 1 , NPI= (param 1) , FirstName= > (param 2) , LastName= (param 3) , Suffix= (param 4) , Email= (param 5) , > Password= (param 6) , Address= (param 7) , City= (param 8) , "State"= > (param 9) , Zip= (param 10) , Phone= (param 11) , Fax= '' WHERE ID= > (param 12) > VENDORERRORCODE 3092 > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305973 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Syntax Error In Update Statement
Location is a number field. When I try changing it to I still get an error. In fact when I remove the statement entirely I still get the error. -Original Message- From: Greg Morphis [mailto:[EMAIL PROTECTED] Sent: 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 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 > <[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. >> >> , Location= ""> >> maxlength="15"> >> >> 0 >> > > shouldn't your be an empty string ("") instead of a 0? > > -- > A byte walks into a bar and orders a pint. Bartender asks him "What's > wrong?" Byte says "Parity error." Bartender nods and says "Yeah, I > thought you looked a bit off." > > > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305972 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Syntax Error In Update Statement
Is this the same query? The query you posted was using a different table UPDATE HomeCareCompany SET Active= The query below uses "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 > C:\users\respiratorydiagnosticsllc.com\www\admin\EditPhysician.cfm: line > 71 > > 69 : '' > 70 : > 71 : WHERE ID= cfsqltype="cf_sql_numeric"> > 72 : > 73 : > > SQLSTATE > SQLUPDATE Physician SET Active= 1 , NPI= (param 1) , FirstName= > (param 2) , LastName= (param 3) , Suffix= (param 4) , Email= (param 5) , > Password= (param 6) , Address= (param 7) , City= (param 8) , "State"= > (param 9) , Zip= (param 10) , 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 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 not work. >> >> >>UPDATE HomeCareCompany >> SET Active= >> 1 >> >> 0 >> >> , Location= ""> >> maxlength="15"> >> >> 0 >> >> , CompanyName= #FORM.CompanyName# NEQ ""> >> maxlength="85"> >> >> '' >> >> , Email= >> maxlength="75"> >> >> '' >> >> , Password= ""> >> maxlength="15"> >> >> '' >> >> , FirstName= ""> >> maxlength="40"> >> >> '' >> >> , LastName= ""> >> maxlength="40"> >> >> '' >> >> , Address= >> maxlength="200"> >> >> '' >> >> , City= >> maxlength="85"> >> >> '' >> >> , "State"= >> maxlength="2"> >> >> '' >> >> , Zip= >> maxlength="10"> >> >> '' >> >> , Phone= >> maxlength="15"> >> >> '' >> >> , Fax= >> maxlength="15"> >> >> '' >> >> WHERE ID= >> >> >> > > > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305971 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Syntax Error In Update Statement
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. Thanks, Patrick J. Hedgepath Pegasus Web Productions [EMAIL PROTECTED] 803-996-0578 -Original Message- From: Charlie Griefer [mailto:[EMAIL 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? > > -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 > <[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. >> >> , Location= ""> >> maxlength="15"> >> >> 0 >> > > shouldn't your be an empty string ("") instead of a 0? > > -- > A byte walks into a bar and orders a pint. Bartender asks him "What's > wrong?" Byte says "Parity error." Bartender nods and says "Yeah, I > thought you looked a bit off." > > > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305970 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
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 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 > <[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. >> >> , Location= ""> >> maxlength="15"> >> >> 0 >> > > shouldn't your be an empty string ("") instead of a 0? > > -- > A byte walks into a bar and orders a pint. Bartender asks him "What's > wrong?" Byte says "Parity error." Bartender nods and says "Yeah, I > thought you looked a bit off." > > > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305969 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
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? > > -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 > <[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. >> >> , Location= ""> >> maxlength="15"> >> >> 0 >> > > shouldn't your be an empty string ("") instead of a 0? > > -- > A byte walks into a bar and orders a pint. Bartender asks him "What's > wrong?" Byte says "Parity error." Bartender nods and says "Yeah, I > thought you looked a bit off." > > > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305968 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Syntax Error In Update Statement
One that is not very helpful :( Error Executing Database Query. Syntax error in UPDATE statement. The error occurred in C:\users\respiratorydiagnosticsllc.com\www\admin\EditPhysician.cfm: line 71 69 : '' 70 : 71 : WHERE ID= 72 : 73 : SQLSTATE SQLUPDATE Physician SET Active= 1 , NPI= (param 1) , FirstName= (param 2) , LastName= (param 3) , Suffix= (param 4) , Email= (param 5) , Password= (param 6) , Address= (param 7) , City= (param 8) , "State"= (param 9) , Zip= (param 10) , 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 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 not work. > > >UPDATE HomeCareCompany > SET Active= > 1 > > 0 > > , Location= > > > 0 > > , CompanyName= > > > '' > > , Email= > > > '' > > , Password= > > > '' > > , FirstName= > > > '' > > , LastName= > > > '' > > , Address= > > > '' > > , City= > > > '' > > , "State"= > > > '' > > , Zip= > > > '' > > , Phone= > > > '' > > , Fax= > > > '' > > WHERE ID= > > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305967 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Syntax Error In Update Statement
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 not work. > > >UPDATE HomeCareCompany > SET Active= > 1 > > 0 > > , Location= > > > 0 > > , CompanyName= ""> > maxlength="85"> > > '' > > , Email= > > > '' > > , Password= > > > '' > > , FirstName= > > > '' > > , LastName= > > > '' > > , Address= > > > '' > > , City= > > > '' > > , "State"= > > > '' > > , Zip= > > > '' > > , Phone= > > > '' > > , Fax= > > > '' > > WHERE ID= > > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305966 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Syntax Error In Update Statement
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 <[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. > > , Location= > > > 0 > shouldn't your be an empty string ("") instead of a 0? -- A byte walks into a bar and orders a pint. Bartender asks him "What's wrong?" Byte says "Parity error." Bartender nods and says "Yeah, I thought you looked a bit off." ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305965 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
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 > (Location). I can't see any reason it would not work. > > , Location= > > > 0 > shouldn't your be an empty string ("") instead of a 0? -- A byte walks into a bar and orders a pint. Bartender asks him "What's wrong?" Byte says "Parity error." Bartender nods and says "Yeah, I thought you looked a bit off." ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305964 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4