Asp VBScript WildCards

[acidrain9]

i have a list of my current inventory in a repeated region. i would like to be able to narrow down the number of items in my repeated region by selecting a category from a drop down list. I have been able to set this up and it does work.....However, if i want to be able to view all of my inventory it will not let me. i have tried using wildcards like % (whick i notice works on asp.net) as well as * and i tried leaving the value blank. does anyone know how i can narrow my searches so that i can switch back and forth between categories and a full list of inventory without using more than one page????

[Newsgroup_User]

The problem with wildcards is that they only work if you have a LIKE
statement and not an = statement. The * only works in Access on the desktop.
For SQL on the server you need a %.



--
Paul Whitham
Certified Dreamweaver MX2004 Professional
Adobe Community Expert - Dreamweaver

Valleybiz Internet Design
www.valleybiz.net

"acidrain9" <webforumsuser@macromedia.com> wrote in message
news:eccn0v$pde$1@forums.macromedia.com...
>i have a list of my current inventory in a repeated region. i would like to
>be
> able to narrow down the number of items in my repeated region by selecting
> a
> category from a drop down list. I have been able to set this up and it
> does
> work.....However, if i want to be able to view all of my inventory it will
> not
> let me. i have tried using wildcards like % (whick i notice works on
> asp.net)
> as well as * and i tried leaving the value blank. does anyone know how i
> can
> narrow my searches so that i can switch back and forth between categories
> and a
> full list of inventory without using more than one page????
>