Re: OT: placeholders and DBI

2001-09-01 Thread Mike808
ryc wrote: ... I am having a problem with DBI (or the db) escaping '\n' characters so when they are inserted into the database they become '\\n' (ie a '\' followed by 'n'). Does anyone have advice on how this could be done while still using placeholders so I dont need to prepare the query

Re: OT: placeholders and DBI

2001-09-01 Thread Ken Williams
On Sat, Sep 01, 2001 at 02:38:05PM -0500, Mike808 wrote: ryc wrote: ... I am having a problem with DBI (or the db) escaping '\n' characters so when they are inserted into the database they become '\\n' (ie a '\' followed by 'n'). Does anyone have advice on how this could be done while

Re: OT: placeholders and DBI

2001-09-01 Thread ryc
Great diagnosis! Turns out somewhere in the code newlines were being converted to '\n' (two characters) in order to prepare the data for mysqlimport. Sorry about the noise on the list for such a silly error.. placeholders do in fact work exactly as expected, but not when combined with faulty