Maybe you should try something like:
If Rs("FieldName") = "" Then
'Do Something
End If
Max.
-----Original Message-----
From: [email protected]
[mailto:[EMAIL PROTECTED] On Behalf Of shortestpath
Sent: Saturday, August 20, 2005 1:55 AM
To: [email protected]
Subject: [ASP] OT: empty sql server text data type field
I'm retrieve some fields from sql server. One of those fields is of
data type text. How can I check using asp if there's no value in that
field? IsEmpty and IsNull are giving me False. Len throws an error.
---------------------------------------------------------------------------
CRBAfrica - providing professional debt management and credit reference
bureau services in Kenya, Uganda, Botswana, Tanzania, Ghana, Zambia, Mauritius
and Egypt.
---------------------------------------------------------------------------
AccessKenya - Your Corporate ISP - CRB's solution provider for fast
efficient Email and Internet Services
---------------------------------------------------------------------------
ATTENTION
---------------------------------------------------------------------------
The information in this electronic mail message is private and confidential
and only for the addressee. Should you receive this message by mistake,
you are hereby notified that any disclosure, reproduction, distribution or
use of this message is strictly prohibited. Please inform the sender by reply
transmission and delete the message without copying or opening it. Any
unauthorised use or interception of this e.mail is illegal. If this e.mail is
not
intended for you, you may not copy, distribute or disclose the contents to
anyone. Save for the bona fide company matters, the CRB Group of
companies does not accept responsibility for the opinions expressed in
this e.mail.
---------------------------------------------------------------------------
------------------------ Yahoo! Groups Sponsor --------------------~-->
<font face=arial size=-1><a
href="http://us.ard.yahoo.com/SIG=12hf570pp/M=362131.6882499.7825260.1510227/D=groups/S=1705115381:TM/Y=YAHOO/EXP=1124534578/A=2889191/R=0/SIG=10r90krvo/*http://www.thebeehive.org
">Get Bzzzy! (real tools to help you find a job) Welcome to the Sweet Life
- brought to you by One Economy</a>.</font>
--------------------------------------------------------------------~->
---------------------------------------------------------------------
Home : http://groups.yahoo.com/group/active-server-pages
---------------------------------------------------------------------
Post : [email protected]
Subscribe : [EMAIL PROTECTED]
Unsubscribe: [EMAIL PROTECTED]
---------------------------------------------------------------------
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/active-server-pages/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
