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 Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:186542 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
