Infopath, rich-text box, and SQL database

D

David

i've created a form template with some text boxes and a couple of rich-text
boxes in it because I would like to write technical articles in Infopath and
then send them to a SQL Server database.

Do you have any positive or negative experience with my scenario?

I hesitate if I should store the article as an XML column in the database,
or maybe fill in a row with columns of String datatype (one for each section
of the article) What's better? Take into account that my article would be in
HTML (bold, lists, etc.) so this is why I'm using a rich-text box. My
intention is to use the database to drive a website (probably written in
ASP.net).

Thank you,
 
D

David

Thanks, I've seen the source code of my filled form and it is something like this:

....
<my:section1>
<div xmlns="....">First paragraph</div>
<ol xmlns="...">
<li>Element1</li>
.....
</ol>
</my:section1>
....

Is it possible to manipulate the embedded XHTML using a .xslt or from Infopath?. I don't understand why Infopath adds so many references to "http://www.w3.org/1999/xhtml". When I see the source code of practically all the pages on the Internet I don't see those references other than in the <html> tag.

I want something like this:

<p>Paragraph</p>
<ol>
<li>Element1</li>
</ol>

With <p> tags to delimit paragraphs and without references to the xhtml prefix (there is already a reference in the <html> tag).

Thank you,
 
S

S.Y.M. Wong-A-Ton

I'm not sure what kind of solution you have in mind, but what you could do is
make that namespace the default namespace, so add it to the my:myFields node
(root node), and then you can remove it from the rest of the nodes. You
should be able to use XML objects to do this programmatically. Not sure how
to do it using XSLT.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Clearing combo boxes and a text box 2
Creating a Search using a combo box and then creating a report. 4
Need help removing extra TOC text from number lists used as TOC levels 0
Rich Text Box 1
Link a text box based on drop down box with four options MS Word 365 0
Rich text from sql database 1
Rich Text Boxes 2
Word OLE to check spelling in text box 1

Top