Re: One per customer
This WebDNA talk-list message is from 2000
It keeps the original formatting.
numero = 27605
interpreted = N
texte = >I need to set up a voting and quiz application. I need some way to >ensure that each visitor can only vote once. What is the best way to >do this in WebCatalog?If it is critical that each person votes only once, I would have each person enter his/her email address into form1, then append a new record to the db with that email address in it, but only if that email address is not already in the db. Also, put a unique number (use [cart] if possible) into another field in that record -- and send a message to the same email address which includes the same unique number in it.In the email message, ask the visitor come back to the website and enter the unique number *and* the same email address into form2. When form2 is posted, check the db to be sure there is only one record i there that matches both the emailAddress field and the uniqueNumber field, as well as making sure the quizDate field is blank in that record ...If the search finds exactly one record matching all 3 parameters, then give the person your voting form. When the person submits the form, replace the blank data in the QuizDate field with the current date. This will prevent him/her from voting again, because your search rejects records with blank values in the quizDate field.The only way someone could vote twice or more in this scenario would be if he/she has more than one email address ... :)================================ Kenneth Grome, WebDNA Consultant 808-737-6499 http://webdna.net ================================------------------------------------------------------------- Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server. To end your Mail problems go to
.This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to
Associated Messages, from the most recent to the oldest:
>I need to set up a voting and quiz application. I need some way to >ensure that each visitor can only vote once. What is the best way to >do this in WebCatalog?If it is critical that each person votes only once, I would have each person enter his/her email address into form1, then append a new record to the db with that email address in it, but only if that email address is not already in the db. Also, put a unique number (use [cart] if possible) into another field in that record -- and send a message to the same email address which includes the same unique number in it.In the email message, ask the visitor come back to the website and enter the unique number *and* the same email address into form2. When form2 is posted, check the db to be sure there is only one record i there that matches both the emailAddress field and the uniqueNumber field, as well as making sure the quizDate field is blank in that record ...If the search finds exactly one record matching all 3 parameters, then give the person your voting form. When the person submits the form, replace the blank data in the QuizDate field with the current date. This will prevent him/her from voting again, because your search rejects records with blank values in the quizDate field.The only way someone could vote twice or more in this scenario would be if he/she has more than one email address ... :)================================ Kenneth Grome, WebDNA Consultant 808-737-6499 http://webdna.net ================================------------------------------------------------------------- Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server. To end your Mail problems go to .This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to
Kenneth Grome
DOWNLOAD WEBDNA NOW!
Top Articles:
Talk List
The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...
Related Readings:
[setcookie] & [redirect] (1998)
[OT] Disable/enable field (2003)
[WebDNA] How to get the domain name? (2009)
[group] ? (1997)
Hiding HTML and page breaks (1997)
Help with nested search (1998)
database size? (1997)
What am I missing (1997)
Share cost of training videos! (1998)
[Announce]: Web server security and password protection (1997)
[Shownext] (1997)
WebCatalog Upgrade Pricing? (1997)
Generating a random image, but avoiding repeated images. (1999)
Emailer on NT CAN'T handle large email files (1997)
WebDNA-Talk Digest mode broken (1997)
Problems getting parameters passed into email. (1997)
sendmail tag when with in comment tags. (2000)
[WebDNA] Encode cookies ONLY via "method=Base64" (2008)
NumFound (1999)
[LOOKUP] (1997)