in reply to Using placeholders in OFFSET clause of SELECT statement

my $offset = int(rand(100)); my $sth = $dbh->prepare("$stmt LIMIT 1 OFFSET $offset"); $sth->execute();

Replies are listed 'Best First'.
Re^2: Using placeholders in OFFSET clause of SELECT statement
by yakoval (Novice) on Apr 29, 2010 at 19:23 UTC
    Thank you! This way I got rid of the error!