No records are shown for database results - newly broken

  • Thread starter Thread starter Mike Edwards
  • Start date Start date
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/
 
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
 
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
 
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
 
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.
 
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
 
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.
 
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
 
Back
Top