Hi,
Can someone help me with the following? I have a simple cgi script that is
trying to take the paragraph from a TEXTAREA field and insert the text into
a MySql table.
This works:
insert into description_tbl(1,'This is a sample paragraph.\nThis is just a
test.\n');
However, by passing $query->param('description') into the sql through DBI
converts the insert statement to:
insert into description_tbl(1,'This is a sample paragraph.
This is just a test.
');
The DBI call fails.
I tried using the following to change the carriage return to two characters
'\n' in the string. But that doesn't work either.
my $query = new CGI;
$query->param('description') =~ tr/\n/'\n'/;
print OUT $query->param('description'),"\n"; - prints nothing
Thoughts anyone?
Thanks in advance!
- Kit
------------------------------------------------------------------------------
This message is intended only for the personal and confidential use of the
designated recipient(s) named above. If you are not the intended recipient of
this message you are hereby notified that any review, dissemination,
distribution or copying of this message is strictly prohibited. This
communication is for information purposes only and should not be regarded as
an offer to sell or as a solicitation of an offer to buy any financial
product, an official confirmation of any transaction, or as an official
statement of Lehman Brothers. Email transmission cannot be guaranteed to be
secure or error-free. Therefore, we do not represent that this information is
complete or accurate and it should not be relied upon as such. All
information is subject to change without notice.
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
