|
|
|
|
|
Total Hits: 4945 | Today: 0 |
|
Rating:
|
|
|
Hated that -1 that kept coming up instead of showing how many records were returned. You need to Set your recordset (first line) and THEN Open it (second line) with your connection (we used cnDZ) and use the adOpenStatic cursor. Confused, check the code....
|
|
|
|
Total Hits: 3053 | Today: 0 |
Author: Phil Paxton
|
Rating:
|
|
|
Phil Paxton has compiled a list of ten commandments all ASP developers should religiously follow.Thou shalt use neither a "counting" loop nor .MoveLast to count the number of records in an ADO recordset. (either set the .CursorType correctly or use a Count() in SQL). In this article, Phil explains why that commandment is so, and the disadvantages present to using .MoveLast or a counting variable....
|
|
|
|
Total Hits: 199 | Today: 0 |
Author: Abdul (Rajib) Bahar
|
Rating:
|
|
|
Try and Catch is very popular among the developer community writing code in C#, C++, or other high level languages. The conventional term referring to Try-Catch blocks is Exception Handling. Exception Handling is simply a breach of an application's predefined assumptions. It enables us to provide a reliable data/process validation mechanism in our applications. SQL Server did not have any close counterpart for it until now. Prior to SQL Server 2005, many of us relied on the variable @@ERROR. If ...
|
|
|
|
Total Hits: 230 | Today: 0 |
Author: Emadullah Gawai
|
Rating:
|
|
|
In this article, you will learn how to count the page hit if there is no file accessing support available. Most of the free servers does not permit file accessing, if you are one of the free users, this article will be great helpful to you....
|
|
|
|
Total Hits: 559 | Today: 0 |
Author: Daniel Morritt
|
Rating:
|
|
|
For simple applications using text files you can count database items using SELECT COUNT in a simple comma delimited txt file database...
|
|
|
|
Total Hits: 1948 | Today: 0 |
Author: Gary Williams
|
Rating:
|
|
|
Are you tired of always getting "-1" returned when you ask your Recordset how many records it contains? ASP 101 thought you might be, and has written an article that describes a workaround....
|
|
|
|
Total Hits: 984 | Today: 0 |
Author: markprijs.nl
|
Rating:
|
|
|
When I added a webtools directory to my website, I wanted to show my visitors the 8 webtools that were last added. I thought it would be an easy thing to do, but it took me quiet some time to find out how....
|
|
|
|
Total Hits: 2130 | Today: 0 |
|
Rating:
|
|
|
I have seen many requests in forums and messageboards for counting records and displaying the total. Well, this little wizard will help you accomplish this task. Fill in the form below and it will crank out the code for you....
|
|
|
|
Total Hits: 2131 | Today: 0 |
Author: Daniel Morritt
|
Rating:
|
|
|
Most people set the right options when opening a RecordSet just so they can use the .RecordCount property to get the number of records in a RecordSet, why? Beats me, when the server can just tell you this information....
|
|
|
|
Total Hits: 2425 | Today: 0 |
Author: Juan Llibre,Charles Carroll
|
Rating:
|
|
|
This script counts the records in a database. Many people who attempt to use the .recordcount property have the value -1 returned to them. In a nutshell, -1 means "I don't know how many records this query/table contains". It happens since the default cursor type is AdOpenforwardonly (see below for explanation of all cursor types). Here is the script that counts the query results and WILL NOT return -1:...
|
|
|
|
Total Hits: 2368 | Today: 0 |
|
Rating:
|
|
|
Are you tired of always getting "-1" returned when you ask your Recordset how many records it contains? ASP 101 thought you might be, and has written an article that describes a workaround....
|
|
|
|
|
|
|
