Please note that this is a ColdFusion deficiency. Oracle's SQLNet tool,
for example, has no problem writing out two different columns with the
same name.
-David
On Thu, 30 Nov 2000 12:52:02 -0000 "Philip Arnold - ASP"
<[EMAIL PROTECTED]> writes:
> > If I'm joining multiple tables together and they have columns
> > with the same
> > name, how do I distinguish between them?
> >
> > I've tried: #queryname.table.column_name# but this doesn't seem to
> work.
>
> Once the data has come out of the CFQuery, the column names are all
> treated
> indiviually - you should alias the columns;
> Select Table1.ID as ID1, Table2.ID as ID2
________________________________________________________________
GET INTERNET ACCESS FROM JUNO!
Juno offers FREE or PREMIUM Internet access for less!
Join Juno today! For your FREE software, visit:
http://dl.www.juno.com/get/tagj.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
