Would be best not to return 2 columns with the same name in the first place: tweak the select statement to either alias them, or exclude the columns you don't want.
SELECT table1.myColumn AS column_1 , table2.myColumn AS column_2 etc Cheers Bert On Wed, 15 Dec 2004 15:53:01 -0400, Asim Manzur <[EMAIL PROTECTED]> wrote: > The last thing which needs to be done is > I have two different table which has same field names. when I am using the > function Query2Form, and these two variables comes to the loop it becomes a > comma delimated value. > > How can I prevent to re-declare the already declared variable in Query2Form > funciton ? ? > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Special thanks to the CF Community Suite Silver Sponsor - CFDynamics http://www.cfdynamics.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:187866 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54