View Full Version : Accessing Access
peacedaletr
08-06-2003, 02:18 AM
I have just posted a new site using Access. Several pages have database queries embedded in them that are not displaying any results when the page is viewed. The db has been moved to my domain. When I run the query outside of my app results are shown ok. No errors are called. Any ideas?
TIA...Bob.
peacedaletr
08-06-2003, 04:01 AM
Bruce...the entire code follows. I am technical by trade but new to HTML. I have been reviewing this forum and related sites such as MS and WebWizGuide, but still do not see the problem. I have to make some assumptions, such as discountasp has all the required apps running on their server.
This page can be executed at http://www.peacedaletraders.com/bulk-orders-home.html and click on the 'automotive' link.
<html>
<head>
<meta name="GENERATOR" content="Microsoft FrontPage 5.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<title>Bulk Order Items</title>
</head>
[b]
<p><font color="#0099FF"><font size="5">Bulk Order Items - Automotive</font></p>
<p><font size="5">Photos are available upon request</font></p>
<p><font size="5">Items are ordered by Brand</font></p>
<p></p>
</font>
<table width="100%" border="1">
<thead>
<tr>
<td>[b]ITEM</b></td>
<td>[b]BRAND</b></td>
<td>[b]DESCR</b></td>
<td>[b]MSRP</b></td>
<td>[b]YOURCOST</b></td>
</tr>
</thead>
<tbody>
<!--webbot bot="DatabaseRegionStart" s-columnnames="ITEM,BRAND,DESCR,MSRP,YOURCOST" s-columntypes="202,202,202,202,6" s-dataconnection="Database1" b-tableformat="TRUE" b-menuformat="FALSE" s-menuchoice s-menuvalue b-tableborder="TRUE" b-tableexpand="TRUE" b-tableheader="TRUE" b-listlabels="TRUE" b-listseparator="TRUE" i-listformat="0" b-makeform="TRUE" s-recordsource s-displaycolumns="ITEM,BRAND,DESCR,MSRP,YOURCOST" s-criteria s-order s-sql="SELECT ITEM, BRAND, DESCR, MSRP, YOURCOST FROM ITEMSBASIC
WHERE CAT = 'Auto'
AND TYPE = 'Restricted'
order by brand" 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' align='left' width='100%'><font color='#000000'>This is the start of a Database Results region. The region will not work unless the page has a file extension of '.asp'. 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 %>
<%
fp_sQry="SELECT ITEM, BRAND, DESCR, MSRP, YOURCOST FROM ITEMSBASIC WHERE CAT = 'Auto' AND TYPE = 'Restricted' order by brand"
fp_sDefault=""
fp_sNoRecords="<tr><td colspan=5 align=left width=""100%"">No records returned.</td></tr>"
fp_sDataConn="Database1"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=True
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_iDisplayCols=5
fp_fCustomQuery=True
BOTID=0
fp_iRegion=BOTID
%>
<!--#include file="_fpclass/fpdbrgn1.inc"-->
<!--webbot bot="DatabaseRegionStart" endspan i-checksum="46177" --><tr>
<td>
<!--webbot bot="DatabaseResultColumn" s-columnnames="ITEM,BRAND,DESCR,MSRP,YOURCOST" s-column="ITEM" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size='-1'>&lt;&lt;</font>ITEM<font size='-1'>&gt;&gt;</font>" startspan --><%=FP_FieldVal(fp_rs,"ITEM")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="1828" --></td>
<td>
<!--webbot bot="DatabaseResultColumn" s-columnnames="ITEM,BRAND,DESCR,MSRP,YOURCOST" s-column="BRAND" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size='-1'>&lt;&lt;</font>BRAND<font size='-1'>&gt;&gt;</font>" startspan --><%=FP_FieldVal(fp_rs,"BRAND")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="4434" --></td>
<td>
<!--webbot bot="DatabaseResultColumn" s-columnnames="ITEM,BRAND,DESCR,MSRP,YOURCOST" s-column="DESCR" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size='-1'>&lt;&lt;</font>DESCR<font size='-1'>&gt;&gt;</font>" startspan --><%=FP_FieldVal(fp_rs,"DESCR")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="2950" --></td>
<td>
<!--webbot bot="DatabaseResultColumn" s-columnnames="ITEM,BRAND,DESCR,MSRP,YOURCOST" s-column="MSRP" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size='-1'>&lt;&lt;</font>MSRP<font size='-1'>&gt;&gt;</font>" startspan --><%=FP_FieldVal(fp_rs,"MSRP")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="1975" --></td>
<td>
<!--webbot bot="DatabaseResultColumn" s-columnnames="ITEM,BRAND,DESCR,MSRP,YOURCOST" s-column="YOURCOST" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size='-1'>&lt;&lt;</font>YOURCOST<font size='-1'>&gt;&gt;</font>" startspan --><%=FP_FieldVal(fp_rs,"YOURCOST")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="11699" --></td>
</tr>
<!--webbot bot="DatabaseRegionEnd" b-tableformat="TRUE" b-menuformat="FALSE" u-dbrgn2="_fpclass/fpdbrgn2.inc" i-groupsize="0" clientside tag="TBODY" preview="<tr><td colspan=64 bgcolor='#FFFF00' align='left' width='100%'><font color='#000000'>This is the end of a Database Results region.</font></td></tr>" startspan --><!--#include file="_fpclass/fpdbrgn2.inc"-->
<!--webbot bot="DatabaseRegionEnd" endspan i-checksum="62730" --></tbody>
</table>
</body>
</html>
Thx again...Bob.
bruce
08-06-2003, 11:25 AM
Can you post the code?
[b]quote:Originally posted by peacedaletr
I have just posted a new site using Access. Several pages have database queries embedded in them that are not displaying any results when the page is viewed. The db has been moved to my domain. When I run the query outside of my app results are shown ok. No errors are called. Any ideas?
TIA...Bob.
</blockquote id="quote"></font id="quote">
bruce
08-07-2003, 11:02 AM
Oh... no.
It's one of those FrontPage created page. I am not sure I can help you here with that. FrontPage created data driven page is not aways stable.
Several things i recommend.
1) Do recalculate web
2) If still doesn't work, contact MS Support.
Sorry can't be of much help.
[b]quote:Originally posted by peacedaletr
Bruce...the entire code follows. I am technical by trade but new to HTML. I have been reviewing this forum and related sites such as MS and WebWizGuide, but still do not see the problem. I have to make some assumptions, such as discountasp has all the required apps running on their server.
This page can be executed at http://www.peacedaletraders.com/bulk-orders-home.html and click on the 'automotive' link.
<html>
<head>
<meta name="GENERATOR" content="Microsoft FrontPage 5.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<title>Bulk Order Items</title>
</head>
[b]
<p><font color="#0099FF"><font size="5">Bulk Order Items - Automotive</font></p>
<p><font size="5">Photos are available upon request</font></p>
<p><font size="5">Items are ordered by Brand</font></p>
<p>*</p>
</font>
<table width="100%" border="1">
<thead>
<tr>
<td>[b]ITEM</b></td>
<td>[b]BRAND</b></td>
<td>[b]DESCR</b></td>
<td>[b]MSRP</b></td>
<td>[b]YOURCOST</b></td>
</tr>
</thead>
<tbody>
<!--webbot bot="DatabaseRegionStart" s-columnnames="ITEM,BRAND,DESCR,MSRP,YOURCOST" s-columntypes="202,202,202,202,6" s-dataconnection="Database1" b-tableformat="TRUE" b-menuformat="FALSE" s-menuchoice s-menuvalue b-tableborder="TRUE" b-tableexpand="TRUE" b-tableheader="TRUE" b-listlabels="TRUE" b-listseparator="TRUE" i-listformat="0" b-makeform="TRUE" s-recordsource s-displaycolumns="ITEM,BRAND,DESCR,MSRP,YOURCOST" s-criteria s-order s-sql="SELECT ITEM, BRAND, DESCR, MSRP, YOURCOST FROM ITEMSBASIC
WHERE CAT = 'Auto'
AND TYPE = 'Restricted'
order by brand" 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" align="left" width="100%"><font color="#000000">This is the start of a Database Results region. The region will not work unless the page has a file extension of ".asp". 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 %>
<%
fp_sQry="SELECT ITEM, BRAND, DESCR, MSRP, YOURCOST FROM ITEMSBASIC WHERE CAT = 'Auto' AND TYPE = 'Restricted' order by brand"
fp_sDefault=""
fp_sNoRecords="<tr><td colspan=5 align=left width=""100%"">No records returned.</td></tr>"
fp_sDataConn="Database1"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=True
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_iDisplayCols=5
fp_fCustomQuery=True
BOTID=0
fp_iRegion=BOTID
%>
<!--#include file="_fpclass/fpdbrgn1.inc"-->
<!--webbot bot="DatabaseRegionStart" endspan i-checksum="46177" --><tr>
<td>
<!--webbot bot="DatabaseResultColumn" s-columnnames="ITEM,BRAND,DESCR,MSRP,YOURCOST" s-column="ITEM" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1"><<</font>ITEM<font size="-1">>></font>" startspan --><%=FP_FieldVal(fp_rs,"ITEM")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="1828" --></td>
<td>
<!--webbot bot="DatabaseResultColumn" s-columnnames="ITEM,BRAND,DESCR,MSRP,YOURCOST" s-column="BRAND" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1"><<</font>BRAND<font size="-1">>></font>" startspan --><%=FP_FieldVal(fp_rs,"BRAND")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="4434" --></td>
<td>
<!--webbot bot="DatabaseResultColumn" s-columnnames="ITEM,BRAND,DESCR,MSRP,YOURCOST" s-column="DESCR" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1"><<</font>DESCR<font size="-1">>></font>" startspan --><%=FP_FieldVal(fp_rs,"DESCR")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="2950" --></td>
<td>
<!--webbot bot="DatabaseResultColumn" s-columnnames="ITEM,BRAND,DESCR,MSRP,YOURCOST" s-column="MSRP" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1"><<</font>MSRP<font size="-1">>></font>" startspan --><%=FP_FieldVal(fp_rs,"MSRP")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="1975" --></td>
<td>
<!--webbot bot="DatabaseResultColumn" s-columnnames="ITEM,BRAND,DESCR,MSRP,YOURCOST" s-column="YOURCOST" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1"><<</font>YOURCOST<font size="-1">>></font>" startspan --><%=FP_FieldVal(fp_rs,"YOURCOST")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="11699" --></td>
</tr>
<!--webbot bot="DatabaseRegionEnd" b-tableformat="TRUE" b-menuformat="FALSE" u-dbrgn2="_fpclass/fpdbrgn2.inc" i-groupsize="0" clientside tag="TBODY" preview="<tr><td colspan=64 bgcolor="#FFFF00" align="left" width="100%"><font color="#000000">This is the end of a Database Results region.</font></td></tr>" startspan --><!--#include file="_fpclass/fpdbrgn2.inc"-->
<!--webbot bot="DatabaseRegionEnd" endspan i-checksum="62730" --></tbody>
</table>
</body>
</html>
Thx again...Bob.
</blockquote id="quote"></font id="quote">
vBulletin® ©Jelsoft Enterprises Ltd.