Database searching

message from ionic on 19 Jul 2004
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.
 
Julian Roberts replied to ionic on 19 Jul 2004
Sounds like you've made an error in the SQL somewhere. For more info on the
basics, see

www.w3schools.com
www.sqlcourse.com
 
ionic replied to Julian Roberts on 19 Jul 2004
Sorted now...... thanks tho.
 

Archived message: Database searching (Macromedia Dreamweaver)