Semicolon at end of SQL Statement???
Not that familiar with doing SQL in Access, but this error does not make sense to me. ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC Microsoft Access Driver] Missing semicolon (;) at end of SQL statement. SQL = insert into tbl_users (fullname) values ('Rich Pragel') where username = rpragel Data Source = DLLR930 The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (1:1) to (1:44) in the template file c:\inetpub\wwwroot\DLLR930\insert.cfm. cfquery name=insert datasource=dllr930 insert into tbl_users (fullname) values ('#firstname# #lastname#') where username = #url.username# /cfquery ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Semicolon at end of SQL Statement???
Not sure about the semi colon. But in ..username = rpragel if rpragle is a string u will need tics ..username = 'rpragel' - Original Message - From: James Taavon [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, October 25, 2001 11:17 AM Subject: Semicolon at end of SQL Statement??? Not that familiar with doing SQL in Access, but this error does not make sense to me. ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC Microsoft Access Driver] Missing semicolon (;) at end of SQL statement. SQL = insert into tbl_users (fullname) values ('Rich Pragel') where username = rpragel Data Source = DLLR930 The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (1:1) to (1:44) in the template file c:\inetpub\wwwroot\DLLR930\insert.cfm. cfquery name=insert datasource=dllr930 insert into tbl_users (fullname) values ('#firstname# #lastname#') where username = #url.username# /cfquery ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Semicolon at end of SQL Statement???
Haven't used Access in a while, but I'm pretty sure you have to place a ; at the end of your statement, as in: insert into tbl_users (fullname) values ('Rich Pragel') where username = rpragel; Also, put single quotes around rpragel. (i.e. 'rpragel') Mark -Original Message- From: James Taavon [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 25, 2001 12:18 PM To: CF-Talk Subject: Semicolon at end of SQL Statement??? Not that familiar with doing SQL in Access, but this error does not make sense to me. ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC Microsoft Access Driver] Missing semicolon (;) at end of SQL statement. SQL = insert into tbl_users (fullname) values ('Rich Pragel') where username = rpragel Data Source = DLLR930 The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (1:1) to (1:44) in the template file c:\inetpub\wwwroot\DLLR930\insert.cfm. cfquery name=insert datasource=dllr930 insert into tbl_users (fullname) values ('#firstname# #lastname#') where username = #url.username# /cfquery ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Semicolon at end of SQL Statement???
tried it both ways, still got error. -Original Message- From: Trishan Singh [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 25, 2001 12:22 PM To: CF-Talk Subject: Re: Semicolon at end of SQL Statement??? Not sure about the semi colon. But in ..username = rpragel if rpragle is a string u will need tics ..username = 'rpragel' - Original Message - From: James Taavon [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, October 25, 2001 11:17 AM Subject: Semicolon at end of SQL Statement??? Not that familiar with doing SQL in Access, but this error does not make sense to me. ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC Microsoft Access Driver] Missing semicolon (;) at end of SQL statement. SQL = insert into tbl_users (fullname) values ('Rich Pragel') where username = rpragel Data Source = DLLR930 The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (1:1) to (1:44) in the template file c:\inetpub\wwwroot\DLLR930\insert.cfm. cfquery name=insert datasource=dllr930 insert into tbl_users (fullname) values ('#firstname# #lastname#') where username = #url.username# /cfquery ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Semicolon at end of SQL Statement???
You don't use a WHERE clause in an INSERT statement. Todd - Original Message - From: James Taavon [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, October 25, 2001 12:17 PM Subject: Semicolon at end of SQL Statement??? Not that familiar with doing SQL in Access, but this error does not make sense to me. ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC Microsoft Access Driver] Missing semicolon (;) at end of SQL statement. SQL = insert into tbl_users (fullname) values ('Rich Pragel') where username = rpragel Data Source = DLLR930 The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (1:1) to (1:44) in the template file c:\inetpub\wwwroot\DLLR930\insert.cfm. cfquery name=insert datasource=dllr930 insert into tbl_users (fullname) values ('#firstname# #lastname#') where username = #url.username# /cfquery ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Semicolon at end of SQL Statement???
yeah, you are right. i all want to do is merge two diff fields into a third one. that is my goal. -Original Message- From: Todd Ashworth [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 25, 2001 12:33 PM To: CF-Talk Subject: Re: Semicolon at end of SQL Statement??? You don't use a WHERE clause in an INSERT statement. Todd - Original Message - From: James Taavon [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, October 25, 2001 12:17 PM Subject: Semicolon at end of SQL Statement??? Not that familiar with doing SQL in Access, but this error does not make sense to me. ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC Microsoft Access Driver] Missing semicolon (;) at end of SQL statement. SQL = insert into tbl_users (fullname) values ('Rich Pragel') where username = rpragel Data Source = DLLR930 The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (1:1) to (1:44) in the template file c:\inetpub\wwwroot\DLLR930\insert.cfm. cfquery name=insert datasource=dllr930 insert into tbl_users (fullname) values ('#firstname# #lastname#') where username = #url.username# /cfquery ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Semicolon at end of SQL Statement???
NEVERMIND, NOT THINNKING -Original Message- From: James Taavon [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 25, 2001 12:46 PM To: CF-Talk Subject: RE: Semicolon at end of SQL Statement??? yeah, you are right. i all want to do is merge two diff fields into a third one. that is my goal. -Original Message- From: Todd Ashworth [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 25, 2001 12:33 PM To: CF-Talk Subject: Re: Semicolon at end of SQL Statement??? You don't use a WHERE clause in an INSERT statement. Todd - Original Message - From: James Taavon [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, October 25, 2001 12:17 PM Subject: Semicolon at end of SQL Statement??? Not that familiar with doing SQL in Access, but this error does not make sense to me. ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC Microsoft Access Driver] Missing semicolon (;) at end of SQL statement. SQL = insert into tbl_users (fullname) values ('Rich Pragel') where username = rpragel Data Source = DLLR930 The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (1:1) to (1:44) in the template file c:\inetpub\wwwroot\DLLR930\insert.cfm. cfquery name=insert datasource=dllr930 insert into tbl_users (fullname) values ('#firstname# #lastname#') where username = #url.username# /cfquery ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists