Page 2 of 4

Connection with MSSQL and php

Posted: Thu May 15, 2014 7:34 pm
by Stelios Geo

Hello! Im afraid i do not understand :-) call it from where? I only call it on the load, just excaclty as the example with the integrated database you have in docs :-) do i need to call it before? I can upload some screenshots with thei events, ifthat helps you :-)
Thank you..


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:
Image

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"