> > 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
>
> 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.
While CF can't do that, I'd hardly call that a deficiency! When you use
SQLNet, or any query front-end tool, you can display any recordset at all -
it essentially is just dumped to the screen. You'd have a hard time
referencing that data in any meaningful sense from the programming
environment of your choice, though. When you output, somewhere in your
output, "#ID#", which one of the ID columns should CF reference?
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
