Create a new data field out of three other data fields

[gambhir]

I have a form that has several inputs.

How can I user a combination of those inputs(concatenate 3 of those) to create a new field in my database.

Can I do this on my processing page where I insert data into the datbase?

So for e.g. three inputs might be LastName, DriverType, Age
The new field will be JonesCourier53

Thanks for any suggestions.

 

[Klotzki]

I'm not quite sure what you mean by 'create a new field'. Does this new field already exist in your database?

If so, then what you can do is to output the 3 form fields in the SQL statement like this.

<CFQUERY DATASOURCE=&quot;MyDSN&quot;>
INSERT INTO tblMyTable(MyField)
VALUES(&quot;#LastName##DriverType##Age#&quot;
</CFQUERY>

HTH,
Klotzki