I have this if then statement that does not return the correct results...even though it is in black and white. please help if you can...
'Retrieve Customer's Info
mySQL = "SELECT " _
& "FROM customers " _
& "WHERE idCust = " & validSQL(idCust,"I") & " "
'Set CursorLocation of the Connection Object back to Server
connTemp.CursorLocation = adUseServer
<%
qpremium = trim(Request.QueryString("premium"))
if len(qpremium) = "Yes" then
%>
Welcome to the Customer Resource Center for Premium Members Only!
<% else %>
Customer Resource Center for Premium Members Only.
<% end if %>
It will only show the first statement if user is premium or not, then if I change the if then statement to
if len(qpremium) = "Yes" then....
the user sees second statement whether premium or not.
??????Puzzled??????