Entering Quotation Marks in a CFUPDATE field?

[andy570]

I am attempting to update a table in MSAccess. When I retreive the info from the database and when it is displayed the quotation marks show up as a box. How do I enter quotes surrounded by quotation marks using a cfupdate page?

Thanks!

 

[ecobb]

Try entering in the values with a SQL Update statement using <cfquery> instead of <cfupdate>.

Hope This Helps!

Ecobb

&quot;Alright Brain, you don't like me, and I don't like you. But lets just do this, and I can get back to killing you with beer.&quot; - Homer Simpson

 

[andy570]

It Worked!

Thanks for the help