I'm tryng to use SqlQuerywidget with Postgis database, but i've some problems!<br>
<br>
i've added this in my html page<br><br><cwc2 type="SharedResource" name="postresource"><br>
<POINTS Name="SearchResults" SRName="postresource"
SRLATCOL="f_latitude" SRLONCOL="f_longitude" siteName="f_csinitname"
/>
<br></cwc2><br><br><br>and this<br><br><CWC2 TYPE="SQLQuery"
VISIBLE="TRUE" ENABLED="TRUE" SQLQUERY="SELECT random();"
SERVER="localhost" DATABASE="name of Database" <br>USERNAME="my_user" PASSWORD="my_pass" DBTYPE="PGSQL" SHAREDRESOURCENAME="postresourc<div id="mb_0">e" SAVEQUERY="TRUE"/> </CWC2>
<br><br><br>My application doesn't work and i've only a white page!
<br><br><br>if i remove <CWC2 TYPE="SQLQuery" VISIBLE="TRUE" ENABLED="TRUE" SQLQUERY="SELECT
random();" SERVER="localhost" DATABASE="name of Database" <br>
USERNAME="my_user" PASSWORD="my_pass" DBTYPE="PGSQL" SHAREDRESOURCENAME="postresource" SAVEQUERY="TRUE"/> </CWC2><br><br>all is fine!<br><br>what is wrong??<br><br>
Thanks in advance</div>