Access database and frontpage problems

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am STILL struggling with my website which is strictly a database for
generating and updating information on rescue dogs. Basically, pretty simple.

Can someone look at my home page and view source and see if anything is
glaringly wrong? I've done everything the way Frontpage instructed me to do
it, database interface wizard, etc., but still am not getting to the
database. Help, please!!

www.luckystardatabase.com

Thanks for any direction you can give me. I'm getting very frustrated!

Toni
 
I opened this page and created it, then followed the database interface
wizard's instructions for adding a new database to the website. I'll try it
again! This is about the fifth time I've tried. As you can tell, I'm very
much a newbie. I thought there might be a step I was failing to do that
might be obvious to someone else.

Toni
 
Now I'm getting this error message:

Database Results Wizard Error
The operation failed. If this continues, please contact your server
administrator.

Do I now need to go in and redo the interface from this page? The only
other pages I have in the website are pages designed by the interface wizard.

Toni
 
The FP2003 code has changed slightly. To see the true error, open the hidden
folder /_fpclass/ and edit the fpdbrgn1.inc file

At about line 19, change :

fp_DEBUG = False

to :

fp_DEBUG = True


--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/
Please reply to the newsgroup for the benefit of others
 
Thank you so much for your help! Now I'm getting this error message:
Database Results Wizard Error
Description: Syntax error in query. Incomplete query clause.
Number: -2147217900 (0x80040E14)
Source: Microsoft JET Database Engine

At least it looks like progress is being made! What to do now?

Toni
 
Open the page in FrontPage, switch to Code View and find your SQL statement
in the gray colored code and copy and paste it into a reply here. The SQL
statement starts with: s-sql="SELECT

--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/
Please reply to the newsgroup for the benefit of others
 
