Hi All



how to insert double quotes into SQL table using ASP.



With Regards

Vivekanand.S

strSQL = _

    "INSERT INTO table1 (field1) " & _

    "VALUES('Here is some text with "" a double quote in it')



Cheers

Ken





~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

----- Original Message ----- 

From: <Vivekanand.S@i...>

To: "ASP Databases" <asp_databases@p...>

Sent: Thursday, June 28, 2001 5:20 PM

Subject: [asp_databases] >>To insert double quotes thro ASP into SQL table





: 

: Hi All

: 

: how to insert double quotes into SQL table using ASP.

: 

: With Regards

: Vivekanand.S

: 

Hi,



Try embedding the value of that column in single

quote.

Something like this



Mysql="insert <TABLENAME> Values('" & "Test "" String"

& "')"



assume that the table contains only one column, this

would insert the value in to the table as follows



ColumnName

-------------

Test " String



Let me know if it works.



Cheers

Vijay.G