By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,751 Members | 1,158 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,751 IT Pros & Developers. It's quick & easy.

merging portions

P: 22
not sure if this is even possible. but i will ask any way

if you have a submit form with field FirstName and field Lastname,
can you update the table fields FirstName and LastName and at the same time update another field that takes the first 5 characters from LastName and concatenate it to the first 2 characters of the FirstName - and have that entered into a field name Login.

for example:
Jonathan Brinkles
would get updated into 3 fields
LastName=Brinkles
FirstName=Jonathan
Login=BrinkJo
Feb 27 '08 #1
Share this Question
Share on Google+
1 Reply


ronverdonk
Expert 2.5K+
P: 4,258
If you want to display that abbreviated userid while having typed the lastname and firstname and not doing a submit: yes you can. But you must use someting that triggers that db update process. So you'll have to use an Ajax setup for that. Process is like:

1. enter lastname en lastname
2. hit some button
3. trigger JS function
4. JS function goes to server db program
5. server constructs login name
5. db updated with lastname, firstname and login name
6. login name sent back to client
7. client displays login name on screen

Something like that roughtly.

Ronald
Feb 27 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.