Your newline problem is probably related to the output record separator. You can just assign to it to change the default behaviour.
$, - output field separator (default: comma)
$\ - output record separator (default: newline)
$" - list separator (default: space) | [reply] |
All:
I used the binding parameters feature of DBI as suggested, and that solution works the best. The problem with other solutions was the nature of the data. These are specially-prepared Naval messages that require that the formatting (lines, etc) be exactly as created. The editors they use for these things can also vary as to how they add CRs and LFs, so my goal was to just have them paste the raw copied text to the web form and have the script dump it to the database as-is. Binding worked perfectly.
Thanks for all the great tips and advice. I am very grateful.
| [reply] |