Hey y'all! I'm trying to create a search that uses wildcards to allow for a user to only know part of a name. I got it to work when you know the whole name but not just part of it. Every time I add the wild card marks either dreamweaver or the browser doesn't like where I put them or it doesn't work. This is what I have so far
as my statement in the results page:
SELECT [catalog].[REG_NUMBER], [catalog].[TITLE], [catalog].[YEAR], [catalog].[MEDIUM], [catalog].[DESCRIPTION], [catalog].[IMAGE], [lots].[LOT_NUMBER]
FROM lots RIGHT JOIN [catalog] ON [lots].[REG_NUMBER] =[catalog].[REG_NUMBER]
WHERE catalog.TITLE LIKE ?

where the parameter TITLE = IIf((Request.QueryString("Title" <> Nothing), Request.QueryString("Title", ""

Where do the %'s go? Or is it on the search page?

Thanks!

John

WHERE catalog.TITLE LIKE '%?%'

HTH

with regards,

Dennis van Galen
Webmaster KPN Telecom Holland
Financial & Information Services

Studio MX / CFMX PRO / SQL 2000 / NT4 AND win2kPRO / IIS5

Edited by - djvgalen on 08 Feb 2003 18:24:29

I tried '%?%' and I get the response "Invalid syntax near '(value tested for)'."

Any thoughts?

John

John,

Can you try this:

TITLE = IIf((Request.QueryString("Title" <> Nothing), Request.QueryString("%Title%", ""


with regards,

Dennis van Galen
Webmaster KPN Telecom Holland
Financial & Information Services

Studio MX / CFMX PRO / SQL 2000 / NT4 AND win2kPRO / IIS5

Dear John,
Is this an Access db? Try the asterisk (*) instead.

Regards,
Brent

I tried both *'s and %'s as suggested by y'all and it still won't cooperate. Is there a (gulp) more complicated way of doing this in order for it to work?

<Parameter Name="Title" Value='<%# IIf((Request.QueryString("Title" <> Nothing), Request.QueryString("*Title*", ""

Thanks

John