I'm having trouble with the recordset object. I'm trying to use the "RecordCount" aspect of the recordset but it keeps diplaying "-1". How do I get it to show the total count of records?
View Repliesi use this code;
Dim aCount
rsArchive.Open "SELECT * FROM qryArchive", db
aCount = rsArchive.RecordCount
but why aCount is still -1? the actual recordcount should be 4?
I searched the web for this, but couldn't find any reason as to why this was happening to me. I have a database set up with one record in the students table. I just issused a query "SELECT * FROM students" to test my DB. When I try to get the number of records with adoRS.RecordCount, it returns a -1.
Code:
set adoConn = Server.CreateObject("ADODB.Connection")
set adoRS = Server.CreateObject("ADODB.Recordset")
adoConn.Open "DSN=myodbc"
adoRS.ActiveConnection = adoConn
adoRS.Open "select * from students"
response.write(adoRS.RecordCount)
I do have an entry in the students table, so the RecordCount should be 1. BTW, I'm using the latest MyODBC 3.51 driver.
when the recordcount of the recordset of a adocon is -1, how can I write the record count correctly? I once tried:
rs.movelast
response.Write(rs.AbsolutePosition)
it report the following message for the movelast method
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E24)
Rowset does not support fetching backward.
How do you display all your fields from an SQL table in a web page - BUT make them clickable to make any changes???
E.G. I have a users table with firstname and surname in, but I wish to amend the surname??
I know the code to amend the changes, but dont know how to display the records and make them clickable!!!
is there a code or query that i can use to display everything but the first record?
here's my sql:
sql = "SELECT * FROM Hotstory ORDER by DateTime DESC"
what i'm using to display:
Response.Write("<a href=' " & rs("URL") & " 'target='_blank'>" &rs("Title")&"-"&rs("DateTime")& "</a>")
I was wondering if anyone would be able to help with the following;
I have a database which contains a list of products with prices and a set of variables.
I'd like to store the product prices as session variables....
I found a displaying records of a Database in a HTML table,but i want the opposite. I want to insert the content from an HTML or ASP page and no a TXT file into a Database.
View Replies View RelatedI have a database that has a column for an expiring date. How would I query the database to display only records whose expiring date is greater than the current date? For example, if the current date was 6/16/2004 and there were these expiring dates:
6/1/2004 6/15/2004 6/17/2004 6/18/2004 then only 6/17 and 6/18 would display.
I am building an asp webshop and have an accesss database with all the products. I can create a catalogue page using repeating regions to display all the products no problems but I want to customise a bit. Just say I want to display products 3, 7 and 10, what I have been doing is to created 3 seperate recordsets in Dreamweaver with the filter ProdID = Entered Value 3, 7 and 10 respectively.
I then bind the product name, price, description for each of the 3 products to the page. My questions - Is there a better way of doing this especially if I have a catalogue page with many products and many recordsets. I want to build the pages in this manner so it is like a static page but with a database content (not with repeating regions).
Is it possible to have just 1 recordset and pass the values 3, 7 and 10 through it and then bind the results to the page seperately (How do I code it?). If this is possible is it a more efficient way of working than having a seperate recordset for each product. Is it a drain on the server to have to deal with say 10 recordsets or it OK?
my search engine shows 14 records per page and displays the total number of pages with that search criteria.
if there are 140 search results it shows 10 page links at the bottom of the screen ( 1 2 3 4 5 6 7 8 9 10)it also does the same thing if there are 1400 results 1 2 3 4 5 6 7 8 9 10 11 12 13 etc etc up untill 140)
i am trying to stop this and only allow it to show 10 page links at a time then next, for example if there are 12 pages it would look like this 1 2 3 4 5 6 7 8 9 10 >next> (then the next links. i would like this to show 10 pages each time.
i want to show records from the database in such a manner that three records will show on on TABLE ROW. and then the next three on next table row and then next 3 on third table row. So nine records on one page. and there will be link for next link to move to next page.
I have some paging idea and i know how to move to next page but i dont know how to display records by limiting the columns of the rows. Like in the past i used to show all the records by either increasing the rows or by increasing the columns of the tables by using loop. but now i want to show records in such manner that limits both the rows and columns.
i have a set of details in the database that looks like this: Code:
Name Number
-------------------------
ABC 123456
ABC 128556
ABC 125559
DFF 559851
DFF 448715
DFF 154873
how do i select then in such a way that they are display like this on the asp page:
Code:
ABC
-------------------
123456
128556
125559
DFF
--------------------
559851
448715
154873
I am working on exporting my results to excel and running into an issue where I wasn't getting any records but have since now been able to see some records now....it appears to only be showing records that I have added thru the web interface to the database, it's not showing the records that I imported (SQL database).
My results.asp displays all the records properly, it's just not working on my export to excel. I've looked at the data in the SQL table but I don't see anything unusual. Has anyone ever run into this before and have any clue on what I can check now?
I want to be able to display records inputed from Monday at 12:00am to Sunday at 5 pm. Every week.
So far, I can display records for the last 7 days, but How can I be more specific?
Any Ideas??
I've got some code that displays public event info on a page - unfortunately, it seems to have stopped working today for some reason and I don't know why (there are 2 records in the database that match the criteria, so I know that's not the problem: Code:
View Replies View RelatedI have a search page which has radio buttons for two search options (location, price) and checkboxes for one other option (type). The radio buttons reference the "general" table in my database, and the checkboxes reference boolean records in the "cuisine" table.
My task is to display, on a subsequent page, records that match the two radio buttons selected as well as each checkbox. Code:
short n simple question: I want to display the number of records returned from a search. Code fragment as follows:
// d/b retrieval SQL code
SQLCode = SQLCode
Set objRS = objConn.Execute (SQLCode)
// displaying the returned results
Do While (Not objRS.EOF
<< spit out records >>
objRS.MoveNext
Loop
Now, is there an instance of objRS I can call that will just display how many records were returned? I tried objRS.Count on a longshot, but that didn't work
Im looking for a very simple and small script that will display 2 random records for a database, but i havnt found one yet. Can someone help me on this one?
View Replies View RelatedSay i have 100 rows in a table and i make a query:"Select * from table", i will get all the 100 rows displayed, but what i want to do is to display 20rows in a page and then have 'Next' and 'Previous' links to navigate through the records 20 by 20. This is in fact exactly as in this forum where only 20 posts are displayed sorted by most recent ones and so on.
View Replies View RelatedI am trying to display all the records in my database when I click a button that I made. Can anyone show me how to do that? Right now I have no code for this. I just want a button on my page, so that someone can print out a list of all the records in my database and have it for reference.
View Replies View RelatedI have created a website using dreamweaver mx 2004 and access 2000 for the database. i want to display the results of a recordset in a grid with a different record in each grid. the grid will be fixed in width and the cells will be fixed in width and height but if more cells are required (eg more records to display) then they will be added to the bottom of the grid. at the minute its not working. This is a screenshot of what im sort of after.
View Replies View RelatedI'm displaying records from an Access db and would appreciate advice on the most efficient/easiest way of displaying a field.
The db holds a list of furniture products where there are a number of ranges. Each record has the range name against it but I've only put the range description against the first record in that range Code:
I am displaying a table that contains 36 columns and 20-40000 rows.The first row is a header.When i scroll the page down the header disappears(anyways this is a fact).Is there any way in which i can keep the header/first row constant when i scroll the page downwards or sideways for n number of records? I am using Access as the Backend and the front scripting is by ASP and connecting thru ADO.
View Replies View RelatedI have a results table that is 5 columns wide. the recordset is returned with 48 items. I have no problem displaying 5 per row until I hit the last row where i get a ADODB.Field error '80020009'.Either BOF or EOF is True, or the current record has been deleted.Requested operation requires a current record.how do I close of the table row when I reach the EOF?
i.e
1 2 3 4 5
1 2 3 4 5
1 2 3 4 5
1 2 3 4 5
1 2 3 4 5
1 2 3 * *
I need to display empty cells (in place of the *'s)or end the row when there is no data to fill it...how is this done?
I currently have entries in my dbase with time stamps. Does anyone know how I would display only those records with the time stamp that reflects a particular day. For example I want to display all records from today which would be 8/23/2004 on the page.
Im assuming this has something to do with the Date () function but i dont understand how it could incorporate it into code.
I am having a bit of trouble with classic asp and tables.
I want to loop through a recordset (easy enough) but I want to display the records in a table with only 3 records in a table row. So in other words each table row needs to have 3 items then a new table row is created dynamically until recordset.eof
Item 1 Item 2 Item 3
Item 4 Item 5.......until eof..
I have a recordset that displays hundreds of records, I would like to display a row number next to each record in the order of 1, 2, 3 etc.
View Replies View RelatedI have an ASP page where I want to display the 3 most recent records within a database using a SQL query. The problem is that my page which output the results is only showing the first most recent record and not the two past ones aswell.
Am I right in thinking that might be related to the 'loop' function? I know that my SQL code is fine as I have previewed the results from the code and they are correct. Code:
I want to display a series of records grouped by nested years and months, e.g.:
2004
December
Record1
Record2
Record3
November
Record4
Record5
...
...
2003
This would be based off of a date value stored with each item in the
recordset.
Does someone have a snip of nested looping script to break this down by
date in this manner? Code:
what the easiest way is to get the number of records in a recordset, or the number of records returned by my query. I can't get this rs.recordcount thing to work. it just returns -1 all the time. I read on asp101 that it only works when you're using the right cursor type but I tried using the cursor type they said to use and it still doesn't work. I also did the test they gave to check if your record set will allow recordcount()
Code:
If rs.Supports(adBookmark) Or rs.Supports(adApproxPosition) Then
Response.write "will work"
End If
and that works...
So can anyone help me plz!
ps. whithout looping through the records and counting them if possible plz! there must be a shorter way than that.
I have a query that is supposed to return only 1 record, however I recently found that because of an error in the database it can return more than 1. So what I need to do is capture if it is more than 1 record and alert the user to contact the database administrator. How can I get the count of records returned by a recordset? Is there no way besides looping through with a counter variable?
View Replies View RelatedIf I want to display the last X number of records in a recordset, how would I do it? Say I have ten records and I want to display them showing the smallest amount first: Code:
View Replies View Related