Re: unique id when form is submitted

["rockhiker" <jimo@xxxxxxxxxxx>]

I tried adding a query to retrieve the date that a person registers on. I set 
the Date Format in access to Now() so adds the data when a user submits a 
registration. I then added a query to retrieve the data. On the action page it 
retrieves the date but it returns ALL of the dates in the table - see query and 
output below. - thank you

 <cfquery name="register" datasource="design2008">
 SELECT RegisterDate FROM 2008RDCRegistratation
 </cfquery>

 <cfoutput query="register">Your registration number is 
#RegisterDate#</cfoutput>


 OUTPUT:

 Your registration number is Your registration number is Your registration 
number is Your registration number is 2008-07-24 10:20:03.0Your registration 
number is 2008-07-24 10:21:28.0Your registration number is 2008-07-24 
10:22:04.0Your registration number is Your registration number is