| johnnycougarflats@hotmail.com 2006-08-17, 1:23 am |
| CS2002 FP1 Com+
..
Having great difficulty with catalog searching. I understand that
freetext searches will not do implicit 'AND' for multi-word fulltext
searches. Therefore, I am trying to pass a 'CONTAINS' clause into the
call. Nothing is getting returned. It seems that it must be throwing
errors, but there is nothing in the app logs.
Here is my code.
s = "CONTAINS (*, '<search term>')"
Set rs = m_objManager.Search(s, , _
m_objCatalog.CatalogName, _
cscProductClass Or cscProductFamilyClass, _
"style_number", _
"style_number", _
False, _
1, 25, , t)
Even if I just have one word in the table, the thing blows up.
Is there anyway I can accomplish getting a query to do an implicit
'AND' other than putting together a huge clause using 'LIKE' operands?
I have tried everything I can think of based on the documentation.
Please don't tell me I have to wait until CS2007 because my customer
really does not want to hear it. Thank you.
|