[Chameleon] SQlQuery Widget

[listserver server]

I'm tryng to use SqlQuerywidget with Postgis database, but i've some
problems!

i've added this in my html page

<cwc2 type="SharedResource" name="postresource">
    <POINTS Name="SearchResults" SRName="postresource" SRLATCOL="f_latitude"
SRLONCOL="f_longitude" siteName="f_csinitname" />
</cwc2>


and this

<CWC2 TYPE="SQLQuery" VISIBLE="TRUE" ENABLED="TRUE" SQLQUERY="SELECT
random();" SERVER="localhost" DATABASE="name of Database"
USERNAME="my_user" PASSWORD="my_pass" DBTYPE="PGSQL"
SHAREDRESOURCENAME="postresource" SAVEQUERY="TRUE"/> </CWC2>


My application doesn't work and i've only a white page!


if i remove <CWC2 TYPE="SQLQuery" VISIBLE="TRUE" ENABLED="TRUE"
SQLQUERY="SELECT random();" SERVER="localhost" DATABASE="name of Database"
USERNAME="my_user" PASSWORD="my_pass" DBTYPE="PGSQL"
SHAREDRESOURCENAME="postresource" SAVEQUERY="TRUE"/> </CWC2>

all is fine!

what is wrong??

Thanks in advance
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.maptools.org/pipermail/chameleon/attachments/20060224/b3e01bcb/attachment.html