RE: Syntax error or sharing violation
live = 0, should be live =0 no comma. -Original Message- From: Darren Adams [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 26, 2001 6:52 AM To: CF-Talk Subject: Syntax error or sharing violation can anyone here see what the problem with this statement is ? cfquery name=news datasource=cosmos1 dbtype=ODBC UPDATE waiting_room_news set headline = '#headline#', subtitle = '#subtitle#', body = '#body#', author = '#author#', expdate = '#expdate#', cfif #audience# EQ 'Keep old value' audience = '#oldaudience#' cfelse audience = '#audience#' /cfif, datestamp = '#date#', !---Set the approval field back to 0 --- live = 0, where id = #id# /cfquery This is the error message I am getting: Error Occurred While Processing Request Error Diagnostic Information ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement. The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (20:1) to (20:56). Date/Time: 04/26/01 14:50:44 Browser: Mozilla/4.0 (compatible; MSIE 5.0; Windows 95; DigExt) Remote Address: 129.153.207.20 HTTP Referer: http://uk1web2:8080/menutest/authorise/edit_news.cfm?id=5country=World Widecontent=news Template: E:\Inetpub\publicsite\menutest\authorise\edit_news_action.cfm Darren Adams Web Developer Marketing Department Systems Union Office: 01252 55 6220 Mobile: 07714 817 038 Email: [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Syntax error or sharing violation
I've done this so many times! The comma in the last item is the culprit: live = 0, where id = #id# /cfquery Greg Creedon cf handyman for hire! Got something that needs getting done? Call the cf handyman! [EMAIL PROTECTED] -Original Message- From: Darren Adams [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 26, 2001 9:52 AM To: CF-Talk Subject: Syntax error or sharing violation can anyone here see what the problem with this statement is ? cfquery name=news datasource=cosmos1 dbtype=ODBC UPDATE waiting_room_news set headline = '#headline#', subtitle = '#subtitle#', body = '#body#', author = '#author#', expdate = '#expdate#', cfif #audience# EQ 'Keep old value' audience = '#oldaudience#' cfelse audience = '#audience#' /cfif, datestamp = '#date#', !---Set the approval field back to 0 --- live = 0, where id = #id# /cfquery This is the error message I am getting: Error Occurred While Processing Request Error Diagnostic Information ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement. The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (20:1) to (20:56). Date/Time: 04/26/01 14:50:44 Browser: Mozilla/4.0 (compatible; MSIE 5.0; Windows 95; DigExt) Remote Address: 129.153.207.20 HTTP Referer: http://uk1web2:8080/menutest/authorise/edit_news.cfm?id=5country=World Widecontent=news Template: E:\Inetpub\publicsite\menutest\authorise\edit_news_action.cfm Darren Adams Web Developer Marketing Department Systems Union Office: 01252 55 6220 Mobile: 07714 817 038 Email: [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Syntax error or sharing violation
no comma after live=0 - Original Message - From: Darren Adams [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, April 26, 2001 9:52 AM Subject: Syntax error or sharing violation can anyone here see what the problem with this statement is ? cfquery name=news datasource=cosmos1 dbtype=ODBC UPDATE waiting_room_news set headline = '#headline#', subtitle = '#subtitle#', body = '#body#', author = '#author#', expdate = '#expdate#', cfif #audience# EQ 'Keep old value' audience = '#oldaudience#' cfelse audience = '#audience#' /cfif, datestamp = '#date#', !---Set the approval field back to 0 --- live = 0, where id = #id# /cfquery This is the error message I am getting: Error Occurred While Processing Request Error Diagnostic Information ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement. The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (20:1) to (20:56). Date/Time: 04/26/01 14:50:44 Browser: Mozilla/4.0 (compatible; MSIE 5.0; Windows 95; DigExt) Remote Address: 129.153.207.20 HTTP Referer: http://uk1web2:8080/menutest/authorise/edit_news.cfm?id=5country=World Widecontent=news Template: E:\Inetpub\publicsite\menutest\authorise\edit_news_action.cfm Darren Adams Web Developer Marketing Department Systems Union Office: 01252 55 6220 Mobile: 07714 817 038 Email: [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Syntax error or sharing violation
It's what you call extending functionality to an authoring tool and copying pages then deleting fields you dont want and accidentally living commas in. That is so infuriating !! -Original Message- From: Greg Creedon [mailto:[EMAIL PROTECTED]] Sent: 26 April 2001 15:06 To: CF-Talk Subject: RE: Syntax error or sharing violation I've done this so many times! The comma in the last item is the culprit: live = 0, where id = #id# /cfquery Greg Creedon cf handyman for hire! Got something that needs getting done? Call the cf handyman! [EMAIL PROTECTED] -Original Message- From: Darren Adams [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 26, 2001 9:52 AM To: CF-Talk Subject: Syntax error or sharing violation can anyone here see what the problem with this statement is ? cfquery name=news datasource=cosmos1 dbtype=ODBC UPDATE waiting_room_news set headline = '#headline#', subtitle = '#subtitle#', body = '#body#', author = '#author#', expdate = '#expdate#', cfif #audience# EQ 'Keep old value' audience = '#oldaudience#' cfelse audience = '#audience#' /cfif, datestamp = '#date#', !---Set the approval field back to 0 --- live = 0, where id = #id# /cfquery This is the error message I am getting: Error Occurred While Processing Request Error Diagnostic Information ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement. The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (20:1) to (20:56). Date/Time: 04/26/01 14:50:44 Browser: Mozilla/4.0 (compatible; MSIE 5.0; Windows 95; DigExt) Remote Address: 129.153.207.20 HTTP Referer: http://uk1web2:8080/menutest/authorise/edit_news.cfm?id=5country=World Widecontent=news Template: E:\Inetpub\publicsite\menutest\authorise\edit_news_action.cfm Darren Adams Web Developer Marketing Department Systems Union Office: 01252 55 6220 Mobile: 07714 817 038 Email: [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Syntax error or sharing violation
ARRRGGG Talk about not seeing the wood for the trees !! dont you justy hate it when you get silly little things like that ? -Original Message- From: Dylan Bromby [mailto:[EMAIL PROTECTED]] Sent: 26 April 2001 15:08 To: CF-Talk Subject: RE: Syntax error or sharing violation live = 0, should be live =0 no comma. -Original Message- From: Darren Adams [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 26, 2001 6:52 AM To: CF-Talk Subject: Syntax error or sharing violation can anyone here see what the problem with this statement is ? cfquery name=news datasource=cosmos1 dbtype=ODBC UPDATE waiting_room_news set headline = '#headline#', subtitle = '#subtitle#', body = '#body#', author = '#author#', expdate = '#expdate#', cfif #audience# EQ 'Keep old value' audience = '#oldaudience#' cfelse audience = '#audience#' /cfif, datestamp = '#date#', !---Set the approval field back to 0 --- live = 0, where id = #id# /cfquery This is the error message I am getting: Error Occurred While Processing Request Error Diagnostic Information ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement. The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (20:1) to (20:56). Date/Time: 04/26/01 14:50:44 Browser: Mozilla/4.0 (compatible; MSIE 5.0; Windows 95; DigExt) Remote Address: 129.153.207.20 HTTP Referer: http://uk1web2:8080/menutest/authorise/edit_news.cfm?id=5country=World Widecontent=news Template: E:\Inetpub\publicsite\menutest\authorise\edit_news_action.cfm Darren Adams Web Developer Marketing Department Systems Union Office: 01252 55 6220 Mobile: 07714 817 038 Email: [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Syntax error or sharing violation
I don't think that you need single quotes around the Date, additionally try formatting the date using CreateODBCDate(date). Jeff Garza Web Developer/Webmaster Spectrum Astro, Inc. 480.892.8200 [EMAIL PROTECTED] http://www.spectrumastro.com -Original Message- From: Darren Adams [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 26, 2001 6:52 AM To: CF-Talk Subject: Syntax error or sharing violation can anyone here see what the problem with this statement is ? cfquery name=news datasource=cosmos1 dbtype=ODBC UPDATE waiting_room_news set headline = '#headline#', subtitle = '#subtitle#', body = '#body#', author = '#author#', expdate = '#expdate#', cfif #audience# EQ 'Keep old value' audience = '#oldaudience#' cfelse audience = '#audience#' /cfif, datestamp = '#date#', !---Set the approval field back to 0 --- live = 0, where id = #id# /cfquery This is the error message I am getting: Error Occurred While Processing Request Error Diagnostic Information ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement. The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (20:1) to (20:56). Date/Time: 04/26/01 14:50:44 Browser: Mozilla/4.0 (compatible; MSIE 5.0; Windows 95; DigExt) Remote Address: 129.153.207.20 HTTP Referer: http://uk1web2:8080/menutest/authorise/edit_news.cfm?id=5country=World Widecontent=news Template: E:\Inetpub\publicsite\menutest\authorise\edit_news_action.cfm Darren Adams Web Developer Marketing Department Systems Union Office: 01252 55 6220 Mobile: 07714 817 038 Email: [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Syntax error or sharing violation
It's the comma after your live=0 line live = 0, where id = #id# -Original Message- From: Garza, Jeff [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 26, 2001 8:09 AM To: CF-Talk Subject: RE: Syntax error or sharing violation I don't think that you need single quotes around the Date, additionally try formatting the date using CreateODBCDate(date). Jeff Garza Web Developer/Webmaster Spectrum Astro, Inc. 480.892.8200 [EMAIL PROTECTED] http://www.spectrumastro.com -Original Message- From: Darren Adams [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 26, 2001 6:52 AM To: CF-Talk Subject: Syntax error or sharing violation can anyone here see what the problem with this statement is ? cfquery name=news datasource=cosmos1 dbtype=ODBC UPDATE waiting_room_news set headline = '#headline#', subtitle = '#subtitle#', body = '#body#', author = '#author#', expdate = '#expdate#', cfif #audience# EQ 'Keep old value' audience = '#oldaudience#' cfelse audience = '#audience#' /cfif, datestamp = '#date#', !---Set the approval field back to 0 --- live = 0, where id = #id# /cfquery This is the error message I am getting: Error Occurred While Processing Request Error Diagnostic Information ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement. The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (20:1) to (20:56). Date/Time: 04/26/01 14:50:44 Browser: Mozilla/4.0 (compatible; MSIE 5.0; Windows 95; DigExt) Remote Address: 129.153.207.20 HTTP Referer: http://uk1web2:8080/menutest/authorise/edit_news.cfm?id=5country=World Widecontent=news Template: E:\Inetpub\publicsite\menutest\authorise\edit_news_action.cfm Darren Adams Web Developer Marketing Department Systems Union Office: 01252 55 6220 Mobile: 07714 817 038 Email: [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists