nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

inline - fetching data from database

vanesh

Iam calling an inline command for getting some DB data and trying to populate a drowpdown in a metadata datacapture form. The callout works fine and iam able to fetch data and fill the drop down with the values.

But in some cases it fails when the data in the table contains special charecters like '&', '<' and '>'
Instead of populating the dropdown I'm getting this error:

Templating Error Page
"There was a problem with metadata capture configuration. Please contact your system administrator."

Can anyone help me how to overcome this problem.

Thanks in advance

Vanesh

Teamsite 6.1/UNIX

Find more posts tagged with

Comments

gzevin

MDCT is an XML file. so, one should always remember to encode necessary entities, especially the characters that you are mentioning as they are breaking underlying XML.

Your <substritution> lines should also produce valid XML

Greg Zevin, Ph.D. Comp. Sc.
Independent Interwoven Consultant/Architect
Sydney, AU

vanesh

Hi Greg,

Thanks for the reply !

Is there any functions to encode the entities ? please let me know.

Vanesh

jbonifaci

You could use CGI::escapeHTML() or TeamSite::CGI_lite->escape_html_data().

~Jeff

gzevin

or HTML::Entities

Greg Zevin, Ph.D. Comp. Sc.
Independent Interwoven Consultant/Architect
Sydney, AU

vanesh

Thanks for your inputs. I tried the soultions you suggested and it works fine.

Regards,
Vanesh

rodigz

SAX Parse:The entity name must immediately follow the '&' in the entity reference.

hmm weird I already use use HTML::Entities;

vanesh?