Re: [Pbwebgui-development] WebGUI::Paginator and returningtemplate variables from a macro.

[JT S. <jt...@pl...>]

BTW. We strongly encourage you to give your code back to the community, because:

1) You can be critiqued, and become a better coder.

2) You can save someone else the work you've done.

3) You can help pay the community back for giving you everything that WebGUI is already.

4) Someone else may enhance your code and then you get more features.

5) Someone else can learn from your code, and what you learned from us.

If you choose to give your code back, see this page: 
http://www.plainblack.com/user_contributions


On Tue, 06 Jul 2004 17:28:16 -0400
  "Roy Johnson" <RJo...@sp...> wrote:
>Hi JT,
>
>You understood me perfectly.  I was unaware of the 'in' keyword for MySQL.  The trick 
>for returning the template vars as the column names also greatly simplifies the code I 
>have presently.  I can't thank you enough for your patience and help with this.  I'm 
>just starting out with Perl and the WebGUI API and obviously have a lot to learn.
>
>Thanks again,
>
>Roy
>
>>>> jt...@pl... 07/06/04 04:12PM >>>
>Pardon me if I misunderstood what you're trying to do.
>
>Your query only returns one row of data because you're where clause includes the 
>primary 
>key, which by definition will only give you one row of data. If you want to get back 
>all 
>the rows that match the primary keys in that array try something like:
>
>$sql = "select...from...where priKey in (".join(",",@PKlist).")";
>
>
>Again, if I misunderstood, I'm sorry about that. If I haven't, the join trick should 
>work nicely.
>
>Also, another neat trick (if you don't mind your template variables being named your 
>field names) is that you can dump the paginator directly into your template variables 
>like this:
>
>$var{data_loop} = $p->getPageData;   # this creates your loop
>$p->appendTemplateVars(\%var);       # this adds your paginator variables
>
>NOTE: Requires 6.0 or higher.
>
>
>
>On Tue, 06 Jul 2004 16:43:09 -0400
>  "Roy Johnson" <RJo...@sp...> wrote:
>>Greetings,
>>
>>I'm slowly learning the WebGUI API and am currently developing a macro for our company 
>>and have a few questions.  Before I ask my question, I'm basing most of my code and 
>>assumptions on the SQLReports Wobject.
>>
>>Basically, I have an array with a single column of values that represent  primary key 
>>field values in a table.  I'm executing the query once for each element of the array 
>>and returning multiple columns from the query using the 
>>WebGUI::Paginator->SetDataByQuery() method.
>>
>>ex:
>>
>>foreach $primaryKey (@PrimaryKeyList) {
>>
>>  $sql = "Select value1, value2, From tblBlah Where primaryKey=$primaryKey";
>>
>>  $page = WebGUI::Paginator->new($url);
>>  $err = $page->setDataByQuery($query, $dbh);
>>  $rowData = $page->getPageData();
>>
>>  #Code to create hashes necessary for returning Template vars
>>
>>}
>>
>>The code that I have is working but I'm not sure that I'm approaching the problem 
>>correctly.  Because my query will never return more than one row  during a single 
>>itteration of the foreach loop (because the where clause is based on a primary key 
>>field) it seems this is the wrong approach to take.  
>>
>>The problem is that I must execute the query once for each value in my array so the 
>>cummulative result (what is sent to the macro in the form of template vars) almost 
>>always has more than one row of information.  So my template for the macro looks 
>>something like this:
>>
>><tmpl_loop rows_loop>
>><tmpl_var row.field.value1.value><br/>
>><tmpl_var row.field.value2.value>
>></tmpl_loop>
>>
>>In case anyone is wondering why I didn't write my SQL statement better to avoid the 
>>need for an array of the necessary primary key values, it's because we are not running 
>>MySQL 4.1 and don't have the support for subselects and the 'having' keyword.  If we 
>>were, I could accomplish what I'm doing without the need for the array of primary key 
>>values.
>>
>>Sorry for the long post.  If anyone could nudge me in the right direction for this type 
>>of programming challenge I would GREATLY appreciate it.
>>
>>Thanks,
>>
>>Roy Johnson
>>
>>
>>
>>-------------------------------------------------------
>>This SF.Net email sponsored by Black Hat Briefings & Training.
>>Attend Black Hat Briefings & Training, Las Vegas July 24-29 - 
>>digital self defense, top technical experts, no vendor pitches, 
>>unmatched networking opportunities. Visit www.blackhat.com 
>>_______________________________________________
>>Pbwebgui-development mailing list
>>Pbw...@li... 
>>https://lists.sourceforge.net/lists/listinfo/pbwebgui-development 
>
>
>JT ~ Plain Black
>
>Create like a god, command like a king, work like a slave. 
>
>
>-------------------------------------------------------
>This SF.Net email sponsored by Black Hat Briefings & Training.
>Attend Black Hat Briefings & Training, Las Vegas July 24-29 - 
>digital self defense, top technical experts, no vendor pitches, 
>unmatched networking opportunities. Visit www.blackhat.com 
>_______________________________________________
>Pbwebgui-development mailing list
>Pbw...@li... 
>https://lists.sourceforge.net/lists/listinfo/pbwebgui-development
>
>
>-------------------------------------------------------
>This SF.Net email sponsored by Black Hat Briefings & Training.
>Attend Black Hat Briefings & Training, Las Vegas July 24-29 - 
>digital self defense, top technical experts, no vendor pitches, 
>unmatched networking opportunities. Visit www.blackhat.com
>_______________________________________________
>Pbwebgui-development mailing list
>Pbw...@li...
>https://lists.sourceforge.net/lists/listinfo/pbwebgui-development


JT ~ Plain Black

Create like a god, command like a king, work like a slave.