Odd Query Problem

[illdill]

I have two different search forms, one is meant to find books only, the other to find media. So for the media form there is only one extra field. For some reason, with this extra field, I get no results...

Query for books (works fine)

SELECT * FROM SearchActive Where title LIKE '%::title::%' AND author LIKE '%::author::%' AND subject LIKE '%::subject::%'

Query for media (returns no results)

SELECT * FROM SearchActive Where title LIKE '%::title::%' AND author LIKE '%::author::%' AND subject LIKE '%::subject::%' AND imgwhoorwhat='%::imgwhoorwhat::%'

Thanks

 

[DCrake]

Simple Software Solutions

What type of value is '%::imgwhoorwhat::%'

and just to waylay my curiosity waht is the logic behind '%::imgwhoorwhat::%'

Never come accros the double :: before.

 

[doco]

Illdill: maybe you need to review a post you had in the past http://www.access-programmers.co.uk/forums/showthread.php?t=151176

 

[illdill]

In FrontPage, ::imgwhoorwhat:: represents a form field (text data type). % at each end represents wild cards. I tried using only one % wild card but I still get no results.