Re: CGI/Perl and MySQL (OT?)

2001-06-06 Thread Alexander Skwar
So sprach Jeffrey L. Fitzgerald am Wed, Jun 06, 2001 at 12:08:18AM -0400: > Currently the text coming back from the database is all runs together in > the web browser... Try nl2br -> php.net/nl2br Alexander Skwar -- How to quote: http://learn.to/quote (german) http://quote.6x.to (engli

Re: CGI/Perl and MySQL (OT?)

2001-06-06 Thread Colin Faber
A better solution would be to use the DBI quote() function, see the DBI perldoc for more information. and FYI 99% of web clients pass CRLF not just LF so you'd need \r\n Chris Thompson wrote: > > > Trying to get text from a CGI textarea box to go into MySQL with the > > line breaks instead on

Re: CGI/Perl and MySQL (OT?)

2001-06-06 Thread Chris Thompson
> Trying to get text from a CGI textarea box to go into MySQL with the > line breaks instead on generic \n breaks. Is there an easy way to parse the var > and make the necessary change? You can use a Perl regular expression. The following seems to work for me: # replace line breaks with HTML

CGI/Perl and MySQL (OT?)

2001-06-05 Thread Jeffrey L. Fitzgerald
Trying to get text from a CGI textarea box to go into MySQL with the line breaks instead on generic \n breaks. Is there an easy way to parse the var and make the necessary change? Currently the text coming back from the database is all runs together in the web browser...