473,893 Members | 1,861 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Asp Javascript language paging larger database record sets

Asp Javascript language paging larger database record sets

i am firmiliar with asp javascript and not asp VB.

i can display the results ok, but if i return 100 records from my table
i would like it to display 5 records per page. i have looked at asp
recordset paging on several sites, however cannot find any scripts that
work with ASP JAVASCRIPT.

can anyone help??????????? ??????????????

below is the code that i have used in my pages
email me zf*******@hotma il.com
thanks zibby1199
Database Connection File
------------------------------------------------------------------------------------------------------------------------------------------

<%@ LANGUAGE="JAVAS CRIPT" %>
<%
myconn=Server.C reateObject("AD ODB.connection" );
mydb = "Driver={Micros oft Access Driver
(*.mdb)};DBQ=c: \\onlinedata\\w ebs\\PhoneUnloc kers.net\\test\ \BizOpps\\BizOp ps.mdb";
myconn.Open (mydb);
rs = Server.CreateOb ject("ADODB.Rec ordset");
%>

------------------------------------------------------------------------------------------------------------------------------------------
Display Page
------------------------------------------------------------------------------------------------------------------------------------------
<%

sql = "Select * from tblUser" ;
rs=myconn.Execu te(sql);
while (!rs.eof)
{
%>
Name: <%=rs("Name")%> ,
DOB: <%=rs("DOB")% >,
Address: <%=rs("Address" )%>
<%
rs.movenext();
}
rs.Close();
%>
------------------------------------------------------------------------------------------------------------------------------------------

Sep 29 '06 #1
4 2250
<zf*******@hotm ail.comwrote in message
news:11******** *************@m 73g2000cwd.goog legroups.com...
Asp Javascript language paging larger database record sets

i am firmiliar with asp javascript and not asp VB.

i can display the results ok, but if i return 100 records from my table
i would like it to display 5 records per page. i have looked at asp
recordset paging on several sites, however cannot find any scripts that
work with ASP JAVASCRIPT.

can anyone help??????????? ??????????????
[snip]

URL:http://databases.aspfaq.com/database...-a-recordset.h
tml
Sep 29 '06 #2
that url does not work

thanks for the reply though.

Sep 30 '06 #3
zibby1199 wrote on 30 Sep 2006 in microsoft.publi c.inetserver.as p.general:
that url does not work

thanks for the reply though.
Where are you posting about?

[please always quote on usenet]

--
Evertjan.
The Netherlands.
(Please change the x'es to dots in my emailaddress)
Sep 30 '06 #4
"zibby1199" <zf*******@hotm ail.comwrote in message
news:11******** **************@ i3g2000cwc.goog legroups.com...
that url does not work

thanks for the reply though.
The "tml" at the end was on the next line.

http://databases.aspfaq.com/database...recordset.html
Sep 30 '06 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

25
4346
by: Jeff | last post by:
Use the MS Script Editor included free with MS Office 2002 and above, for debugging Internet Explorer (IE). This subject is of great interest to many JS developers, as there is no obvious, low cost way to do sophisticated debugging in IE6 other than to use the debugger described below, which is horribly documented otherwise. I feel debugging is an important aspect of projecting the useability of the language and needs to be made more...
14
5858
by: Luiz Antonio Gomes Pican?o | last post by:
How i can store a variable length data in file ? I want to do it using pure C, without existing databases. I'm thinking to use pages to store data. Anyone has idea for the file format ? I want to store data like a database: ---------------------------------- Custumer:
4
6280
by: karunakar rao | last post by:
Hi All I need some help. I have been populated 50,000 Records in asp.net C# datagrid. Ever page has 10 records Example "<< Prev 1 2 3 4 5 6 7 8 9 10 Next>> Iam showing like that in my datagrid When ever click the Next Buttuon Iam getting data from database Total(50,000) Records.Every time performanse wise it is taken lot of
5
2524
by: aaronwmail-usenet | last post by:
Hi folks. I'd really like some comments or flames please :). I've ported my xsdb database engine to javascript. I put up a demo page here: http://www.xfeedme.com/xsdbXML/xsdbjs/runqueries.html The xsdb framework provides a flexible and well defined infrastructure to allow tabular data to be published, retrieved, and combined over the Internet.
5
2180
by: Mike S | last post by:
I'm working on a .NET application that was under development by a previous developer, who is no longer working with the company. The program basically extracts records from a source database and outputs them in an XML document, mapping the source records into a third-party XML schema. The mapping process is handled by C# code that was auto-generated by Altova MapForce -- code was added to extract a subset of records from the source...
8
8545
by: AG | last post by:
ASP.NET 2.0, VS 2005 I have a gridview with paging enabled, bound to an objectdatasource. Both were dropped on to the page and configured via the wizards. Basically working as expected. The gridview's databind method is apparently called when the page is loaded as I have no code calling the databind method. How can I keep the gridview from databinding automatically and control it myself?
3
3748
by: Ronald S. Cook | last post by:
I was told that if calling lots of records from the database (let's say 100,000), that the GridView's paging feature would automatically "handle" everything. But the 100,000 records are still coming to the client, right? I mean, the paging feature isn't somehow making calls to the database for 25 records at a time or anything like that is it? I remember in the past having to write nasty stored procedures that took in
5
3222
by: Donald Adams | last post by:
Hi, I will have both web and win clients and would like to page my data. I could not find out how the datagrid control does it's paging though I did find some sample code that says they do it this way, but I can't see these methods as public. BookmarksDataSetTableAdapters.BookmarksTableAdapter bookTA = new BookmarksDataSetTableAdapters.BookmarksTableAdapter(); BookmarkList1.DataSource = bookTA.GetAllBookmarksWrtUser(
8
1459
by: Donald Adams | last post by:
I heard in an online video by Scott Gu, that there is an option to have the asp.net datagrid in .net 2.0 do the paging in SQL Server 2005 rather than pull all the data from the database and do it on the web server. I've been unable to find any good documentation on this. I saw a property to turn on paging if the select supports it, but that did not give me enough information to complete my task. Does anyone know where I can find...
0
9832
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
11245
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
10840
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
10469
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
9647
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
0
7175
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
6066
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
4684
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
4281
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.