Gossamer Forum
(Advanced Search)
for
May 29, 2010, 12:10 PM
Eraser
Enthusiast (619 posts)
May 29, 2010, 12:10 PM
Views: 4467
Shortcut
Quote Reply
SQL Wildcard Query
Using a [charlist] Wildcard query I get no results although I'm sure the query is valid:

Code:
$sth = $link_db->select ( { CategoryID => $fidlb}, GT::SQL::Condition->new ('Links.Title', 'LIKE', '[abc]%'), VIEWABLE);

Results show with a single query ok:

Code:
$sth = $link_db->select ( { CategoryID => $fidlb}, GT::SQL::Condition->new ('Links.Title', 'LIKE', 'a%'), VIEWABLE);

What am I doing wrong?

~ ERASER

Free JavaScripts @ Insight Eye
Subject Author Views Date
Thread SQL Wildcard Query Eraser 4467 May 29, 2010, 12:10 PM
Thread Re: [Eraser] SQL Wildcard Query 		Andy 4298 May 30, 2010, 5:19 AM
Post Re: [Andy] SQL Wildcard Query 		Eraser 4127 Jun 11, 2010, 7:42 AM