I dont know why the following query:
===================beging query========================
<cfquery name="changes" datasource="mydatabase" dbtype="odbc">INSERT INTO mainpage (main_title,main_subtitle,main_text_one_title,main_text_one,main_text_two_title,main_text_two,main_email_link)
VALUES ('#form.titlefield#','#form.subtitlefield#','#form.textonetitlefield#','#form.textareaonefield#','#form.texttwotitlefield#','#form.textareatwofield#','#form.emailfield#')
WHERE m_frn_id=#localmid#
</cfquery>
===================end query========================
Is giving me the following error:
===================beging error========================
ODBC Error Code = 37000 (Syntax error or access violation)
[Microsoft][ODBC Microsoft Access Driver] Missing semicolon (
at end of SQL statement.
The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (10:1) to (10:76).
===================end error========================
I tried the obvious (a semicolon at the end of the sql statement) but get the same error.
===================beging query========================
<cfquery name="changes" datasource="mydatabase" dbtype="odbc">INSERT INTO mainpage (main_title,main_subtitle,main_text_one_title,main_text_one,main_text_two_title,main_text_two,main_email_link)
VALUES ('#form.titlefield#','#form.subtitlefield#','#form.textonetitlefield#','#form.textareaonefield#','#form.texttwotitlefield#','#form.textareatwofield#','#form.emailfield#')
WHERE m_frn_id=#localmid#
</cfquery>
===================end query========================
Is giving me the following error:
===================beging error========================
ODBC Error Code = 37000 (Syntax error or access violation)
[Microsoft][ODBC Microsoft Access Driver] Missing semicolon (

The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (10:1) to (10:76).
===================end error========================
I tried the obvious (a semicolon at the end of the sql statement) but get the same error.