Question
Simple SQL, but i get an error?
Here's my code:
<cfquery name="setNote"
datasource="#DS#" dbtype="ODBC"
username="#DSUsername#" password="#DSPassword#"
>
update Notes set note = 'test' where noteid = 1
</cfquery>
Seems simple enough, but I get this:
[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement.
Yeah, I know "Access Sucks.", but this still seems like it should work, no?
If I do a "select * from notes" and cfdump the results, I see the data that is there, I just can't update it.
What am I missing here?
<cfquery name="setNote"
datasource="#DS#" dbtype="ODBC"
username="#DSUsername#" password="#DSPassword#"
>
update Notes set note = 'test' where noteid = 1
</cfquery>
Seems simple enough, but I get this:
[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement.
Yeah, I know "Access Sucks.", but this still seems like it should work, no?
If I do a "select * from notes" and cfdump the results, I see the data that is there, I just can't update it.
What am I missing here?
AdChoices