InfoPath 2003: Error with Rich Text Field

D

Daniel Brown

Hi all,

I’m having a spot of trouble with a InfoPath form I am working on.

First, ill give some background info of what I’m trying to do.

What this form does, is retrieve data from various sources (mainly
SharePoint and SQL server) and displays the info all nice and neatly on the
InfoPath form.

The Data is read out of a database and into a rich text field (with some
script to copy the data from the source to the control). This works fine.

However, with saving, the issue lies.

When I save 90% of my records, they save fine, no issues, no stray html, all
is fine.

However the remaining 10% return with some funkiness.

On some records I get the following error:

"You have error A string literal was expected, but no opening quote
character was found."

and for whatever reason I cannot find what is causing this error.

On other records, the text saves fine, however, when i go back into the form
and load up their data, the following appears


Geological and geophysical studies and PPL application documentation for
Dorodillo, Muscat, Keena, Wirrarie/Caladan, Wooloo, Shiraz, Kirralee,
Atreides, Grenache, Waukatanna, Touriga and Trebbiano fields, including HIP
review
5) Member of Technical Limit Team, Nov. 2000-May 2001
G&G representative team commissioned to improve spud to online time for SABU
development wells
<div xmlns='http://www.w3.org/1999/xhtml'> </div> <div
xmlns='http://www.w3.org/1999/xhtml'>6) Member of TeamLink Peer Assist
Team</div> <div xmlns='http://www.w3.org/1999/xhtml'> </div> <div
xmlns="http://www.w3.org/1999/xhtml">Pre-Santos experience:</div> <div
xmlns="http://www.w3.org/1999/xhtml"> </div> <div
xmlns="http://www.w3.org/1999/xhtml">1) 1990-1998 Chevron Europe:</div> <div

note: I cut this timed from the start ad end for this post. Also note that
this is not the source of the text box, this is what is actually displayed IN
the textbox as plain text.

If needs be I can post the data which I use and anything else required. This
is a real tricky one and I’m going bald with stress and ripping out my hair
trying to figure out what is the problem.

Any help would be greatly appreciated!

Regards,

Daniel Brown
 
S

S.Y.M. Wong-A-Ton

Check whether the data for the records that are failing contain a single
quote (') anywhere in the text.
 
A

Agnihotram

Hello Daniel,
When setting any data to a rich text field you need first verify if the data
that you are setting is a valid "XML". Other wise you will the see the issues.
 

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

Top