Database Results Wizard Error - FrontPage 2003

SP · Mar 3, 2006

Hi all this Damsel is up against a wall and getting ready to bang my head.
I am using FrontPage 2003 and Access 2003. I have created a database with a
photo (Employees). I used the FrontPage 2003 Database results wizard to
have it pull the information to post on our intranet. I could not get the
image to show, so I searched the Microsoft Knowledge Base, finding How to
display a picture by using an Access database in FrontPage 2003. I followed
the steps and things fell into place, until I followed the step: Remove the
quotation marks from the start and end of the field value. When I did this,
I get this error message:

ADODB.Recordset error '800a0cc1'

Item cannot be found in the collection corresponding to the requested name
or ordinal.

G:\WEBS\INTRANETWEB\DATABASE\../_fpclass/fpdblib.inc, line 48

When I put the quotes back, I have the photo field with a small box with a
red X. I know I am almost there. What do I need to do to get the page the
to show the images for the employees.

Here is my code from my .asp page that is showing the results from the
Database Results Wizard. Please HELP!!!

<html>

<head>
<% ' FP_ASP -- ASP Automatically generated by a Frontpage Component. Do not
Edit.
FP_CharSet = "windows-1252"
FP_CodePage = 1252 %>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<title>Employee Photo Gallery</title>
<meta name="Microsoft Theme" content="compass 1011, default">
<meta name="Microsoft Border" content="l, default">
</head>

<body>
<table width="100%">
<thead>
<tr>
<th ALIGN="LEFT"><b>Last Name</b></th>
<th ALIGN="LEFT"><b>First Name</b></th>
<th ALIGN="LEFT"><b>Title</b></th>
<th ALIGN="LEFT"><b>Studio</b></th>
<th ALIGN="LEFT"><b>Photo</b></th>
<th ALIGN="LEFT"><b>Extension</b></th>
</tr>
</thead>
<tbody>

<% 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 %>
<%
fp_sQry="SELECT * FROM [LBDG Employees] ORDER BY ""First Name"" DESC"
fp_sDefault=""
fp_sNoRecords="<tr><td colspan=6 align=""LEFT"" width=""100%"">No records
returned.</td></tr>"
fp_sDataConn="LBDGPhotos"
fp_iMaxRecords=0
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=True
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_sColTypes="&First Name=202&Last
Name=202&Title=202&Studio=202&Photo=202&Extension=202&"
fp_iDisplayCols=6
fp_fCustomQuery=True
BOTID=0
fp_iRegion=BOTID
%>

<tr>
<td>
<%=FP_FieldVal(fp_rs,"Last Name")%></td>
<td>
<%=FP_FieldVal(fp_rs,"First Name")%></td>
<td>
<%=FP_FieldVal(fp_rs,"Title")%></td>
<td>
<%=FP_FieldVal(fp_rs,"Studio")%></td>
<td><img border="0" src="<%=FP_FieldLink(fp_rs, Photo)%>"></td>
<td>
<%=FP_FieldVal(fp_rs,"Extension")%></td>
</tr>

</tbody>
</table>

</body></html>

Kathleen Anderson [MVP - FrontPage] · Mar 4, 2006

Try putting brackets around First Name - [First Name]

--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/

SP said:
Hi all this Damsel is up against a wall and getting ready to bang my head.
I am using FrontPage 2003 and Access 2003. I have created a database with
a photo (Employees). I used the FrontPage 2003 Database results wizard to
have it pull the information to post on our intranet. I could not get the
image to show, so I searched the Microsoft Knowledge Base, finding How to
display a picture by using an Access database in FrontPage 2003. I
followed the steps and things fell into place, until I followed the step:
Remove the quotation marks from the start and end of the field value.
When I did this, I get this error message:

ADODB.Recordset error '800a0cc1'

Item cannot be found in the collection corresponding to the requested name
or ordinal.

G:\WEBS\INTRANETWEB\DATABASE\../_fpclass/fpdblib.inc, line 48

When I put the quotes back, I have the photo field with a small box with a
red X. I know I am almost there. What do I need to do to get the page
the to show the images for the employees.

Here is my code from my .asp page that is showing the results from the
Database Results Wizard. Please HELP!!!

<html>

