Dreamweaver - select all from url parameter

Author

select all from url parameter

funkster

2004-08-26, 12:18 pm

Hi,

I'm using a dynamic list box to pass an url parameter which then filters a
recordset.
I would like one of the options in my listbox to be all (return all of the
records). I thought I would be able to just add an option called 'all' to the
table which populates my listmenu, with its value set to some sort of wildcard
like * but I've tried everything I can think of and can't get it to work? Very
grateful for any suggestions, Thanks.

PS. Using MX / MS Access / ASP VBScript

Also one other minor thing is bugging me - the list box data is sorted by name
in ascending order and yet the default value always comes up as the last item
in the list, when you select the list it is in ascending order though (i could
swear i never had this problem with ultradev)?

Paul Whitham TMM

2004-08-26, 12:19 pm

The wild card in a SQL statement is a % and not the * which is internal to
Access.

--
Regards

Paul Whitham
Macromedia Certified Professional for Dreamweaver MX2004
Valleybiz Internet Design
www.valleybiz.net

Team Macromedia Volunteer for Ultradev/Dreamweaver MX
www.macromedia.com/support/forums/team_macromedia

"funkster" <webforumsuser@macromedia.com> wrote in message
news:cgfn1q$pqs$1@forums.macromedia.com...
> Hi,
>
> I'm using a dynamic list box to pass an url parameter which then filters
a
> recordset.
> I would like one of the options in my listbox to be all (return all of
the
> records). I thought I would be able to just add an option called 'all' to
the
> table which populates my listmenu, with its value set to some sort of
wildcard
> like * but I've tried everything I can think of and can't get it to work?
Very
> grateful for any suggestions, Thanks.
>
> PS. Using MX / MS Access / ASP VBScript
>
> Also one other minor thing is bugging me - the list box data is sorted by
name
> in ascending order and yet the default value always comes up as the last
item
> in the list, when you select the list it is in ascending order though (i
could
> swear i never had this problem with ultradev)?
>

funkster

2004-08-26, 12:20 pm

This doesn't work either when you pass it as an url parameter, the value it passes is '%25' which I think is the html code for %?