VB/Script Help

[BillB]

What is a ASP operator that will return all values from a field when use in
a form object??

I've tried % which spits an error. And "%" return the first value in comes
across. * spits an error. "" returns nothing.

What am I missing or forgetting. Anyone know??

Bill

[Julian Roberts]

Sounds like the error is in your SQL

--
Jules
[url]http://www.charon.co.uk/charoncart[/url]
Charon Cart 3
Shopping Cart Extension for Dreamweaver MX/MX 2004

[BillB]

I've got it figured out to have something to do with my default value and
the SQL saying "dbo.DBTable.field1 = "Request(MyForm)"

What I want is to have the first option in a select menu to be a select all.
My SQL say = to
Do ya think I should be doing something else?

there are 4 select menus submitting to a results page. The SQL works great
as long as a selection has been made. The first option in each field I have
a "Select All" option and it's this I can't seem to figure out. I guess I
need a value for each of these options in the select menus and a default
value for the Recordset.

Does this make sense??

Bill

"Julian Roberts" <newsg@charon.co.uk> wrote in message
news:d1se5h$ark$1@forums.macromedia.com...

> Sounds like the error is in your SQL
>
> --
> Jules
> [url]http://www.charon.co.uk/charoncart[/url]
> Charon Cart 3
> Shopping Cart Extension for Dreamweaver MX/MX 2004
>
>
>