Hi, I use the smart node "Query database". Someone has try t

Victor Bouchery

A Score Level 2

over 8 years ago

Hi,
I use the smart node "Query database".
Someone has try to use a "data inupt" to specify a field's name on my SQL query?
I have some identical requests on differents fields, and for now i use several "query database" nodes.
Thanks in advance.

Discussion posts and replies are publicly visible

Parents

0 Chris over 8 years ago

I don't believe you will be able to dynamically define the selection fields with the Query Database node. You can either pull back all columns you would need in each query, or run multiple Query DB nodes as you are now. Another alternative would be to use the Execute Stored Procedure node - create a procedure in SQL that allows you to send column name as an input, for use in a dynamic query there.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Chris over 8 years ago

I don't believe you will be able to dynamically define the selection fields with the Query Database node. You can either pull back all columns you would need in each query, or run multiple Query DB nodes as you are now. Another alternative would be to use the Execute Stored Procedure node - create a procedure in SQL that allows you to send column name as an input, for use in a dynamic query there.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data