PC Review


Reply
Thread Tools Rate Thread

DB Results Problem

 
 
Rob
Guest
Posts: n/a
 
      3rd Jul 2004
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



 
Reply With Quote
 
 
 
 
Jim Buyens
Guest
Posts: n/a
 
      4th Jul 2004
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)
|/---------------------------------------------------
*----------------------------------------------------

 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Re: Problem with Gridview and SP without results anr Microsoft ASP .NET 0 17th Feb 2009 03:34 PM
Search Results Problem =?Utf-8?B?ZWxlbWV0bmFsMzgxOQ==?= Windows XP General 5 18th Jul 2007 01:03 PM
problem w/ form results =?Utf-8?B?bWVnaA==?= Microsoft Frontpage 3 22nd Mar 2005 09:10 PM
SUM problem with too many results Tom Drill Microsoft Excel Worksheet Functions 6 6th Apr 2004 01:57 PM
ASp Results Problem Ed Richter Microsoft Frontpage 2 2nd Apr 2004 04:28 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 01:00 AM.