Preparing an ORM mapping for inserting data


show more Preparing an ORM mapping for inserting data provides you with in-depth training on Developer. Taught by David Gassner as part of the ColdFusion 9 Essential Training show less
please wait ...

Preparing an ORM mapping for inserting data

Once you've created a data entry form that allows the user to submit values for a database record, you can then insert the data using a very simple bit of code that depends on the Object Relational Mapping features that are new to ColdFusion 9. I am going to start in this demonstration by examining the structure of my photographer table into which I am going to insert data. It has four columns: the FIRSTNAME and LASTNAME column, which are both variable character columns, the FEATURED column, an integer, which I am going to put either a value of zero or one into, and the PHOTOGRAPHERID, a primary key.

In Apache Derby and in a number of other databases such as MySQL and SQL Server, you can set up database table structures that auto-increment their values. That is to say, when you add a new record into a database table, the database assigns the next available value to the primary key, so you don't have to worry about it. You can leverage this functionality using Object Relational M...

Preparing an ORM mapping for inserting data
Video duration: 3m 47s 7h 21m Beginner

Viewers:

Preparing an ORM mapping for inserting data provides you with in-depth training on Developer. Taught by David Gassner as part of the ColdFusion 9 Essential Training

Subjects:
Developer Web
Software:
ColdFusion
Author:
please wait ...