close ad
Databridge V2 with MySQLi support IS Now Available!
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

Membership registration with existing membership database

Thread began 4/06/2011 12:04 pm by Dennis | Last modified 5/12/2011 4:36 pm by Dennis | 2131 views | 11 replies

Jason ByrnesWebAssist

you will need to make sure that all of the existing records have an email address.

you should also create a new column for Registerred, set the default value to 0, this will be used to make sure they dont come back and overwrite the registration with a new one.

next, create a recordset to filter the email address column on the email address form element, then set the recordset to advanced view, in the bottom section expand the tdatabase and the users table, select the registered column and click the where button to add it to the where clause, find it in the where clause;
AND Registered

and add " = 0":

ANDRegistered = 0

this will look up the email address and be used to make sure they have not filled in the registration already.

Now add server validation from Form Toolkit to the page:
?lid=webforms

Select number validation. For the server variable, enter:
$totalRows_<RecordsetName>

where <RecordsetName> is the name of the recordset you created.

set the minimum number to 1 and the max number to 100

This will allow the form to submit only if the record set returns a value.


Next you will need to replace the Insert behavior on the registration page with an Data Assist Update behavior to update the registration record, make sure to update the Registered column to 1.

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