Gossamer Forum
Home : Products : Gossamer Links : Version 1.x :

Re: How do i alter the sql search

Quote Reply
Re: How do i alter the sql search In reply to
Hi Jason and all. Real novice here so keep that in mind with anything I type in reply to this thread. I likely have more questions than helpful info on resolving your problem.

help me understand here . . .
if ($in->param('query') = $in->param('query') . ' ' . $in->param('query2')') {

it appears to me this if statement is asking whether param('query') = itself AND/OR param('query2')? Wouldn't that defeat the purpose of your "bikes AND locale" targeted searches?

wouldn't something like this work?
my param('query') = param('query1') . " AND " . param('query2')


pugdog had wrote:
Quote:
In looking at search.cgi I don't see where the parameter 'bool' is actually used in the search routines....
and really piqued my interest. Surely, bool combinations had to be in there somewhere . . . after several attempts at various find combinations, it looks like (again, I may be wrong - I honestly don't know what I'm doing!) in:
sub log_query
at my $time = $db->get_date . " " . $db->get_time;
may be an example you can use.
(way at the bottom of search.cgi)

Please accept my apologies if I've been out in left field on the problem you've identified and my reply on your topic.




------------------
~ ~ ~ ~ ~
Karen


[This message has been edited by Karen (edited February 28, 2000).]
Subject Author Views Date
Thread How do i alter the sql search jasonx 4432 Feb 25, 2000, 3:42 PM
Post Re: How do i alter the sql search
pugdog 4329 Feb 25, 2000, 5:07 PM
Post Re: How do i alter the sql search
jasonx 4318 Feb 25, 2000, 6:16 PM
Post Re: How do i alter the sql search
Bmxer 4323 Feb 26, 2000, 11:41 AM
Post Re: How do i alter the sql search
jasonx 4343 Feb 27, 2000, 7:22 PM
Post Re: How do i alter the sql search
jasonx 4321 Feb 28, 2000, 12:36 AM
Post Re: How do i alter the sql search
Karen 4334 Feb 28, 2000, 5:29 AM
Post Re: How do i alter the sql search
pugdog 4333 Feb 28, 2000, 9:36 AM
Post Re: How do i alter the sql search
pugdog 4319 Feb 28, 2000, 6:18 PM
Post Re: How do i alter the sql search
jasonx 4326 Feb 28, 2000, 8:14 PM
Post Re: How do i alter the sql search
pugdog 4327 Feb 29, 2000, 7:27 AM
Post Re: How do i alter the sql search
Alex 4331 Feb 29, 2000, 7:34 PM
Post Re: How do i alter the sql search
jasonx 4332 Mar 1, 2000, 10:29 AM
Post Re: How do i alter the sql search
pugdog 4335 Mar 1, 2000, 5:11 PM
Post Re: How do i alter the sql search
klangan 4321 Mar 1, 2000, 7:49 PM