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
    Thanks very much to the both of you, didn't realise that bind_param() didn't look inside quotes.