ASP blank fields

[vero]

I notice that on my webpage: when I check if a field in a database is not blank then I write the Item out else I write the word "None".

I use this for various fields on my page. The problem is that when the field is not blank it won't write the field out.

Can someone tell me what I'm doing wrong.

This is how my code looks
<% if qryEmp(middlename) <> "" then response.write qryEmp(middlename) else response.write "None" end if %>

[Jake Duckworth]

Your problem is that the database field is not blank, it is null... what you
need to do is convert the null values to an empty string when doing your
comparison. Try this code:

<%if qryEmp(middlename) & "" <> "" then
response.write qryEmp(middlename)
else
response.write "None"
end if %>

Jake Duckworth


vero <c_vero00@yahoo.com> wrote:
>I notice that on my webpage: when I check if a field in a database is not
blank then
>I write the Item out else I write the word "None".
>
>I use this for various fields on my page. The problem is that when the
field is not
>blank it won't write the field out.
>
>Can someone tell me what I'm doing wrong.
>
>This is how my code looks
><% if qryEmp(middlename) <> "" then response.write qryEmp(middlename) else
response.write
>"None" end if %>