Paging MySQL Database records......again

2 Sep 2006 7:17 AM

Jay

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

2 Sep 2006 7:36 AM

Evertjan.

Jay wrote on 02 sep 2006 in microsoft.public.inetserver.asp.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_01C6CE35.FF84A730
> <!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)

2 Sep 2006 7:50 AM

Jay

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

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

that is where the page is located.

Thanks

James Jones

Show quoteHide quote

"Evertjan." <exjxw.hannivo***@interxnl.net> wrote in message
news:Xns983261C2329E8eejj99@194.109.133.242...
> Jay wrote on 02 sep 2006 in microsoft.public.inetserver.asp.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_01C6CE35.FF84A730
>> <!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)

2 Sep 2006 8:16 AM

Evertjan.

Jay wrote on 02 sep 2006 in microsoft.public.inetserver.asp.general:

Show quoteHide quote

>
> "Evertjan." <exjxw.hannivo***@interxnl.net> wrote in message
> news:Xns983261C2329E8eejj99@194.109.133.242...
>> Jay wrote on 02 sep 2006 in microsoft.public.inetserver.asp.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_01C6CE35.FF84A730
>>> <!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/how-do-i-page-through-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.Execute(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)