the last comma Tim <[EMAIL PROTECTED]> wrote: I have a pre-filled form for users to change a record. The form calls an action page to update the record. I keep getting the dreaded error: Error Diagnostic Information ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement. I have looked backward and forward, checked spelling, quotes, etc., and can't figure out the problem. I figureed it was time for a new set of eyes. Is there something about this that I am missing: <CFQUERY NAME="qDoUpdate" DATASOURCE="teleconference"> UPDATE data SET conf_name = '#Form.conf_name#', conf_purpose = '#Form.conf_purpose#', conf_date = #Form.conf_date#, occurance = '#Form.occurance#', begin_time = '#Form.begin_time#', end_time = '#Form.end_time#', mod_name = '#Form.mod_name#', mod_phone = '#Form.mod_phone#', mod_station = '#Form.mod_station#', poc_name = '#Form.poc_name#', poc_phone = '#Form.poc_phone#', poc_station = '#Form.poc_station#', facilities = '#Form.facilities#', comments = '#Form.comments#', WHERE ID = #Form.ID# </CFQUERY> I can add and view records in the database. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
