Question
ValueList question
I need to join table A to table B via docNo. In table A,
docNo is a unique key but it is not in table B.
Table A contains docNo...something else. Table B contains DocNo, Descr...something else. So the first line of table B is docNo 12345, descr D1, next line is docNo 12345, descr D2, next line docNo 9999, descr D9...etc.
When I do the join with docNo 12345, I would get two lines with the cfoutput, one for descr D1 and the other for descr D2. I tried to use valueList to combine them, hopoing to get one line only, docNo 12345, descr D1,D2.
But instead, it is giving me docNo 12345, descr D1,D2,D9...etc, all the descr in the same valuelist.
What do I need to do to get the desired output, with a comma as the separator (only if there is more than on descr) .
Table A contains docNo...something else. Table B contains DocNo, Descr...something else. So the first line of table B is docNo 12345, descr D1, next line is docNo 12345, descr D2, next line docNo 9999, descr D9...etc.
When I do the join with docNo 12345, I would get two lines with the cfoutput, one for descr D1 and the other for descr D2. I tried to use valueList to combine them, hopoing to get one line only, docNo 12345, descr D1,D2.
But instead, it is giving me docNo 12345, descr D1,D2,D9...etc, all the descr in the same valuelist.
What do I need to do to get the desired output, with a comma as the separator (only if there is more than on descr) .
AdChoices