Solved

# Simple If

Posted on 2004-04-15
Medium Priority
189 Views
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
Question by:Pigdogmonster
• 6
• 3

LVL 9

Accepted Solution

Nick_72 earned 80 total points
ID: 10833745
try:

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

Author Comment

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

ID: 10833990
:)

the easiest way would be to:

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

LVL 9

Expert Comment

ID: 10833995
argh, that would be

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

Author Comment

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

LVL 9

Expert Comment

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

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

Author Comment

ID: 10834462
thats great thanks Nick!
0

LVL 9

Expert Comment

ID: 10834620
no problem :)
0

## Featured Post

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.