How to execute a stored procedure with date in adsweb

Question

I'm trying to execute a stored procedure in a http call to adsweb. The procedure calls for a date and a string. if i enter:

GetBalance?todate='2018-03-15'&phone='9999999' 

I get a: Error 7200: AQE Error: State = 07006; NativeError = 2109; [iAnywhere Solutions][Advantage SQL Engine]Conversion error

How would I enter the date? It works fine in Arc32 Thanks, Kim

Answer 1

I've done this a lot in the past so I know it works. Usually problems are due to special characters in the URI. First of all, don't include any actual quote characters in the URI string like you have in your example.

For example the URI would just be:

GetBalance?todate=2018-03-15&phone=9999999

The adsweb module parser will split the procedure arguments on the & character so you don't need to use quotes.

Also if you have parameter data with special characters like quotes or percents, you need to encode them prior to sending and the module will decode them for you. I use encodeURIComponent in javascript to encode them.