Type mismatch: 'Server.HTMLEncode' ASP

Question

I need to encode the contents of the record, and I use this code:

If(rsScadenze("testo") <> "") Then myString = rsScadenze("testo") 'this is a result of a query myEncodeString=Server.HTMLEncode(myString) 'here there is my error 

Can someone help me?

thanks

Answer 1

Is the result your NULL entry?

Try Server.HTMLEncode (rsScadenze ("testo") and "")

Answer 2

change

If (rsScadenze ("testo") <> "") Then

to

If ("" and rsScadenze ("testo") <> "") Then

why?

in case rsScadenze ("testo") returns as null, adding to it, "makes it"

this is an easier way to deal with potential zeros.