|
 |
asp_databases thread: Checking of blank records
Message #1 by "Joe" <bugmania76@y...> on Thu, 12 Sep 2002 10:07:34
|
|
Hi guys, i've got a problem here, Is there a way to check for empty fields
in the database?
What i have are rows of records, some with empty fields, but some are not.
If i were to use the normal check routine rs.EOF or rs.BOF, it will only
give me the result of the whole recordset.
What i needed is the command to check for indivisual field,
something like rs("image").EOF (pardon me,i know this sentences is
invalid")
I've tried things like
If rs("Image") = "" Then
do this
Else
do that
End If
but it seems like even the particular record is empty,
it still not equal to ""..
Help needed, Thanks in advance
Joe
Message #2 by Sunil Singh <sunil.singh@i...> on Thu, 12 Sep 2002 14:47:56 +0530
|
|
Hi
u can use..
if isNull(rs("image")) then
do this
Else
do that
End If
Regds
Sunil...
-----Original Message-----
From: Joe [mailto:bugmania76@y...]
Sent: Thursday, September 12, 2002 3:38 PM
To: ASP Databases
Subject: [asp_databases] Checking of blank records
Hi guys, i've got a problem here, Is there a way to check for empty fields
in the database?
What i have are rows of records, some with empty fields, but some are not.
If i were to use the normal check routine rs.EOF or rs.BOF, it will only
give me the result of the whole recordset.
What i needed is the command to check for indivisual field,
something like rs("image").EOF (pardon me,i know this sentences is
invalid")
I've tried things like
If rs("Image") = "" Then
do this
Else
do that
End If
but it seems like even the particular record is empty,
it still not equal to ""..
Help needed, Thanks in advance
Joe
Message #3 by "Awdhil" <Awdhil@g...> on Thu, 12 Sep 2002 12:10:58 +0300
|
|
Hi:
When a field is empty in DB, it is NULL. I cannot be equated with
"=3D".
Check for NULL or nothing. Shud work fine
Hope this helps
Regards
Syed Awdhil Ahmed
September 12, 2002
-----Original Message-----
From: Joe [mailto:bugmania76@y...]
Sent: Thursday, September 12, 2002 1:08 PM
To: ASP Databases
Subject: [asp_databases] Checking of blank records
Hi guys, i've got a problem here, Is there a way to check for empty
fields
in the database?
What i have are rows of records, some with empty fields, but some are
not.
If i were to use the normal check routine rs.EOF or rs.BOF, it will only
give me the result of the whole recordset.
What i needed is the command to check for indivisual field,
something like rs("image").EOF (pardon me,i know this sentences is
invalid")
I've tried things like
If rs("Image") =3D "" Then
do this
Else
do that
End If
but it seems like even the particular record is empty,
it still not equal to ""..
Help needed, Thanks in advance
Joe
|
|
|
View Cart
