[Chameleon] SQlQuery Widget

[Julien-Samuel Lacroix]

Hi,
I've never personnally used the PGSQL support in the SQLQuery widget, 
but I may have 2 suggestion for you.
1- Add the ConnectFailed event in your widget:
<ONEVENT Event="ConnectFailed" Text="Connection failed."/>
2- Remove the '@' in the SQLQuery file 
(chameleon/htdocs/widgets/SQLQuery/SQLQuery.widget.php)
around line 267 ($link = @pg_connect($szConnect);) you may see what happen.

Julien


listserver server wrote:
> 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="postresourc
> e" 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
> 
> 
> ------------------------------------------------------------------------
> 
> _______________________________________________
> Chameleon mailing list
> Chameleon at lists.maptools.org
> http://lists.maptools.org/mailman/listinfo/chameleon

-- 
------------------------------------------------------------
Julien-Samuel Lacroix            jlacroix at dmsolutions.ca
DM Solutions Group               http://www.dmsolutions.ca/
------------------------------------------------------------