DB Results Problem

[Rob]

I have a database results page on my web site that does not show all of the
results. I have it set to show 999 results, but for some reason it will not
show all of the entries in the database.

Here is the page http://www.rollingbluethunder.com/Guestbook.asp

Can anyone help me figure out why all the results are not showing?

Also, the dates do not show up the same way for each entry. Some of them
show with the month first and the others show with the day and then the
month.

I would also like to know how I can make them all show the same way...month,
day, year.

Thanks in advance for your assistance

 

[Jim Buyens]

Responses interspersed...

-----Original Message-----
I have a database results page on my web site that does
not show all of the results. I have it set to show 999
results, but for some reason it will not show all of the
entries in the database.

Here is the page
http://www.rollingbluethunder.com/Guestbook.asp

Can anyone help me figure out why all the results are
not showing?

On page 3 of the wizard, click More Options and clear the
Limit Number Of Returned Records To check box.

Also, the dates do not show up the same way for each
entry. Some of them show with the month first and the
others show with the day and then the month.

I would also like to know how I can make them all show
the same way...month, day, year.

Your database field is probably set up to contain text.
You would need to change the database so it stores the
field in true date format.

Jim Buyens
Microsoft FrontPage MVP
http://www.interlacken.com
Author of:
*----------------------------------------------------
|\---------------------------------------------------
|| Microsoft Office FrontPage 2003 Inside Out
||---------------------------------------------------
|| Web Database Development Step by Step .NET Edition
|| Microsoft FrontPage Version 2002 Inside Out
|| Faster Smarter Beginning Programming
|| (All from Microsoft Press)
|/---------------------------------------------------
*----------------------------------------------------