>>
@list = SELECT 'Full_Name" From Category Where (Category.ID=>Editors.CategoryID) AND ( Editors.User =>$user ) to return Category.Full_Name fetchall_list
<<
Try:
...otherwise try:
Thats a guess. I've added the die in to catch any screwups :)
@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 :)