Accessibility

ColdFusion Developer Center

Databases

Sam Neff

Learning stored procedure basics in ColdFusion 8


Find out why using stored procedures yields security and performance advantages in database interactions.

Getting Some Background: Databases 101

Introduction to Databases and SQL

A LiveDocs overview of many important database and SQL concepts.

launchLiveDocs: Introduction to Databases and SQL

Logged In: Databases and ColdFusion

Debbie Dickerson points out database resources and helpful hints for ColdFusion users.

Ben Forta: Databases and SQL

Learn about databases connections and SQL in these chapters from the Web Application Construction Kit.

Avoiding Conflicts Caused By Reserved Words

Use naming conventions to prevent reserved word issues in your code.

Reserved Words in ColdFusion SQL

Check out the list of reserved words to avoid using for column or table names.

launchLiveDocs: Reserved Words in ColdFusion SQL


Taking the First Steps

Displaying database data on a web page

Use ColdFusion to display custom data in your web pages.

Connecting to a Database

Master the basics of working with databases in ColdFusion and Dreamweaver.


Improving Performance

Ben Forta: Faster and Safer Queries

Tune up your ColdFusion database queries with the <cfqueryparam> tag.

Caching in ColdFusion

Boost app performance by caching queries and pages and by using the trusted cache feature in ColdFusion Administrator.

Caching ColdFusion Queries

Improve application performance by caching queries to disk or to memory.

Ben Forta on Advanced ColdFusion: Simplicity Is Just the Start of It

Ben Forta introduces resources for taking your ColdFusion application development skills to the next level.

Optimizing ColdFusion Queries

See how one developer sped up the performance of SQL queries in this case study.

Securing Database Access with the cfqueryparam Tag

Verify data with the cfqueryparam tag and protect your database from SQL injection hacks.


Advanced Lessons

A Beginner's Guide to Stored Procedures with ColdFusion

Find out which criteria to request from your database admin to query stored procedures in your company's database.

Learning stored procedure basics in ColdFusion 8


Find out why using stored procedures yields security and performance advantages in database interactions.

Storing Macromedia Captivate Test Scores in a Database with ColdFusion

Track users' test results in a database and export them to Excel spreadsheets with ColdFusion.

Building Advanced Queries in ColdFusion MX

Graduate beyond query basics. Learn how to query a query, nest, group, filter, cache queries, and display the complex results.

Understanding Design-Time and Run-Time Connections

Get the scoop on different ways to connect to your database when creating dynamic pages.

Controlling Database Transactions in ColdFusion MX

Encapsulate multiple database queries to ensure data integrity using the cftransaction tag.


Submit your feedback about the Developer Center.