No records are shown for database results - newly broken

M

Mike Edwards

I have a FP2000 website that has worked for years. Now, all asp pages behave
badly. If they open, I see the headings for the columns, however, no records
are shown, and the "No Records Found" warning does not show. The results are
simply a blank page. I checked the underlying database and queries and all
is well.

Also, some asp pages ask if I want to open them or save them.

I've added no new software or hardware. The only changes would be automatic
updates via Norton Antivirus and Windows Update.

I can't find anything searching MSDN or NAV. Does this ring a bell with
anyone?

Sincerely,
Mike Edwards
http://www.kingmuddfish.com/
 
S

Steve Easton

If you mean you get the open or save prompt when trying to view in your browser, I would
suspect your file associations have become hosed.
Simply way to fix.
Save one to your desktop, right click and select "Open With" select the "Choose Program"
option.
In the dialog that opens, select Internet Explorer and make sure the
"Always use the selected program to open this kind of file" option is checked.

--

Steve Easton
Microsoft MVP FrontPage
FP Cleaner
http://www.95isalive.com/fixes/fpclean.htm
Hit Me FP
http://www.95isalive.com/fixes/HitMeFP.htm
 
M

Mike Edwards

Thanks Steve,

That is not the problem. I checked just to make sure. It still asks to open
or save some asp pages. If I click to open from the dialog box, it sends the
page to a temp file and asks me again to open or save. If I hit open, a
dialog box opens and closes so fast that I can't read it, but the page does
not open. I am not as concerned about that because I can redo the pages from
Frontpage and they will open without prompting; however, they do not show
any records.

The other asp pages that do open on their own still show no records.

page that represents problem is:
http://www.kingmuddfish.com/king_muddfish_schedule.asp

The query does return records, they are just not displayed on the webpage.

Sincerely,
Mike
 
M

Mike Edwards

Either way, if I go to it from the webserver machine via IE or if I go to
the site from a computer via the internet, I get the same results.

Mike
 
J

Jim Fitzgerald

Mike Edwards said:
Thanks Steve,

That is not the problem. I checked just to make sure. It still asks to open
or save some asp pages. If I click to open from the dialog box, it sends the
page to a temp file and asks me again to open or save. If I hit open, a
dialog box opens and closes so fast that I can't read it, but the page does
not open. I am not as concerned about that because I can redo the pages from
Frontpage and they will open without prompting; however, they do not show
any records.

The other asp pages that do open on their own still show no records.

page that represents problem is:
http://www.kingmuddfish.com/king_muddfish_schedule.asp

The query does return records, they are just not displayed on the webpage.

Sincerely,
Mike
Click to expand...
Use the Database wizard and create a simple database with a submission form
and results page, and add a couple of records. Then look at the results and
see if the records show up. in there.
 
M

Mike Edwards

Tried it...I got the "save or open" dialog box with the same behavior listed
earlier.

I checked some other things that seem to be funky:

Running IIS 5.1 on WinXP Professional
FP Server Extensions 2002
FP 2000

When I open console via inetmgr, it says the default web site is stopped. I
tell it to start but it won't -- says it did not start or respond to the
request in a timely fashion.

When I checked the Server Extension console, it says the FP Server
extensions are installed.

When I try to publish the site from FP 2000 via http, it says the site does
not have Frontpage server extensions installed.

I removed the FP Extensions and re-applied them -- no change.

I ran the FP Server Extensions 2002 update -- no change.

None of this makes any sense to me. Does it make sense to anyone else?

Mike
 
J

Jim Fitzgerald

I don't know if it has anything to do with it, but you aoppear to have a
field named "Date" and one named "Time". I had a similar problem that
suddenly appeared involving a field I had named "Last". I changed the name
and it worked fine. Apparently Microsoft did something to cause it to be more
"Picky" about file names. If your fields are really named Date and Time, try
changing the field names and see if that makes any difference.
 
M

Mike Edwards

Thanks Jim,

I am aware of that problem -- the actual column names are GigDate and
GigTime -- only the form lable uses "Date" and "Time". None of the field
names are MS reserved names.

Sincerely,
Mike
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Show database results horizontally 5
Unable to publish via http, broken site 5
.asp pages containing Database results does not work 4
sorting database records and criteria 0
The newly created record is now shown in the form 3
New to FP and Access Database results help please 2
Filtering Database Results 1
Database Results Wizard and Record Advance Buttons 1

Top