2 Replies Latest reply: Jul 13, 2010 3:20 PM by 736634 RSS

    Campaign SQL Query Question

    736634
      I have a table that has at least 40 values that I need to use as variables in CCA. My questions is. If I write query as follows;

      SELECT VALUE1 AS $Var1, VALUE2 AS $Var2 , ETC.... I would have to do this for 40 fields. Would it work if I simply do a query where I

      SELECT * FROM DBNAME WHERE CALLER = '$ANI'

      and then just use the column names as variables?