Writing Data into a Database

The easiest method of entering data is to open the table, put your cursor into the proper cell, and just start typing. This is a great method if all your data consists of only a word or two, but if you need to enter long sentences or lists you're going to be doing a lot of horizontal scrolling to see your text. Horizontal scrolling is a royal pain in the butt, so there must be a better way.

There are four primary methods for getting data into a database. The first, typing information directly into the cells, is the most basic, but let's look at some others.

The Input Form

The input form is a handy feature offered by most modern database packages. Input forms let you view your database one record at a time. After you ...

Get Sams Teach Yourself ColdFusion® in 21 Days now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.