Re: placeholder error with selectall_arrayref

2002-04-07 Thread Tim Bunce
On Fri, Apr 05, 2002 at 10:19:30AM -0800, Douglas Wilson wrote: > From: "Zachary Buckholz" <[EMAIL PROTECTED]> > > > my $url_list = $dbh->selectall_arrayref($select_query, $current_time) > > Check the docs again. The optional second argument is a hash ref of > attributes (usually just '{}' an e

Re: placeholder error with selectall_arrayref

2002-04-06 Thread Douglas Wilson
From: "Zachary Buckholz" <[EMAIL PROTECTED]> > my $url_list = $dbh->selectall_arrayref($select_query, $current_time) Check the docs again. The optional second argument is a hash ref of attributes (usually just '{}' an empty hash ref), following that is a list of your placeholder bind values. H

placeholder error with selectall_arrayref

2002-04-05 Thread Zachary Buckholz
sub select_url($current_time) { my $dbh = DBI->connect("DBI:mysql:database=saint;host=localhost","user","password", {'RaiseError' => 1}); my $select_query = "SELECT url_id, chk_freq, url_timeout, UNIX_TIMESTAMP(lc_epoch) FROM monitor_check WHERE (