<!--- ----------------------------------------------------------------------------------------------------
Query's a specific contact. A specific contact will not be identified when adding a new contact, so
contact id will be set to 0 and the query will return an empty recordset.
----------------------------------------------------------------------------------------------------- --->
<CFPARAM NAME="Attributes.Con_ID" DEFAULT="0">

<CFQUERY NAME="GetContactDetail" DATASOURCE="#DSN#">
   SELECT ContactID, FirstName, LastName,  Phone, Address, City, State, Zip, Country,
      Email, UserLogin, UserPassword, MailingList
   FROM Contacts
   <CFIF attributes.Con_ID NEQ 0>
      WHERE ContactID = #Attributes.Con_ID#
   <CFELSE>
      <!--- When adding, will return empty result set --->
      WHERE 0 = 1
   </CFIF>
</CFQUERY>