Paging MySQL Database records......again

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Jay
    #1

    Paging MySQL Database records......again

    i post a while back on how to page thru database records. i dont really understand the ASPFAQ one. Its not well commented. This is how i learn anything, is if its commented on what does what.

    Can someone please help me. i have a datbase of about 90 records so far, that i would like to page thru.


    Thank you.

    James Jones

    Tags: None
    • Evertjan.
      #2
      Re: Paging MySQL Database records......ag ain

      Jay wrote on 02 sep 2006 in microsoft.publi c.inetserver.as p.general:
      i post a while back on how to page thru database records. i dont
      really understand the ASPFAQ one. Its not well commented.
      [..]
      Can someone please help me. i have a datbase of about 90 records so
      far, that i would like to page thru.
      Please show us the link to the aspfaq page, we can have a look
      ... the ASPFAQ one. Its not well commented. This is how
      i learn anything, is if its commented on what does what.
      What is not "well" about it?

      Hands on learning is the best. Did you try a piece of code you made
      yourself? After all you managed to fill the db.
      ------=_Next Part_000_0062_0 1C6CE35.FF84A73 0
      <!DOCTYPE HTM L PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
      <HTML><HEAD>
      Please NEVER send a HTML part to usenet.


      --
      Evertjan.
      The Netherlands.
      (Please change the x'es to dots in my emailaddress)

        Comment

        • Jay
          #3
          Re: Paging MySQL Database records......ag ain

          sorry i didnt kno i am posting HTML to usenet..i didnt type any.......


          500 Internal Server Error
          http://databases.aspfaq.com/database/how-do-i-page-through-a-recordset.html




          that is where the page is located.


          Thanks


          James Jones



          "Evertjan." <exjxw.hannivoo rt@interxnl.net wrote in message
          news:Xns983261C 2329E8eejj99@19 4.109.133.242.. .
          Jay wrote on 02 sep 2006 in microsoft.publi c.inetserver.as p.general:
          >
          >i post a while back on how to page thru database records. i dont
          >really understand the ASPFAQ one. Its not well commented.
          >
          [..]
          >
          >Can someone please help me. i have a datbase of about 90 records so
          >far, that i would like to page thru.
          >
          Please show us the link to the aspfaq page, we can have a look
          >
          >... the ASPFAQ one. Its not well commented. This is how
          >i learn anything, is if its commented on what does what.
          >
          What is not "well" about it?
          >
          Hands on learning is the best. Did you try a piece of code you made
          yourself? After all you managed to fill the db.
          >
          >------=_Next Part_000_0062_0 1C6CE35.FF84A73 0
          ><!DOCTYPE HTM L PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
          ><HTML><HEAD>
          >
          Please NEVER send a HTML part to usenet.
          >
          >
          --
          Evertjan.
          The Netherlands.
          (Please change the x'es to dots in my emailaddress)

            Comment

            • Evertjan.
              #4
              Re: Paging MySQL Database records......ag ain

              Jay wrote on 02 sep 2006 in microsoft.publi c.inetserver.as p.general:
              >
              "Evertjan." <exjxw.hannivoo rt@interxnl.net wrote in message
              news:Xns983261C 2329E8eejj99@19 4.109.133.242.. .
              >Jay wrote on 02 sep 2006 in microsoft.publi c.inetserver.as p.general:
              >>
              >>i post a while back on how to page thru database records. i dont
              >>really understand the ASPFAQ one. Its not well commented.
              >>
              >[..]
              >>
              >>Can someone please help me. i have a datbase of about 90 records so
              >>far, that i would like to page thru.
              >>
              >Please show us the link to the aspfaq page, we can have a look
              >>
              >>... the ASPFAQ one. Its not well commented. This is how
              >>i learn anything, is if its commented on what does what.
              >>
              >What is not "well" about it?
              >>
              >Hands on learning is the best. Did you try a piece of code you made
              >yourself? After all you managed to fill the db.
              >>
              >>------=_Next Part_000_0062_0 1C6CE35.FF84A73 0
              >><!DOCTYPE HTM L PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
              >><HTML><HEAD >
              >>
              >Please NEVER send a HTML part to usenet.
              [please do not toppost on usenet]
              sorry i didnt kno i am posting HTML to usenet..i didnt type any.......
              You did send HTML as if you were using an email agent.

              Topposting and HTML, they are not the best way to inroduce yourself,
              methinks. Perhaps a dedicated news reader would do?

              =============
              http://databases.aspfaq.com/database...gh-a-recordset.
              html
              that is where the page is located.
              That page is well documented in my opinion but is not geared for mySQL.
              mySQL is, as far as I know, a LINUX database, not the primary choice for
              ASP.

              A general "page through SQL" line could look something like this:

              [setup CONNECT as your db connection]
              SQL = "SELECT * FROM myTbl ORDER BY name,age"
              set mData=CONNECT.E xecute(SQL)
              Do Until mData.Eof
              response.write mData("name") & "<br>"
              response.write mData("age") & "<br>"
              mData.MoveNext
              response.write "<hr>"
              Loop

              However, I would not know about mySQL.


              --
              Evertjan.
              The Netherlands.
              (Please change the x'es to dots in my emailaddress)

                Comment

                Previous template Next
                Working...