<head>
<% ' FP_ASP -- ASP Automatically generated by a Frontpage Component. Do
not Edit.
FP_CharSet = "windows-1252"
FP_CodePage = 1252 %>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<title>Employee Photo Gallery</title>
<meta name="Microsoft Theme" content="compass 1011, default">
<meta name="Microsoft Border" content="l, default">
</head>

<body>
<table width="100%">
<thead>
<tr>
<th ALIGN="LEFT"><b>Last Name</b></th>
<th ALIGN="LEFT"><b>First Name</b></th>
<th ALIGN="LEFT"><b>Title</b></th>
<th ALIGN="LEFT"><b>Studio</b></th>
<th ALIGN="LEFT"><b>Photo</b></th>
<th ALIGN="LEFT"><b>Extension</b></th>
</tr>
</thead>
<tbody>

<% 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 %>
<%
fp_sQry="SELECT * FROM [LBDG Employees] ORDER BY ""First Name"" DESC"
fp_sDefault=""
fp_sNoRecords="<tr><td colspan=6 align=""LEFT"" width=""100%"">No records
returned.</td></tr>"
fp_sDataConn="LBDGPhotos"
fp_iMaxRecords=0
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=True
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_sColTypes="&First Name=202&Last
Name=202&Title=202&Studio=202&Photo=202&Extension=202&"
fp_iDisplayCols=6
fp_fCustomQuery=True
BOTID=0
fp_iRegion=BOTID
%>

<tr>
<td>
<%=FP_FieldVal(fp_rs,"Last Name")%></td>
<td>
<%=FP_FieldVal(fp_rs,"First Name")%></td>
<td>
<%=FP_FieldVal(fp_rs,"Title")%></td>
<td>
<%=FP_FieldVal(fp_rs,"Studio")%></td>
<td><img border="0" src="<%=FP_FieldLink(fp_rs, Photo)%>"></td>
<td>
<%=FP_FieldVal(fp_rs,"Extension")%></td>
</tr>

</tbody>
</table>

</body></html>

SP · Mar 6, 2006

Kathleen thank you fixed one challenge, any ideas to the other one?

Sheri

Kathleen Anderson said:
Try putting brackets around First Name - [First Name]

--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/

SP said:

Hi all this Damsel is up against a wall and getting ready to bang my
head. I am using FrontPage 2003 and Access 2003. I have created a
database with a photo (Employees). I used the FrontPage 2003 Database
results wizard to have it pull the information to post on our intranet.
I could not get the image to show, so I searched the Microsoft Knowledge
Base, finding How to display a picture by using an Access database in
FrontPage 2003. I followed the steps and things fell into place, until I
followed the step: Remove the quotation marks from the start and end of
the field value. When I did this, I get this error message:

ADODB.Recordset error '800a0cc1'

Item cannot be found in the collection corresponding to the requested
name or ordinal.

G:\WEBS\INTRANETWEB\DATABASE\../_fpclass/fpdblib.inc, line 48

When I put the quotes back, I have the photo field with a small box with
a red X. I know I am almost there. What do I need to do to get the page
the to show the images for the employees.

Here is my code from my .asp page that is showing the results from the
Database Results Wizard. Please HELP!!!

<html>

<head>
<% ' FP_ASP -- ASP Automatically generated by a Frontpage Component. Do
not Edit.
FP_CharSet = "windows-1252"
FP_CodePage = 1252 %>
<meta http-equiv="Content-Type" content="text/html;
charset=windows-1252">
<title>Employee Photo Gallery</title>
<meta name="Microsoft Theme" content="compass 1011, default">
<meta name="Microsoft Border" content="l, default">
</head>

<body>
<table width="100%">
<thead>
<tr>
<th ALIGN="LEFT"><b>Last Name</b></th>
<th ALIGN="LEFT"><b>First Name</b></th>
<th ALIGN="LEFT"><b>Title</b></th>
<th ALIGN="LEFT"><b>Studio</b></th>
<th ALIGN="LEFT"><b>Photo</b></th>
<th ALIGN="LEFT"><b>Extension</b></th>
</tr>
</thead>
<tbody>

