2570Using Multiple Recordsetshttp://www.4guysfromrolla.com/webtech/083101-1.shtmlMultiple Recordsets - the ability to stuff multiple SQL query results into one Recordset - is an ADO feature that's few developers are aware of. In this article, we are going to take a look on what a Mutliple Recordset is, exactly, and how it can make your development life easier (and your code more efficient). But before we start examining Multiple Recordsets, let's look at a common task in ASP and how it is handled without using Multiple Recordsets.ASP > Tips and Tutorials > Database-relatedOct 10, 2006
Databases are a way of organizing and keeping your data. The data stored in databases can be anything from user email addresses to binary files. Databases have become so popular in the past decade that it is almost unimaginable to not to use them on the web.
In this article we will learn on how to use database transactions in ASP. This will allow us to execute all database queries or none at all. How many times have you wanted to insert, update a lot of records collectively wanting that either all of them get executed or if there is an error then none is executed at all ? Well, if you haven't this need yet, you will have it in near future.
This page demonstrates the capabilities how to display a table from a SQL statement. It illustrates not only how to display the table, but also how to detect that no records were returned from a query, and how to detect null and blank values in the data.
ASP is a pseudo-programming language aimed at HTML development. It allows web pages to do more than contain just static content. By placing ASP tags in with your HTML tags, you can have a page that interacts with the user. The page can make decisions based on logic and user input. If you're familiar with HTML, then you know that an HTML tag uses <> around it's tags. For example this text will be bold would make this text will be bold. ASP is similar in that it uses delimiter tags like HTML. However, the tags differ slightly. An ASP delimiter tag starts with <% and ends with %>.
Joining mailing list will entitle you
to receive occasional emails informing you of news and
updates to the site and any special offers that may be
of interest to you.