cannot update data has apotrophe with ODBC

[firehorse24]

Hi Guys,

Hope someone can help me with this issue.

I have an asp script updating dbf with ODBC. The dbf is in AS400. Since in the data contain an apostrophe, Like "INT'L". The objconn.excute(sql) failed with the error message:

Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)[IBM][iSeries Access ODBC Driver][DB2 UDB]SQL0104 - Token L was not valid. Valid tokens: )

What can I do to make objconn.excute(sql) accept this kind of data? Please help. Appreciate a lot !!!

Thanks !!!

 

[firehorse24]

Hi Guys,

Sorry, I searched the history of the forums, Got the answer.

Just replace "'" with "''". It works good.


Thank you all !!!

 

[gbaughma]

Yup.

string = replace(string,"'","''")



Just my 2¢
-Cole's Law: Shredded cabbage

--Greg

http://parallel.tzo.com