The statement has to look like this: SELECT * FROM logs where datetime like ?
Tom
Jason Friedman wrote:
> my $sth = $dbh->prepare("SELECT * FROM logs where datetime like '?'")
> or die $dbh->errstr;
> print "Enter datetime: ";
> while ($datetime = <>) {
> my @data;
> chomp $datetime;
> $sth->execute($datetime) or die $sth->errstr;
>
> then I am prompted to enter a date, which I can, but immediately after
> that:
>
> DBD::mysql::st execute failed: called with 1 bind variables when 0 are
> needed at datetime.pl line 19, <> line 1.
>
>
>>>I've seen this, too. You might try using a naked ? without the single
>>>quotes.
>
>
> If I define $datetime beforehand and interpolate it in the query, it
> works, but I read here that it is not reccommended:
>
>
>>>True that it's not recommended, because for each iteration the query will
>>>need to be re-parsed, but if you are not executing this query a million
>>>times, it probably won't matter much.
>
>
signature.asc
Description: OpenPGP digital signature
