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