<% 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 %>
<%
fp_sQry="SELECT * FROM [LBDG Employees] ORDER BY ""First Name"" DESC"
fp_sDefault=""
fp_sNoRecords="<tr><td colspan=6 align=""LEFT"" width=""100%"">No records
returned.</td></tr>"
fp_sDataConn="LBDGPhotos"
fp_iMaxRecords=0
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=True
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_sColTypes="&First Name=202&Last
Name=202&Title=202&Studio=202&Photo=202&Extension=202&"
fp_iDisplayCols=6
fp_fCustomQuery=True
BOTID=0
fp_iRegion=BOTID
%>

<tr>
<td>
<%=FP_FieldVal(fp_rs,"Last Name")%></td>
<td>
<%=FP_FieldVal(fp_rs,"First Name")%></td>
<td>
<%=FP_FieldVal(fp_rs,"Title")%></td>
<td>
<%=FP_FieldVal(fp_rs,"Studio")%></td>
<td><img border="0" src="<%=FP_FieldLink(fp_rs, Photo)%>"></td>
<td>
<%=FP_FieldVal(fp_rs,"Extension")%></td>
</tr>

</tbody>
</table>

</body></html>

Click to expand...

Kathleen Anderson [MVP - FrontPage] · Mar 6, 2006

Can you send me an extract of your database - just 4 or 5 records - and I
will figure it out for you?

--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/
FrontPage Support: http://www.frontpagemvps.com/

SP said:
Kathleen thank you fixed one challenge, any ideas to the other one?

Sheri

Kathleen Anderson said:

Try putting brackets around First Name - [First Name]

--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/

SP said:

Hi all this Damsel is up against a wall and getting ready to bang my
head. I am using FrontPage 2003 and Access 2003. I have created a
database with a photo (Employees). I used the FrontPage 2003 Database
results wizard to have it pull the information to post on our intranet.
I could not get the image to show, so I searched the Microsoft Knowledge
Base, finding How to display a picture by using an Access database in
FrontPage 2003. I followed the steps and things fell into place, until
I followed the step: Remove the quotation marks from the start and end
of the field value. When I did this, I get this error message:

ADODB.Recordset error '800a0cc1'

Item cannot be found in the collection corresponding to the requested
name or ordinal.

G:\WEBS\INTRANETWEB\DATABASE\../_fpclass/fpdblib.inc, line 48

When I put the quotes back, I have the photo field with a small box with
a red X. I know I am almost there. What do I need to do to get the
page the to show the images for the employees.

Here is my code from my .asp page that is showing the results from the
Database Results Wizard. Please HELP!!!

<html>

<head>
<% ' FP_ASP -- ASP Automatically generated by a Frontpage Component. Do
not Edit.
FP_CharSet = "windows-1252"
FP_CodePage = 1252 %>
<meta http-equiv="Content-Type" content="text/html;
charset=windows-1252">
<title>Employee Photo Gallery</title>
<meta name="Microsoft Theme" content="compass 1011, default">
<meta name="Microsoft Border" content="l, default">
</head>

<body>
<table width="100%">
<thead>
<tr>
<th ALIGN="LEFT"><b>Last Name</b></th>
<th ALIGN="LEFT"><b>First Name</b></th>
<th ALIGN="LEFT"><b>Title</b></th>
<th ALIGN="LEFT"><b>Studio</b></th>
<th ALIGN="LEFT"><b>Photo</b></th>
<th ALIGN="LEFT"><b>Extension</b></th>
</tr>
</thead>
<tbody>

<% 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 %>
<%
fp_sQry="SELECT * FROM [LBDG Employees] ORDER BY ""First Name"" DESC"
fp_sDefault=""
fp_sNoRecords="<tr><td colspan=6 align=""LEFT"" width=""100%"">No
records returned.</td></tr>"
fp_sDataConn="LBDGPhotos"
fp_iMaxRecords=0
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=True
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_sColTypes="&First Name=202&Last
Name=202&Title=202&Studio=202&Photo=202&Extension=202&"
fp_iDisplayCols=6
fp_fCustomQuery=True
BOTID=0
fp_iRegion=BOTID
%>

<tr>
<td>
<%=FP_FieldVal(fp_rs,"Last Name")%></td>
<td>
<%=FP_FieldVal(fp_rs,"First Name")%></td>
<td>
<%=FP_FieldVal(fp_rs,"Title")%></td>
<td>
<%=FP_FieldVal(fp_rs,"Studio")%></td>
<td><img border="0" src="<%=FP_FieldLink(fp_rs, Photo)%>"></td>
<td>
<%=FP_FieldVal(fp_rs,"Extension")%></td>
</tr>

