Evgene Karachevtsev
Posts: 12
Joined: Mon Apr 28, 2014 1:12 pm

Correct syntax for database request

Hello Joe,

Please check your MessagesDB_statusupdate_list_service now. I just set up method POST instead of GET in Settings. Now response looks like good response.

Joe Bohen
Posts: 0
Joined: Wed Nov 28, 2012 11:28 am

Correct syntax for database request

Hi Evgene, Thanks for the information. The data returned does not take into account the between date parameters. Is this possible?

Evgene Karachevtsev
Posts: 12
Joined: Mon Apr 28, 2014 1:12 pm

Correct syntax for database request

Joe,

As I can see you haven't search between 2 dates at your 'where' parameter now http://gyazo.com/6e8324cbb3d118f46478...
Please try to add them

Joe Bohen
Posts: 0
Joined: Wed Nov 28, 2012 11:28 am

Correct syntax for database request

Hi I have a greater than parameter in the where clause this doe's not appear to have any effect on the query!

http://gyazo.com/3a5da08d30a2c51cfdc9...

Evgene Karachevtsev
Posts: 12
Joined: Mon Apr 28, 2014 1:12 pm

Correct syntax for database request

Joe,

Could you please share your data base with support and tell us its name?

Joe Bohen
Posts: 0
Joined: Wed Nov 28, 2012 11:28 am

Correct syntax for database request

I have shared the data base with support.

Joe Bohen
Posts: 0
Joined: Wed Nov 28, 2012 11:28 am

Correct syntax for database request

Do you have any update on this?

Illya Stepanov
Posts: 0
Joined: Mon Mar 18, 2013 8:48 am

Correct syntax for database request

Hi Joe -

Unfortunately nothing yet. We'll post an update as soon as possible.

Joe Bohen
Posts: 0
Joined: Wed Nov 28, 2012 11:28 am

Correct syntax for database request

Hi do you have any news on this please?

Evgene Karachevtsev
Posts: 12
Joined: Mon Apr 28, 2014 1:12 pm

Correct syntax for database request

Hello Joe,

Unfortunately it seems to be a bug we are working on it
For the more:
1) you had wrong url for your service
2) also there should be method GET instead of POST

Return to “Issues”