in reply to DBI Substring index query and passing value
And what does your query produce when run straight against the database with an SQL command prompt?
How many records are there in the database that begin with '$name'? Does fetchrow_array return false? (If so, your resultset is zero rows.)
Also, I'm quite confused by the query. Do you have fields that are named $$$? (Double quotes are meant to quote table and field names in the SQL dialects I'm familiar with.)
Perhaps you mean:
my $sql = sprintf("... where CustomField = ? and Name like %s", $dbh-> +quote($name . '%')); $agent1 = $dbh->prepare($sql) || die $DBI::errstr; $Agent1->execute(291) || die $DBI::errstr ; ( $phone_no,$mail )= $Agent1->fetchrow_array or die "no results :(";
May I recommend you put RaiseError into your connection string? Less explicit dying.
|
---|
Replies are listed 'Best First'. | |
---|---|
Re^2: DBI Substring index query and passing value
by SriniK (Beadle) on Dec 11, 2012 at 10:41 UTC | |
by Anonymous Monk on Dec 11, 2012 at 11:12 UTC |
In Section
Seekers of Perl Wisdom