LAE

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: gabygyy

hi,

i'm interested to use a value return by an sql code as a parameter in the graph.
for example the sql code will return always 1 line with one or more columns, the value inside one column can be a column name or an array containing more columns comma separated. In the graph i need for example to make a join after that columnname or after that array containing more columns.
How can i do this? using sql as a graph param or other solutions
thx
Gaby

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: mgajdosik

Hi,

to be honest I don't think that something like this is possible. You may try to use python node, but then still this python node would have to contain the logic for join itself. However I find this as a nice to have feature, to have something like function in brainscript "setParameter".

Marek

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: stonysmith

You can construct a SQL statement using any method, and then execute it with the DbExecute node.
The database engine will restrict you to a single SQL SELECT statement, but you can execute as many UPDATE or INSERT statements.