They would be ok in the postgres database - but Frank said the means by which
he is importing the data, is using carriage returns as row delimiters - that's
why I suggested doing a simple select * from the access database. then loop
over the result set inserting the data into postgres from a cf script. It
won't care about the carriage returns
jason
----- Original Message -----
From: "Brett Frisch" <[EMAIL PROTECTED]>
To: "CF-Linux" <[EMAIL PROTECTED]>
Sent: Sunday, February 04, 2001 10:46 AM
Subject: Re: Deleting carrage returns in a CSV file
> I was just wondering why the carriage returns are ok in the access db and
> not in the progres db? Maybe the question should have been "I guess the
> real question is why do you have the carriage returns in your
> access db and why can't they just go over to the progres db? Or am I
> missing something?
>
> Brett
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-linux%40houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_linux or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
