Ok this is starting to bug me.
What I'm trying to do is display a list on records from the Database.
If a field is empty then I should display an image.
Here is the code.....


If rslist.fields("tablename")="" then <<<<<<problem is here
Response.Write "<table border=0 cellpadding=0 cellspacing=0
style=border-collapse: collapse width=100% bordercolor=#FF0000>" & vbcrlf & _
"<tr>" & vbcrlf & _
"<td>" & vbcrlf & _
"<p class=8><img border=0 src=images/emptyfield.gif width=146 height=10></td>" & vbcrlf & _
"</tr>" & vbcrlf & _
"</table>"

Else

Response.Write "<table border=0 cellpadding=0 cellspacing=0 style=border-collapse: collapse width=100% bordercolor=#FF0000>" & vbcrlf & _
"<tr>" & vbcrlf & _
"<td>" & vbcrlf & _
"<p class=8>" & rslist("tablename") & "</td>" & vbcrlf & _
"</tr>" & vbcrlf & _
"</table>"

End IF


I have tried using...

If rslist.fields("tablename")<> 0 then

but it only works with numbers

This is probably due to the fact that the field is not an empty string, but null. Either append an empty string to the field's value before you compare, or check the Length of the field's value:

If rslist.Fields("tablename").Value & "" = "" Then

This chnges any null value into an empty string ("") so you can successfully compare it with another empty string.

Alternatively, use this:

If Len(rslist.Fields("tablename").Value) = 0 Then

Both Null and an empty string have a length of 0.

HtH,

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.

Ever ask a question because your so wired up then someone gives you the answer and you thinking "%#!@!?*....I somehow knew that"

Thank You very much

Yeah, that sounds familiar.... ;)

Glad I could help.

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.