Hi. I've hit a bit of a stumbeling block, with the GT::SQL documents don't seem to cover. Basically, I have this code;
my $table = $DB->table('Links','CatLinks');
$table->select_options ("LIMIT $limit");
$table->select_options ('ORDER BY RAND()');
my $sth = $table->select( { }, { CategoryID => 12 } );
If I comment out the 3rd line, it brings up the results fine... but as soon asI try to use a 'LIMIT', itdoesn't give me any results.
Has anyone ever come across this, and if so, would you mind sharing the fix for it?
TIA.
Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Code:
# create a table connection... my $table = $DB->table('Links','CatLinks');
$table->select_options ("LIMIT $limit");
$table->select_options ('ORDER BY RAND()');
my $sth = $table->select( { }, { CategoryID => 12 } );
If I comment out the 3rd line, it brings up the results fine... but as soon asI try to use a 'LIMIT', itdoesn't give me any results.
Has anyone ever come across this, and if so, would you mind sharing the fix for it?
TIA.
Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Concacinated SQL queries...