Last Of

	Home Register Search Help Login

Sponsors
Frontpage website templates
Creative Website Templates for FrontPage, Dreamweaver, Flash, SwishMax
Shopping Cart Software
Ecommerce software integrated into Frontpage, Dreamweaver and Golive templates. No monthly fees and available in ASP and PHP versions.
Website Templates
We also have a wide selection of Dreamweaver, Expression Web and Frontpage templates as well as webmaster tools and CSS layouts.

Recent Posts
Todays Posts
Most Active posts
Posts since last visit
My Recent Posts
Mark posts read

Last Of

View related threads: (in this forum | in all forums)

Logged in as: Guest

Users viewing this topic: none

Printable Version

All Forums >> Web Development >> ASP, PHP, and Database >> Last Of

Page: [1]


chadb Posts: 524 From: Kansas Status: offline	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 Posts: 761 Joined: 2/22/2002 From: Dallas, TX Status: offline	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. _____________________________ Follow us on TWITTER (in reply to chadb)