<!--- 
Module:         qry_GetContactRecord.cfm
Author:         M Jeo, L Chalnick
Function:       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.
Date created:   4/25/2002
--->

<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>