Passing Field value in an External Script

nserpiot · Post by **nserpiot** » Fri Oct 03, 2014 4:34 pm

I need to pass the Field value, as a variable in a Server script, in order to call a PHP page.
I know that for getting the value is : $myVar = CurrentPage()->myField->CurrentValue;
How can I use $myVar after a DELETE page finishes, so as to run a server script using this variable ?

scs · Post by **scs** » Fri Oct 03, 2014 7:42 pm

How about
$SESSION["var"] = CurrentPage()->myField->CurrentValue; // Assign
unset($SESSION["var"]); // Release

nserpiot · Post by **nserpiot** » Fri Oct 03, 2014 8:03 pm

OK, but how can I take the value of a Field that is going to be deleted ?

scs · Post by **scs** » Fri Oct 03, 2014 8:18 pm

Try

$_SESSION["var"] = $rs["the_field_name"];

nserpiot · Post by **nserpiot** » Fri Oct 03, 2014 8:35 pm

No, it does not returns the value.

nserpiot · Post by **nserpiot** » Fri Oct 03, 2014 9:01 pm

Is it possible to make a select before the Delete and take the value needed ?
Please sent me an example, since I can not accomplished it.

eg $myvar = ew_Execute("SELECT FileIN FROM test WHERE FileIN=" . $rs["FileIN"]);

scs · Post by **scs** » Sat Oct 04, 2014 12:06 am

Place the code in Row_Deleting (not Row_Deleted)

nserpiot · Post by **nserpiot** » Sat Oct 04, 2014 3:36 am

Î¤hat's OK. Thank you scs.But can I busy you a little more?
I can not use the SELECT through ew_Execute and the mistake is always a syntax error. Could you give me an example lile the below ?

ew_Execute("SELECT FileIN FROM test WHERE FileIN=" . $rs["FileIN"]);

scs · Post by **scs** » Sat Oct 04, 2014 6:09 am

nserpiot wrote:
ew_Execute("SELECT FileIN FROM test WHERE FileIN=" . $rs["FileIN"]);

for string
where fieldname = 'ABC';

for numeric
where fieldname = 123;

see the different?

Look like your FileIN is string, so the correct syntax is
WHERE FileIN = '". $rs["FileIN"] ."';";

Hope this help.