I'm afraid I don't know the answer to the type issue. QoQ is problematic and in the past I have had to look to other solutions where, if it were working, QoQ would have been preferrable.
There may be a solution to do with explicitly typing the columns that someone here can offer though. How is the data in the query got at? If it is from a single dynamic query that you have access to then the ideal solution would be to have the SELECT DISTINCT in the original query so no need for the additional query. Dominic On 29/02/2008, Richard White <[EMAIL PROTECTED]> wrote: > > >Another thing, building a query string isn't required with ColdFusion in > the > >way you are doing it, have you come from another language? > > > hi dominic, thanks for the response. i have come from VB but dont think > this explains the poor coding!!!! i still class myself as a newbie to coding > even though i have built a couple of full applications. i am trying hard to > pick as many good standards as possible as i go along so thanks very much > for this. this does help me to understand coldfusion further, and your right > - to make it more readable > > ill give it a go and see what happens, but sorry i didn't quite get what > you were saying on the QoQ, if its producing the error as it is typeless is > there a way i can get around this. i can obviously do it through a loop now > i have got it this far but, as you said, for readability i would like to do > it this way as it cuts down on alot of confusion > > thanks > > richard > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300158 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
