Solved

ASP.NET Form / SQL Logic

Posted on 2011-09-09
3
178 Views
Last Modified: 2012-05-12

Hi,
I'm not sure if this is the correct forum for this question. I'm not necessarily looking for code, but just help with the logic on how I can get something to work .......

I'm creating an ASP.NET (vb) application that is going to be a car mileage claim form. The user inputs car journeys indicating their start mileage and end mileage, the form is totalled and once a month submitted to the payroll section to pay so much per mile.

When the user enters a new journey, the start mileage of the new journey must be equal to or greater than the end mileage of the last journey they input.  This in theory works fine – UNTIL, the user forgets to put one day’s journey in, and then the new journeys start and end mileage are in-between another journey.

0
Comment
Question by:ncht
  • 2
3 Comments
 
LVL 83

Expert Comment

by:Dave Baldwin
ID: 36512996
I think that you should have three variables to check.  Starting Date/Time, starting mileage, and ending mileage.  Possibly Ending Date/Time too if you want to be real picky.  If you have the Starting Date/Time and use that to order the results then you wont' have the overlapping results problem (at least not for legitimate data).  Actually if you just sort on the starting mileage, the results should end up in the correct order.
0
 
LVL 1

Accepted Solution

by:
ncht earned 0 total points
ID: 37216031
Thanks
0
 
LVL 1

Author Closing Comment

by:ncht
ID: 37236421
Found solution elswhere.
0

Featured Post

Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

Question has a verified solution.

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

Lots of people ask this question on how to extend the “MembershipProvider” to make use of custom authentication like using existing database or make use of some other way of authentication. Many blogs show you how to extend the membership provider c…
It was really hard time for me to get the understanding of Delegates in C#. I went through many websites and articles but I found them very clumsy. After going through those sites, I noted down the points in a easy way so here I am sharing that unde…
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

856 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