[Chameleon] Re: SQL: Error registering widget

[Julien-Samuel Lacroix]

Hi Steven,

First, please use the mailing list for chameleon specific questions. You 
will have more chances to get help.

For your specific question, I think you are right, the widget is not 
correctly registered in your CWC2 instance. You use CWC2 right, not 
chameleon? I will suggest you to upgrade to the latest version of 
chameleon if it's possible. If you can't upgrade, then you will need to 
register the widget. I think the only thing you have to do is to add 
this at the bottom of your widget file:

//register widget
if (function_exists( "RegisterWidget" ))
     RegisterWidget( "QuickZoom", "QuickZoomWidget" );

just before the "?>". It's possible that I forgot a step to register 
widget, so if it does not work, let us know via the mailing-list. Also, 
you may encounter some problem because the SQLQuery widget have been 
design on chameleon 1.1, so it may have so problem to work directly out 
of the box with CWC2. Let us know.

Cheers,

Julien

D'cruz,Steven [Ontario] wrote:
> Greetings,
> 
>         In regards to the Chameleon application, I've recently attempted 
> to configure Chameleon for use with the SQLQuery widget.  I've added 
> SQLQuery.widget.php, MapImageSharedResource.widget.php, expression.php, 
> and geomath.php.  I've inserted the following line of code into the 
> template right before the image projection (MapDHTMLImage) for testing 
> purposes;
> 
> <CWC2 TYPE="SQLQuery" SharedResourceName="Station" SQLQUERY="SELECT * 
> FROM STATIONINFO" Server="server.name.com" DATABASE="databasename" 
> USERNAME="username" PASSWORD="password"/>
> 
> Where STATIONINFO is a table in the database, and I've used the proper 
> username/password/server/database selections.
> 
> Whenever the CWC2 instance is run, the following error results in a 
> popup box;
> ERROR: Widget Definition for SQLQuery not found. 
> 
> In addition, the following code appears immediately before the projected 
> map image;
> <CWC2 TYPE="SQLQuery" SharedResourceName="Station" SQLQUERY="SELECT * 
> FROM STATIONINFO" Server="server.name.com" DATABASE="databasename" 
> USERNAME="username" PASSWORD="password"/>
> 
> I'm of a mind that the problem has to do with the SQLQuery widget not 
> being properly added to our CWC2 instance, as it was copied from a -dev 
> instance widget folder to our production widget folder.  Any 
> suggestions/help would be graciously appreciated
> 
>                                                                         
>         -Steven D'Cruz
>                                                                         
>         Steven.Dcruz at ec.gc.ca
>                                                                         
>         GIS/Web Developer
>                                                                         
>         Environment Canada
> 

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