The problem here is the text pasted from MS Word IS NOT pure
text. It is binary as well as text. On the upload, it goes
in the DB fine. When retrieved and sent to HTML, it barfs on
the binary stuff imbedded within the MS Word content. You
can scrub all the binary stuff you don't want, but the user
might not be happy. The way MS word creates the bullet is
binary. So the scrubbed text will ose the bullets.
John Caputo
johnjc surewest.net
---- Original message ----
>Date: Fri, 18 Jul 2008 14:55:28 -0800
>From: "Raymond De Bruyn" <rdebruynsympatico.ca>
>Subject: RE: Scrubbing user inputs
>To: Multiple recipients of list ODTUG-WEBDEV-L
<ODTUG-WEBDEV-Lfatcity.com>
>
> It's hard to tell what's happening without code, but
I assume you are getting a
> successful post and are failing on the redirect. I
work in PLSQL Web Toolkit
> every day and my code for submit is typically:
>
> initialize
>
> perform dml operations
>
> owa_util.redirect_url
>
> If this is what you're doing try commenting out the
owa_util.redirect_url and
> just do an htp.p of the url you've built. Run the
form with a pasted value
> you've identified as causing the error. Then look at
the url provided.
>
> At one point we had a form that echoed all parameters
back to the original form
> when the dml failed. It worked ok unless the user
added too much text to the
> comments field. The URL built was too long and
failed. It seems you can go to
> about 1500 characters before the URL fails.
>
> Since you had a PLSQL error, you may be doing an
encode URL that's throwing the
> error.
>
> Hope this helps,
> Ray
>
>
------------------------------------------------------------
----------------
>
> Hello all,
>
>
>
> I’ve built a simple html form using the pl/sql
web toolkit that has a place
> for the user to include comments.
>
> It’s been in production for months if not years.
>
>
>
> Recently, we’ve experienced errors related to the
content of the comments
> and I’ve traced it to users cutting and pasting
content from MS Word
> directly into the web form comments field.
>
> Even that is fine except for when the user attempts
to paste in bullets.
>
>
>
> I’ll have to handle this on the client-side. Any
ideas?
>
>
>
>
>
> Regards,
>
>
>
> Monty
>
> -- For more information on this topic or to become a
member, visit our Web site
> at http://www.ODTUG.com Join
ODTUG for The PL/SQL and The APEX Expert Gathering
> of the Year! OPP2008 and APEXposed! 2008 will be held
on October 29-30, 2008 at
> the Wyndham O'Hare, Chicago. Visit www.odtugopp.com
or www.odtugapextraining.com
> for more details. -- Author: Raymond De Bruyn INET:
rdebruynsympatico.ca Fat
> City Hosting, San Diego, California -- http://www.fatcity.com
>
------------------------------------------------------------
--------- To REMOVE
> yourself from this mailing list, send an E-Mail
message to: ListGurufatcity.com
> (note EXACT spelling of 'ListGuru') and in the
message BODY, include a line
> containing: UNSUB ODTUG-WEBDEV-L (or the name of
mailing list you want to be
> removed from). You may also send the HELP command for
other information (like
> subscribing).
--
For more information on this topic or to become a member,
visit our Web site at http://www.ODTUG.com
Join ODTUG for The PL/SQL and The APEX Expert Gathering of
the Year! OPP2008 and APEXposed! 2008 will be held on
October 29-30, 2008 at the Wyndham O'Hare, Chicago. Visit
www.odtugopp.com or www.odtugapextraining.com for more
details.
--
Author: John Caputo
INET: johnjcsurewest.net
Fat City Hosting, San Diego, California -- http://www.fatcity.com
------------------------------------------------------------
---------
To REMOVE yourself from this mailing list, send an E-Mail
message
to: ListGurufatcity.com (note EXACT spelling of 'ListGuru') and
in
the message BODY, include a line containing: UNSUB
ODTUG-WEBDEV-L
(or the name of mailing list you want to be removed from).
You may
also send the HELP command for other information (like
subscribing).
|
