Hey everyone - I have a question about Cold Fusion and trying to read the Column name
off of a Cross-Tab (MS SQL Server 7).
I can generate the cross-tab without a problem, and if you look at the query output in
Access, it correctly identifies the 11th and 12th Columns as Fax and Phone.
But I cannot seem to name them, and Cold Fusion will not recognize the names of the
columns. IE:
Error resolving parameter CLIENTSEARCH.PHONE
The column PHONE is not present in the query named CLIENTSEARCH. It is likely that you
have misspelled the name of the column.
It asctually is there, dynamically being named on the fly. Is there a way for Cold
Fusion to recognize the columns?
TRANSFORM First(A.Phone) AS Phone
SELECT A.ClientID, A.ClientName, A.FullName, A.City, A.State, A.Zip, A.Email, A.Title,
A.CreateDate, A.UpdateDate, A.contactStatus
FROM (SELECT Clients.ClientID, Clients.ClientName, [ClientContacts].[FirstName]+'
'+[ClientContacts].[LastName] AS FullName, ClientContacts.City, ClientContacts.State,
ClientContacts.Email, ClientContacts.Title, ClientContacts.CreateDate,
ClientContacts.UpdateDate, ClientContacts.StatusID AS contactStatus,
ContactPhones.Phone, PhoneTypes.Type
FROM (ClientContacts INNER JOIN Clients ON ClientContacts.ClientID = Clients.ClientID)
INNER JOIN (PhoneTypes INNER JOIN ContactPhones ON PhoneTypes.TypeID =
ContactPhones.TypeID) ON ClientContacts.ContactID = ContactPhones.ContactID) AS A
WHERE (blah blah stuff goes here etc.)
Thanks for your time,
Stephen R. Cassady
[EMAIL PROTECTED]
http://www.tallylist.com
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
