Velocity Reviews > If Then

# If Then

paulmitchell507
Guest
Posts: n/a

 09-03-2008
I am designing a small .asp (classic) application, I am connecting to
a Access 2k database via ADO to retrieve data. I have a number
variable's that contain text that is posted from a previous screen

AMPM = Request.Form("AMPM")
AMPMDate = Request.Form("AMPMDate")
halfday = "(" & AMPM & "," & AMPMDate & ")"

I then compose a CDOSYS email and send the value of the variable in
the .HTML body of the email

..HTML = "Number of Days" & halfday

What I would like to do is only display the value of the halfday
variable if it contains a value. I was thinking along the lines of

If halfday = Null Then
halfday = ""

Else

halfday = halfday

End if

I know this does not work, but it gives an idea of what I am trying to
achieve.
Any help would be appreciated.

Regards

Bob Barrows [MVP]
Guest
Posts: n/a

 09-03-2008
paulmitchell507 wrote:
> I am designing a small .asp (classic) application, I am connecting to
> a Access 2k database via ADO to retrieve data. I have a number
> variable's that contain text that is posted from a previous screen
>
> AMPM = Request.Form("AMPM")
> AMPMDate = Request.Form("AMPMDate")
> halfday = "(" & AMPM & "," & AMPMDate & ")"
>
> I then compose a CDOSYS email and send the value of the variable in
> the .HTML body of the email
>
> .HTML = "Number of Days" & halfday
>
> What I would like to do is only display the value of the halfday
> variable if it contains a value. I was thinking along the lines of
>
> If halfday = Null Then

This will never be true. Comparisons to Null always result in Null. You
probably mean:

If halfday Is Null Then

However, this will also never be the case at this point because in your
previous statements, you assigned values to halfday. I think what you
intend to do is something like;

If AMPM = "" And AMPMDate = "" then
halfday=""
Else
halfday = "(" & AMPM & "," & AMPMDate & ")"
End if

--
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.

Anthony Jones
Guest
Posts: n/a

 09-04-2008
"Bob Barrows [MVP]" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> paulmitchell507 wrote:
>> I am designing a small .asp (classic) application, I am connecting to
>> a Access 2k database via ADO to retrieve data. I have a number
>> variable's that contain text that is posted from a previous screen
>>
>> AMPM = Request.Form("AMPM")
>> AMPMDate = Request.Form("AMPMDate")
>> halfday = "(" & AMPM & "," & AMPMDate & ")"
>>
>> I then compose a CDOSYS email and send the value of the variable in
>> the .HTML body of the email
>>
>> .HTML = "Number of Days" & halfday
>>
>> What I would like to do is only display the value of the halfday
>> variable if it contains a value. I was thinking along the lines of
>>
>> If halfday = Null Then

>
> This will never be true. Comparisons to Null always result in Null. You
> probably mean:
>
> If halfday Is Null Then
>

Your VBScript getting a bit rusty Bob?

If IsNull(halfday) Then

The Is keyword in VBScript tests the type of an object (via the
QueryInterface method).

--
Anthony Jones - MVP ASP/ASP.NET

paulmitchell507
Guest
Posts: n/a

 09-04-2008
On Sep 4, 9:08*am, "Anthony Jones" <(E-Mail Removed)>
wrote:
> "Bob Barrows [MVP]" <(E-Mail Removed)> wrote in messagenews:(E-Mail Removed). ..
>
>
>
>
>
> > paulmitchell507 wrote:
> >> I am designing a small .asp (classic) application, I am connecting to
> >> a Access 2k database via ADO to retrieve data. *I have a number
> >> variable's that contain text that is posted from a previous screen

>
> >> AMPM = Request.Form("AMPM")
> >> AMPMDate = Request.Form("AMPMDate")
> >> halfday = "(" & AMPM & "," & AMPMDate & ")"

>
> >> I then compose a CDOSYS email and send the value of the variable in
> >> the .HTML body of the email

>
> >> .HTML = "Number of Days" & halfday

>
> >> What I would like to do is only display the value of the halfday
> >> variable if it contains a value. *I was thinking along the lines of

>
> >> If halfday = Null Then

>
> > This will never be true. Comparisons to Null always result in Null. You
> > probably mean:

>
> > If halfday Is Null Then

>
> Your VBScript getting a bit rusty Bob?
>
> If IsNull(halfday) Then
>
> The Is keyword in VBScript tests the type of an object (via the
> QueryInterface method).
>
> --
> Anthony Jones - MVP ASP/ASP.NET- Hide quoted text -
>
> - Show quoted text -

Bob's VBScript may/may not be a bit rusty (I am not qualified to
judge, hence my question) but it worked for me!
Thank you both very much for your help.

Bob Barrows [MVP]
Guest
Posts: n/a

 09-04-2008
Anthony Jones wrote:
>>> What I would like to do is only display the value of the halfday
>>> variable if it contains a value. I was thinking along the lines of
>>>
>>> If halfday = Null Then

>>
>> This will never be true. Comparisons to Null always result in Null.
>> You probably mean:
>>
>> If halfday Is Null Then
>>

>
> Your VBScript getting a bit rusty Bob?
>
> If IsNull(halfday) Then
>
> The Is keyword in VBScript tests the type of an object (via the
> QueryInterface method).

Oops. Doing too much sql lately ...

--
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"