ok you solved my problem. figures the only problems I cant figure out are the ones that I screw up.
Thanks phil -----Original Message----- From: Ray Champagne [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 07, 2004 3:19 PM To: CF-Talk Subject: Re: Strange error message How can you have a WHERE clause in an insert statement? are u trying to do an update? or am i missing something? Ray At 03:13 PM 12/7/2004, Phillip Perry wrote: >Hi, > >I'm getting this error message during an insert attempt... > >Error Executing Database Query. >[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft >Access Driver] Missing semicolon (;) at end of SQL statement. > >I've never used a semicolon before and things worked ok. here is my >statement... > ><cfquery datasource="#mydbname#" name="linkinsert"> > INSERT INTO users > ( > link1, > link2, > link3, > link4, > link5, > link6, > link7, > link8 > ) > Values > ( > '#form.link1#', > '#form.link2#', > '#form.link3#', > '#form.link4#', > '#form.link5#', > '#form.link6#', > '#form.link7#', > '#form.link8#' > ) > WHERE uid = #user_var# ></cfquery> > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Special thanks to the CF Community Suite Silver Sponsor - New Atlanta http://www.newatlanta.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:186543 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
