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.



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";







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