Displaying # Records Returned

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

View Replies


ADVERTISEMENT

Count No Of Records Returned

I have created a simple search engine which retrieves records from an access database using sql and displays them using ASP.How do I go about counting the number of records that have been retrieved?

View Replies View Related

Count Records Returned

I have been using the following code to count the number of rows returned from a query:

Alldata = rs.Getrows()
NumRows = Ubound(Alldata, 2)

The problem is I am now having to limit the number of rows that it returns:

Alldata = rs.Getrows(300)

Now my NumRows always equals 300 no matter how many matches are found so my counter doesn't work. Does anyone know a way around this?I know that I can use SELECT COUNT(*)..... instead in an SQL query but that means making two trips to the server which I don't really want to do.

View Replies View Related

Records Returned From Stored Proc

I've created a Stored Procedure which adds a new record and updates some more records and then returns the primary key for the added record.

The SP seems to work OK, but I'm having problems getting at the returned key in my ASP code:

"Item cannot be found in the collection corresponding to the requested name or ordinal."

A common error, but in this case I can't see why... I output the SQL instruction that is sent to the DB and have run it in Query Analyser and it runs OK and returns a single row, with a single column - the new primary key...

But when I try and access this in ASP, I get the error message....

View Replies View Related

Counting Records Returned From A Database

I've been trying to find a simple way to count the records returned from a database query short of looping through the recordset and incrementing a counter.

I've tried the following without any success:

Ubound(select_rs) - afterall the recordset is returned in an array right? Ubound gives the following error: Microsoft VBScript runtime (0x800A000D)
Type mismatch

I've tried select_rs.count which gives the following error: VBScript runtime (0x800A01B6)

Basically, I've reached the point where I think I may have to loop through the recordset and count the number of records returned. Seems like an awfully inefficent way to do something so simple.

View Replies View Related

Displaying All Records

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!!!

View Replies View Related

Displaying Records

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>")

View Replies View Related

Displaying Records

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....

View Replies View Related

Displaying Records

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 Related

Displaying Records

I 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.

View Replies View Related

Displaying Different Records

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?

View Replies View Related

Displaying No Of Records

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.

View Replies View Related

Not Displaying Imported Records

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?

View Replies View Related

Displaying Records By Date From To

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??

View Replies View Related

Records Stopped Displaying?

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 Related

Displaying Matching Records

I 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:

View Replies View Related

Displaying 2 Random Records For DB

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 Related

Displaying Records From Table

Say 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 Related

Displaying All Records In My Database

I 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 Related

Displaying Records In A Grid

I 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 Related

Advice On Displaying Records

I'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:

View Replies View Related

Displaying Records From A Database

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 Related

Displaying Records Based On Timestamp

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.

View Replies View Related

Loop For Displaying Multiple Records From An SQL Query?

I 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:

View Replies View Related

Recordset.RecordCount Keeps Displaying "-1" Instead Of All Of The Records

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 Replies View Related

Run An Exe From Asp And Get Returned Values

How is it possible to execute an exe from asp and get a returned string (no http headers in exe) ?

To run exe I use :
<%
cmdExe = sPath & "cgi-bin
equest.exe"
Set WshShell = Server.CreateObject("WScript.Shell")
sResult = WshShell.Run(cmdExe, 1, True)
Set WshShell = Nothing

Response.write sResult
%>

sResult always content "0" and not the string returned by exe file (something like "!!-1!blabla!blablablabla!")

- How is it possible to get the exe returned value ?
- Is there a solution with asp.net ?

View Replies View Related

How Many Rows Returned?

When I do a query that I know has 2 rows, I get rs.recordcount equals -1. Same thing when it's just one row. I need something that gives me the number of rows.

View Replies View Related

Error Returned

I am trying to update a record but it returns this error :

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near the keyword 'Function'.
/performaindia/security/functionssys.asp, line 210


Now at line 210, I have this function :
rs.Update.

View Replies View Related

Error Is Returned

I am getting this error on selecting an option :

Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert the value NULL into column 'SystemUserOnly', table 'performaindia.dbo.SecurityTableFields'; column does not allow nulls. INSERT fails.

/performaindia/security/tablefields.asp, line 220

now the line 220 is an update statement :
rs.Update

View Replies View Related

Returned Values

I have a bit of a situation here, I own a job board and have multi-posting comapnies posting jobs to our database and we have returned values going back to them to tell them if the job vacancy was posted succesfully or not.

The problem I have is that our main ASP guru is of sick and the other is off away on business. I have pretty good knowledge of ASP but not as much as these guys. So I need to know how to send a response back to the posting company whether it has been succesfull in posting the job vacancy instead of sending back a page back displaying whether it was successful.

View Replies View Related

Pagesize Not Returned

I define a recordset with a pagesize of 100 in my COM object and return this recordset to ASP. When I check my pagesize at the ASP level,it is 10 I assume this is the default.

I can set my pagesize at the ASP level after the COM function is called, but I would prefer to have this encapsulated within the COM.

View Replies View Related

Text Returned From Sql Db

I am not sure what way to do this, i want a specific row returned and displayed in asp but not in a text box, in acess and vb i ahve done this and its just a label but not sure in asp.

View Replies View Related

Determine If More Than One Row Returned

I have an ASP/ADO application querying an SQL Server DB. I want know the most efficient way to determine if more than one row is returned from a query. If more than one row is returned, the user will be presented with a choice of which row to process. If only one row is returned, I want to skip this stage, and process that single row immediately.

I can think of a number of ways of acheiving this (eg. .recordcount) but I'm looking for the slickest and most efficient method.

View Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved