I believe you can reference columns and tables that have spaces in them by
surrounding them with brackets ([table name]). It's been a while since I've
done this, though.
Chris Evans
[EMAIL PROTECTED]
http://www.fuseware.com
-----Original Message-----
From: Don Vawter [mailto:[EMAIL PROTECTED]]
Sent: Friday, April 14, 2000 8:46 AM
To: [EMAIL PROTECTED]
Subject: Re: CFFILE Woes
The problem is the choking on the first read. If I try to split it as a list
with delims of chr(13)chtr(10) I get only two elements. If I open it in
Studio first and then save it. I get 1200 the second time which is correct.
Somehow there must be a character that studio and odbc thow away but that
chokes cffile.
----- Original Message -----
From: "Jim McAtee" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, April 13, 2000 11:05 PM
Subject: Re: CFFILE Woes
> When you say "I try to print it out" do you mean display it on a web page
> or print the file contents to a printer? The file may inadvertently
> contain control characters, possibly an end of file marker, which could
> cause it to not print completely on a printer. Removing control
> characters from the file with a regular expression would probably fix the
> problem.
>
> If you knew that the fields will always be the same, and in the same
> order, then you could just throw out the first line, and parse the file
> contents yourself(most likely using CF list functions), rather than
> bothering with using ODBC. If you want to use your ODBC datasource, then
> you could once again use a regular expression to replace spaces with
> underscores in the first line's field names, then write the file back to
> disk before making your query.
>
> Jim
>
>
> -----Original Message-----
> From: Don Vawter <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
> Date: Thursday, April 13, 2000 8:16 PM
> Subject: CFFILE Woes
>
>
> >I receive a text file over which I have no control. It is an ascii
> delimited
> >file with column names in the
> >first line. When I try to read it in using cffile:
> >
> ><cffile action="READ" file="I:\Stressless\sl0930\downloads\inventory.txt"
> >variable="inventory">
> ><cfa_dump var="#inventory#">
> >
> >it gives the proper length string but if I try to print it out it
> truncates
> >after about 350 characters. (No its not the cfa_dump tag it happens with
> >cfoutput also)
> >
> >If I open it in studio and then save it (making no changes) and use
> cffile
> >again it comes in properly.
> >
> >Also if I create an ODBC datasource for the file and bring it in as a
> query
> >it comes in fine. The only problem with that is <RANT>the owners of the
> file
> >have spaces in field names</RANT> and I can't refer to them in CF (unless
> >someone else can give me a hint on that).
> >
> >If this were a one time occurence I would just clean up the names in
> studio
> >and be done with it. Unfortunately it comes in daily.
> >
> >Any suggestions? TIA
> >Don
>
>
> --------------------------------------------------------------------------
----
> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
----------------------------------------------------------------------------
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
