<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2900.2802" name=GENERATOR></HEAD>
<BODY style="MARGIN: 4px 4px 1px; FONT: 10pt Tahoma">
<DIV>Hi list,</DIV>
<DIV> </DIV>
<DIV>I have two related problems:</DIV>
<DIV> </DIV>
<DIV>1)</DIV>
<DIV>I've configured a report using the table widget based on the SQL query widget and would like this report to be a popup window. </DIV>
<DIV> </DIV>
<DIV>I think the best solution might be to incorporate the popup widget's functionality into the table widget (creating a new widget), but I'm guessing there might be a simpler solution. I've been going around in circles for a few days on this and am rather stuck.</DIV>
<DIV> </DIV>
<DIV>2)</DIV>
<DIV>Is it possible to pass php variables into the SQL Query? I have coordinates stored in variables to generate a spatial query, but am running into parse errors when I use SQL similar to that used in generating a new layer on the map, snippet as follows:</DIV>
<DIV><EM>where the_geom && SetSRID('BOX3D($rMinX $rMaxX,$rMinY $rMaxY)'::box3d,-1) AND within(the_geom, SetSRID('BOX3D($rMinX $rMaxX,$rMinY $rMaxY )'::box3d,-1));</EM></DIV>
<DIV> </DIV>
<DIV>Does anyone have any advice or a step in the right direction for these items?</DIV>
<DIV>Thanks in advance,</DIV>
<DIV>Jessica</DIV></BODY></HTML>