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

Reply via email to