Here's the code i am now using Andy
---
sub {
my $user = $_[0];
my $tbl = $DB->table('Links');
$tbl->select_options(LIMIT 6');
my $sth = $tbl->select( { LinkOwner => $user, isValidated => 'Yes' } ) || return $GT::SQL::error;
my $back;
while (my $hit = $sth->fetchrow_hashref) {
$back .= Links::SiteHTML::display('link', $hit);
}
return $back;
}
---
here's the error message - when I re-build
---
Building
What's New Index...
Number found where operator expected at (eval 47) line 5, near "LIMIT 6"
(Do you need to predeclare LIMIT?)
String found where operator expected at (eval 47) line 6, near "6');
my $sth = $tbl->select( { LinkOwner => $user, isValidated => '"
(Might be a runaway multi-line '' string starting on line 5)
(Missing operator before ');
my $sth = $tbl->select( { LinkOwner => $user, isValidated => '?)
A fatal error has occured:Bizarre copy of HASH in sassign at /home/the3gportal.com/www/cgi-bin/admin/GT/Config.pm line 619.
Please enable debugging in setup for more details. Bizarre copy of HASH in sassign at /home/the3gportal.com/www/cgi-bin/admin/GT/Config.pm line 619.
---
Cheers
Steve