Replacing Quotation marks in SQL

[nonni]

Hi.

I came across this site while looking for a function to replace Quotation marks in SQL.

This is my code.

<!-- Begin Code -->

Intro = Replace(Intro,"'","''")
Text = Replace(Text,"'","''")



SQL = "Insert Into Articles(AuthorId,CatId,TopstoryId,Headline,Subhea dline,Intro,Text) Values ('" & Request("AuthorId") & "','" & Request("CatId") & "','" & Request("TopStoryId") & "','" & Request("Headline") & "','" & Request("Subheadline") & "','" & Intro & "','" & Text &"')"

<!-- End Quote -->


Now the problem I have is that when I execute my sql server statement no value is written in the database for Intro and Text, can anyone see where I am going wrong?

[dorinbogdan]

Text could be a reserved word, use other var name instead, i.e. strText:

Intro = Replace(Intro,"'","''") 
strText = Replace(strText,"'","''")
 
SQL = "Insert Into Articles 
     (AuthorId, CatId, TopstoryId, Headline, Subheadline, Intro, [Text]) 
    Values ('" & Request("AuthorId") & "','" & 
             Request("CatId") & "','" & 
                           Request("TopStoryId") & "','" & 
             Request("Headline") & "','" & 
              Request("Subheadline") & "','" & 
             Intro & "','" & 
              strText & "')"