NEW LISTINGS 
HOT LISTINGS
TOP RATED
EDITOR PICK
ADD A LISTING
UPDATE A LISTING
GET RATED
UPGRADE A LISTING
HOT LISTINGS
TOP RATED
EDITOR PICK
ADD A LISTING
UPDATE A LISTING
GET RATED
UPGRADE A LISTING
Executing All or None queries : ASP Transactions
2613
Executing All or None queries : ASP Transactions
http://www.stardeveloper.com/asp_trans_1.asp
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.
ASP > Tips and Tutorials > Database-related
Oct 10, 2006
Write a Review
Add to My Favorite
Refer it to Friend
Report Broken Link
| |
|
||
| Bookmark Executing All or None queries : ASP Transactions: |
|||
Other links at ASP > Tips and Tutorials > Database-related
You can upload your images to MS-SQL server with this simple script. To upload a picture to sql database, be sure Persist AspUpoad installed in you server.
Run create_image_table.sql on your sql server. This database holds some information about your image : size of image, width and height of image.
Run create_image_table.sql on your sql server. This database holds some information about your image : size of image, width and height of image.
Category:
This is called a singleton query. ADO.Net has specific functions for singleton queries, but not ADO (ActiveX Data Objects). This article describes how to use an ADO command object to perform faster singleton queries.
Category:
No matter what kind of site you have got, you will need your ASP pages to access databases. ASP makes it easier to work with databases by providing support for ADO ( Activex Data Objects ). You already know how to build DSN ( Data Source Name ) and then access database, if you don't then you might want to check out my tutorial on Accessing Databases via ASP.
Category:
Dropdown lists in HTML are very useful for multiple-option choices, especially within a web form that user needs to fill out.
Producing them dynamically from a database can saves a lot of time and energy.
In this example, we will use ASP 3.0 to generate dynamic dropdown lists from a Microsoft Access database. The database table in question contains fruit and vegetable types.
Producing them dynamically from a database can saves a lot of time and energy.
In this example, we will use ASP 3.0 to generate dynamic dropdown lists from a Microsoft Access database. The database table in question contains fruit and vegetable types.
Category:
This article covers two advanced ADO topics: creating hierarchical Recordsets (via data shaping) and creating custom Recordsets. Specifically, this article looks at how to create custom hierarchical Recordsets. Therefore, it is essential that the reader have a fluid understanding of both data shaping and custom Recordsets, topics that this article doesn't aim at teaching. To learn about these topics, be sure to read the following articles
Category:
Main Category
199
2044
829
286
175
1801
1439
913
1177
7568
70
917
59
2238
175
Join Mailing List
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.
Top 10
Directory Statistics
Links: 19871
Categories: 1275
Registered Users: 766
Mailing List Subscribers: 2047
Unique Outgoing Hits: 231095
Pagerank Statistics
PHP News