It can work on just one field. It's just that I wrote it to work on a keyword field and now I need to change it.

The first thing you need to do is go through and change back all of the places where you changed "keyword" to "Quote." I'll go take a look at the code again to see what changes I need to make.


JPD
----------------------------------------------------
JPDeni's DBMan-ual
How to ask questions the smart way.

Thanks, I've already changed everything back to Quote...sorry for the hassle!

Move the code I gave you before to after the line

local (%sortby);

In that section, change every instance of keyword to Quote, so it looks like this:



That should do it. I haven't had a chance to work on phrases today.


JPD
----------------------------------------------------
JPDeni's DBMan-ual
How to ask questions the smart way.

Should I only change the new code from Keyword to quote, or everything in the sub query section? For example, there is a later piece of code like this:

if ($in{'keyword'}) { # If this is a keyword search, we are searching the same
$i = 0; # thing in all fields. Make sure "match any" option is
$in{'ma'} = "on"; # on, otherwise this will almost always fail.

Only the code in this section. Just the lines I posted. We're only applying the "and" search to the one field. If you change the next lines, you'll have the same problem you were having before.


JPD
----------------------------------------------------
JPDeni's DBMan-ual
How to ask questions the smart way.

It's working perfectly now. Thank you!

I don't seem to be able to work out how to do phrase searches with this. For some reason, it's just not coming. Sorry.


JPD
----------------------------------------------------
JPDeni's DBMan-ual
How to ask questions the smart way.

It's cool, just being able to search two different words is a huge help. Thanks again!