Apostrophe ' problem (General questions)

Using the Formpost.Add method.

I notice that when I do formpost.Add of character string:
space is translated by your program to become + (I thought it should be 20 ?)

becomes 2F
' becomes 27

+, 20, 2F seems to work fine. but not 27.

Why does the apostrophe cause problem? Among other data, I have a companyname data eg. ALex's Company formpost.Add and Post(). The receiving program did not update . IS this a problem with the 27 or is it a problem with the receiving program?

Thanks for any clue.

Can someone also point me to some documentation for translation of symbols if I were to string it myself?

Hi Skc,

I'm not really sure what is wrong here. When I do a FormPost.Add for a string ALex's Company I receive the output of ALex 27s+Company which is exactly how it should look like.

Could you explain it a bit more thorougly?

Regards,
Damba

Yes Alex's Company is output as Alex 27+Company - that's correct. Somehow when Post, the database was not updated. If I remove the apostrophe to become Alex Company , then it updates the database fine.

The SQL database and the .asp program that I call belong to another third-party vendor I am trying to work with. I am not sure whether this is caused by your com component or whether it's a bug in the 3rd-party .asp program that is called. What do you think?

Thanks.

Skc,

You can update it if you use IE or FireFox?

Maybe you could use a program like IEWatch to check what exactly is sent by IE when the update is successful and try to mimic it's behaviour?

That way you could probably see why it fails and what went wrong.

Regards,
Damba

Their web application is written in visual basic and seem to work only with IE. Not with firefox.

Anything else beside IEWatch that can be used? Thanks

Hi Skc,

IEWatch is working with Internet Explorer.

Please try it and let us know how it goes.

Regards,
Drazen

Hi Guys

I have tried all special symbols and they are able to post and update the SQLdatabase correctly except for apostrophe. On further checking, the cause is most likely the 3rd-party .asp program. There is a build-up of SQL command within the .asp and it makes use of both and ' to do the build-up. So my guess is that passing a ' probably cause the problem.

Thank you for your input. I will continue to test your component.