displaying single quotes and double quotes

ren_123 · February 22nd, 2006, 05:13 AM

I am using ASP with MS Access. I store "orange" in database table. Now when i retrive this value and show it on page, it works fine.

    When i retirve this value and show in text box it display fine.

     i using <input type=text value='<%=querystring%>'>. But when i need to display 'apple',it cannot work. Please give me a solution to include both double quote and single quote.

    How can i display full value in text box.

ChrisScott · February 22nd, 2006, 05:39 AM

One way is...

Code:

<input type=text value="<%=Server.HTMLEncode(querystring)%>">

HTH,

Chris

rstelma · February 22nd, 2006, 02:17 PM

I'm not a 100% sure about Access but for MS-SQL you can use this on the insert. You may have to use this in conjunction with Chris' solution.

Replace([text value],"'","''")

This ends up writing only one single quote into the table cell.

This:

INSERT INTO Table1 (TheVar) VALUES ('This is the single ''apple'' and double "quotes" test')

Actual data in the table cell:

This is the single 'apple' and double "quotes" test