Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: alwy ali
  Where is alwy ali?
 mombasa
 Kenya
 alwy ali
 To: Marco Plaza
  Where is Marco Plaza?
 Caracas
 Venezuela
 Marco Plaza
 Tags
Subject: RE: JSON to cursor
Thread ID: 344769 Message ID: 345178 # Views: 50 # Ratings: 0
Version: Visual FoxPro 9 SP2 Category: Web Applications
Date: Saturday, May 19, 2012 4:42:52 PM         
   


Hi Marco.

Thanks i have seen that, i really like it. It simple and very straight forward to learn with plenty of examples.
for Vfp developers it really serves the purpose.
Thanks again.

Sincerely

Alwy Ali.



> I've uploaded a json page on my web server for anybody
> who wants to test the victor's qdfoxjson library ( download at http://qdfoxjson.codeplex.com/releases/view/87290 )
>
> This code executes a query on my web server that returns a json string,
> and converts it to a vfp cursor for browsing.
>
>
> *********************************************************
> * vfp internet json client
> *********************************************************
> CLEAR
>
> LOCAL loXMLHTTP as "MSXML2.XMLHTTP"
> loXmlHttp = CREATEOBJECT("MSXML2.XMLHTTP")
>
> WITH loXmlHttp
>
> .open("GET", "http://micaja.dyndns.biz/pruebas/jsontest.aprg",.f.)
> .Send()
> jsonString= .responseText
>
> ENDWITH
>
> SET PROCEDURE TO qdfoxjson.prg
>
> jsonstart()
> json.parseCursor(jsonString,'CursorTest')
>
> BROWSE
>
> ******************************************************
>
> ********************************
> * server side vfp script: ( active vfp / web connection )
> * this is all it takes to send a server query
> * over internet json encoded with victor's qdfoxjson library:
> ********************************
>
> <%
>
> SET PROCEDURE TO qdfoxjson
>
> jsonstart()
>
> SELECT * TOP 3 FROM employees ORDER BY 1 into cursor jsontest
>
> cJson=json.encodecursor(ALIAS())
>
> %>
>
> <%=cJson%>
>
> **********************************
>
> Marco

ENTIRE THREAD

JSON to cursor Posted by alwy ali @ 5/13/2012 9:51:46 PM
RE: JSON to cursor Posted by Anders Altberg @ 5/14/2012 2:14:21 AM
RE: JSON to cursor Posted by alwy ali @ 5/14/2012 7:25:25 PM
RE: JSON to cursor Posted by Cetin Basoz @ 5/14/2012 1:17:56 PM
RE: JSON to cursor Posted by alwy ali @ 5/14/2012 7:56:59 PM
RE: JSON to cursor Posted by Cetin Basoz @ 5/15/2012 12:48:50 PM
RE: JSON to cursor Posted by alwy ali @ 5/15/2012 7:08:48 PM
RE: JSON to cursor Posted by claude fox @ 5/14/2012 1:29:12 PM
RE: JSON to cursor Posted by michael johnson @ 5/14/2012 1:29:59 PM
RE: JSON to cursor Posted by alwy ali @ 5/14/2012 8:10:10 PM
RE: JSON to cursor Posted by Marco Plaza @ 5/18/2012 11:59:22 PM
RE: JSON to cursor Posted by claude fox @ 5/14/2012 2:52:19 PM
RE: JSON to cursor Posted by claude fox @ 5/14/2012 8:18:48 PM
RE: JSON to cursor Posted by alwy ali @ 5/15/2012 7:05:06 AM
RE: JSON to cursor Posted by Martin Krivka @ 5/15/2012 4:28:17 PM
RE: JSON to cursor Posted by alwy ali @ 5/15/2012 11:24:25 PM
RE: JSON to cursor Posted by claude fox @ 5/16/2012 3:23:23 AM
RE: JSON to cursor Posted by alwy ali @ 5/17/2012 12:12:14 AM
RE: JSON to cursor Posted by claude fox @ 5/17/2012 4:51:40 AM
RE: JSON to cursor Posted by Martin Krivka @ 5/16/2012 8:53:15 AM
RE: JSON to cursor Posted by alwy ali @ 5/18/2012 7:54:29 PM
RE: JSON to cursor Posted by alwy ali @ 5/18/2012 9:07:32 PM
RE: JSON to cursor Posted by Martin Krivka @ 5/20/2012 11:54:47 AM
RE: JSON to cursor Posted by alwy ali @ 5/23/2012 9:40:39 PM
RE: JSON to cursor Posted by Martin Krivka @ 5/24/2012 8:26:52 AM
RE: JSON to cursor Posted by alwy ali @ 5/24/2012 5:44:06 PM
RE: JSON to cursor Posted by Martin Krivka @ 5/25/2012 7:48:27 AM
RE: JSON to cursor Posted by alwy ali @ 5/25/2012 10:25:56 AM
RE: JSON to cursor Posted by alwy ali @ 5/25/2012 6:22:52 PM
RE: JSON to cursor Posted by alwy ali @ 5/14/2012 8:37:24 PM
RE: JSON to cursor Posted by Marco Plaza @ 5/19/2012 12:20:36 AM
RE: JSON to cursor Posted by alwy ali @ 5/19/2012 4:42:52 PM