single code problem

[parames]

Hi list,
I need to transfer data from txt file to my database.
Most of the data is somesort like this:

GD3025006861168K|SITS01|220164 |DEL:EXPORT PACKING, FOR MONTH OF DEC'00

I use the split function to split the data..

The problem is, my sql statement stops running whenever there is a single code (') in my .txt file and prompt error message. Some of the data don't have the single code ..

How to solve this problem..

thanks a lot,
Parames.s

 

[iqof188]

Try to place Server.URLEncode around the variables you send to the SQL query, it should escape the single quotes. Hope this helps...


<webguru>iqof188</webguru>