Forums

ASP

This topic is locked

MoveNext and MoveFirst problem

Posted 11 Oct 2003 13:48:08
1
has voted
11 Oct 2003 13:48:08 David Lash posted:
Can you tell me where I might be able to find an article or tutorial on how to make my filtered database content (in ASP), be presented on the page from the most current date down to the farthest date (descending order), and still be able to view other dynamic content that is to be displayed after that. Okay, here's my scenario, since that probably made no sense:



· I have a blog board that I am creating.

· It pulls the blog info from the MySQL database. I have MX setup to filter the blog postings by descending date, so that the most current date is always read first.

· The blog content is also in a repeated region, so it pulls all the blogs tied to a particular username.

· Here's where I start to have problems. I have other information on the right side of the page that tells some personal information about the blog poster (i.e. first name, city, state, etc.). Unfortunately, that info will not show up on the page when I use DESC order (ASC shows all page data fine).

I have tried using the MoveFirst command after the MoveNext in the repeat region, but I still can't get it to loop back through and show the rest of the data from the table.



Any suggestions?



David

Reply to this topic