What is a "Foreword" to a blog?
If Then
Hello Guest		   
  • Login
• Register…
• Start blog		   • Who, Where, When
• What can I do?
• What to Read?		   • Polls
• Avatars
• Interests		   • Cities and Countries
• Random blog
• Users search		   • Search
• Games
• Tests
• QAIX		   • Сообщества
• Talxy Chat
• Horoscope
• Online		  
Зарегистрируйся!
QAIX > ASP web-programming > If Then 4 September 2008 11:08:02
  Recent blog posts: 
_4_
…

mego day!
:-O­ yesss I today went for a walk from a 6 morning! it super! so merrily that pipec!

Everybody is a book
Everybody is a book, parents are our publishing houses, and our publication time on birthday, the ID…

boring..boring...boring :-|…
boring..boring...bor­­ing :-|­ where people? bitchs...not abandon me one…

here so quietly and boring! on…
here so quietly and boring! on beone merrier far! well but I can sit in a quiet.... and not who by the…

Transfer iTunes Library to Zune
If you have moved from Apple iPod to Microsoft Zune, you probably have some songs that you purchased&hellip­;

hello!
hello!I here new! interestingly me what people dwell on this site... I search friends from the command…

Routes on Sale!
Looking for great Quality/Competitive­­ Rates???? Breezecom FZC is offering: PAKISTAN! CLI…

Hello!
Hello!

How to rip DVD and convert…
You may have at hand many fantastic DVD movies and video files, which you definitely love very much…

  Forums:   
    topic feeds

• QAIX  all topics, blogs and comments

• PHP web-programming

• Perl web-programming

• ASP web-programming

• Visual Basic Programming

• .Net Development

• C/C++ Programming

• Java Programming

• Javascript web-programming

• Apache HTTP Server

• Web-design

• Web-hosting, dedicated, colocation

• HTML web-programming

• XML development

• General Web-programming

• Content Management Systems

• ColdFusion

• Search Engine Optimization

• Hardware

• Software, Computer Help

• MySQL database development

• PostgreSQL database development

• MS Access database development

• Oracle database development

• MS SQL database development

• Informix database development

• Buy / Sell

• Open discussion

• Anonymous
  Discuss: 
Select Records between…
I've built a Point-of-Sale using "classic" asp (it's what I know) and I'm trying to get daily…

Borwser prompts for…
I have put together a very simple internal web site that runs on Windows 2003 Server. Anonymous access…

Possible to include SSI in ASP…
Hi, We want to include some SSI in our ASP pages, but where the SSI is located on a different server…

text wait or hourglass
Hi Can someone please help me with the following: I have an ASP-page where a query runs, it…
  Recent forum topics: 
[blead-227-gbd2db5d] mkppport…
Small fix, mkppport is using catfile instead of catdir. -John wb8tyw@gmai.com…

[blead-227-gbd2db5d]…
When VMS is in UNIX mode, conversions from UNIX specifications to VMS can result in a trailing '.'…

[blead-227-gbd2db5d]…
The tests lib/blib.t and lib/h2xs.t need fixes to know when VMS is in the UNIX report mode. -John…
  Recent forum comments:
RE: [blead-259-gca03d8e] VMS thread…
On Jan 5, 2009, at 11:30 PM, John Malmberg wrote: You missed this one, but I added it and applied…

RE: [blead-259-gca03d8e] VMS thread…
John Malmberg wrote: This patch also fixes a memory leak in trim_unixpath(). -John wb8tyw@gmail.com…

RE: Limitation in Number of Fields…
No And it is probably to long to post here You need to check for a broken form - tables or other block…

RE: How to Create a Cross-Frame…
Can't be done. A frame is a window, and all content (including fly out menus), will be constrained to…

RE: Captcha
FrontPage validation will not work if Javascript is turned off in the browser, often the case with…

RE: How to Create a Cross-Frame…
sharsy, I have read this post, but using frames is no longer a strong point with me. If I can help, I…

RE: Limitation in Number of Fields…
Stefan, The form is used for Athletic Registration and can be only accessed locally from within the…

RE: Captcha
You can do a simple captcha-like validation with FP's forms...just put question there like; Ice is Hot…

RE: Limitation in Number of Fields…
Post a URL to the form online -- ___________________­____________________­______ SBR…

RE: Limitation in Number of Fields…
Stefan, Thanks for your response ... The last field that is captured by the database in called (40…
  Moderators:
 Administrator
 Protorioris

If Then

Paulmitchell507 4 September 2008 11:08:02
 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("AMPMD­ate")
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

Add comment
Bob Barrows 3 September 2008 17:49:34 [ permanent link ]
 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("AMPMD­ate")
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.


Add comment
Anthony Jones 4 September 2008 11:08:02 [ permanent link ]
 "Bob Barrows [MVP]" <reb01501@NOyahoo.S­PAMcom> wrote in message
news:uzdFJRdDJHA.34­32@TK2MSFTNGP05.phx.­gbl...
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("AMPMD­ate")
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



Add comment
 

Add new comment

As:
Login:  Password:  
 
 
  
 
Пожалуйста, относитесь к собеседникам уважительно, не используйте нецензурные слова, не злоупотребляйте заглавными буквами, не публикуйте рекламу и объявления о купле/продаже, а также материалы нарушающие сетевой этикет или УК РФ.

QAIX > ASP web-programming > If Then 4 September 2008 11:08:02
see also:
function for current date-time
How to split a table?
Newbie needs help with ERROR: could not…
пройди тесты:
see also:
Everybody is a book
Greeting from VevoCart Team
How to Remove DRM from iTunes AAC M4V…
  Copyright © 2001—2008 QAIX
Idea: Miсhael Monashev
Помощь и задать вопросы можно в сообществе support.qaix.com.
Сообщения об ошибках оставляем в сообществе bugs.qaix.com.
Предложения и комментарии пишем в сообществе suggest.qaix.com.
Информация для родителей.
Write us at:
If you would like to report an abuse of our service, such as a spam message, please .