Hi Brett,
Your first sentence is where the problem lies. I can't get the csv file containing the
table into postgres until and unless it exactly matches the columns defined in
postgres. To do
this, it can't have any carrage returns, except at the end of each record. I only have
a few records, but there are hundreds of carrage returns in some of the cells.
Frank Hilliard
Brett Frisch wrote:
> At 08:21 AM 2/3/01 +0000, you wrote:
> >Hi Mark,
> Frank,
>
> I think what Mark is saying is, after you upload your db to progres, run a
> cfm script that strips all the carriage returns from each record. My
> question is, are the carriage returns in the record before you convert to
> progres or is the PGAccess program putting them in for some reason?
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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.
