empty value of ms access, asp, vbscript

Forums

My Profile

Inbox

Address Book

My Subscription

My Forums

empty value of ms access, asp, vbscript

Logged in as: Guest

arrSession:exec spGetSession 2,3,53625

	Active Users: There are 0 members and 0 guests.
	Users viewing this topic: none

Printable Version

All Forums >> [Scripting] >> ASP >> empty value of ms access, asp, vbscript
Do you like VisualBasicScript.com? Link to us and help spread the word about our forum. Thanks!

Page: [1]

Message

<< Older Topic Newer Topic >>

empty value of ms access, asp, vbscript - 11/17/2007 3:06:17 PM

Dilruba

Posts: 5
Score: 0
Joined: 11/11/2007
Status: offline

How we can recognize an empty value of ms access field.

suppose :
[CODE]Dim empVal, empVal1, num
num = 0
empVal = Recordset.Fields.Item("subj").Value
empVal1 = Recordset.Fields.Item("org").Value[/CODE]
here empVal = "" and empVal1 = "" i. e. in the database there are no value i.e. empty
so if i wrote
[CODE]If ( (empVal = "") AND (empVal = "") ) Then
num = num + 1
response.write num
response num
end if [/CODE]
here value should show "1"
But it is not entering within the if condition.
So, how can we evaluate the value of empty