http://www.emerle.net/programming/display.cfm/t/cfx_text2query
(it's free)
"CFX_Text2Query works better than other methods because it can handle
empty fields and fields with line breaks.."
"One alternative, using CFHTTP, requires the file to be
web-accessible, and cannot handle empty fields OR line breaks. This
often results in the "Incorrect number of columns in row." error and a
lot of headaches."
On Wed, 29 Sep 2004 18:56:47 -0400, Anders Green <[EMAIL PROTECTED]> wrote:
> Interesting. Seems that CFHTTP can turn a .csv file
> into a query easily. But CFFILE can't.
>
> So I can pull the file from another server and handle
> it easily, but not when it's on my own machine?
> Weird.
>
> Ok, I guess I could copy the file to the web root,
> CFHTTP it from myself, then delete it, but that
> seems a little roundabout.
>
> Or, read it in, parse it, etcetera. Certainly doable,
> but not as oh-look-its-done-already easy. I have to
> do that anyway for a different file that's certainly
> NOT csv, and once would be just fine. :)
>
> Anyone want to jump in here?
>
> Cheers!
> Anders
> +===========================================================+
> |Anders Green Email: [EMAIL PROTECTED] |
> | Home: 919.303.0218 |
> | Off Road Rally Racing Team: http://linaracing.com/ |
> +===========================================================+
>
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
