Because you are using an input syntax that requires that quotes and
backslashes be escaped. There are other input methods available that
don't require this, but they have disadvantages of their own. In
particular, you have to separate data from SQL command if you want a
no-escape-processing behav
and this may be another instance of that
functionality.
Original Message Follows
From: Bruno Wolff III <[EMAIL PROTECTED]>
To: Matt Van Mater <[EMAIL PROTECTED]>
CC: [EMAIL PROTECTED]
Subject: Re: [SQL] how to preserve \n in select statement
Date: Fri, 19 Dec 2003 15:26:07 -0600
On F
Inside the commandfile I have lines like:
INSERT INTO tablename (col1, col2, col3) VALUES ($val1, $val2, $val3);
How do I escape the data from a select statement? Something like: SELECT \*
FROM tablename; ?
Original Message Follows
From: Guy Fraser <[EMAIL PROTECTED]>
To: Matt V
t statement not interpret newline escape
characters?
Matt Van Mater
_
Have fun customizing MSN Messenger learn how here!
http://www.msnmessenger-download.com/tracking/reach_customize
---