If any of those fields are numeric, the single quotes will cause an error.
Additionally, think about changing the column "name": that seems like a good
candidate for a reserved word.
--
Billy Cravens
HR Web Development, Sabre
[EMAIL PROTECTED]
"Phillips, Eddie" wrote:
> 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
-------------------------------------------------------------------------
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
