Database searching

Hi all

This is copied from an earlier post, I have tried to resolve the issue
myself but cannot. I really need help with this.........thanks



I'm a novice user, using DWMX.

I have successfuly made a dynamic page(ASPvbs) which allows a user to
search a
database using 1 search criteria.

However, I cannot make a page which allows the user to search using 2
search
criteria.

When I make a recordset to put in the 'Bindings' panel I follow the
instructions in the help files. But, when I use the 'Test' facility I get
the
error message:-

'Too few parameters. Expected 1'

Of course nothing happens.

When I use 1 search criteria (whilst in the 'advanced' mode, ALL records
are
displayed with the relevant search field altered to display the 'Default'
value
for the search variable.

I have tried various alterations to the SQL but to no avail (I know nothing
about sql)

Can anyone help please????

Thanks in advance.

--

"It's all in fun or life isn't worth it!"

Sounds like you've made an error in the SQL somewhere. For more info on the
basics, see

www.w3schools.com
www.sqlcourse.com

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

Sorted now...... thanks tho.



--

"It's all in fun or life isn't worth it!"


"Julian Roberts" <newsg (AT) charon (DOT) co.uk> wrote

Sounds like you've made an error in the SQL somewhere. For more info on
the
basics, see

www.w3schools.com
www.sqlcourse.com

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