[Chameleon] SQL and Tables

[Sacha Fournier]

No. If you're gonna hard code the output and the SQL query, then make 
you wapquery widget extends from CWCWidget. Make sure you have a member 
for SQLQuery widget and Table widget in you wapquery widget (don t 
forget to include needed code). Then your wapquery widget have to take 
care of creating the SQLQuery and table widget instances and set the 
member values to what you need. Also make sure to call the right 
function for SQLQeury and Template at the right moment in you wapquery 
class (for instance, you'll probably want to call DrawPublish of Table 
widget inside your wapquery drawpublish function).


Rene Teniere wrote:
> Hi Sacha,
> 
> Just want to make sure I am about to do this right. I have my new
> widget created (almost), and am about to implement the sqlquery and
> table widget functionality. At the end of my wapquery class, would I
> copy and paste the sqlquery class after it and hard-code all the values
> like sqlquery, server, database... etc. and then do the same with the
> table widget?
> 
> Rene
> 
> 
>>>>Sacha Fournier <sfournier@dmsolutions.ca> 2004-02-02 9:36:36 AM
>>>>
> 
> Hi,
> 
> Sure it can be done. There's many way to do this. First you can make 
> your new widget inherit from Table widget and add a class member of
> type 
> SQLQuery widget and make sure to set all attributes of SQLQuery widget
> 
> based on the UID (Please note that current SQLQuery widget don't
> support 
> DBF yet). Your SQLQuery widget will put the result in a shared
> resource. 
> Make sure your shared resource is set to the same in both SQLQuery 
> Widget and you new widget.
> 
> An other way, you can create a widget that inherit from the base widget
> 
> and add Table and SQLQuery widget as class member. This way, the user 
> don't have any control on the way the table is displayed (hard coded in
> 
> you code).
> 
> It's basicly how to do it.
> 
> Rene Teniere wrote:
> 
>>Hi All,
>>
>>Question: When using the SQL and Table widgets, can those be
> 
> embedded
> 
>>within the PHP code of a custom widget? Reason being that I am
> 
> creating
> 
>>a query widget that filters out data from a DBF and publishes the
>>resultant data as a table for the user. The above widgets seem to be
> 
> the
> 
>>way to go, however, just wanting to know if this can all be done in
> 
> one
> 
>>shot through my new widget. I.E. enter the UID# and all the results
>>should come up in table form automatically.
>>
>>Thanks,
>>
>>Rene
>>
>>Rene J.R. Teniere - BSc., D.GIS
>>GIS Technician
>>Nova Scotia Department of Natural Resources
>>Forestry Division (GIS) - Truro
>>
>>Phone: (902) 893-5655
>>Mobile: (902) 209-8956
>>_______________________________________________
>>Chameleon mailing list
>>Chameleon@lists.maptools.org 
>>http://lists.maptools.org/mailman/listinfo/chameleon 
>>
> 
> 
> 


-- 
Sacha Fournier
Applications Developer
DM Solutions Group
tel: 418.696.5056
fax: 418.696.5056
http://www.dmsolutions.ca
mailto://sfournier@dmsolutions.ca
-- 
-------------------------------------------------
/"\  ASCII Ribbon Campaign against HTML
\ /  email and proprietary format
  X   attachments.
/ \
-------------------------------------------------