Re: Re: textarea with multiple rows and mysql insert

dunno if this made it: Here's an example. In the first textbox of the form I write in the following link: http://xxxxxxxx/xxxxxxxxx/servlet/xxxxxxxxxAuthGW/wt.enterprise.URLProcessor/URLTemplateAction?u8&oid=OR%3Awt.folder.SubFolder%3A492999&action=ObjProps And in the second box: These are comments that I am writing in the textarea that is available for these. The resulting insert statement is: INSERT into aplicaciones set id = NULL, Nombre = "AUTOCAD", Version = "2000", Modulo = "", Fabricante = "AUTODESK", mansycontratos = "http://xxxxxxxx/xxxxxxxxx/servlet/xxxxxxxxxAuthGW/", comentarios = "These are comments that I am writing in the textar", cat_id = "1" Jay --- Viorel Dragomir <bc@vio.ro> wrote: > mysql_escape_string? > [try to print what kind of values do you receive in > post vars] > > > > vio- > ----- Original Message ----- > From: "Jason End" <bensnephew@yahoo.com> > To: "George Patterson" <george@visp.com.au>; > <php-db@lists.php.net> > Sent: Monday, October 13, 2003 10:35 AM > Subject: Re: [PHP-DB] Re: textarea with multiple > rows and mysql insert > > > > I'm using post > > Here's the code: > > --- > > <html> > > <head><title>Detalles</title></head> > > <body bgcolor="white"> > > <form method="post" action="editarsoftsel.2.php"> > > <table> > > [...] > > <tr> > > <td><font>Manuales:</font></td> > > <td><textarea name="manuales" rows="2" > > cols="50"><? echo $formVars["mansycontrato"] . > > "http://"; ?></textarea></td> > > </tr> > > > > <tr> > > <td><font>Comentarios:</font></td> > > <td><textarea name="comentarios" rows="5" > > cols="50"><? echo $formVars["comentarios"]; > > ?></textarea></td> > > </tr> > > > > <tr> > > <td><br><input type="image" src="enviar.gif" > > border="0"> > > <INPUT name="submit" type="hidden" > > value="1"></td> > > </tr> > > </table> > > </form> > > </body> > > </html> > > --- > > > > --- George Patterson <george@visp.com.au> wrote: > > > On Sun, 12 Oct 2003 23:31:55 -0700 (PDT) > > > Jason End <bensnephew@yahoo.com> wrote: > > > > > > > The type was already set to "text". > > > > The problem isn't at the mysql level but at > the > > > > form/php level. The insert statement that is > > > formed > > > > extracting the values from the form is only > giving > > > > that part of the url or comments. > > > > > > > > Jay > > > > > > > Jason, > > > > > > Are you using the get or post form method?? If > the > > > method isn't > > > specified, browser will default to Get. The get > > > method is will truncate > > > the data from the browser, whereas the Post > method > > > will allow alot more. > > > > > > Consider posting back the html for the form. > > > > > > The other possiblity is that you have carriage > > > returns comming back from > > > the form that you need to parse out. > > > > > > George Patterson > > > > > > > --- Dan Brunner <daniel.brunner@duni.com> > wrote: > > > > > What is your field length??? > > > > > > > > > > > > > > > Varchar(10)?? > > > > > > > > > > You should set the column type to text. > > > > > > > > > > > > > > > Dan > > > > > > > > > > > > > > > > > > > > On Oct 10, 2003, at 10:27 AM, > > > joao@mrmidia.com.br > > > > > wrote: > > > > > > > > > > > > > > > > >> I have a form that includes two text > areas > > > that span > > > > > >> multiple rows. The first textarea > (rows=2, > > > cols=50) is > > > > > >> used to insert a pretty long url, while > the > > > second > > > > > >> (rows=5, cols=50) is used for inserting > free > > > text (comments). > > > > > >> When I process the form to create the > > > mysqlinsert > > > > > >> statement, the values inserted for both > those > > > text > > > > > >> areas get cut off after the end of each > row. > > > > > >> How can I get the script to process the > full > > > contents? > > > > > >> > > > > > > -- > > > PHP Database Mailing List (http://www.php.net/) > > > To unsubscribe, visit: > http://www.php.net/unsub.php > > > > > > > > > __________________________________ > > Do you Yahoo!? > > Yahoo! SiteBuilder - Free, easy-to-use web site > design software > > http://sitebuilder.yahoo.com > > > > -- > > PHP Database Mailing List (http://www.php.net/) > > To unsubscribe, visit: > http://www.php.net/unsub.php > > __________________________________ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com