close ad
WARNING: Do Not Install the DREAMWEAVER CC 2017 Update »
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

registration and insert data same time

Thread began 2/15/2011 2:33 am by un33k9309513 | Last modified 2/22/2011 1:01 pm by Jason Byrnes | 2179 views | 17 replies |

un33k9309513

registration and insert data same time

Hi,

What is the best procedure to do a full registration form and have all data go into 3 different tables while still having security assist create the forgot password and all the pages it does. I need the full registration of adding/managing users like on powerstore.

table 1 - users
table 2 - parent info
table 3 - detail info

I am using:
security assist
dataassist
digitial file pro

I looked at the security assist pdf but that didn't show me how. It did say look at Using SecurityAssist with DataAssist but I couldn't find that one.

If there is an easier or better way of doing it? Should I be using DA insert multiple? Should I use DA first 3 times to insert the data in all 3 tables, then SA?

Would it be wiser and simpler to create a simple registration page and then create a full registration page after that? (ie: run DA first with multiple insert, then SA for creating user/pass)

Thanks,
Ed

Sign in to reply to this post

Jason ByrnesWebAssist

For this you will need to edit the registration page that is created by security assist.


you will need to delete the Dreamweaver Insert Record behavior that is applied, and replace it with the DataAssist insert record behaivior. This is covered in the Solution recipe on the security assist support page in the Modifying registration video:
securityassist/

(Note: This video uses encryption for the password field, you dont have to follow that part if you dont wish to encrypt the password).

Make sure that the insert record beahavior does not have a redirect set, and make note of the Session name that will be created in the store as section, this session will contain the id of the record that is inserted to be used in the foreign key column of the other tables.


Now you will need add the additional form elements to collect the data that will be store in the other tables.

After these elements are added, add another Data Assist Insert record behavior for the parent info table, bind the parent info columns to the parent info form elements, then add a third insert record behavior for the detail info table, binding the detail info columns to the detail info form elements. In both of these insert record behaviors, bind the foreign key columns that relate the info to the user to the session created by the user insert record behavior.


In the last insert record behavior, you can set the redirect to go to the login page.

Sign in to reply to this post

un33k9309513

I want to make sure I go forward correctly so
I've done everything and I'm on this step:
After these elements are added, add another Data Assist Insert record...

1. Just to clarify, do I use the DA insert single record for each of the 2 tables (not the multi)?

2. For the store as: do I put the same one that was created earlier you said make a note of for each DA insert record?

3. Each of my 3 tables has a Uid field which I made so they are all the same in addition to their own specific Id fields for each table.

How do I do the following you stated:
In both of these insert record behaviors, bind the foreign key columns that relate the info to the user to the session created by the user insert record behavior.

Is this the right way - in step 2 of DA insert record: do I click on Uid > value lightning > session > pick the session made earlier ?

Do I do this same step for the 3rd table too?

Thanks

Sign in to reply to this post

Jason ByrnesWebAssist

1) Yes, use the single record insert

2) No, for the store as, the names should not be the same.


3)

  Is this the right way - in step 2 of DA insert record: do I click on Uid > value lightning > session > pick the session made earlier ?  



yes, that is the correct way.


yes, use the same step for the 3rd table too.

Sign in to reply to this post

un33k9309513

thanks for your quick response,

my third table is actually a kid table and I need my form to be dynamic so if one parent has 1 kid or how ever many, I need to be able to add more kids accordingly to that same registration form and simple enough so I can make it.

It would be nice to have another set of text fields generate when a plus sign or something is pressed. Do you have a suggestion how to get this put into the same form?

Sign in to reply to this post

Jason ByrnesWebAssist

There is no built in support for dynamic forms like this in Data Assist, it would require creating the code by hand to accomplish.

Sign in to reply to this post

un33k9309513

Ok thanks for the help

could I just create it with 1 kid on the registration page and then use a insert record on another page to insert another kid?
How can DA make sure it's going to the same parent? or Uid

Sign in to reply to this post

Jason ByrnesWebAssist

Yes, you could insert aditional kids using a second form.


you would need to pass the Uid of the parent record to the second form, probably as a query string variable to the second page, make sure the forms action passes the queruystring variable as well and use that in the insert record behavior to assign the correct Uid in the inserted record

Sign in to reply to this post

un33k9309513

Ok I thought of another way maybe,

I am following the solution recipe for DA
Inserting multiple records (Interactive Tutorial)

Because I am going to make room for adding 4 kids on the registration form and hope there is no more, and then specify DA multiple insert to skip if empty -there is no data in any form fields of the repeat region (ie only 2 kids present). But in skip if empty I can only pick on table field, not the entire row of fields, does this mean that if one of the fields is empty it will skip all of the row?

So I have created the repeat region just for the 4 kids below all that other registration info and I am at this point:

So far I have
-all my form fields
-1 DA insert single record for table 1 users

Since I am taking a slightly different approach, what should I do next?
Should I make
-1 DA insert single record for table 2 parents
-1 DA insert multiple record for table 3 kid and redirect to go to login page


thanks

Sign in to reply to this post

Jason ByrnesWebAssist

  Since I am taking a slightly different approach, what should I do next?
Should I make
-1 DA insert single record for table 2 parents
-1 DA insert multiple record for table 3 kid and redirect to go to login page  




yes, that is correct.

Sign in to reply to this post
loading

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...