Accessing Access

Discussion in 'Databases' started by peacedaletr, Aug 6, 2003.

Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.
  1. peacedaletr

    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.
     
    peacedaletr, Aug 6, 2003
    #1
  2. peacedaletr

    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>



    <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>ITEM</b></td>
    <td>BRAND</b></td>
    <td>DESCR</b></td>
    <td>MSRP</b></td>
    <td>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'>&amp;lt;&amp;lt;</font>ITEM<font size='-1'>&amp;gt;&amp;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'>&amp;lt;&amp;lt;</font>BRAND<font size='-1'>&amp;gt;&amp;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'>&amp;lt;&amp;lt;</font>DESCR<font size='-1'>&amp;gt;&amp;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'>&amp;lt;&amp;lt;</font>MSRP<font size='-1'>&amp;gt;&amp;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'>&amp;lt;&amp;lt;</font>YOURCOST<font size='-1'>&amp;gt;&amp;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.
     
    peacedaletr, Aug 6, 2003
    #2
  3. Bruce

    Bruce DiscountASP.NET Staff

    Can you post the code?

    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, Aug 6, 2003
    #3
  4. Bruce

    Bruce DiscountASP.NET Staff

    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.
    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>



    <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>ITEM</b></td>
    <td>BRAND</b></td>
    <td>DESCR</b></td>
    <td>MSRP</b></td>
    <td>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">
     
    Bruce, Aug 7, 2003
    #4
Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.

Share This Page