sql="SELECT category,company,address,city,st FROM Category WHERE category LIKE '"&category&"%', WHERE company LIKE '"&company&"%'"

i try the above statement but of course it does not work, Im new at ASP so please can some one give me an idea how can i edit the above line to fix the search?

Thanks!

...helmut

__________________
...helmut

sql="SELECT category,company,address,city,st FROM Category WHERE category LIKE '" & category & "%' AND company LIKE '" & company &"%'"

Replace , WHERE
with
AND

...but the Soon is eclipsed by the Moon

I didnt want to bring this question up, bc it seems so newbiesh.

in flash i do

if (a==1) && (b==2){
function();
}

but i cant find anything similar for ASP

If category<>"" & company<>"" Then

the above goes through without even testing for the if statements.

sorry if this too basic for this forum

...helmut

If category<>"" And company<>"" Then

...but the Soon is eclipsed by the Moon

If category<>"" OR company<>"" Then


exactly!

...helmut