AnsweredAssumed Answered

EXECUTESQL() and I'm stumped

Question asked by aknudsen on Mar 20, 2017
Latest reply on Mar 20, 2017 by alecgregory

Trying to declare an SQL statement with a variable, but I just can't get it to work. Using FM 15.

 

LET(

publicaddress = $$publicaddress;

 

ExecuteSQL ("select DISTINCT app, dport, protocol FROM pathfinder

                       WHERE dstloc IS NOT NULL

                       AND fromzone = 'ae_ext_in'

                       AND tozone = 'ae_ext_out'

                       AND src = ?

                      ORDER BY app";

"";"";

"";"";

publicaddress

)

)

 

If I replace the AND src = 'xx.xx.xx.xx' it works just as it should. I've also tried public address = "'" & $$publicaddress & "'" with no luck. The $$publucaddress value is text and I've also tried GetAsText() with the same result.

 

This can't be that difficult

Outcomes