2. ASPRunnerPro General questions
  3. update fullname with first + last
This topic is locked

update fullname with first + last

 		5/2/2008 9:56:08 AM
ASPRunnerPro General questions
T
 Tim author

Hello,
I have a table with the fields: firstname, lastname, and fullname. On the Add form I have text boxes for the first and last name and I'd like to create the fullname from that. I thought it would be as easy as:
dict("fullname") = dict("firstname") + " " + dict("lastname")
but that doesn't seem to work. No error, just no data in the fullname field. What am I missing?
thanks,

Tim
Sergey Kornilov admin 5/2/2008

Correct syntax is:

dict("fullname") = dict("firstname") & " " & dict("lastname")


Also make sure that Fullname field appears on the Add page (Choose fields screen in ASPRunnerPro). In other case it won't be updated.
T
 		Tim author 5/2/2008

Ah yes, of course. Thank you.
I have to add the fullname field to the form? Is there a way to make it hidden then? I hate to confuse the user with this. Or do I just delete it in the visual editor?
Thanks
Sergey Kornilov admin 5/2/2008

Add it via "Choose pages" screen and then delete in Visual Editor.