Solved

Simple If

Posted on 2004-04-15
9
175 Views
Last Modified: 2010-04-01
This is causing me a real pain and I cannot figure out why this is not working!!

simple if Statement:-

<% if (varDelTime==("00:00:00") ) {%> N/A <%ELSE%><%=varDelTime%><%}%>

Basically if varDelTime has no delivery time i.e. 00:00:00 show n/a in the table

The datatype in the SQL table for del time is a varchar 8.

I tried converting varDelTime to an int but it had a problem with the :
0
Comment
Question by:Pigdogmonster
  • 6
  • 3
9 Comments
 
LVL 9

Accepted Solution

by:
Nick_72 earned 20 total points
ID: 10833745
try:

<% if (varDelTime.equals("00:00:00") ) {
%>   N/A
<% }
      else {
         out.println(varDelTime);
       }
%>
0
 

Author Comment

by:Pigdogmonster
ID: 10833951
wicked thanks!

I need to readjust my brain - its because I have been working on ASP for the last 2 weeks!

just one quick thing on this - Do you know how I would display the time without the seconds?

i.e. at the moment it shows the time like this 09:00:00

I just want it to show: 09:00

0
 
LVL 9

Expert Comment

by:Nick_72
ID: 10833990
:)

the easiest way would be to:

out.println(varDelTime).substring(0, 5);
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 9

Expert Comment

by:Nick_72
ID: 10833995
argh, that would be

out.println(varDelTime.substring(0, 5));
0
 

Author Comment

by:Pigdogmonster
ID: 10834167
cool - for future ref:-  what does the 0, 5 denote?
0
 
LVL 9

Expert Comment

by:Nick_72
ID: 10834305
A String is zero based, which means that the index of the first character is 0,
so substring(0, 5) means: start at position 0 (first position, which is included in the substring) and end at position 5 (which is not included in the substring).

so index
0 = 0
1 = 9
2 = :
3 = 0
4 = 0

Another way to look at it is, start at position 0 and take 5 characters.

/Nick

09:00:00
0
 
LVL 9

Expert Comment

by:Nick_72
ID: 10834313
oops, ignore the last 09:00:00 :)
0
 

Author Comment

by:Pigdogmonster
ID: 10834462
thats great thanks Nick!
0
 
LVL 9

Expert Comment

by:Nick_72
ID: 10834620
no problem :)
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Facebook has became the #1 social media platform. People share many funny videos there, yet you don't know how to download them? Now you can download Videos from Facebook in just 3 simple steps.
Arrow Electronics was searching for a KVM  (Keyboard/Video/Mouse) switch that could display on one single monitor the current status of all units being tested on the rack.
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an antispam), the admini…

713 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question