wood burning stoves 2.0*
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

 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Modify my query to get requests from timeslots
 
Similar Threads
need help in pivot
paging resultset in servlets
retrieve data from huge result set
SQL question
sql syntax question