Mr. Makhoul,
You're most welcome. Glad I could help.
Marianne
-----Original Message-----
From: Eyad Makhoul [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 04, 2001 1:09 PM
To: CF-Community
Subject: RE: How we could get data from database to text file
Dear Daye..,
Thx very much about your help and really it works perfect....
MR.Eyad Makhoul
TelNo/Home:+96265359801
Mobile:+96277304797
---------- Original Message ----------------------------------
From: "Daye, Marianne" <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
Date: Tue, 03 Apr 2001 10:39:48 -0400
>OK, different approach:
>
><cfquery datasource="#DataSource#">
> SELECT *
> FROM MyTable
></cfquery>
>
><!--- Create file and insert column headers. --->
><cffile action="WRITE"
> file="full_path_name.txt"
> output="ColHdr1,ColHdr2,ColHdr3">
>
><!--- Append each record on a new line. --->
><cfloop query="MyQuery">
> <cffile action="APPEND"
> file="full_path_name.txt"
> output="#Col1#,Col2#,#Col3#">
>
></cfloop>
>
>
>-----Original Message-----
>From: Eyad Makhoul [mailto:[EMAIL PROTECTED]]
>Sent: Tuesday, April 03, 2001 8:45 AM
>To: CF-Community
>Subject: RE: How we could get data from database to text file
>
>
>Thx for uyour Concernity...,
>But how you could replace the(CFHTTP.FileContent) whith the query
>which will load the data in to text file.
>
>
>MR.Eyad Makhoul
>TelNo/Home:+96265359801
>Mobile:+96277304797
>
>
>
>---------- Original Message ----------------------------------
>From: "Daye, Marianne" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>Date: Tue, 03 Apr 2001 07:59:36 -0400
>
>>Sorry, I just realized I understood the question backwards.
What
>I did
>>below will get the data from a text file to a database.
However,
>I've also
>>seen a case where the contents of cfhttp were used to enter data
>into a text
>>file as follows:
>>
>><cffile action="WRITE" file="full_path_name.txt"
>>output="#CFHTTP.FileContent#">
>>
>>Since the cfhttp is a query of sorts, I wonder if you can't do
>something
>>similar with a regular query.
>>
>>Marianne Daye
>>
>>-----Original Message-----
>>From: Daye, Marianne [mailto:[EMAIL PROTECTED]]
>>Sent: Tuesday, April 03, 2001 7:45 AM
>>To: CF-Community
>>Subject: RE: How we could get data from database to text file
>>
>>
>><CFHTTP> seems to read a delimited file into a query and use the
>column
>>headers as field names. This has worked for me:
>>
>><cfhttp URL="http://localhost/path/file.htm method="GET"
>> name="MyQuery"
>> textqualifier=""""
>> delimiter=",">
>>
>> <!--- Update database table with file contents. --->
>> <cfloop query="MyQuery">
>> <cfquery datasource="#DataSource#">
>> UPDATE MyTable
>> SET Field1 = '#Col1#',
>> Field2 = '#Col2#'
>> </cfquery>
>> </cfloop>
>>
>>Marianne Daye
>>Programmer/Analyst
>>Information Delivery Systems (IDS)
>>http://ids.rti.org
>>
>>
>>-----Original Message-----
>>From: Derek Hamilton [mailto:[EMAIL PROTECTED]]
>>Sent: Tuesday, April 03, 2001 3:04 AM
>>To: CF-Community
>>Subject: Re: How we could get data from database to text file
>>
>>
>>Some more info on what/how you are trying to do would be helpful.
>>
>>Derek
>>----- Original Message -----
>>From: "Eyad Makhoul" <[EMAIL PROTECTED]>
>>To: "CF-Community" <[EMAIL PROTECTED]>
>>Sent: Monday, April 02, 2001 11:47 PM
>>Subject: How we could get data from database to text file
>>
>>
>>> Dear all..,
>>> I face a problem in how to get data from database to a text
file
>>> through coldfusion ...and i used CFFILE but it seems it does
not
>>> perform the job perfectly, because i want the data with thier
>>> columns to be inserted in to file.
>>>
>>> any Help...?
>>>
>>>
>>>
>>> MR.Eyad Makhoul
>>> TelNo/Home:+96265359801
>>> Mobile:+96277304797
>>>
>
>>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
