SELECT
N.intNewsID ID,
'intNewsID' as IDLabel,
etc.
UNION
SELECT
C.intContentNr ID,
'intContentNr' as IDLabel,
etc etc.
Then each row in your recordset would have that field name in IDLabel
accordingly. I believe. :)
At 12:58 PM 3/13/2004, you wrote:
>Hi all. How to get da real name of ID colum alias name when retrieving
>data from a CF query? It's possible?
>SELECT
> N.intNewsID ID,
> N.strNewsTit Title,
> N.strNewsGrav Grav,
> N.memoNewsContent Content,
> N.dtNewsDateInc DateInc,
> S.strSiteName SiteName
>FROM
> tblsite S
> INNER JOIN tblnews N ON (S.strSiteID = N.strSiteID)
>WHERE S.strSiteID='#siteID#'
>AND N.intNewsStatus=1
>AND
>#PreserveSingleQuotes(booleansearch)#
>
>UNION
>
>SELECT
> C.intContentNr ID,
> C.strTitle Title,
> C.strGrav Grav,
> C.memoContnt Content,
> C.dtInc DateInc,
> S.strSiteName SiteName
>FROM
> tblcontent C
> INNER JOIN tblsite S ON (C.strSiteID = S.strSiteID)
>WHERE S.strSiteID='#siteID#'
>AND
>#PreserveSingleQuotes(booleansearch2)#
>
>ORDER BY DateInc DESC
>
>I'll need the real column name for N.intNewsID ID and C.intContentNr ID.
>
>Thanx in advance.
>
>SWD
>
>--
>___________________________________________________________
>Sign-up for Ads Free at Mail.com
>http://promo.mail.com/adsfreejump.htm
>
>----------
>[
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
