Re: Access foxweb\'s JSON sting in Javascript

Thanks for the idea. It worked perfectly. Below is the working javascript function.

function servLookup1() {

var scharge = JSON.parse('<%=SchargeJSON%>');

var needle = document.getElementById("servcode1").value;

needle = needle.trim();

var i;

for (i = 0; i < scharge.rows.length; i++){

if (scharge.rows[i].servcode == needle){

break;

}

document.getElementById("servprice1").value = scharge.rows[i].servprice;

var x1 = document.getElementById("servqty1").value;

var y1 = document.getElementById("servprice1").value;

var z1 = parseInt(x1) * parseInt(y1);

document.getElementById("servamt1").value = z1;

var a1 = z1;

var a2 = document.getElementById("servamt2").value;

var a3 = document.getElementById("servamt3").value;

var a4 = document.getElementById("servamt4").value;

var a5 = document.getElementById("servamt5").value;

var aTot = parseInt(a1) + parseInt(a2) + parseInt(a3) + parseInt(a4) + parseInt(a5);

document.getElementById("demandamt").value = aTot;

}

Sent by FoxWeb Support on 08/07/2018 02:13:35 AM:

Jeff's response describes the more common (and probably better method) of retrieving data through separate ajax calls. If you would like to return the data with your HTML and javascript code, you can dynamically generate the javascript as follows:

SELECT * FROM SON5200 INTO CURSOR crScharge ORDER BY Servcode

IF _TALLY > 0

SchargeJSON = fwJSON.WriteCursor()

ENDIF

var scharge = JSON.parse('<%=SchargeJSON%>');

...JS code that uses the data in the scharge variable

</script>

Note the the above code is just an example to illustrate this specific technique. You should probably make sure to not create variables in the global scope and in general use modern JS practices.

FoxWeb Support Team
support@foxweb.com email

Sent by Olatunji Beckley on 08/05/2018 02:42:30 PM:

The foxweb script below already stores the json string to the variable SchargeJSON.

(Sample Foxweb Script):

SELECT * FROM SON5200 INTO CURSOR crScharge ORDER BY Servcode

IF _TALLY > 0

SchargeJSON = fwJSON.WriteCursor()

ENDIF

In the same foxweb script, i have a form with a select input type with the onchange event attribute that calls a javascript function "servLookup1()". See the script below.

The problem is that i need to reference the foxweb variable "SchargeJSON" in the javascript.

Sent by Jeff Grippe on 08/01/2018 08:46:16 PM:

Hello,

I think you need to use Response.Write(fwJSON.WriteCursor()) so that the FWX will return json instead of a page. Then all you have to do is to write an ajax/ http request.

users={}

$http.get('\getusers.fwx').then(function(resp){

users =resp.data;

});

Sent by Olatunji Beckley on 07/27/2018 04:02:09 PM:

Hi All,

This is really not a foxweb issue, but need someone to help or suggest a solution.

I would like to access a json string generated with fwJSON.WriteCursor() as a JSON object in javascript function.

E.g. (Sample Foxweb Script):

SELECT * FROM SON5200 INTO CURSOR crScharge ORDER BY Servcode

IF _TALLY > 0

SchargeJSON = fwJSON.WriteCursor()

ENDIF

Is there a way to reference the SchargeJSON variable/object in a javascript function?

TIA