</tbody>
</table>

</body></html>

Click to expand...

Click to expand...

SP · Mar 6, 2006

I am sorry, I am not familar with how to so that, could you provide me with
guidance

Kathleen Anderson said:
Can you send me an extract of your database - just 4 or 5 records - and I
will figure it out for you?

--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/
FrontPage Support: http://www.frontpagemvps.com/

SP said:

Kathleen thank you fixed one challenge, any ideas to the other one?

Sheri

Kathleen Anderson said:

Try putting brackets around First Name - [First Name]

--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/

Hi all this Damsel is up against a wall and getting ready to bang my
head. I am using FrontPage 2003 and Access 2003. I have created a
database with a photo (Employees). I used the FrontPage 2003 Database
results wizard to have it pull the information to post on our intranet.
I could not get the image to show, so I searched the Microsoft
Knowledge Base, finding How to display a picture by using an Access
database in FrontPage 2003. I followed the steps and things fell into
place, until I followed the step: Remove the quotation marks from the
start and end of the field value. When I did this, I get this error
message:

ADODB.Recordset error '800a0cc1'

Item cannot be found in the collection corresponding to the requested
name or ordinal.

G:\WEBS\INTRANETWEB\DATABASE\../_fpclass/fpdblib.inc, line 48

When I put the quotes back, I have the photo field with a small box
with a red X. I know I am almost there. What do I need to do to get
the page the to show the images for the employees.

Here is my code from my .asp page that is showing the results from the
Database Results Wizard. Please HELP!!!

<html>

<head>
<% ' FP_ASP -- ASP Automatically generated by a Frontpage Component. Do
not Edit.
FP_CharSet = "windows-1252"
FP_CodePage = 1252 %>
<meta http-equiv="Content-Type" content="text/html;
charset=windows-1252">
<title>Employee Photo Gallery</title>
<meta name="Microsoft Theme" content="compass 1011, default">
<meta name="Microsoft Border" content="l, default">
</head>

<body>
<table width="100%">
<thead>
<tr>
<th ALIGN="LEFT"><b>Last Name</b></th>
<th ALIGN="LEFT"><b>First Name</b></th>
<th ALIGN="LEFT"><b>Title</b></th>
<th ALIGN="LEFT"><b>Studio</b></th>
<th ALIGN="LEFT"><b>Photo</b></th>
<th ALIGN="LEFT"><b>Extension</b></th>
</tr>
</thead>
<tbody>

<% 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 %>
<%
fp_sQry="SELECT * FROM [LBDG Employees] ORDER BY ""First Name"" DESC"
fp_sDefault=""
fp_sNoRecords="<tr><td colspan=6 align=""LEFT"" width=""100%"">No
records returned.</td></tr>"
fp_sDataConn="LBDGPhotos"
fp_iMaxRecords=0
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=True
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_sColTypes="&First Name=202&Last
Name=202&Title=202&Studio=202&Photo=202&Extension=202&"
fp_iDisplayCols=6
fp_fCustomQuery=True
BOTID=0
fp_iRegion=BOTID
%>

<tr>
<td>
<%=FP_FieldVal(fp_rs,"Last Name")%></td>
<td>
<%=FP_FieldVal(fp_rs,"First Name")%></td>
<td>
<%=FP_FieldVal(fp_rs,"Title")%></td>
<td>
<%=FP_FieldVal(fp_rs,"Studio")%></td>
<td><img border="0" src="<%=FP_FieldLink(fp_rs, Photo)%>"></td>
<td>
<%=FP_FieldVal(fp_rs,"Extension")%></td>
</tr>

</tbody>
</table>

</body></html>

Click to expand...

Click to expand...

Kathleen Anderson [MVP - FrontPage] · Mar 6, 2006

In Access, create an empty database, then do a File | Get External Data |
Import Find the original database, double-click and it will show you a list
of the objects in the database. Select the table and import it into the
empty database. Then you can delete records from the table IN THE COPY so
there’s only 4 or 5 left, save the table and send me the database.

--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/
FrontPage Support: http://www.frontpagemvps.com/

