2. ASPRunnerPro General questions
  3. After Registration update another table
This topic is locked

After Registration update another table

 		1/19/2010 11:04:07 AM
ASPRunnerPro General questions
T
 text author

Hi
I have two tables a member table and a member profile table. I only want each member to have one profile record therefore thought the best way to approach this would be to add the userid created in the member table on registration to a field in the member profile table. Then when the new member logs in there would be an empty member profile record that the member can edit.
I'm having trouble adding the userId to the member profile table.
Is this a before or after registration event ?
Thanks
Richard
T
 		text author 1/20/2010

Hi
Any ideas how I can achieve this. I have tried the following code before and after registration but with no luck
dal.memberprofile.Param("memberid")=Session("UserID")

dal.memberprofile.Add()
t



Hi
I have two tables a member table and a member profile table. I only want each member to have one profile record therefore thought the best way to approach this would be to add the userid created in the member table on registration to a field in the member profile table. Then when the new member logs in there would be an empty member profile record that the member can edit.
I'm having trouble adding the userId to the member profile table.
Is this a before or after registration event ?
Thanks
Richard
J
 		Jane 1/21/2010

Hi,
here is a sample:

dal.memberprofile.Value("memberid")=userdata("memberID")

dal.memberprofile.Add()
T
 		text author 1/21/2010

Thanks very much Jane. I must have something wrong with my tables relating to the integer format because it is only the id number that I am having a problem with, all of the other parameters pass easily enough.
regards
Richard



Hi,
here is a sample:

dal.memberprofile.Value("memberid")=userdata("memberID")

dal.memberprofile.Add()