U can use IsNull
both in the back end and
front end
HTH Roji
----- Original Message -----
From: <[EMAIL PROTECTED]>
To: "ActiveServerPages" <[EMAIL PROTECTED]>
Sent: Tuesday, October 15, 2002 8:10 PM
Subject: Avoiding Empty Records
> I'm using the below code to add a row with information if the database
> contains any, but sometimes I get info, others, an empty row, others, no
row
> at all..
>
> There must be a better way to ensure that the database field is actually
> empty, VBNull ????
>
> if rs("Fee") <> "" then
> response.write "<tr>" & vbcrlf
> response.write "<font size='2' face='Arial'>" & vbcrlf
> response.write "<td valign='top'><p align='right'>Fee:</font></td>" &
vbcrlf
> response.write "<td><p align='left'><font size='2' face='Arial'
> Color='Black'>" & rs("Fee") & "</font></td>" & vbcrlf
> response.Write"</tr>" & vbcrlf
> end if
>
>
> Tim
>
>
> ---
> 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]
