aspose file tools*
The moose likes JDBC and the fly likes Modify my query to get requests from timeslots Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Modify my query to get requests from timeslots" Watch "Modify my query to get requests from timeslots" New topic
Author

Modify my query to get requests from timeslots

tom davies
Ranch Hand

Joined: Apr 27, 2012
Posts: 168
I have a query which i am using to find the log in duration of users which i have added below.
I now want to modify it so instead of finding the difference between times it finds the web requests between those times from the same user.
I will do this by searching the WebProxy table with the columns
aDate | aTime | UserIP | WebAddress
The time slots are find using the username and finding entries where the message is LIKE '%logged in%' and the associated username where the IP matches and the message is LIKE '%logged out%'
The webProxy results will have to match the IP and be between the time slots found in T1 and T2.
I have had this working with Separate queries and using ArrayLists to store time slots but from my previous topic i have been trying to change these to single queries and ResultSets

 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
 
subject: Modify my query to get requests from timeslots