Solved

Simple If

Posted on 2004-04-15
9
174 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
Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

 
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

Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Apache server configuration 7 82
java cyclic graphs 15 208
console vs log file 16 79
Limiting the number of characters a user can type in a text field 6 54
FAQ pages provide a simple way for you to supply and for customers to find answers to the most common questions about your company. Here are six reasons why your company website should have a FAQ page
Employees depend heavily on their PCs, and new threats like ransomware make it even more critical to protect their important data.
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …

813 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

Need Help in Real-Time?

Connect with top rated Experts

8 Experts available now in Live!

Get 1:1 Help Now