Multiple Category Search Page

[Calvin Willman]

I'm trying to create a search page, with the option of selecting one of more
categories.

I understand how to code it, so the Click event runs through which are
checked and which aren't.. etc... but wanted to use a SPROC rather than
create a SQL Statement (the latter would be easier I know)

I'm wondering how I can construct the SPROC, on the Database??

I suppose, the one way would create a string to pass as the parameter to end
up something like

WHERE CategoryID = '1' OR '2' OR '3' etc...

if my SPROC is along lines.. SELECT * FROM dbo.Table WHERE CategoryID =
@CategoryID

Anyone have any ideas??

[Calvin Willman]

Parp...

i use the in keyword.

so select * from products where categoryid in @categoryid and pass (1,2)


On 20/4/05 5:40 pm, in article BE8C4493.B22%calvinwillman@orange.net,
"Calvin Willman" <calvinwillman@orange.net> wrote:

> I'm trying to create a search page, with the option of selecting one of more
> categories.
>
> I understand how to code it, so the Click event runs through which are
> checked and which aren't.. etc... but wanted to use a SPROC rather than
> create a SQL Statement (the latter would be easier I know)
>
> I'm wondering how I can construct the SPROC, on the Database??
>
> I suppose, the one way would create a string to pass as the parameter to end
> up something like
>
> WHERE CategoryID = '1' OR '2' OR '3' etc...
>
> if my SPROC is along lines.. SELECT * FROM dbo.Table WHERE CategoryID =
> @CategoryID
>
> Anyone have any ideas??
>