Urgggg. Blank records...

[wilkeyc]

Greetings...

I'm querying a database and displaying the results. I'm trying to figure out a way to disregard NULL or blank fields. I've written the following code - which I can't undertand why it doesn't work - It should only write lines if the record is not blank or NULL. Can someone shed some light on this for me>

<%If FP_FieldVal(fp_rs,"dtime1")<> "" Then%><%=FP_FieldVal(fp_rs,"dtime1")& "<br>"%><%End If%>


I should mention that I've tried the following:
<%If FP_FieldVal(fp_rs,"dtime1")<> NULL Then%><%=FP_FieldVal(fp_rs,"dtime1")& "<br>"%><%End If%>

[lmf232s]

do this w/ in the sql query.

what ever field is null then do a

WHERE fieldname IS NOT NULL

[wilkeyc]

Thanks. I'll give it a shot