Variable problem

Forums

My Profile

Inbox

Address Book

My Subscription

My Forums

Variable problem

Logged in as: Guest

arrSession:exec spGetSession 2,3,39484

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

Printable Version

All Forums >> [Scripting] >> ASP >> Variable problem
Do you like VisualBasicScript.com? Link to us and help spread the word about our forum. Thanks!

Page: [1]

Message

<< Older Topic Newer Topic >>

Variable problem - 11/6/2006 6:55:39 PM

shajimanjeri

Posts: 2
Score: 0
Joined: 10/31/2006
Status: offline

Hi all,

when I execute a query like this
Dim todayDate
todayDate = 10/30/2006
' Case 1
SELECT DATEADD(day, DATEDIFF(day, 0, dateVariable), 0) = todayDate
The result is getting false means zero

at same way if I execute like this
' Case 2
SELECT DATEADD(day, DATEDIFF(day, 0, dateVariable), 0) = 10/30/2006
The result is getting True means One

What is the wrong here

In the case1, I just compared with a variable
In case2, Just compared direct value, with out using a variable

Could you pls help me!

Shaji