• Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
    Dedicated community for Japanese speakers
  • 한국 커뮤니티
    Dedicated community for Korean speakers
Exit
0

Can it be done and if so, hint please

LEGEND ,
Oct 07, 2007 Oct 07, 2007

Copy link to clipboard

Copied

I have 7 flat text files. Can I use cfhttp to turn each of them into a query
and then UNION then into one useable query?

--
Wally Kolcz
MyNextPet.org
Founder / Developer
586.871.4126


TOPICS
Advanced techniques

Views

348

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
LEGEND ,
Oct 07, 2007 Oct 07, 2007

Copy link to clipboard

Copied

> I have 7 flat text files. Can I use cfhttp to turn each of them into a query
> and then UNION then into one useable query?

What the schema of the files?

From reading the CFHTTP docs, it sounds like you CAN do this, provided the
files can be treated as a CSV (or some similar uniformly delimited data).

http://livedocs.adobe.com/coldfusion/8/htmldocs/help.html?content=Tags_g-h_09.html

--
Adam

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
LEGEND ,
Oct 07, 2007 Oct 07, 2007

Copy link to clipboard

Copied

quote:

Originally posted by: Newsgroup User
I have 7 flat text files. Can I use cfhttp to turn each of them into a query
and then UNION then into one useable query?


What happened when you tried?

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
LEGEND ,
Oct 08, 2007 Oct 08, 2007

Copy link to clipboard

Copied

Took some figuring out, but it worked. I am then using IsDefined('') To make
sure the cfhttp query works. It grows from one day to the next.


Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
Oct 08, 2007 Oct 08, 2007

Copy link to clipboard

Copied

It grows from one day to the next.
That's life.

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
LEGEND ,
Oct 08, 2007 Oct 08, 2007

Copy link to clipboard

Copied

LATEST
Of course you have to love it when the host supplier puts out data that is
inconsistent and never checked for consistent data or foreign characters
like pipes in a pipe delimited document......


Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Resources
Documentation