[Top] [All Lists]

Re: Display fields on Action Page

Subject: Re: Display fields on Action Page
From: "cf_dev2"
Date: Wed, 22 Aug 2007 15:34:50 +0000 UTC
Newsgroups: macromedia.coldfusion.cfml_general_discussion
Check the data type of the ContactsID column. Is it really autonumber?

 Also, don't use a FROM clause in the "GetNewID" query.  That would return one 
record for each row in the Conf2007Registration table.  You only want to return 
1 record.

 <cfquery name="GetNewID" datasource="DSSurvey">
 SELECT @@identity AS ContactsID

<Prev in Thread] Current Thread [Next in Thread>