I have just set up my database to search using the "CONTAIN" method. But I can't seem to figure out how to use the "CONTAIN" search method via DWMX. Basically if I type in "ms mouse" in my search text box I want the database to return all products with "ms mouse" in the description.

I can do this fine in MS SQL Server (Query Analyser) but how do I get it to work in DWMX.

So far I have only used simple WHERE searches via the DWMX recordsets.

Regards

Fayaz

Hi Fayaz,

WHERE CONTAINS should work fine in your advanced recordset window.

Curious, i just setup a search with contains in simple mode and it outputs this in advanced:

SELECT *
FROM Articles
WHERE Bulk_content LIKE '%MMColParam%'

tres bizar, could be the Access database, but CONTAINS works with SQL cause i also have it in some of my pages at work. To be safe connect in simple mode to SQL and setup a contains query, see what it writes in advanced mode and use that <img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle>

with regards,

Dennis van Galen
DMXzone Manager
dennis@dmxzone.com
Extension, Tutorial and FAQ's Manager

Thanks again, Dennis. It works very well. <img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle>

Regards

Fayaz

Edited by - fk001 on 04 Dec 2002 10:34:15