Passing Parameters to a Web Service

[RichBowman]

In my testing I've noticed that an & in the data stream can cause problems (when passing the parameter as a string to the url).

Are there other characters that should be off limits?

Also I'm having trouble understanding the "Clarion" way of calling this web service and passing it a JSON string with multiple records. Any sample code excerpts would be very welcome.

[Bruce]

Hi Rich,

>> In my testing I've noticed that an & in the data stream can cause problems (when passing the parameter as a string to the url).
>> Are there other characters that should be off limits?

yes, there are a few. &, <, > " and '

There is a method
string = p_web._jsok(string)
that "sanitizes" the text. This is automatically called for browses and forms and so on, so if you are seeing it cause a problem then let me know where (specifically) the text is so I can check and see.

cheers
Bruce

[RichBowman]

Just to be clear, we should avoid these in our data, so:

Bruce & Sons Lumber Co. should be Bruce and Sons Lumber Co.

Bruce's Cabinet Shop should be Bruces Cabinet Shop

Correct?

[bshields]

Hi Rich,

You can't really avoid "Bruce & Sons Lumber Co." unless your users are fabulously well behaved.

But if you run your fields through p_web._jsok() it will fix them.

eg:

Bruce & Sons Lumber Co.

becomes

Bruce &amp; Sons Lumber Co.

NetTalk does this automatically pretty much all the time for you. But, there are times when you've got to do this yourself. Eg, if you are constructing a URL, then you must URL Encode the string.

Regards
Bill

[RichBowman]

Clear explanation.

Thank you,