?
Solved

Simple If

Posted on 2004-04-15
9
Medium Priority
?
189 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 80 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
Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

 
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

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Read this post to discover how will you get your first iPhone App Approved by Apple. Make these necessary changes to prevent rejection of the app.
Article by: Eric
When it comes to building apps, it's more than just writing code. And unfortunately, many people (and companies) forget that. In fact, the raw time it takes to build the app itself is only half the battle.
When you have multiple client accounts to manage, it often feels like there aren’t enough hours in the day. With too many applications to juggle, you can’t focus on your clients, much less your growing to-do list. But that doesn’t have to be the cas…
Watch the software video of Kernel Import PST to Office 365 tools which can easily import PST and OST files to Office 365 for bulk mailboxes. The process of migration is simple and user can map source and destination mailboxes and easily import data…

590 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