Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: tridith
- Content: Threads
- Order by date
-
4 table query...maybe 5??
I don't know if I will be able to describe this very well, I hardly understand it...who am I kidding, I don't understand it. On the page that I have to make selections from that are used to build the query are. StartDate, EndDate, List of trucks, drop down with sensor names populated from...- tridith
- Thread
- Replies: 11
- Forum: Oracle: All versions
-
Is This Statement Valid?
IIF("@Data.heading~" <= "22.4", "N", IIF("@Data.heading~" <= "67.4", "NE", IIF("@Data.heading~" <= "112.4", "E", IIF("@Data.heading~" <= "157.4", "SE", IIF("@Data.heading~" <= "202.4", "S", IIF("@Data.heading~" <= "247.4", "SW", IIF("@Data.heading~" <= "292.4", "W", IIF("@Data.heading~" <=... -
Group By Date
The query I need, I suspect will be very close to the one below. The query below returns a total of distance traveled between 2 dates for each truck. So if I select 2 dates that span a week, it will return the total distance traveled over the week for each truck. The new query that I am trying...- tridith
- Thread
- Replies: 2
- Forum: Oracle: All versions
-
Between Date Trouble
What I am doing is making a report displaying all the trucks that are inactive for a certian amount of time. The time that we are going to use is selected from a dropdown box(1-24hours) So, if I pick 3 from the dropdown box, I want to display all the trucks that have been inactive for over 3...- tridith
- Thread
- Replies: 11
- Forum: Oracle: All versions
-
CASE Missing Keyword
What I have is one table that I have a "heading" it is a number that is between 0 and 360. What I want to do is change it to a N,E,S,W,NW,SW,NE,SE heading. N = (0-22.4) NE = (22.5-67.4) E = (67.5-112.4) SE = (112.5-157.4) S = (157.5-202.4) SW = (202.5-247.4) W = (247.5-292.4) NW = (292.5-337.4)...- tridith
- Thread
- Replies: 5
- Forum: Oracle: All versions
-
SQL max and date trouble
I have one table, (table1). Fields (date, asset_id, and location)..*and some other ones* I want to get the most resent date and the location on that date, for each asset_id. I was trying to use a MAX() on the date, in combination with a distinct on the asset_id. It didnt work. How do I do... -
....Editing Page for a multi page Webform...
I am making a 4 paged webform where the user will be using textboxes, checkboxes, radio buttons, and dropdownboxes. I have finished the part where the user is entering in a new "product", now I am trying to make it possible for the user to select a previously entered in product and edit it...- tridith
- Thread
- Replies: 1
- Forum: Microsoft: ASP.NET
