in reply to DBI:SQLite bind_param problem
WHERE fldTags LIKE '%?%' ORDER
That looks pretty weird to me. Try
my $blogTagToShow = '%' . (shift) . '%'; my $query = "SELECT * FROM tblBlogPosts WHERE fldTags LIKE ? ORDER BY +fldDate DESC"; my $sth = $dbh->prepare($query); $sth->bind_param(1, $blogTagToShow);
--shmem
_($_=" "x(1<<5)."?\n".q·/)Oo. G°\ /
/\_¯/(q /
---------------------------- \__(m.====·.(_("always off the crowd"))."·
");sub _{s./.($e="'Itrs `mnsgdq Gdbj O`qkdq")=~y/"-y/#-z/;$e.e && print}
|
|---|
| Replies are listed 'Best First'. | |
|---|---|
|
Re^2: DBI:SQLite bind_param problem
by davehope (Initiate) on Jun 17, 2007 at 17:35 UTC |