Null compared to anything (including Null) yields a null result (i.e. False). When looking for Null values in your (VB[Script]) code, use the IsNull() function. In SQL statements, use WHERE THUMBNAIL IS NOT NULL.
HTH, Tore. -----Original Message----- From: jake williamson [mailto:[EMAIL PROTECTED]] Sent: Friday, September 06, 2002 5:04 AM To: ActiveServerPages Subject: desperate! null detect just not working!! 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]
