Newbie Database Problem

Results 1 to 2 of 2

Thread: Newbie Database Problem

  1. #1
    Join Date
    Dec 1969

    Default Newbie Database Problem

    I am using asp to insert/select information from a database field. I need to have the functionality to have single and double quotes in the database field and retrieve them back with the quotes. Is there an easy way to do this?<BR>

  2. #2
    Join Date
    Dec 1969

    Default Yep

    Just leave them in there. Just make sure when querying or inserting or anything that you replace single quotes with a doubled up version:<BR><BR>var = replace(var, "&#039;", "&#039;&#039;")

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts