Back before i started using swish-e (BS), and before mysqlfulltext, i used
to use a set of modules:
-- snip --
my $fields_searched =
"id,long_caption,crop,keywords,photographer,subject,short_caption,categories,short_keys,orig_id";
my $query = Text::Query($in{'Keywords'},
-fields_searched => $fields_searched,
-parse => 'Text::Query::ParseAdvanced',
-solve => 'Text::Query::SolveSQL',
-build => 'Text::Query::BuildSQLMySQL',
-select => $select
-- snip --
as i recall, the idea was to take user input and optimize it
then turn it into sql.
i don't even know if people still use it, i practically had to go to tape
for that snippet.
Brad
------------------------------------------------------------
Brad Miele
Technology Director
IPNStock
(866) 476-7862 x902
bmiele@ipnstock.com
It is hard to predict, in particular about the future.
-- Robert Storm Petersen
On Fri, 5 Nov 2004, Bill Moseley wrote:
> On Fri, Nov 05, 2004 at 04:33:31PM -0500, brad@auroraquanta.com wrote:
> > Are you using a query builder to search against it? like one of the
> > Text::Query modules?
>
> No, I was just adding a full-text search to an existing application.
> For the mysql boolean full-text query I just pass the user data
> directly to mysql.
>
> What do the Text::Query modules do for you?
>
>
>
> --
> Bill Moseley
> moseley@hank.org
>
> Unsubscribe from or help with the swish-e list:
> http://swish-e.org/Discussion/
>
> Help with Swish-e:
> http://swish-e.org/current/docs
> swish-e@sunsite.berkeley.edu
>
>
Received on Fri Nov 5 16:42:18 2004