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

Re: [sooke] Editors Online: Table Join Prob

Quote Reply
Re: [sooke] Editors Online: Table Join Prob In reply to
I guess what I am trying to say is:

@list = SELECT 'Full_Name" From Category Where (Category.ID=>Editors.CategoryID) AND ( Editors.User =>$user ) to return Category.Full_Name fetchall_list


My bad attempt ->

@editor_categories = $DB->table('Editors','Category')->select({'Category.ID'=>'EditorCategoryID'},{Username => $user}, ['Category.ID', 'Category.Full_Name'])->fetchall_list;




?Crazy



http://www.iuni.com/...tware/web/index.html
Links Plugins

Last edited by:

sooke: May 17, 2002, 1:11 PM
Subject Author Views Date
Thread Editors Online: Table Join Prob Ian 3688 May 17, 2002, 11:26 AM
Thread Re: [sooke] Editors Online: Table Join Prob
Ian 3472 May 17, 2002, 1:09 PM
Post Re: [Ian] Editors Online: Table Join Prob
pugdog 3436 May 27, 2002, 3:42 AM
Thread Re: [Ian] Editors Online: Table Join Prob
Paul 3415 May 27, 2002, 4:29 AM
Thread Re: [Paul] Editors Online: Table Join Prob
Ian 3420 May 27, 2002, 8:28 AM
Thread Re: [Ian] Editors Online: Table Join Prob
silky 3398 Jun 2, 2002, 7:46 PM
Post Re: [chaos] Editors Online: Table Join Prob
Ian 3407 Jun 2, 2002, 7:53 PM