close ad
 
Important WebAssist Announcement
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

Structure for inserting data through a validated 2 field login

Thread began 2/28/2010 8:46 am by roger391472 | Last modified 3/03/2010 4:07 pm by roger391472 | 1656 views | 6 replies

Eric Mittman

This is how I see things, you have this page for users to register for the sweepstakes. To register they must already be registered in your sweeps_registration table. When they fill in the form you will have a recordset for the user that is filtered on the entered email address. It would be a good idea to also filter this on the password entered to ensure that it is that user who is signing up for the sweepstakes.

I think you could do this in the following order.

Have the form post to itself (done)

Have a recordset toward the top of the page that is filtered on the user's email address and password. These are the form fields for the username and password.

Next is the validation, you will need to validate the total rows from this recordset to ensure that there was a match. (done)

Finally after all of this you can have the insert to insert the user into the sweeps_entries_tracking table. For this insert you will be inserting the same user information that you already have in your sweeps_registration table. Since you have the rs that is filtering this table based on the email and password you can use the bindings from this rs directly in the insert.

That is all that you need to accomplish this, in the end you will have a form that a registered user can get to and enter their email address and password. The information will be posted back to this page and filter a recordset. It is this recordset that will be used for the validation to ensure that the user is registered. You will also use this same recordset in your insert server behavior.

You should start this by editing your existing rs to be filtered on at least the form field for the email, and the password as well if that is an option. Once you have got that part worked out the validations should already be working and you can move onto the insert. Please post back with any questions that you have and we can help you get things worked out.

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