close ad
Install the LAtest Updates to Work with CC 2017 and CC 2018
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Creating Registration Page

Thread began 10/27/2013 3:17 pm by balexander389215 | Last modified 11/14/2013 11:31 am by balexander389215 | 1961 views | 19 replies |

balexander389215

Creating Registration Page

I used SA Wizard to create the login/registration pages. My problem is that the information I want to include in my Registration page is contained in two tables in the DB. I was unable to figure out how to pull the information from two pages. Is there a way to make this happen or perhaps a way to edit the page to add these fields after the fact?

Sign in to reply to this post

Jason ByrnesWebAssist

please provide more details on the table structure of each table and the use case for the second table.

Sign in to reply to this post

balexander389215

I'm trying to set up login and registration pages with a 'my account' section, very much like what you have on your site. I have an eCommerce db which divides the registration and address tables into two, but for the pages I want to createI need information from both tables. The registration pages I'm creating are not for the store but another part of the site, however I want to use these tables to avoid having a dual login.

Attached Files
xcart_address_book.sql
xcart_customers.sql
Sign in to reply to this post

Jason ByrnesWebAssist

so in the address book table, it looks like you have the userid to be used as the foreign key to create the relation to the customers table


your registration page needs to have 2 data assist insert record behavior. The foist one will store data to the customers table and save the id to a session variable.

the second one will store data to the address book table. For the userid column use the session that is created by the first insert behavior

Sign in to reply to this post

balexander389215

Yes but how do I do it, that's the question. The one tutorial I can find only shows how to use the wizard to create the initial pages. Is there another tutorial hidden somewhere on how to add additional record sets?

Sign in to reply to this post

Jason ByrnesWebAssist

there is no tutorial for this, it is not a normal use case.

To do this, you need to create the functionality manually using Dreamweaver and the Server Behaviors of Security Assist And Data Assist.

Create the form with the needed form elements.

add the insert record behavior to save data to the customers table (on the server behaviors panel click the plus button and select WebAssist -> Data Assist -> Insert -> Insert Single record) , in the first screen make note of the session name that the ID will be stored to.

On the bindings tab, select each column, click the lightning bolt for value and select the corresponding form element.

Add the second insert behavior to save data to the address book table.

on the bindings tab, select each column, click the lightning bolt for value and select the corresponding form element.

For the user ID column use the session that is created in the first insert behavior.

Sign in to reply to this post

balexander389215

Thank you for your help Jason. Okay I followed your instructions and got to the insert single record screen. The first thing to set is Trigger. I have no idea what is supposed to go here but clicking on the lightning bolt I have several options. I went to the record set dropdown and chose address as it was the address I wanted to insert. (However I'm sure that's wrong. It doesn't look at all like the Trigger inserted by the wizard.)

Then there's the session name you told me to take note of. That was blank. The wizard uses a session id name of SecurityAssist_id so I used that name. Is there any special name that is supposed to go in here?

On the bindings screen I simply went to the bolt and clicked again on address.

Okaying this added the new record set into the head of the page but nothing into the body. How do I get the field into the body? Is this something I have to do manually? Are there instructions to create this and link it to the record set?

Finally how do I get rid of the security question component on the registration page. I just want the captcha but saw no point where I could configure this in the wizard.

Thanks

Sign in to reply to this post

Jason ByrnesWebAssist

see pm

Sign in to reply to this post

balexander389215

See pm

Sign in to reply to this post

Jason ByrnesWebAssist

See PM

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...