Link to home
Start Free TrialLog in
Avatar of Aleks
AleksFlag for United States of America

asked on

SQL with parameters

I have an sql statement which is as follow:

Select id, name, lastname, username, password from users

then I call the view from dreamweaver to create a recordset, and at that level I have to add more code something like:  

Select [view] where username = 'parameter1' and lastname = 'parameter2'

Then I pass the parameters and returns one record.

Is there a way to build the parameter request inside the view (query statement) ?

Like:

Select id, name, lastname, username, password from users
where username = 'parameter1' and password = 'parameter2' ... if so ... can I pass the value at the recordset level and how ?

Using sql 2008 R2 and Dreamweaver CS6 with ASP.
SOLUTION
Avatar of Wayne Barron
Wayne Barron
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
:)
Just caught on to what I wrote.
>> Accept Database
Supposed to have been
Access Database.

Have a good one, and glad that we could assist.
Carrzkiss