Re: [SQL] how to preserve \n in select statement

2003-12-20 Thread Matt Van Mater
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

Re: [SQL] how to preserve \n in select statement

2003-12-19 Thread Matt Van Mater
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

Re: [SQL] how to preserve \n in select statement

2003-12-19 Thread Matt Van Mater
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

[SQL] how to preserve \n in select statement

2003-12-19 Thread Matt Van Mater
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 ---