cffunction access="public" name="qry_peopleGet" output="false" 
returntype="query">
  <cfargument name="personKeyList" type="string" required="no" default="">
  <cfargument name="emailAddress" type="string" required="no" default="">
  <cfargument name="returnvariable" type="string" required="no" 
default="qry_thepeopleGet">
  <cfquery
                        name="qry_mypersongetting" datasource = 
"theartof_theartoflovingmoney">
                        SELECT  *
                        FROM    #request.sqlObjectPrefix#tblPeople
            
                        where
                        
                        tablePK         = '#arguments.personKeyList#' 
                        

                        AND             emailAddress = 
'#arguments.emailAddress#'
                        
                </cfquery>
  <cfreturn qry_mypersongetting>
</cffunction>



~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-community/message.cfm/messageid:370786
Subscription: http://www.houseoffusion.com/groups/cf-community/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-community/unsubscribe.cfm

Reply via email to