Menu Item problem with SQL query

[singh83]

Hi,

I have a search page which contains a form with 2 drop down menus (Application
and Operating System), which are used to search for records. The SQL query
returns records on a result page matching results that match Application AND
Operating System selected by the user. The SQL query works fine when the user
selects items from both the Application and Operating System menus.

However, the problem is when you only select one of the menus e.g .if you only
want to search using the Operating System menu>>> No results show up.

Currently, in each of the menus the first item is just blank and I think the
query is trying to search for records with blank values. Does anyone know a way
around this? How do you get the query to ignore menus the user does not select?

Your help is much appreciated. Thanks,

Sarb.

[Nathon Jones]

Hi,

If the first item in a menu is blank, make sure its value is "%". That way,
it will search for ALL, if someone has selected from only one of the menus.

I think. :-)

Nath.

"singh83" <webforumsuser@macromedia.com> wrote in message
news:d3hvv7$mqv$1@forums.macromedia.com...

> Hi,
>
> I have a search page which contains a form with 2 drop down menus
> (Application
> and Operating System), which are used to search for records. The SQL query
> returns records on a result page matching results that match Application
> AND
> Operating System selected by the user. The SQL query works fine when the
> user
> selects items from both the Application and Operating System menus.
>
> However, the problem is when you only select one of the menus e.g .if you
> only
> want to search using the Operating System menu>>> No results show up.
>
> Currently, in each of the menus the first item is just blank and I think
> the
> query is trying to search for records with blank values. Does anyone know
> a way
> around this? How do you get the query to ignore menus the user does not
> select?
>
> Your help is much appreciated. Thanks,
>
> Sarb.
>

[singh83]

Cheers Nath,

yes that's right the % is what is needed as the value.

Sarb.