CodeVerge.Net Beta


   Explore    Item Entry   Register  Login  
Microsoft News
Asp.Net Forums
IBM Software
Borland Forums
Adobe Forums
Novell Forums

ASP.NET Web Hosting
Microsoft Gold Certified Partner – 3 Months Free and Free Setup



Can Reply:  No Members Can Edit: No Online: Yes
Zone: > NEWSGROUP > Asp.Net Forum > starter_kits_and_source_projects.microsoft_application_blocks Tags:
Item Type: NewsGroup Date Entered: 9/9/2004 8:38:22 PM Date Modified: Subscribers: 0 Subscribe Alert
Rate It:
NR
XPoints: N/A Replies: 0 Views: 26 Favorited: 0 Favorite
1 Items, 1 Pages 1 |< << Go >> >|
griff303
Asp.Net User
selecting 15 records at a time...9/9/2004 8:38:22 PM

0

I'm in the process of creating a little post site, where they can enter in a post and it will show after. I have an Access DB with the auto # on. When the page_loads for the first time it binds the datalist with the TOP 15 DESC(because of the most rescent). What is the easiest way to do a select on a range that I have in session variables?? I am going to keep track of the last post # and 15 message #'s from last post # in order to go every 15 post displayed. Is there an easy SQL query to do that??

EX. Start Post #20 - 6, then hit the next button and display pst # 5 - 1...
- km

______________________________________

"always here and always forever"
1 Items, 1 Pages 1 |< << Go >> >|


Free Download:

Books:
Access 2003 Bible Authors: Cary N. Prague, Michael R. Irwin, Jennifer Reardon, Pages: 1464, Published: 2003
How to Do Everything with Microsoft Office Access 2003 Authors: Virginia Andersen, Pages: 556, Published: 2003

Web:
selecting 15 records at a time... - ASP.NET Forums selecting 15 records at a time... Last post 09-09-2004 4:38 PM by griff303. 0 replies. Sort Posts:. Oldest to newest, Newest to oldest ...
SQL Server Forums - Selecting Records Between Time ranges on Dates Selecting Records Between Time ranges on Dates, New Topic · Reply to Topic ... 5 /8/2008 4:23:25 AM, 0200, 5/8/2008, M20, 5/8/2008 5:15:34 AM ...
HQL query to select first records in time interval. : Hibernate, HQL HQL query to select first records in time interval. ..... 1: 2: 3: 4: 5: 6: 7: 8 : 9: 10: 11: 12: 13: 14: 15: select r.deviceId , min(r.reading) ...
RE: Select most recent record? For time '2000-11-20 15:56' */ SELECT * FROM d_people WHERE ( time ... May 16, 2001 6:28 AM > To: pgsql-sql List > Subject: [SQL] Select most recent record? ...
Select records at interval of 5 minutes ... 5 minutes later, time should be 06:42:53 am, but no records at this .... Select 15 ,to_date('11-06-08 06.21.55','dd-mm-rr hh:mi:ss') From ...
sql statement to delete records older than XXX as long as there ... Date < @tDate and item_id not in ( select top 15 item_id from MyTable order by Date ... How to get records after a certain time using SQL datetime field ...
"SELECT N records from each category" thread from MySQL Talk Aug 10, 2008 ... From: Peter Brawley, Date Sent: 2008-08-10 15:33:44. Subject: Re: SELECT N records from each category, To: MySQL Talk ...
Calculating consecutive Date/Time records - MS Access Calculating consecutive Date/Time records. ... 12:15 PM ... select A.product, ' Step' & count(*) as StepNbr, A.step ...
[thelist] MySQL selecting sum of records from time period [thelist] MySQL selecting sum of records from time period ... On Tue, 17 Aug 2004 15:20:30 -0700, David Siedband I'm ...
Business Objects: Crystal Reports 1 Formulas - Format Time and ... The display would be Room # Status Time C1012 GRA in Room 15:30 Thanks, ... Using the Select Expert select only the records that have Status = 5. ...

Videos:
My Record Collection - British Invasion Albums Here are some great British invasion albums from my record collection, spanning the years 1964-1967. When choosing both the albums shown and the mus...
The Student(Kirk Hammett) Vs. The Master(Joe Satriani) 2 A video comparing the guitar solos of kirk hammett and joe satriani. just before Metallica was to record its first album, Kill 'Em All. At the time ...
Gary Lewis & The Playboys - She's Just My Style Gary Lewis had a great background for a showbiz career: He was the son of noted comedian and actor Jerry Lewis. His musical career began when he rece...
Roland JP-8000 JP-8080 DVD Video Tutorial Demonstration This is an excerpt from a full length DVD available at www.ProAudioDVDs.com. Host David Wills has toured with major artists such as Michael Jackson,...
Gary Lewis & The Playboys - Count Me In Gary Lewis had a great background for a showbiz career: He was the son of noted comedian and actor Jerry Lewis. His musical career began when he rece...
Gary Lewis & the Playboys - This Diamond Ring Gary Lewis had a great background for a showbiz career: He was the son of noted comedian and actor Jerry Lewis. His musical career began when he rece...
SNIKT! AND THWIP! AGED 15 WEEKS PART 1 Snikt! and Thwip! are brothers. They are both 31/32 Cornish Rex and 1/32 Siamese. (It is important to introduce a different breed every 3rd or 4th ge...
PowerPoint: Voice Episode 15 (of an 18-part series). This Nortel LearniT tutorial reviews the use and control of voice in PowerPoint.
Reveal: Super Mario Galaxy: Purple Coin Spacewalk Space Junk Galaxy's Purple Coin Challange. My record: 1:15. can Lonewolf beat it? For those who don't know, we have this running competition betwee...
Miles Away 4 youtube Maine where the weather is cold and well the weather is cold... We have been writing original music for 17 years and have seen a great deal of change...












how can i remove the little triangle from menu itmes that have dynamic items?

accessing methods from a dll file

problem with master/child page displaying edge line

maintainscrollpositiononpostback="true" in master

treeview node selected problem.

treeview control help

download themes - help please...

treeview selectednode value from master page.

css rule isn't recognized in my theme folder

load different web.sitemap file based on the user

back button causes masterpage width to change

how to execute code in content page when button on master page is clicked

inheritence of skinid's

head tag duplication

css link refs not working from masterpage

customizing the site navigation

firefox and the asp.net 2.0 menu control

removing wizard step from wizard control

response.flush causes page to loose theme ???

site map depth and current position within the site map

content place holder

googlebot and master and content-pages

skin files defaults

wizard data collection question

usinng a second menu control to display childitems permanently

css placed in app_themes not placed in <head> ?

how to change the layout of a treeview component to this?

accessing controls in a wizard header?

how can i hide the expand/collapse image while set showexpandcollapse to true in treeview

expand/collapse treeview bound to web directory

   
  Privacy | Contact Us
All Times Are GMT