Home : Products : Gossamer Links : Development, Plugins and Globals :

Products: Gossamer Links: Development, Plugins and Globals: Re: [Paul] GROUP BY: Edit Log

Here is the list of edits for this post
Re: [Paul] GROUP BY

Yes, currently select_options() are not prefixed. So you can either do:

my $prefix = $DB->prefix;
$tab->select_options ("GROUP BY " . $prefix . "CatLinks.CategoryID");


$tab->select_options ("GROUP BY CategoryID");

Since the column is not in both tables, you don't need to prefix it with table name.


Gossamer Threads Inc.

Last edited by:

Alex: Mar 17, 2002, 1:53 PM

Edit Log: