|
|
|
|
|
Total Hits: 202 | Today: 0 |
Author: William Toledo
|
Rating:
|
|
|
This is a small data entry form in Windows XP style for the browser (IE). Addressess basic data base functionality such as INSERT, DELETE and UPDATE, as well navigation thru the record set....
|
|
|
|
Total Hits: 291 | Today: 0 |
Author: Rama Ramachandran
|
Rating:
|
|
|
The previous two 10-Minute Solutions covered a couple of different techniques to present a recordset of data in the form of logical pages so that the user could navigate from page to page. Instead of continuing with the third article in the series that deals with using the Remote Data Services, let's take a break and see how you can optimize and enhance the paged recordset techniques you have learned so far. Specifically, you will see how you can improve the data access performance to load your ...
|
|
|
|
Total Hits: 619 | Today: 0 |
Author: David Morgan
|
Rating:
|
|
|
This function provides you with ability to input the max number of character’s of a records from a database before truncation. And the ability to input the text you would like to be placed after the truncated text....
|
|
|
|
Total Hits: 493 | Today: 0 |
|
Rating:
|
|
|
By checking for both Beginning Of File (BOF) and End Of File (EOF) then you can be certain that there are no records....
|
|
|
|
Total Hits: 497 | Today: 0 |
Author: Gabriel Garcia
|
Rating:
|
|
|
The purpose of this code is to read a text file and put it into a record set. The code does not depend on DNS and programmer has full control of record set properties....
|
|
|
|
Total Hits: 3247 | Today: 1 |
Author: Faisal Khan
|
Rating:
|
|
|
In depth article on showing records in a page by page fashion with 'first page', 'next','back' and 'last page' links at the bottom to navigate through the records. Sample code and database available for download. Online demo also available....
|
|
|
|
Total Hits: 1589 | Today: 0 |
Author: Nannette Thacker
|
Rating:
|
|
|
Don't hard code your data connections every time you need them! Use these functions to open and close a Database Connection and Record Set....
|
|
|
|
Total Hits: 487 | Today: 0 |
Author: Ryan S.
|
Rating:
|
|
|
an article that discusses what custom recordsets are, and how you can use them to track the number of visitors on your site at a given point in time....
|
|
|
|
Total Hits: 1107 | Today: 0 |
|
Rating:
|
|
|
This article discusses the performance differences between ADO’s various types of cursors and locktypes and shows you the importance of using the correct cursor and locktype....
|
|
|
|
Total Hits: 730 | Today: 0 |
Author: Evagoras Charalambous
|
Rating:
|
|
|
I showed how to create a class which returns your recordset as an array using the GetRows function. In this article, I will expand on the class, adding two more functions......
|
|
|
|
Total Hits: 2418 | Today: 0 |
Author: Antonin Foller
|
Rating:
|
|
|
You can use GetString method of recordset object to convert recordset (SQL query) to csv file......
|
|
|
|
Total Hits: 1197 | Today: 0 |
|
Rating:
|
|
|
This FAQ describes the process of displaying data on a Web page through arrays instead of the traditional Recordset method. The way we've all likely used to display arrays involves opening a Recordset object and then using a Do While Not objRS.EOF ... Loop......
|
|
|
|
Total Hits: 301 | Today: 0 |
|
Rating:
|
|
|
Recordcount is not supported with the default forward-only cursor. If you open a recordset in the following manner, you will have access to recordcount...
|
|
|
|
Total Hits: 271 | Today: 0 |
Author: Nathan Arendt
|
Rating:
|
|
|
Return a random ADO recordset using VB Script. While working on a web based competency-testing application I needed a way to return not just ONE random record but a group of random records. I searched the net high and low for a couple of months trying to find something that would allow me do this. I eventually hunkered down and came up with my own way of doing this....
|
|
|
|
Total Hits: 3480 | Today: 0 |
Author: Serkan Polat
|
Rating:
|
|
|
you have an xml document and maybe want to convert it to a recordset, but how? this article shows how you can do it....
|
|
|
|
Total Hits: 449 | Today: 0 |
Author: Robert Chartier
|
Rating:
|
|
|
With ADO, we can typically use the oRS.CLONE method of the Recordset in order to clone the Recordset and perform some new actions on the cloned object. In some cases this is just not enough. In allot of cases we will not be able to update this new recordset because the underlying data source will either not support the update or it has not been properly disconnected. Thus I have managed to use the new MDAC 2.5's stream object to copy an entire recordset and make it updateable....
|
|
|
|
Total Hits: 2221 | Today: 0 |
Author: Robert Chartier
|
Rating:
|
|
|
This is a very simple introduction to the .SAVE and .OPEN Methods of the Recordset object of ADO. These are two functions that will convert an ADO Recordset object into an XML document, and SAVE it to the File System and convert that same XML document and OPEN it back into a Recordset Object....
|
|
|
|
Total Hits: 391 | Today: 0 |
Author: Shmarya
|
Rating:
|
|
|
This code demonstrates how to generate a table with alternating rowcolours from any ADO Recordset....
|
|
|
|
Total Hits: 1106 | Today: 0 |
Author: John Pragnell
|
Rating:
|
|
|
Shows how to get recordset data into a VB (or other) application from remote databases on the web, edit it, and put back the changes - all from simple ASP pages on the server via HTTP using ADO + XML - 1 line of code in VB to retrieve, 3 to return (+ not more than 25 lines of ASP on the server) for the simplest case....
|
|
|
|
Total Hits: 346 | Today: 0 |
Author: Phillip Quinn
|
Rating:
|
|
|
I find navigating XML using the XMLDOM object to be hell. Some people seem to get the hang of it, but I don't. However, I find navigating a RecordSet to be much easier. This article will detail how to import an XML file into a RecordSet and to navigate it....
|
|
|
|
|
|
|
