I'm curious about a couple of things:
- you refer to "two tables(files) in the tdatabase", but being CSV files,
there is no
"database", right? Do you mean in "the datasource"? If so, why/how would you
have two
CSV files defined in one datasource? Does anything change if you create two
DSNs, on
>>
>> On Wed, Sep 8, 2010 at 12:00 PM, Charlie Arehart wrote:
>>
>>> Stumper. (Thanks for the clarifications about multiple files in a text
>>> DSN. It’s been years since I last used the feature, so my memory was hazy.)
>>>
>>>
>>>
>
8, 2010 at 12:00 PM, Charlie Arehart wrote:
>
>> Stumper. (Thanks for the clarifications about multiple files in a text
>> DSN. It’s been years since I last used the feature, so my memory was hazy.)
>>
>>
>>
>> /charlie
>>
>>
>>
>> *From:
ssion@acfug.org
Subject: Re: [ACFUG Discuss] bizarre issue with output from cfquery
There is one Cold Fusion datasource that points to a system datasource that
uses the
MS text file driver. It allows me to query any of the csv files I have in a
folder.
For example:
select phone, fax
There is one Cold Fusion datasource that points to a system datasource that
uses the MS text file driver. It allows me to query any of the csv files I
have in a folder. For example:
select phone, fax from [pathToFolder]\[filname].csv
Then as a test scenario I output as follows:
Phone: #phone#[
