just watch out for international numbers! :P
On Wed, Sep 8, 2010 at 2:21 PM, Dusty Hale wrote:
> Ahh yes ... hostmysite had to set up the DSN for this and when I called
> last night I asked about that. I was working last night from my mac so
> wasn't able to check on a local server.
>
> Now make
Ahh yes ... hostmysite had to set up the DSN for this and when I called last
night I asked about that. I was working last night from my mac so wasn't
able to check on a local server.
Now makes perfect sense. Honestly this is the first time I ever really used
SQL code to query text files.
Concerni
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: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of Dusty Hale
Sent: Wednesday, September 08, 2010 11:54 AM
To: discussion@acf
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#[