SQL HELP

Imar · December 14th, 2005, 02:22 PM

Great; hopefully it will work now....

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.

malhyp · December 16th, 2005, 07:05 AM

Heya, thanks for the help. I did as you metioned. Copied the SQL to Access and made a few changes there an it worked.

One last question.

in the search page I have 2 dynamic list/menu fields. They both have quote a few categories and locations to choose from. They all work perfectly when searching except for the 1st one in each filed called 'All Categories' and 'All Locations'.

Is there something that I should do or look out for to get these working?

As there anything in the book that might help?

Mally.

Imar · December 17th, 2005, 06:49 AM

You could simply not add them to the WHERE clause when they don't have a value. E.g.

Code:

If Request.Form("lstCategories") <> "" Then
  myWhereClause = myWhereClause & " Category = " & Request.Form("lstCategories")
End If

This assumes you build up the where clause dynamically and then assign it together with the rest of the SQL statements to the Source of the Recordset.

This will likely break the DW Recordset dialog, as DW is no longer capable of generating a good dialog from the complex ASP.

HtH,

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.