> Is there a way to refer to 2 fields in one query with > the same name? > > I have a field called "title" in table "tbl_Pages" and a > field called "Name" in table "tbl_Categories" > > <cfquery name="getHyperlinks" datasource="#ds#"> > SELECT tbl_Pages.title AS hyperlink_title, > tbl_Categories.Name AS hyperlink_title > FROM tbl_Pages, tbl_Categories > </cfquery> > > Obviously the above gives me the error: Duplicate output > alias 'hyperlink_title' > > Is there a way around this? This is for cf 4.5.
There's no way around this; that's just the way SQL works! Even if it did work - that is, if it didn't produce an error - what would you want this to do? If you're trying to build one field that contains both of the other fields, you can do that by simple concatenation: SELECT tbl_Pages.title + ' ' + tbl_Categories.Name AS hyperlink_title ... 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
