Samuel Neff (Oct. 15, 2007)
Find out why using stored procedures yields security and performance advantages
in database interactions.
A LiveDocs overview of many important database and SQL concepts.
LiveDocs: Introduction to Databases and SQL
Debbie Dickerson points out database resources and helpful hints for ColdFusion users.
Learn about databases connections and SQL in these chapters from the Web Application Construction Kit.
Use naming conventions to prevent reserved word issues in your code.
Check out the list of reserved words to avoid using for column or table names.
Use ColdFusion to display custom data in your web pages. (Updated July 30, 2007)
Master the basics of working with databases in ColdFusion and Dreamweaver. (Updated July 30, 2007)
Tune up your ColdFusion database queries with the <cfqueryparam> tag.
Boost app performance by caching queries and pages and by using the trusted cache feature in ColdFusion Administrator.
Improve application performance by caching queries to disk or to memory.
Ben Forta introduces resources for taking your ColdFusion application development skills to the next level.
See how one developer sped up the performance of SQL queries in this case study.
Verify data with the cfqueryparam tag and protect your database from SQL injection hacks.
Find out which criteria to request from your database admin to query stored procedures in your company's database.
Samuel Neff (Oct. 15, 2007)
Find out why using stored procedures yields security and performance advantages
in database interactions.
Track users' test results in a database and export them to Excel spreadsheets with ColdFusion.
Graduate beyond query basics. Learn how to query a query, nest, group, filter, cache queries, and display the complex results.
Get the scoop on different ways to connect to your database when creating dynamic pages.
Encapsulate multiple database queries to ensure data integrity using the cftransaction tag.
Submit your feedback about the Developer Center.