How to deal with "&" in ASP/SQL

Results 1 to 2 of 2

Thread: How to deal with "&" in ASP/SQL

  1. #1
    Oxynaz Guest

    Default How to deal with "&" in ASP/SQL

    hi,<BR>some months ago i readed an article "how to deal with apostrophes in your sql string" from this website, <BR><BR>now i need to know how to deal with this symbol "&" in Sql strings, plz hlp me<BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: How to deal with

    I believe you can do the same as you would do with the "&#039".... I alsways do this using the replace function... Duplicating the symbol fixes it...<BR><BR>replace(rs.fields("fieldname"),"&#039 ","&#039&#039")<BR><BR>thus,<BR><BR>replace(rs.fie lds("fieldname"),"&","&&")<BR><BR>I think this would be the solution... although I&#039ve next actually tried it....I could be talking complete crap! :o)<BR><BR>

Posting Permissions

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