1. Home

Product groups

Support

Apostrophe ' problem - WeOnlyDo Discussion board

Apostrophe ' problem (General questions)

by Skc, Monday, September 24, 2007, 10:56 (6270 days ago)

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?

locked
  1649 views

Re: Apostrophe ' problem

by wodDamir, Monday, September 24, 2007, 12:09 (6270 days ago) @ Skc

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

locked
  1494 views

Re: Apostrophe ' problem

by skc, Monday, September 24, 2007, 14:06 (6270 days ago) @ wodDamir

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.

locked
  1511 views

Re: Apostrophe ' problem

by wodDamir, Monday, September 24, 2007, 14:38 (6270 days ago) @ skc

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

locked
  1500 views

Re: Apostrophe ' problem

by Skc, Monday, September 24, 2007, 16:40 (6270 days ago) @ wodDamir

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

locked
  1483 views

Re: Apostrophe ' problem

by woddrazen, Monday, September 24, 2007, 16:44 (6270 days ago) @ Skc

Hi Skc,


IEWatch is working with Internet Explorer.

Please try it and let us know how it goes.


Regards,
Drazen

locked
  1501 views

Re: Apostrophe ' problem

by Skc, Tuesday, September 25, 2007, 05:18 (6269 days ago) @ woddrazen

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.


locked
  1502 views

Thank you so much for your hard work and commitment in producing well thought-out solutions. WeOnlyDo is very committed to customer satisfaction!

Mike McPherson
Nokia Inc.

Thank you for the great customer service ... I am really impressed with the wodSSH ActiveX control.

Andrew Ross
Kiwi Enterprises

This has been, by far, the best experience I have ever had dealing with a support entity in my long career in the technical arena

Frank Kloskowski
GlobalCare Inc.

We are having great success with your component ... email server that has over 750 000 mailboxes back ended by a SQL server...

Conrad Leigh
Leaf Wireless

Many thanks for your excellent support service. I can see why you have a long list of excellent testimonials on your website.

Martyn Walker
Batmore Technolgies

...what I really like is that wodSSH and wodSFTP components work excellently and are constantly being improved...

Steven Jones
SABIEN project

...what I really like is that wodSSH and wodSFTP components work excellently and are constantly being improved...

Steven Jones
SABIEN project

It is very refreshing to find such helpful, knowledgeable and quick responding technical support.

Jason Sears
CompuSource Systems, Inc.

...with WOD's excellent support I was able to bypass Winsock and focus on the task at hand...

Sander Pool
Rhapsody Networks

Not only wodSFTPdll is excellent, the service you have provided is outstanding and second to none!

Ian D. Mead, author of UltraEdit-32
IDM Computer Solutions