Jake,
Try this:
If isnull(productsResults.Fields.Item("THUMBNAIL")) OR 
productsResults.Fields.Item("THUMBNAIL") = "" THEN
...

HTH,
Jesse

At 02:04 AM 9/6/02, you wrote:

>hello,
>
>got a real simple null detection script in a web page that works on other 
>sites i've done, i just cant figure out why it's not working on this one!
>
>this is it:
>
><%
>If productsResults.Fields.Item("THUMBNAIL") = null OR 
>productsResults.Fields.Item("THUMBNAIL") = "" THEN
>         Response.Write ""
>         Else
>         Response.Write "then write the image"
>End If
>%>
>
>it looks at the THUMBNAIL column and if it is null or has no entry nothing 
>is written to the page. if it is though, it writes the image.
>
>but it isn't working!! when i run the query in dw it shows null in the 
>results panel????
>
>any thoughts??? it's real desperate, i neet ot get this site up today!
>
>cheers,
>
>jake
>
>
>---
>You are currently subscribed to activeserverpages as: [EMAIL PROTECTED]
>To unsubscribe send a blank email to 
>%%email.unsub%%


---
You are currently subscribed to activeserverpages as: [email protected]
To unsubscribe send a blank email to [EMAIL PROTECTED]

Reply via email to