Re: Re: Trouble updating value of variable for a placeholder

[peppiv]

in reply to Re: Trouble updating value of variable for a placeholder
in thread Trouble updating value of variable for a placeholder

I've tried using

my $sth = $dbh->prepare('SELECT * FROM applicant WHERE date_col = ? OR
+DER BY job_position LIMIT ?'); 
     $sth->execute($date,10) or die $sth->errstr;

and this worked. I've even tried using placeholders for both LIMIT values.

peppiv

[peppiv]

stajich Thanks for the help. I've tried printing $limit. It returns '0' when I first call the sub, which is what I want. LIMIT 0,10 returns rows 1-10. The second time I call it it returns 10, which is also what I want. LIMIT 10,10 returns rows 11-20. But for some reason it bugs out.

Still getting the error:

You have an error in your SQL syntax near ''10',10' at line 1 at /usr/local/etc/httpd/cgi-bin/return.pl line 590.

Which is where LIMIT is used.

Aarrggggh!

peppiv