Forum Moderators: open

Message Too Old, No Replies

Need Replacement Statement in ASP

         

Headed North

9:04 pm on Apr 11, 2006 (gmt 0)

10+ Year Member



I have a field in an Access db that can contain quotation marks. I need to display it on the web but the quotation marks throw off the sql statement. How can I replace the quotes in a statement so they will also display the value w/ the quotes on the webpage in ASP.

I have this so far:
PERFORMER_NAME= Replace(Info("performer_name"),,)

Thanks!

mattglet

11:09 pm on Apr 11, 2006 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



PERFORMER_NAME= Replace(Info("performer_name"),"""", """)

Headed North

3:20 am on Apr 12, 2006 (gmt 0)

10+ Year Member



thanks mattglet! Worked perfect.