[Zope] Textareas and SQL (Gadfly)

[Jim Sanford]

I use 
<dtml-sqlvar "_.string.replace(textarea_field,_.chr(10),'')" type=string>


----- Original Message ----- 
From: Evan Gibson <egibson@connect.com.au>
To: <zope@zope.org>
Sent: Tuesday, February 08, 2000 9:53 AM
Subject: [Zope] Textareas and SQL (Gadfly)


I've been hitting my head on the wall for hours over this...

I've got a large collection of forms feeding into a gadfly
database without a problem, and then a few that don't work
at all.
The only difference I can see is that the ones that fail have
<textarea> data and the ones that work don't.

I'm getting a:

Error Type: LexTokenError
Error Value: Lexical token not found near ::
 "s of Bloodax',\012"*"'A determined c"


What I _think_ is happening is that gadfly can't handle carriage
returns and line feeds in the string input. (Which is why I
was trying things like "virtual" to perhaps get rid of them.)

Hmmm... Actually, just tried something else, the below versions
actually work, but _only_ if you delete all linefeeds from the
textarea and let it wrap all by it's lonesome... Something I
can't guarantee my users will do.

Is there a way I can remove the carriage returns prior to 
hitting the sql? I was hoping to use some kind of formatting
command rather than trying some weird kind of _.string.sub
call.


Thanks.
Evan Gibson


(below is the demo info)


The form has fields:
Name: <input type="text" name="name:string" size="40" value=""><br>
Description: <textarea name="description:text" wrap="virtual" cols="50"
rows="5"></textarea><br>

(I've tried description with wrap=On/Off/Virtual and with and without
the :text typecasting.)


Sql is called by:
<dtml-call "item_create(item_name=name,description=description)">


Sql query has:
Arguments-   description:string name:string

insert into item_table
(name, description)
values
(<dtml-sqlvar item_name type=string>,
<dtml-sqlvar description type=string optional>)


-- 
  Evan ~ThunderFoot~ Gibson    ~ nihil mutatem, omni deletum ~
      May the machines watch over you with loving grace.

_______________________________________________
Zope maillist  -  Zope@zope.org
http://lists.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
 http://lists.zope.org/mailman/listinfo/zope-announce
 http://lists.zope.org/mailman/listinfo/zope-dev )