I have the following code in a Coldfusion insert transaction. My goal is to combine the “number” and “street” fields to create the “address” value.
ins_c_homes.setTable(“c_homes”);
ins_c_homes.addColumn(“number”, “STRING_TYPE”, “POST”, “number”);
ins_c_homes.addColumn(“street”, “STRING_TYPE”, “POST”, “street”);
ins_c_homes.addColumn(“address”, “STRING_TYPE”, “POST”, “address”);
If I do the following:
ins_c_homes.addColumn(“address”, “STRING_TYPE”, “POST”, “number”);
The house number appears in the address field as desired. Same thing for “street”. I have been unable to figure out a way to combine them.
How do I code this so that both “number” and “street” are posted to the address field with a space in between number and street. (i.e. “1002 Ceder Street”)
Another option is to add a default value using the values from the form. I have tried everything I can think of to no avail. I am sure there probably is a simple answer.