Now if we could get our data to save, that would be great. We will be using the same database that we used in the last chapter. We can see the appendix if we need to set up this database for practice. Let us look at the two ways in which a record is saved in ColdFusion. The first is how we would save a new record. This is called an
<cfquery datasource="cfb"name="qryInsert"> INSERT INTO product( name , description , price)VALUES( <cfqueryparam value="#form.name#"> , <cfqueryparam value="#form.description#"> , <cfqueryparam value="#form.price#">) </cfquery>
Here, we see the basic code structure of an insert query. We can see that the one thing different from the standard queries here in the values section. We have ...