Page 2 of 4
Connection with MSSQL and php
Posted: Thu May 15, 2014 7:34 pm
by Stelios Geo
Connection with MSSQL and php
Posted: Thu May 15, 2014 8:00 pm
by Evgene Karachevtsev
Could you please give us public link to your application: http://docs.appery.io/documentation/s... and steps to reproduce the error
Connection with MSSQL and php
Posted: Fri May 16, 2014 6:56 am
by Stelios Geo
Sure Evgene, there you go:
http://appery.io/app/mobile-frame?src...
Well actually I dont get an "error" but in debug mode from chrome, the Network status of my php file is (canceled).
What have I done wrong? 
Thank you.
Connection with MSSQL and php
Posted: Fri May 16, 2014 8:52 am
by Kateryna Grynko
Hi,
As we can see, you invoke SQLService on Load event, with proxy disabled. What parameters do you need to pass to server? Only 'q'? Why do you pass 'appery-rest' and 'appery-transformation'?
Connection with MSSQL and php
Posted: Fri May 16, 2014 11:25 am
by Stelios Geo
Hi, yes proxy is disabled as Maryna told me. I pass only q as parameter, the others (appery-rest and appery-transformation) took them from the example.. i guess they are not needed, right? how can this play anyway? 
Thank you for your replies 
Connection with MSSQL and php
Posted: Fri May 16, 2014 1:16 pm
by Kateryna Grynko
Hi,
Create a proxy here https://appery.io/proxy/ and specify it in service settings.
As we can see from Postman, an incorrect JSON is generated on your site:
However, you can use such service, just create service response parameters:
http://docs.appery.io/documentation/r...
Connection with MSSQL and php
Posted: Fri May 16, 2014 1:31 pm
by Stelios Geo
Hi Katya,
Yes i had done this thing with the proxy, but the JSON format seems to be valid, doesn't it? I mean the http://jsonlint.com validates my response :-/
The fields 0, 1, 2 are not used, I just use the USR_FULL_NAME one.
How my JSON should be generated?
Thank you..
Connection with MSSQL and php
Posted: Fri May 16, 2014 2:34 pm
by Kateryna Grynko
Sorry, I misunderstood you, I thought you did not need such parameters.
It is valid. Let us know if you have any other questions.
Connection with MSSQL and php
Posted: Fri May 16, 2014 2:46 pm
by Stelios Geo
Well, as a matter of fact, i get the following error in my chrome:
GET https://api.appery.io/rest/1/proxy/tu... 400 (Bad Request) and link says :
{"code":"PTCT010","description":"Mandatory parameter 'appery-rest' is missing"}
even though i already have this parameter and the value is my Proxy ID just like the doc: http://docs.appery.io/documentation/s...
Connection with MSSQL and php
Posted: Fri May 16, 2014 7:12 pm
by Evgene Karachevtsev
Hello Stelios,
You don't need to add any request parameters like "appery-rest" manually. You should delete them. Your service should have one request parameter "q" and use Appery,io proxy.
But you have changed file "StartScreen.js" manually. So it won't change from appery builder anymore. So you need delete it and then execute "undo all source changes"