sugoi_kat Posted April 30, 2006 Share Posted April 30, 2006 i'm just wondering if it was possible to use SQL to retrieve the latest information.Part of the database has to retrieve the last exercise the student has completed regardless of when they completed it, in other words, user's don't specify a date.The date of when this exercise is completed is going to be placed on the form along with the name of the exercise. Link to comment Share on other sites More sharing options...
justsomeguy Posted May 1, 2006 Share Posted May 1, 2006 i'm just wondering if it was possible to use SQL to retrieve the latest information.Part of the database has to retrieve the last exercise the student has completed regardless of when they completed it, in other words, user's don't specify a date.The date of when this exercise is completed is going to be placed on the form along with the name of the exercise. Just get all records (or limit 1) and order them descending by date. The first record will be the most recent. Link to comment Share on other sites More sharing options...
pulpfiction Posted May 1, 2006 Share Posted May 1, 2006 Hi, You can also check for the higest value of the Identity Column for that student. this will be the last record added for that student. Link to comment Share on other sites More sharing options...
muhammadadilmalik Posted May 15, 2006 Share Posted May 15, 2006 Hi, You can also check for the higest value of the Identity Column for that student. this will be the last record added for that student.<{POST_SNAPBACK}> all the two solution are good but i think you have to send student name or login name in where clause also other wise it will give you general results Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now