Multiple results

[VK Link]

Hi, Setting up a simple survey, where collects email address, answers and display options. Answers stored in database. And using table to select out and display information. There is some logic as to how the answers are displayed. Question - the user can take the survey multiple times. How to query the last set of answers for particular email address, if the user has taken the survey for the second time.

[Ista]

use a timestamp in the table to specify when the test was taken. then just select it out select top 1 * from Answers where personid=1 order by CreateDate I'm not an expert yet, but I play one at work. Yeah and here too. -- modified at 14:26 Monday 12th December, 2005

[VK Link]

Like the way you had specified TOP - is there a BOTTOM or DOWN as well? thanks.

[SABhatti]

change the order sorting order to .. CreateDate DESC and you will get bottom record...:-D -----

[Ista]

only a DIAGONAL!! :wtf: I'm not an expert yet, but I play one at work. Yeah and here too.

[VK Link]

Thanks for all the "great" ideas! solved the problem by adding a random number after the email address, so that way it will always be unique. And delete the number after email address to restore the original email address.

[Ista]

just use an identity field instead. its easier. although the timestamp will make it unique I'm not an expert yet, but I play one at work. Yeah and here too.