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 - CFDynamics
http://www.cfdynamics.com
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:186539
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=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
