Search found 30 matches

Go to advanced search

by Stelios Geo
Fri May 16, 2014 2:46 pm
Forum: Issues
Topic: Connection with MSSQL and php
Replies: 32
Views: 2718
 
Jump to post

Connection with MSSQL and php

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 pa...
by Stelios Geo
Fri May 16, 2014 1:31 pm
Forum: Issues
Topic: Connection with MSSQL and php
Replies: 32
Views: 2718
 
Jump to post

Connection with MSSQL and php

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..

by Stelios Geo
Fri May 16, 2014 11:25 am
Forum: Issues
Topic: Connection with MSSQL and php
Replies: 32
Views: 2718
 
Jump to post

Connection with MSSQL and php

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

by Stelios Geo
Fri May 16, 2014 6:56 am
Forum: Issues
Topic: Connection with MSSQL and php
Replies: 32
Views: 2718
 
Jump to post

Connection with MSSQL and php

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.

by Stelios Geo
Thu May 15, 2014 7:34 pm
Forum: Issues
Topic: Connection with MSSQL and php
Replies: 32
Views: 2718
 
Jump to post

Connection with MSSQL and php

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..

by Stelios Geo
Thu May 15, 2014 1:07 pm
Forum: Issues
Topic: Connection with MSSQL and php
Replies: 32
Views: 2718
 
Jump to post

Connection with MSSQL and php

Hi Maryana, So, ok I uncheck the Proxy option. I receive the expected response from server as you see in the last screenshot of my previous post. It is in json format and the field is USR_FULL_NAME : Administrator Now, i have binded the this field with a label on my program as you see on the last sc...
by Stelios Geo
Thu May 15, 2014 10:10 am
Forum: Issues
Topic: Connection with MSSQL and php
Replies: 32
Views: 2718
 
Jump to post

Connection with MSSQL and php

Hi Katya, Thank you very much for your reply. As i understand correctly I just need a proxy service between the json parsing and the REST service. So i made one as you can see below: Here i just created a proxy with a name https://d2r1vs3d9006ap.cloudfront.net/s3_images/1056399/5_inline.jpg?14001483...
by Stelios Geo
Thu May 15, 2014 7:14 am
Forum: Issues
Topic: Connection with MSSQL and php
Replies: 32
Views: 2718
 
Jump to post

Connection with MSSQL and php

Forgive me, the event is "Load" on the startScreen component. thats where I invoke my MSSSQL service. i have some screenshots that might help you a bit. on this picture i have my url with the .php file (inside the php is just a select statement) https://d2r1vs3d9006ap.cloudfront.net/s3_ima...
by Stelios Geo
Wed May 14, 2014 5:36 pm
Forum: Issues
Topic: Connection with MSSQL and php
Replies: 32
Views: 2718
 
Jump to post

Connection with MSSQL and php

Evgene, thank you very much for your quick reply. I had created a REST service, using the url and i have a parameter "q" when i set a value to this parameter (lets say, 1) in the test response, i get the desired result as json :) Also i have set the table field in the "Response" ...
by Stelios Geo
Wed May 14, 2014 11:37 am
Forum: Issues
Topic: Connection with MSSQL and php
Replies: 32
Views: 2718
 
Jump to post

Connection with MSSQL and php

How can i connect my MSSQL database to an application? i have allready an IIS installed and i have a url with .php encoding and exporting data with json format. how can i show the results to an appery application?

Go to advanced search