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

Re: [Ian] Editors Online: Table Join Prob

Quote Reply
Re: [Ian] Editors Online: Table Join Prob In reply to
>>
@list = SELECT 'Full_Name" From Category Where (Category.ID=>Editors.CategoryID) AND ( Editors.User =>$user ) to return Category.Full_Name fetchall_list
<<

Try:

Code:
my @list = $DB->table('Category', 'Editors')->select( { Username => $user }, 'Full_Name' )->fetchall_list || die $GT::SQL::error;

...otherwise try:

Code:
my @list = $DB->table('Category', 'Editors')->select( { ID => \'CategoryID', Username => $user }, 'Full_Name' )->fetchall_list || die $GT::SQL::error;

Thats a guess. I've added the die in to catch any screwups :)
Subject Author Views Date
Thread Editors Online: Table Join Prob Ian 3568 May 17, 2002, 11:26 AM
Thread Re: [sooke] Editors Online: Table Join Prob
Ian 3353 May 17, 2002, 1:09 PM
Post Re: [Ian] Editors Online: Table Join Prob
pugdog 3318 May 27, 2002, 3:42 AM
Thread Re: [Ian] Editors Online: Table Join Prob
Paul 3296 May 27, 2002, 4:29 AM
Thread Re: [Paul] Editors Online: Table Join Prob
Ian 3300 May 27, 2002, 8:28 AM
Thread Re: [Ian] Editors Online: Table Join Prob
silky 3279 Jun 2, 2002, 7:46 PM
Post Re: [chaos] Editors Online: Table Join Prob
Ian 3289 Jun 2, 2002, 7:53 PM