Well ---- ;-)
We're using SQL 7 for all the database work, but we want to combine some tables (doing
mods on a 3rd party program). We thought to use Transform/Pivot. That avoids running
hundered of queries on a page (or even an additional 50) because of a funny table
structure.
We approched the problem by building the Transform Query in ACCESS (their little
wizards!) and then utilizing it in the CF code to access the SQL7 server.
So, that's how I can see the columns being properly named, but me hair is falling out
at being inable to utilize the information. If it's a MS SQL 7 situation - then at
least I know it's time to take a different approach!
Stephen
[EMAIL PROTECTED]
http://www.tallylist.com
---------- Original Message ----------------------------------
From: Dave Watts <[EMAIL PROTECTED]>
Date: Tue, 20 Mar 2001 10:49:06 -0500
>> 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
