jCay.org

last scripts

popular scripts

top rated

search
 
search:

Advertisment

Database-related

DeEnFrSp
Amount: 137
Displaying: 1 - 10
Pages: [1] 2 3 4 5 6 7 8 9 10 11 12 13 14 >>
Sort Listings By:
Hits: 2033

Make database access safer with transactions

Rating 5.0 5.0
You can use transactions in ASP as a kind of insurance policy for your database activities, making them safer and providing better error recovery. Transactions are most useful when doing multiple actions on multiple tables. The example below shows just how easy it is to use transactions from ASP, inserting a record into a table and doing a "rollback" if there's a problem.
Platform(s): Windows Date: Jan, 08 2007
DETAIL
Hits: 1016

ASP Speed Tricks

Rating 5.0 5.0
This article describes practical methods of optimizing the performance of ASP pages which retrieve and display tabular data from a database. Test results of each coding technique show the potential for dramatic speedups of dynamic web pages.
Platform(s): Windows Date: Oct, 20 2006
DETAIL
Hits: 984

Faster Singleton Queries with ADO

Rating 0.0 0.0
It is very common operation to request one field of information via a database query. 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.
Platform(s): Windows Date: Oct, 20 2006
DETAIL
Hits: 1678

How to connect to database using a connection string

Rating 4.0 4.0
The power of Active Server Pages comes through when we tie databases to our web sites. To connect to a database, ASP uses what is called ActiveX Data Objects, or ADO for short. ADO comes with ASP, and can be used easily from your ASP pages. In this tutorial we will show you how to connect to Access database and retrieve all the records from the table.
Platform(s): Windows Date: Sep, 25 2006
DETAIL
Hits: 795

Encrypt Passwords Before Storing In a Database

Rating 5.0 5.0
This code demonstrates how to use an MD5 hash to encrypt user passwords when storing them in a database. There are constantly news items about companies where user information is compromised. By storing passwords using an MD5 hash, even if your database is compromised the passwords cannot be decoded. The only downside is that users cannot retrieve lost passwords, they must reset them.
Platform(s): Windows Date: Sep, 18 2006
DETAIL
Hits: 1506

How to Encrypt Passwords in the Database

Rating 3.5 3.5
If you are developing a password-protected web site, you have to make a decision about how to store user password information securely. This article will show you how to encrypt user passwords with md5 algorithm and how to start using encrypted passwords if you already have users' database ready.
Platform(s): Windows Date: Sep, 07 2006
DETAIL
Hits: 2618

Counting Records in SQL Script

Rating 3.5 3.5
Sometimes we worry about limits of database table and we need to know how manay recods we have. In ASP we could count all recods using a loop. But if we have a small piece of knowledge about SQL script, our script works better and faster.
Platform(s): Date: Sep, 06 2006
DETAIL
Hits: 863

ASP Tutorials - Connecting and Using MS Access Databases

Rating 4.0 4.0
This tutorial helps you to understand: Connecting ASP Pages to MS Access Databases Persisting Data to MS Access Databases Protecting Data in SQL Statements
Platform(s): Windows Date: Sep, 06 2006
DETAIL
Hits: 771

An Useful Method : RecordSet.Filter

Rating 4.0 4.0
Filter method is very useful working with large datasets. You might need to put only some records from your database but you should select all data from database. Fileter method is advantage working on recordsets after querying on SQL command.
Platform(s): Windows Date: Aug, 09 2006
DETAIL
Hits: 1233

Dynamically Dependent Dropdown

Rating 3.0 3.0
Learn how to create dynamically dependent dropdown lists with. There's an online demo and source code provided.
Platform(s): Windows Date: Jul, 21 2006
DETAIL
Amount: 137
Displaying: 1 - 10
Pages: [1] 2 3 4 5 6 7 8 9 10 11 12 13 14 >>