If /Then statement

[ProTouch]

I am having trouble coding this...
I want to have a statement like this

SQL2 = "SELECT * FROM tblSupplier WHERE suppID=" & request("suppID&quot

if provretail = no
then
response.write " "
else
response.write "Find a Retailer Near You"
end if

where provretail is a field in my database that is either yes or no.

Can any one help?
J.Gilbert

 

[ehsant]

Hi ...
you have to user a recordset to access your fields in your DB ...
and then you can do this :
If RS("provretail&quot = 0 Then
response.write " "
else
response.write "Find a Retailer Near You"
end if

----
TNX.
E.T.