2 Replies Latest reply on Aug 30, 2006 8:48 AM by Newsgroup_User

    Dynamic pages and Access

    Genxbyapinch


      I have been searching for help ( more than a few days) but have not yet found anything that works.
      My database connection is ok
      My record set comes up with data ie test is okay
      I have followed the instructions for putting data on results page ie dragging and inserting, primarily I want to
      show images from my access 2002, but anything other than that would be good. I did read that access doesnt support binary data but on a sample database in a course I was doing they used access for displaying dynamic content so I am !confuSed!.

      I have Dreamweaver 8, I am using OBDC, I have enabled permissions, my server brings up my home page with search form ok.

      detailed error: 800a0bcd, eigher BOF is True or the current record has been deleted , It then gives me the line# I have many books but none on asp and vbscript so am floundering,
      <img src="<%=(Recordset1.Fields.Item("dphotos").Value)%>" alt="">

      Thanks for any help

        • 1. Re: Dynamic pages and Access
          Level 7
          What is the value of your first record in that field?
          What does your SQL look like?
          Are you able to access text-only fields and display their data?

          Jon

          "Genxbyapinch" <webforumsuser@macromedia.com> wrote in message
          news:ed2ldu$r0$1@forums.macromedia.com...
          >
          >
          > I have been searching for help ( more than a few days) but have not yet
          > found
          > anything that works.
          > My database connection is ok
          > My record set comes up with data ie test is okay
          > I have followed the instructions for putting data on results page ie
          > dragging
          > and inserting, primarily I want to
          > show images from my access 2002, but anything other than that would be
          > good.
          > I did read that access doesnt support binary data but on a sample database
          > in a
          > course I was doing they used access for displaying dynamic content so I am
          > !confuSed!.
          >
          > I have Dreamweaver 8, I am using OBDC, I have enabled permissions, my
          > server
          > brings up my home page with search form ok.
          >
          > detailed error: 800a0bcd, eigher BOF is True or the current record has
          > been
          > deleted , It then gives me the line# I have many books but none on asp and
          > vbscript so am floundering,
          > <img src="<%=(Recordset1.Fields.Item("dphotos").Value)%>" alt="">
          >
          > Thanks for any help
          >
          >
          >


          • 2. Re: Dynamic pages and Access
            Level 7
            your recordset query returned no results...

            do you have a error trap for no records returned like
            <%
            if not Recordset1.eof then
            %>
            <img src="<%=Recordset1("dphotos")%>" alt="">
            <%
            else
            response.write "Something went wrong...." & err.description
            end if
            %>

            this will help you diagnose errors

            or

            <%
            if not recordset1.eof then
            NXB=1
            end if
            %>
            <img src="<% if NXB=1 then response.write Recordset1("dphotos") %>" alt="">


            Mike K


            "Genxbyapinch" <webforumsuser@macromedia.com> wrote in message
            news:ed2ldu$r0$1@forums.macromedia.com...
            >
            >
            > I have been searching for help ( more than a few days) but have not yet
            found
            > anything that works.
            > My database connection is ok
            > My record set comes up with data ie test is okay
            > I have followed the instructions for putting data on results page ie
            dragging
            > and inserting, primarily I want to
            > show images from my access 2002, but anything other than that would be
            good.
            > I did read that access doesnt support binary data but on a sample database
            in a
            > course I was doing they used access for displaying dynamic content so I am
            > !confuSed!.
            >
            > I have Dreamweaver 8, I am using OBDC, I have enabled permissions, my
            server
            > brings up my home page with search form ok.
            >
            > detailed error: 800a0bcd, eigher BOF is True or the current record has
            been
            > deleted , It then gives me the line# I have many books but none on asp and
            > vbscript so am floundering,
            > <img src="<%=(Recordset1.Fields.Item("dphotos").Value)%>" alt="">
            >
            > Thanks for any help
            >
            >
            >