Hi,
I am not able to save rich text (htm tag) to the database. when i save textfield-rich text content to database, it is getting saved as plain text but not as rich text.
when i make select statement from the table. I am getting Plain text but not rich text.
this could be variable mismatch. I have mapped text field rich content to Text variable type column. Please let me know what do i do to store the mapped rich text to database.
following commands i used..
CREATE TABLE fordEformTC4
(
eformName VARCHAR(25),
Fr1Value TEXT,
Fr2Value TEXT,
Fr3Value TEXT
);
I am trying to put below content to column Fr1Value
<?xml version="1.0" encoding="UTF-8" ?>
- <TextField1 type="text">- <body xmlns="http://www.w3.org/1999/xhtml">- <p style="margin-top:0pt;margin-bottom:0pt;text-valign:middle;text-align:justify;font-family:'Myriad Pro';font-size:10pt;font-weight:bold;text-decoration:none"> Problem <span style="font-weight:normal">in Storing Text in Database</span> </p>
</body>
</TextField1>
when i retrieve the xml from the database, i see plain text ...
<?xml version="1.0" encoding="UTF-8"?>
<form1>
<Page1>
<TextField1 type="text">Problem in Storing Text in Database</TextField1>
</TextField1>
</Page1>
</form1>
Please let me know what is the issue. What mistake i am doing in my designing.
Regards
Sunil