s-sql="SELECT * FROM "Dog Intake"" b-procedure="FALSE" clientside
suggestedext="asp" s-defaultfields s-norecordsfound="No records returned."
i-maxrecords="256" i-groupsize="0" botid="0" u-dblib="_fpclass/fpdblib.inc"
u-dbrgn1="_fpclass/fpdbrgn1.inc" u-dbrgn2="_fpclass/fpdbrgn2.inc" tag="TBODY"
preview="<tr><td colspan=64 bgcolor="#FFFF00" width="100%"><font
color="#000000">This is the start of a Database Results region. The page must
be fetched from a web server with a web browser to display correctly; the
current web is stored on your local disk or network.</font></td></tr>"
startspan --><!--#include file="_fpclass/fpdblib.inc"-->
<% if 0 then %>
<SCRIPT Language="JavaScript">
document.write("<div style='background: yellow; color: black;'>The Database
Results component on this page is unable to display database content. The
page must have a filename ending in '.asp', and the web must be hosted on a
server that supports Active Server Pages.</div>");
</SCRIPT>
<% end if %>
 
Your table name has a space in it, which could be causing the problem. Try
enclosing it with brackets, like this:

s-sql="SELECT * FROM [Dog Intake]"

Make the change in the gray colored code and save the changes while still in
Code view. You will notice that once you've saved your changes they are also
made to the maroon colored code - that is by design. The maroon colored code
should never be touched; it's generated by the gray code at save time.

--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/
Please reply to the newsgroup for the benefit of others
 
Thank you, thank you, thank you!!!
One final question!! How to I populate the database results so that the
last entry is the first to appear?
After that, I think I'll leave you alone!

Toni

Kathleen Anderson said:
Your table name has a space in it, which could be causing the problem. Try
enclosing it with brackets, like this:

s-sql="SELECT * FROM [Dog Intake]"

Make the change in the gray colored code and save the changes while still in
Code view. You will notice that once you've saved your changes they are also
made to the maroon colored code - that is by design. The maroon colored code
should never be touched; it's generated by the gray code at save time.

--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/
Please reply to the newsgroup for the benefit of others


Toni said:
s-sql="SELECT * FROM "Dog Intake"" b-procedure="FALSE" clientside
suggestedext="asp" s-defaultfields s-norecordsfound="No records returned."
i-maxrecords="256" i-groupsize="0" botid="0"
u-dblib="_fpclass/fpdblib.inc"
u-dbrgn1="_fpclass/fpdbrgn1.inc" u-dbrgn2="_fpclass/fpdbrgn2.inc"
tag="TBODY"
preview="<tr><td colspan=64 bgcolor="#FFFF00" width="100%"><font
color="#000000">This is the start of a Database Results region. The page
must
be fetched from a web server with a web browser to display correctly; the
current web is stored on your local disk or network.</font></td></tr>"
startspan --><!--#include file="_fpclass/fpdblib.inc"-->
<% if 0 then %>
<SCRIPT Language="JavaScript">
document.write("<div style='background: yellow; color: black;'>The
Database
Results component on this page is unable to display database content. The
page must have a filename ending in '.asp', and the web must be hosted on
a
server that supports Active Server Pages.</div>");
</SCRIPT>
<% end if %>
Click to expand...
Click to expand...
 
You could try sorting on either ID or Timestamp, if you have either one of
those fields in your table.

Your SQL statement would look like this:

s-sql="SELECT * FROM [Dog Intake] ORDER BY ID"

or

s-sql="SELECT * FROM [Dog Intake] ORDER BY Timestamp"


--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/
Please reply to the newsgroup for the benefit of others


Toni said:
Thank you, thank you, thank you!!!
One final question!! How to I populate the database results so that the
last entry is the first to appear?
After that, I think I'll leave you alone!

Toni

Kathleen Anderson said:
Your table name has a space in it, which could be causing the problem.
Try
enclosing it with brackets, like this:

s-sql="SELECT * FROM [Dog Intake]"

Make the change in the gray colored code and save the changes while still
in
Code view. You will notice that once you've saved your changes they are
also
made to the maroon colored code - that is by design. The maroon colored
code
should never be touched; it's generated by the gray code at save time.

--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/
Please reply to the newsgroup for the benefit of others


Toni said:
s-sql="SELECT * FROM "Dog Intake"" b-procedure="FALSE" clientside
suggestedext="asp" s-defaultfields s-norecordsfound="No records
returned."
i-maxrecords="256" i-groupsize="0" botid="0"
u-dblib="_fpclass/fpdblib.inc"
u-dbrgn1="_fpclass/fpdbrgn1.inc" u-dbrgn2="_fpclass/fpdbrgn2.inc"
tag="TBODY"
preview="<tr><td colspan=64 bgcolor="#FFFF00" width="100%"><font
color="#000000">This is the start of a Database Results region. The
page
must
be fetched from a web server with a web browser to display correctly;
the
current web is stored on your local disk or network.</font></td></tr>"
startspan --><!--#include file="_fpclass/fpdblib.inc"-->
<% if 0 then %>
<SCRIPT Language="JavaScript">
document.write("<div style='background: yellow; color: black;'>The
Database
Results component on this page is unable to display database content.
The
page must have a filename ending in '.asp', and the web must be hosted
on
a
server that supports Active Server Pages.</div>");
</SCRIPT>
<% end if %>


:

Open the page in FrontPage, switch to Code View and find your SQL
statement
in the gray colored code and copy and paste it into a reply here. The
SQL
statement starts with: s-sql="SELECT

--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/
Please reply to the newsgroup for the benefit of others


Thank you so much for your help! Now I'm getting this error
message:
Database Results Wizard Error
Description: Syntax error in query. Incomplete query clause.
Number: -2147217900 (0x80040E14)
Source: Microsoft JET Database Engine

At least it looks like progress is being made! What to do now?

Toni

:

The FP2003 code has changed slightly. To see the true error, open
the
hidden
folder /_fpclass/ and edit the fpdbrgn1.inc file

At about line 19, change :

fp_DEBUG = False

to :

fp_DEBUG = True


--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/
Please reply to the newsgroup for the benefit of others


Now I'm getting this error message:

Database Results Wizard Error
The operation failed. If this continues, please contact your
server
administrator.

Do I now need to go in and redo the interface from this page?
The
only
other pages I have in the website are pages designed by the
interface
wizard.

Toni


:

Are there any other pages on your site that we can look at?

--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/
Please reply to the newsgroup for the benefit of others


I opened this page and created it, then followed the database
interface
wizard's instructions for adding a new database to the
website.
I'll
try
it
again! This is about the fifth time I've tried. As you can
tell,
I'm
very
much a newbie. I thought there might be a step I was failing
to
do
that
might be obvious to someone else.

Toni

:

<html>

<head>
<meta http-equiv="Content-Language" content="en-us">
<meta http-equiv="Content-Type" content="text/html;
charset=windows-1252">
</head>

<body bgcolor="#FFFFCC">

<p align="center"><b><font face="Comic Sans MS" size="6"
color="#800080">Lucky
Star Database</font></b></p>
<p align="center"> </p>

</body>

</html>

I don't see any reference to a database anywhere.

What have you tried so far?

--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/
Please reply to the newsgroup for the benefit of others


I am STILL struggling with my website which is strictly a
database
for
generating and updating information on rescue dogs.
Basically,
pretty
simple.

Can someone look at my home page and view source and see if
anything
is
glaringly wrong? I've done everything the way Frontpage
instructed
me
to
do
it, database interface wizard, etc., but still am not
getting
to
the
database. Help, please!!

www.luckystardatabase.com

Thanks for any direction you can give me. I'm getting very
frustrated!

Toni
Click to expand...
Click to expand...
Click to expand...
 
Back
Top