[darrylw]

Once again I find myself a bit confused……

I decided to create a new table to import a csv file that was left in DOS format. The import file

was the same one that I had problems with before.

I entered (rn), not in parenthesis in the line termination and (,) as the field delimiter as I had done before.

This time the file imported with no complaints other than missing some of the records.

I emptied the table and re-ran the routine and it worked again.

So I then did it again but changed the table to not have any primary key or non-null conditions.

This time it imported all of the records.

I must admit that I have no idea why the pgm seemed to remove the ` from the field indicators

when I was trying to import the file originally.

Perhaps I should now simply not worry and be happy.

Thanks for your help…..maybe I found a bug but maybe I created one in my environment somehow.

P.S. Should I remove version 3.52 and go back to 3.11 that did not complain about registering?

[darrylw]

Thanks for the speedy reply.

I also tried adding rn as line terminators in the interface but that did not seem to work

at the time.

Should these show in SQL as something like `r n` or `r` `n` or something that combines them like (`r`, `n`)

The book is PHP/MySQL Programming by ANDY HARRIS from Premier Press. The Acknowledgements included the webyog development team. ISBN 1-931841-32-2

[Author]

Posts