Well, let's see if this is what you need.
First, you mention that you're getting multiple values. Do you mean more than one record are the same. If this is the case you should include another word (DISTINCT) in your query that will return only one of the duplicated records.
CFQUERY...