Re: Replacing carriage return with character string '\n' coming from a textarea param

2003-08-21 Thread zsdc
Li, Kit-Wing wrote: 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. Use placeholders. See: http://search.cpan.org/author/TIMB/DBI-1.37/DBI.pm#Placeholders_and_Bind_Values You ca

Replacing carriage return with character string '\n' coming from a textarea param

2003-08-21 Thread Li, Kit-Wing
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-