SP said:
I am sorry, I am not familar with how to so that, could you provide me with
guidance

Kathleen Anderson said:

Can you send me an extract of your database - just 4 or 5 records - and I
will figure it out for you?

--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/
FrontPage Support: http://www.frontpagemvps.com/

SP said:

Kathleen thank you fixed one challenge, any ideas to the other one?

Sheri

message Try putting brackets around First Name - [First Name]

--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/

Hi all this Damsel is up against a wall and getting ready to bang my
head. I am using FrontPage 2003 and Access 2003. I have created a
database with a photo (Employees). I used the FrontPage 2003 Database
results wizard to have it pull the information to post on our
intranet. I could not get the image to show, so I searched the
Microsoft Knowledge Base, finding How to display a picture by using an
Access database in FrontPage 2003. I followed the steps and things
fell into place, until I followed the step: Remove the quotation marks
from the start and end of the field value. When I did this, I get this
error message:

ADODB.Recordset error '800a0cc1'

Item cannot be found in the collection corresponding to the requested
name or ordinal.

G:\WEBS\INTRANETWEB\DATABASE\../_fpclass/fpdblib.inc, line 48

When I put the quotes back, I have the photo field with a small box
with a red X. I know I am almost there. What do I need to do to get
the page the to show the images for the employees.

Here is my code from my .asp page that is showing the results from the
Database Results Wizard. Please HELP!!!

<html>

<head>
<% ' FP_ASP -- ASP Automatically generated by a Frontpage Component.
Do not Edit.
FP_CharSet = "windows-1252"
FP_CodePage = 1252 %>
<meta http-equiv="Content-Type" content="text/html;
charset=windows-1252">
<title>Employee Photo Gallery</title>
<meta name="Microsoft Theme" content="compass 1011, default">
<meta name="Microsoft Border" content="l, default">
</head>

<body>
<table width="100%">
<thead>
<tr>
<th ALIGN="LEFT"><b>Last Name</b></th>
<th ALIGN="LEFT"><b>First Name</b></th>
<th ALIGN="LEFT"><b>Title</b></th>
<th ALIGN="LEFT"><b>Studio</b></th>
<th ALIGN="LEFT"><b>Photo</b></th>
<th ALIGN="LEFT"><b>Extension</b></th>
</tr>
</thead>
<tbody>

<% 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 %>
<%
fp_sQry="SELECT * FROM [LBDG Employees] ORDER BY ""First Name"" DESC"
fp_sDefault=""
fp_sNoRecords="<tr><td colspan=6 align=""LEFT"" width=""100%"">No
records returned.</td></tr>"
fp_sDataConn="LBDGPhotos"
fp_iMaxRecords=0
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=True
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_sColTypes="&First Name=202&Last
Name=202&Title=202&Studio=202&Photo=202&Extension=202&"
fp_iDisplayCols=6
fp_fCustomQuery=True
BOTID=0
fp_iRegion=BOTID
%>

<tr>
<td>
<%=FP_FieldVal(fp_rs,"Last Name")%></td>
<td>
<%=FP_FieldVal(fp_rs,"First Name")%></td>
<td>
<%=FP_FieldVal(fp_rs,"Title")%></td>
<td>
<%=FP_FieldVal(fp_rs,"Studio")%></td>
<td><img border="0" src="<%=FP_FieldLink(fp_rs, Photo)%>"></td>
<td>
<%=FP_FieldVal(fp_rs,"Extension")%></td>
</tr>

</tbody>
</table>

</body></html>

Click to expand...

Click to expand...

I am trying to understand this code...	3	Jul 26, 2008
Database Results Error	2	Nov 24, 2004
FP2003 SQL ignoring values passed through hyperlink	2	Apr 24, 2005
bullet list extra spacing	2	Jan 18, 2009
any ideas why I can update one table in my database but not the other?	2	Sep 22, 2006
UPDATE database problems	0	Aug 9, 2004
@ my wits end	1	Sep 12, 2006
Recurring number on asp result page	0	Oct 17, 2003

Database Results Wizard Error - FrontPage 2003

SP

Kathleen Anderson [MVP - FrontPage]

SP

Kathleen Anderson [MVP - FrontPage]

SP

Kathleen Anderson [MVP - FrontPage]

Ask a Question

Similar Threads