Jay wrote on 02 sep 2006 in microsoft.publi c.inetserver.as p.general:
>
"Evertjan." <ex************ **@interxnl.net wrote in message
news:Xn******** ************@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)
