«

Hello there

Im having trouble in storing blank or space value on a variable wich data
type is Date/Time, if i make a statement like this

Field Data Type
CPARCAVEDate Date/Time

strCPARCAVEDate = rstFEVV.fields("CPARCAVEDate").value

if strCPARCAVEDate = "" then
counter = counter + 1
end if

The value doesnt increment. Do you guys have an idea how to recognize a no
value

Thanks
Leo

IsNull()
IsEmpty()
Len()

ASP isn't like VB, so most of the time (depending on what you are doing of
course), you can switch datatype checks while you go ...

e.g;

sSomeDate = "10/05/2005"
Response.Write "sSomeDate: " & sSomeDate & "<br><br>"
Response.Write "Len: " & Len(sSomeDate) & "<br>"
Response.Write "IsNull: " & IsNull(sSomeDate) & "<br>"
Response.Write "IsEmpty: " & IsEmpty(sSomeDate) & "<br>"

http://mysteryfcm.plus.com/misc/pdatatype.asp


--
Regards

Steven Burn
Ur I.T. Mate Group
www.it-mate.co.uk

Keeping it FREE!

"leo" <> wrote in message
news:...
> Hello there
>
> Im having trouble in storing blank or space value on a variable wich data
> type is Date/Time, if i make a statement like this
>
> Field Data Type
> CPARCAVEDate Date/Time
>
> strCPARCAVEDate = rstFEVV.fields("CPARCAVEDate").value
>
> if strCPARCAVEDate = "" then
> counter = counter + 1
> end if
>
> The value doesnt increment. Do you guys have an idea how to recognize a no
> value
>
> Thanks
> Leo
>
>
>

Steven Burn wrote:
> IsNull()
> IsEmpty()
> Len()

Since he is dealing with dates, I would add IsDate() to this list.

>
> ASP isn't like VB,

You mean "vbscript isn't like VB"

> so most of the time (depending on what you are
> doing of course), you can switch datatype checks while you go ...
>

I think you meany to say: in vbscript, all variables are Variants, so their
datatypes are not predefined, and vbscript does implicit conversions
depending on the use being made of the data contained in the variable. For
example, if a method expects a string argument, vbscript will implicitly
convert the value being supplied to the method to a string (if possible).
E.G:

myDate = #2005/10/24# 'definitely contains a date
Response.Write myDate

Response.Write expects a string argument, so vbscript converts the date to a
string

>> Im having trouble in storing blank or space value on a variable wich
>> data type is Date/Time, if i make a statement like this
>>
>> Field Data Type
>> CPARCAVEDate Date/Time
>>
>> strCPARCAVEDate = rstFEVV.fields("CPARCAVEDate").value
>>
>> if strCPARCAVEDate = "" then
>> counter = counter + 1
>> end if
>>

Steven's advice will work for you. I was just adding some additional
information.

Bob Barrows
--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"

Bob,
hehe, cheers for the AI (was trying to keep it simple, lol).

.... and yep.. meant VBScript ;o) (tend to class 'em as virtually the same
thing personally - saves confusion for people I'm talking to, lol)

--
Regards

Steven Burn
Ur I.T. Mate Group
www.it-mate.co.uk

Keeping it FREE!

"Bob Barrows [MVP]" <> wrote in message
news:#...
> Steven Burn wrote:
> > IsNull()
> > IsEmpty()
> > Len()
>
> Since he is dealing with dates, I would add IsDate() to this list.
>
> >
> > ASP isn't like VB,
>
> You mean "vbscript isn't like VB"
>
> > so most of the time (depending on what you are
> > doing of course), you can switch datatype checks while you go ...
> >
>
> I think you meany to say: in vbscript, all variables are Variants, so
their
> datatypes are not predefined, and vbscript does implicit conversions
> depending on the use being made of the data contained in the variable. For
> example, if a method expects a string argument, vbscript will implicitly
> convert the value being supplied to the method to a string (if possible).
> E.G:
>
> myDate = #2005/10/24# 'definitely contains a date
> Response.Write myDate
>
> Response.Write expects a string argument, so vbscript converts the date to
a
> string
>
> >> Im having trouble in storing blank or space value on a variable wich
> >> data type is Date/Time, if i make a statement like this
> >>
> >> Field Data Type
> >> CPARCAVEDate Date/Time
> >>
> >> strCPARCAVEDate = rstFEVV.fields("CPARCAVEDate").value
> >>
> >> if strCPARCAVEDate = "" then
> >> counter = counter + 1
> >> end if
> >>
>
> Steven's advice will work for you. I was just adding some additional
> information.
>
> Bob Barrows
> --
> Microsoft MVP - ASP/ASP.NET
> Please reply to the newsgroup. This email account is my spam trap so I
> don't check it very often. If you must reply off-line, then remove the
> "NO SPAM"
>
>

Steven Burn wrote:
> Bob,
> hehe, cheers for the AI (was trying to keep it simple, lol).
>
> ... and yep.. meant VBScript ;o) (tend to class 'em as virtually the
> same thing personally - saves confusion for people I'm talking to,
> lol)
>
.... except for the ones using jscript in their server-side code
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

rofl yep.... 'cept I don't use that one personally ;o)

--
Regards

Steven Burn
Ur I.T. Mate Group
www.it-mate.co.uk

Keeping it FREE!

"Bob Barrows [MVP]" <> wrote in message
news:...
> Steven Burn wrote:
> > Bob,
> > hehe, cheers for the AI (was trying to keep it simple, lol).
> >
> > ... and yep.. meant VBScript ;o) (tend to class 'em as virtually the
> > same thing personally - saves confusion for people I'm talking to,
> > lol)
> >
> ... except for the ones using jscript in their server-side code
> --
> Microsoft MVP -- ASP/ASP.NET
> Please reply to the newsgroup. The email account listed in my From
> header is my spam trap, so I don't check it very often. You will get a
> quicker response by posting to the newsgroup.
>
>

Thanks guys this is really a great help

thaaankssss...

"Steven Burn" <> wrote in message
news:#...
> rofl yep.... 'cept I don't use that one personally ;o)
>
> --
> Regards
>
> Steven Burn
> Ur I.T. Mate Group
> www.it-mate.co.uk
>
> Keeping it FREE!
>
> "Bob Barrows [MVP]" <> wrote in message
> news:...
> > Steven Burn wrote:
> > > Bob,
> > > hehe, cheers for the AI (was trying to keep it simple, lol).
> > >
> > > ... and yep.. meant VBScript ;o) (tend to class 'em as virtually the
> > > same thing personally - saves confusion for people I'm talking to,
> > > lol)
> > >
> > ... except for the ones using jscript in their server-side code
> > --
> > Microsoft MVP -- ASP/ASP.NET
> > Please reply to the newsgroup. The email account listed in my From
> > header is my spam trap, so I don't check it very often. You will get a
> > quicker response by posting to the newsgroup.
> >
> >
>
>