show no shipping text

hi I have a database with some products that are free shipping.

I did this coding to have it show free shipping, but didn't work, and the error kept on point at the end if.

<% 'Show noshipping text
call opendb()
mySQL="SELECT noshippingtext FROM products WHERE idproduct=" &pidProduct
set rs=conntemp.execute(mySQL)
pnoshippingtext=rs("noshippingtext")
If pnoshippingtext="-1" then
response.write "Free Shipping"
end if
call closeDb()
set rs=nothing
'End show short product description %>

any help or pointer would be great, thank you in advance.

I had the same problem using true or false values in a MySQL database. I simply solved this by placing 0 or 1 in the table (int value) and queried the database for 0 or 1 (True or false) This worked fine. On the ASP page I have a pulldown menu wit Yes and No and the value behind the pulldown menu is 0 and 1

With kind regards,

Alexander