update a field based on concatinating other fields

[Brian]

Is it possible to create/update a field in a record based on the concatination of 2 other editable fields in the same record. I don't want to display the concatinated field to the user.

[John]

Hi Brian,

One way to accomplish this would be to do the update "after the fact". You can simply add a dbSilentCmdText command into your ASP code and when the user has pressed the Add/Update button silently concatenate the fields you wish into a new string and add it to the record with a SQL "UPDATE" command.

We have an example of dbSilentCmdText at: http://208.196.181.86/apps/ example #58.

You'll need to see what the "last click" was. See example 13b for an example of this.

Thanks,
John


------------
Brian at 3/8/01 6:31:50 PM

Is it possible to create/update a field in a record based on the concatination of 2 other editable fields in the same record. I don't want to display the concatinated field to the user.