I have $escmode = 7 and $optRawInput = 1.
now, that seems to fix the issue i was having with saveing the format of the
input string. now, if I have a statement such as this: This could not be a
good "TEST", life is good, the double quotes are saved into the database and
when i bring the record back from the database i can see the double quotes
on the screen.
But, if i have a statement such as this: This couldn't be a good "TEST",
life is bad. I get a DB error. I am using straight DBI:
$fdat{'incident.logged_datetime'} =
"TO_DATE('$fdat{'incident.logged_datetime'}','MM/DD/YYYY HH24:MI:SS')";
$sql = "INSERT INTO incident (incident.q2, incident.logged_datetime)
VALUES
('$fdat{'incident.q2'}',$fdat{'incident.logged_datetime'})";
$dbh = GetDSN();
$dat = $dbh->prepare($sql);
$dat->execute;
....
-----Original Message-----
From: Gerald Richter [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 23, 2001 11:01 PM
To: Boyd, David; EmbPerl News Group (E-mail)
Subject: Re: Help working with html, embper, and oracle
>
> i would like for the user to be able to enter single and double quotes and
> carrage returns in these areas. basically save the formatting.
> ...
Unless you have set escmode to a different value Embperl should handle this
correctly for you. Please verify the value of $escmode (e.g. insert [+
$escmode +] before your textbox). It should be set to 3 (the default)
Gerald
-------------------------------------------------------------
Gerald Richter ecos electronic communication services gmbh
Internetconnect * Webserver/-design/-datenbanken * Consulting
Post: Tulpenstrasse 5 D-55276 Dienheim b. Mainz
E-Mail: [EMAIL PROTECTED] Voice: +49 6133 925131
WWW: http://www.ecos.de Fax: +49 6133 925152
-------------------------------------------------------------
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
