Display all when first selection is made on drop down menu
Posted on 2013-12-14
I am using SQL, ASP classic and VBscript on my results page.
On the search page I have a drop down menu listing a list of clients, it displays the name of the client and passes on the ID of the client to page # 2
The query on page # 2 filters out using the ID.
I am using Dreamweaver to create my recordsets.
The sql reads: Select * from table where b.userid = MMColParam11
The first item of the list of clients says "All clients", which is manually entered, the rest come from a recordset and all have names and ID's.
When I filter text fields I can use the '%' to get all records for "All" or when no selection is made, in this case they are integer numbers, I get an error if I use % ... is there a way alternative to pass a value that will return ALL records like when comparing a text ?