Hello Pmp Experts,I need your help on how to select and extract value from executing sql using ajax. Here is my code:var sur_amt = ew_Ajax(“<?php echo ew_Encrypt("SELECT top 1 isnull(amount,0)
FROM ln_loanfines WHERE loanid = '{query_value_1}' AND transid = '{query_value_2}'") ?>” ,
{q1:loanid,q2:23});What I need is to include multiple fields, since the code above select only single field
Since you use ew_Encrypt(), you must be using PHPMaker < 2019. Anyway, the Ajax result depends on your SQL, you select one field, the result is a value. If you select more than one field, the result is a JavaScript object.