[ic] \r being inserted into my db by log_transaction??

[Cameron]

That's just the thing - i immediately assumed that was what i had done, and
went to check - the file looks FINE in vi. I even went as far as to cut and
paste the file back in from one vi on a securecrt ssh session to another vi
on a securecrt ssh session, and it made no difference. I even tried a :se
ff=unix. No Go. Somewhere, somehow, i'm getting a \r appended to everything
being inserted, and i don't know why :(

----- Original Message -----
From: "Kevin Walsh" <kevin@cursor.biz>
To: <interchange-users@icdevgroup.org>
Sent: Tuesday, February 04, 2003 5:09 AM
Subject: RE: [ic] \r being inserted into my db by log_transaction??


> Cameron [ritontor@icenet.com.au] wrote:
> >
> > I've been having all sorts of problems with orders not going into the db
> > correctly, and i've discovered what the issue is - for *SOME* ungodly
> > reason, my log_transaction file seems to be appending a \r to everything
> > it's inserting into the orderline and transactions tables. i'm at a
loss....
> > can anyone help?
> >
> If you edited your log_transaction file with some sort of non-UNIX
> editor, such as MS Notepad, you may find that it has a CR character at
> the end of each line.  This may or may not be why you see the extra CR
> inserted into your tables.  Check your log_transaction file to see if
> this is the case, and remove the extra junk characters as appropriate.
>
> --
>    _/   _/  _/_/_/_/  _/    _/  _/_/_/  _/    _/
>   _/_/_/   _/_/      _/    _/    _/    _/_/  _/   K e v i n   W a l s h
>  _/ _/    _/          _/ _/     _/    _/  _/_/    kevin@cursor.biz
> _/   _/  _/_/_/_/      _/    _/_/_/  _/    _/
>
> _______________________________________________
> interchange-users mailing list
> interchange-users@icdevgroup.org
> http://www.icdevgroup.org/mailman/listinfo/interchange-users
>