Select channels.ChannelName, channels.ChannelID, RemoteNews.NewsID, RemoteNews.InChannel >From Channels, RemoteNews Where channels.ChannelID = RemoteNews.InChannel
- j -----Original Message----- From: Tony Hicks [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 21, 2002 5:40 AM To: CF-Talk Subject: Getting Real Channel Name I'm working on a CMS and actually using db relationships for the first time... I have the tables: Channels ChannelName ChannelID RemoteNews NewsID .... InChannel InChannel reads from the table channels and in the db I see a drop down list withe the nice clean names of the channels.. but in cf I have to reference the fields by their ChannelID via InChannel... is there anyway to fix this?? Thanks, Tony Hicks ______________________________________________________________________ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists