Paging Records
I am trying to develop a page where users can click on alphabets to look for a company name that starts with the selected letter.
Searching through the forums i came across the method of using DoCmd.
alpha = Request.QueryString("alp")
if alpha <> "" then
DoCmd.ApplyFilter "", "[com_name] Like ""[" & alpha & "]*"""
end if
The 'alpha' variable here holds the alphabet selected by user from another page. However, I'm getting an error message saying
Microsoft VBScript runtime (0x800A01F4)
Variable is undefined: 'DoCmd'
Initially i tried the usual filtering
if alpha <> "" then
rs.Filter = "com_name LIKE " & alpha
end if
The pages are suppose to display records in 10s. But instead of showing only the records of company starting "A" (example) it shows everything.
then, i was told in the forum that DoCmd is not used with ASP. Is there any other way?
View Replies
ADVERTISEMENT
I'm having a bug here that is driving me nuts
I read more than 10 tutorials so far about paging records using ASP and Access, and all of them are basically using the same way I am, but no one seens to have this bug:
When I page my records, instead of listing ordered, the records shown on each page seens to be sort of compressed in a resumed search. Humm, let me try give an example:
The DB has 40 rows and Im using rs.cursorlocation=3, rs.pagesize=10, rs.cachesize=10
I do a search ordered by the field called 'name'.
Instead of showin on first page A-G, second page G-M, etc.., the list is showin A-Z on each page skiping the records. like "resuming" the seach in each page. And the other weird thing is that as I go from page to page the number of records start changin from 10, to 8 to 5
Does anyone ever had a bug like that?
View Replies
View Related
I have a page that returns a query onto a page 30 at a time. At the bottom are the navigation controls, back, next, etc. Printing it becomes a problem. I don't want the controls printed with the rest of the information.
Is there a way to keep them from printing or can they be moved to a seperate page in the frameset?Can the results be sent to the printer in a formatted manner without being displayed?
View Replies
View Related
I am trying to provide a paged listing of Access DB table data using ADO. I have a problem using the AbsolutePage method. I am using the following:
[VBS]
objRs.Open strSQL, objDbConn, adOpenStatic, adLockReadOnly, adCmdText
objRs.PageSize = 5
objRs.CacheSize = 5
objRs.MoveFirst
objRs.AbsolutePage = 24
Response.Write(objRs.AbsolutePage)
Do While objRs.AbsolutePage = 24 And Not objPubRs.EOF
Response.Write(objRs("data"))
objRs.MoveNext
Loop
[/VBS]
The line "Response.Write(objRs.AbsolutePage)" writes "-1" and the loop does not write any data.
If I remove the "objRs.AbsolutePage = 24 And" from the loop test it will write recordset data starting with the proper page position but continues to the end of the recordset (including all following pages).
With objRs.AbsolutePage reporting -1 I cannot test out of the loop based on the recordset page number.
View Replies
View Related
I am displaying my records horiztonally and i have set a limit on the records to be shown on my page the limit is 5 records per page and i have a category which has 8 records.
the code was working fine with paging when the records were displayed vertically but when i added the code so that it displays horizontally its giving this error Code:
View Replies
View Related
I'm trying to set up a "simple" page to display six items at a time in a 2 col x 3 row grid I've succeeded in doing this and displaying all the records but am struggling to only display six at a time I've searched on recordset paging and no one seems to cover this sort of problem Anyone any ideas? Code:
View Replies
View Related
I am having a problem with my recordset paging. It does not crash however no records are viewable. It shows no information from my database.
It shows that there are 8456 pages and the href links and thats it.
I also did a response.write(mysql) response.end to check that my sql was correct. It is picking up the correct sql except no information. Code:
View Replies
View Related
I'm trying to only show 10 records at a time. I have the first 10 records showing. The problem is that when I click the Next button I get an error message: ADODB.Recordset (0x800A0BB9)
Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another. Also different people are going to search for different things so there will always be a different amount of records returned each time. I can't figure this out. My code is:
View Replies
View Related
The problem concerns 2 tables, cart_products and cart_shoppingcart.
Cart_products contains all the product data (eg, prices, product's key name, etc), but most importantly, it contains the quantity of stock (prod_quantity) for each item.
cart_shoppingcart contains all of the user's items in their shoppingcart, including those that are part of an (customer) order; these have the order_number to differentiate from those that aren't in any order (their Order_number is 'no_order', the others have the order number).
Now, what I want to do is this:
For every item in the order (ie, every entry in cart_shoppingcart that matches the username and order number), take the quantity (x) the customer is ordering, then take the quantity of stock remaining (y), then subtract x from y to create the new stock level (z) and update the appropriate record in cart_products with z (all this with SQl preferably).
I was thinking of using a Do while loop, but realised that it wouldn't work as I'd have to use several SQL statements and then I'd run into a problem the minute ASP reads "objrec.movenext".
View Replies
View Related
I'm trying to pull the last 5 records from my database.
<% j=5
rs.MoveLast
While ((j>0) AND (NOT rs_article.BOF))%>
''Execute HTML and data insertion here
<%rs_article.MovePrevious
j=j-1
Wend%>
Everytime I attempt to run this code, I recieve an HTTP 500- Internal Server Error. It tells me no more than that. I know that my connection settings are OK because when I move forward through the database (first five records), the code executes without error. And yes, my Cursor type is Dynamic.
Alternatively, I would also like to know how to add new recordset to the beginning of a database rather than the end.
View Replies
View Related
I have an Access database with two fields that I would like to group by. The two fields are location and department. Field names are "Location" and "DeptName".
I have the code correct for grouping by location. That code looks like this: Code:
View Replies
View Related
Is there a way of using the ALT outside the IMG? I was wondering if it's possible of using an ALT on paging # to show which page is at what record. This is what I have though it doesn't work: Code:
View Replies
View Related
I was wondering if any body can kindly help me with a little dilemma I have.
ASP and SQL paging was relatively easy to implement, however, I cannot manage to get start the paging from a certain record:
In the script that I made, about 4,000 pictures get displayed as thumbnails in paged view, when users click on a thumbnail they are taken to individual picture view, with “next” and “back” controls, however, I cannot find a way of returning the user to the thumbnail view that starts with the picture they just viewed, and not the beginning of the recordset.
View Replies
View Related
I have a database table with field as a three digit number like 001 (I did that because when I was searching for example 1, it would bring all the numbers which included 1, like 1, 10, 11, 12...100...). I have the following so far: Code:
View Replies
View Related
I'M using paging in my application.
I have separated my pages by 50 records per page.
Now, lets say Iwant to sort by name only 50 records
that exist in page 3 for example(lets say page 3 is the
currently displaying page). How can i achieve this.
Because as it is my sql sorts all the table(all pages)
and a specific record that was in page 4 maybe
in page6 for example.
View Replies
View Related
I do done paging of first previous next last but now i want the paging in displaying page number. i.e. if there is 25 pages then display only 1 2 3 4 5 .... and if click on number the page will be display and next five will be apper on screen
View Replies
View Related
I have an asp page that I would like to do paging. The problem I'm running
into is that the same page that prints to the output is also recieving data
from the previous page for query parameters for the sql string.
When I click on the next page, it queries itself and loses all the query
parameter information from the parameter page and brings back all the
records.How can I keep the parameter values from the query form and still advance to
the next page?
View Replies
View Related
I am building up a search engine with .ASP 3.0 using sql server database for data listing and what I Like to do is display max 10 items in one page per search query and have Prev and Next to display pages with informations requested and found in recordset. sort of like google.
View Replies
View Related
I am working on a database based web page that has paging. I'm not getting error message, but it is not working at all. Let me tell you what it is not accomplishing and what I want it to accomplish.
1.) I want it to only display 20 records per page. It is currently displaying all records at this time.
2.) I want the numbers of page to be reduced. I don;'t want it to show all of the pages. I would prefer that it show something like next 10 after about 20 numbers.
You can find my code. It's lengthy. I have attached a document to let you see what I don't like.
Code: ....
View Replies
View Related
Just need to know if it's possible to page using FSO, hardly used FSO before, struggling like hell trying to get it to page - if it's not possible then i'll give up now .
View Replies
View Related
I am writing up code which pulls information from a DB...
the code as it is now displays all the information down the page... I'd like it to only display a certain number of rows of info, and at the bottom of the page, show the number of pages and a next/prev to page trough the db and display a certain # of info at a time.
eg: if i want to display 10 rows of uinfo, from a db that contains 20 rows of info, after displaying the first 10, you'll see this at the bottom:
next 1, 2, 3 etc... so u click on next or the number and it'll display the info for that page... so 2 will show row 11 - 20 and 3 21 - 30..
View Replies
View Related
What are different ways of provding PAGING THRU RECORDSETS, I am working on search engine website.
View Replies
View Related
I have done a paging pages but something went wrong. The problem that i encountered was that let say i have 15 records and each page will only display 10 records in 1 page..however when i try to click the 2nd page, nothing was being displayed..is there anything wrong with my codings? .....
View Replies
View Related
I have written code in ASP for paging records from the database (SQL Server 2000).The real problem I have around 10,000 records and it tries to fetch all the records everytime (I'm saying because its take a lot time to display it). Even though,it displays all the data correctly and you can also navigate through links.
Is it possible to set the limit on recordset while it fetches the data. Lets say page size is 20 records per page, so it should fetch only twenty records from the database (depends on page being displayed) rather fetches all records and displaying twenty records.I know its possible if we use mysql database so can you set the limit (its keyword) in the query statement.
View Replies
View Related
Have a set number of records on the screen displaying products as well as a text box where people can enter quantity to be ordered. Customer can go to next page where balance of products are displayed to same. When returning to original screen the amounts entered are gone.How should one address this to redisplay the already entered amounts.
View Replies
View Related
I have a table in SQL which has almost 400 records. So i dont want to list the records in one page only becoz it will require lot of scrolling. i want to display only 40 records per page. And show the previous and next buttons also on the pages.
View Replies
View Related
I have found this article/code showing RS paging with GetRows:
http://www.4guysfromrolla.com/webtech/070500-1.shtml
However, it does not show anything like "page: 1 | 2 | 3 | 4", with only "next" and "previous" links. This makes it very difficult to find a record in a huge database.
Does anyone have code for GetRows paging that does this? [Additionally, I can no longer find the non-Getrows paging method that I used to use, that I got from this forum...]
View Replies
View Related
can you give me the code of paging?
View Replies
View Related
I have a page in ASP that retrieves products in MS ACCESS, my problem is that, it displays evrything in just one page and the page gets crowded, how can i limit the number of products it will display in one page? say, i want to display only 10 products and the rest will go to the next pages.
View Replies
View Related
some web sites have paging buttom of the page, but i want to know some time they will show just 10 numbers for ex:
1 , 2 , 3 , 4 , 5 , 6 , 7 , 8 , 9 , 10
1 , 2 , 3 , 4 , 5 , 6 , 7 , 8 , 9 , 10
1 , 2 , 3 , 4 , 5 , 6 , 7 , 8 , 9 , 10
.
.
.
.
8 , 9 , 10, 11, 12 , 13, 14 , 15, 16 , 17
I want to let 10 spaces but the number changing how to do it?
View Replies
View Related
is there anyway to tell the page to break after a specific record? Like when the group name changes instead of i.e. when pagesize = 25?
View Replies
View Related
I have written a pagination script and the first page appears fine, however if I click next I get a ADODB.Recordset error '800a0cb3' .
Current Recordset does not support bookmarks. This may be a limitation of the provider or of the selected cursortype Code:
View Replies
View Related
I try to find a script in ASP that combines sorting and paging. I already found various scripts that do one or the other but none does it both. I know I should combine them, but it is very difficult at my level of asp knowledge.
View Replies
View Related