I like the Expiring record idea. But apart from making a scheduled task delete all invalid accounts, is there any setting in SQL Server 2000 to expire a db record automatically on a expiration date?
On 4/3/06, Adrian Lynch <[EMAIL PROTECTED]> wrote: > > Most things are possible but you seem to be making an awful lot of extra > work for yourself doing it this way. Just put a record in the DB and flag > it > at inactive till they confirm via the email. If you're worried about the > number of inactive entries, use a time stamp to expire them after a period > of time. > > Adrian > > -----Original Message----- > From: Ken [mailto:[EMAIL PROTECTED] > Sent: 03 April 2006 16:03 > To: CF-Talk > Subject: Creating double confirm > > > Hi. I am trying to force a Email Confirmation for new user registrations > on > my site. > The user Enters only basic info on the website, First Name, Last Name, > Email > Address. Then they should be taken to a page that stops them from going > ahead until they click a link in the email. > Problem: > I want to do it in such a manner that I don't create a db record for them > at > all, until they have clicked the link. Is it possible to Encrypt the > entire > string consisting of FirstName, LastName, EmailAddress, and Promotional > Code, Attach it the link in the email, then when the user clicks the link, > we Decrypt the string, separate the partts and do a db insert? > > If so, are there any pitfalls or problems in doing so? Which Encryption > Algorithm would the best to use? > > Thanks, > Ken > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236817 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
