Hello all. I have a problem with a query output returning multiple outputs of the same record. I only want the information once but for some reason it seems to be cycling trough it 7 times. Any help would be appreciated. I'm sure it's a simple solution sitting right under my nose. Code as follows. <cfquery name="job" dbtype="odbc" datasource="somesource"> select DISTINCT jobiinfo.place, jobiinfo.importance, jobiinfo.jobid, propinfo.propaddress, propinfo.propname, propinfo.jobid, clientinfo.lname, clientinfo.fname, clientinfo.coname, clientinfo.email, clientinfo.phone from (jobiinfo INNER JOIN propinfo ON jobiinfo.jobid = propinfo.jobid) INNER JOIN clientinfo ON jobiinfo.userid = clientinfo.userid where jobiinfo.jobid = #jobid# order by importance </cfquery> <!--- this is the code that is giving me 7 results of the same info. I've checked the DB and there is only one record for the query specified---> <cfoutput query="job"> CLIENT NAME:#fname# #lname#<br> PROPERTY NAME:#propname#<br> PROPERTY ADDRESS:#propaddress#<br> JOB ID:#jobid#<br> </cfoutput> Thanks to all that respond. spencer ------------------------------------------------------------------------------ Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
