> 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.
My guess is that you're running this query through Access itself, right?
To the best of my knowledge, SQL Server 7 doesn't support the use of
TRANSFORM.
When you query the database from CF, are you using CF to talk to the SQL
server through an Access linked table?
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
