Greetings All,
I am coming across a strange error, that I am sure is the result of
something simple. I have a simple form that is passing vales to a template
that is inserting into an Access 2000 Database.
Here is the cfquery code:
<cfquery name="insert_rec" datasource="feedback">
Insert into feedback (Name, request, requesttype, dept, approved, feedback)
Values ('#form.name#', '#form.request#', '#form.requesttype#',
'#form.dept#', '#form.approved#', '#form.feedback#')
</cfquery>
The error I get is:
ODBC Error Code = S1000 (General error)
[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable
query.
The really strange thing is I copied the code into query analyzer, replaced
the cf variables with actual data and it works. I then took that exact SQL
line (including the data I put in) and put it between my cfquery tags,
replacing the above and I still get the same error.
Any suggestions would be greatly appreciated.
Eddie
-------------------------------------------------------------------------
This email server is running an evaluation copy of the MailShield anti-
spam software. Please contact your email administrator if you have any
questions about this message. MailShield product info: www.mailshield.com
-----------------------------------------------
To post, send email to [EMAIL PROTECTED]
To subscribe / unsubscribe: http://www.dfwcfug.org
