and where clause

[jayeshp100]

sql="select * from cars where car_id='" & Request("car") & "'; " and where fuel_type ='" & Request("car") & "'; " the above coding does not work...it comes with an end of statement error after the Request("car") & "'; partCan anyone help me..MANY THANKS.AND THE WHERE CLAUSES ARE SELECTED FROM A PICKLIST

[Siddhesh]

sql="select * from cars where car_id='" & Request("car") & "'; " and where fuel_type ='" & Request("car") & "'; " the above coding does not work...it comes with an end of statement error after the Request("car") & "'; partCan anyone help me..MANY THANKS.AND THE WHERE CLAUSES ARE SELECTED FROM A PICKLIST

<{POST_SNAPBACK}>

First check ur Sql StatementThe simple code query isSelect * from Table_Name where Field1=' Value1' and Field2=' Value2 'In ASP we can writesql="select * from cars where car_id=' " & Request("car") & " ' and fuel_type =' " & Request("car") & " ' " I Think this will help uBye