Update variable from SQL node

[terry_stjean]

Is there anyway to update a variable from a SQL node or do I need to use a Procedure node?

[MFGF]

Hi,

You can reference a variable to grab its contents from within a SQL node, but there is no way of updating it from within the node. Your best bet is to use a procedure node to update the variable.

If you want to return the results of a select (for example) into a variable, just use a lookup() function within your Procedure node

eg

$YourVariable := lookup('Your Data Source','select max(xxx) from yyy');

Cheers!

MF.

[terry_stjean]

Thank you.