Last Of (Full Version)

All Forums >> [Web Development] >> ASP, PHP, and Database



Message


chadb -> Last Of (4/28/2009 17:31:07)

What is the best way to check for the last of a record, example, 20 records of the date 01/01/09 and I want to do something after the last one?

Thanks
Chad




TexasWebDevelopers -> RE: Last Of (4/29/2009 14:16:29)

I don't understand what you want to do.
If you want to write the last record you could select the first item of a reversed select like: sql="SELECT TOP1 [field_name] FROM [table_name] WHERE [date_field] = [your date requirements] ORDER BY DESC;"
If you want to write into the data then just do a sql insert and it will be the last entry.




Page: [1]

Valid CSS!




Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI
0.0625