Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

How can I have HTML within my XML DB?

5 posts in General Discussion Last posting was on 2006-05-04 22:13:12.0Z
Chris M Posted on 2006-05-02 15:32:08.0Z
Sender: 7dd7.44577203.1804289383@sybase.com
From: Chris M
Newsgroups: ianywhere.public.mbusinessanywhere.general
Subject: How can I have HTML within my XML DB?
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <44577c3b.7ec0.1681692777@sybase.com>
X-Original-NNTP-Posting-Host: 10.22.241.42
X-Original-Trace: 2 May 2006 08:35:23 -0700, 10.22.241.42
Lines: 31
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 2 May 2006 08:35:26 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 2 May 2006 08:32:08 -0700
X-Trace: forums-1-dub 1146583928 10.22.108.75 (2 May 2006 08:32:08 -0700)
X-Original-Trace: 2 May 2006 08:32:08 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.mbusinessanywhere.general:799
Article PK: 9080

Hi,

I have a situation where I want to have some HTML within my
XML DB to assist in formatting.

For example in my XML I am sending down to MBusiness
database on the device, I have the following;
...NOTES="1) Stuff <BR>2) More Stuff <BR>3) Other Stuff"...

This is not rendered correctly as I get a "XML Parsing
Error: not well-formed" error.

I have then tried swapping the angle brackets for &lt; and
&gt; However, this simply renders as <BR> within the html
and doesn't give me any line breaks.

I have also tried CDATA as in
...NOTES="![CDATA[ 1) Stuff <BR>2) More Stuff <BR>3) Other
Stuff]]"...
although this still give me an XML Parsing Error.

Any thoughts on how to contain HTML within XML so it is
correctly interperted by the browser on our mobile device
would be greatly appreciated.

Chris

PS ->
We have MBusiness client 5.7 build 63
Windows mobile 2003 SE Version 4.21.1088
MBusiness server - 5.7 b47 Windows


Enrico Pallazzo Posted on 2006-05-02 22:31:24.0Z
From: "Enrico Pallazzo" <enricopallazzo@myway.com>
Newsgroups: ianywhere.public.mbusinessanywhere.general
References: <44577c3b.7ec0.1681692777@sybase.com>
Subject: Re: How can I have HTML within my XML DB?
Lines: 42
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2869
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2869
X-Original-NNTP-Posting-Host: vpn-dub-125.sybase.com
Message-ID: <4457de7d$1@forums-2-dub>
X-Original-Trace: 2 May 2006 15:34:37 -0700, vpn-dub-125.sybase.com
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 2 May 2006 15:34:40 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 2 May 2006 15:31:24 -0700
X-Trace: forums-1-dub 1146609084 10.22.108.75 (2 May 2006 15:31:24 -0700)
X-Original-Trace: 2 May 2006 15:31:24 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.mbusinessanywhere.general:801
Article PK: 9079

You can't and even if you could it wouldn't help. The MBA client doesn't
understand HTML, all the HTML parsing is done on the server. You need to
take your data and insert the appropriate tags into the DOM using
JavaScript.

Enrico

<Chris M> wrote in message news:44577c3b.7ec0.1681692777@sybase.com...
> Hi,
>
> I have a situation where I want to have some HTML within my
> XML DB to assist in formatting.
>
> For example in my XML I am sending down to MBusiness
> database on the device, I have the following;
> ...NOTES="1) Stuff <BR>2) More Stuff <BR>3) Other Stuff"...
>
> This is not rendered correctly as I get a "XML Parsing
> Error: not well-formed" error.
>
> I have then tried swapping the angle brackets for &lt; and
> &gt; However, this simply renders as <BR> within the html
> and doesn't give me any line breaks.
>
> I have also tried CDATA as in
> ...NOTES="![CDATA[ 1) Stuff <BR>2) More Stuff <BR>3) Other
> Stuff]]"...
> although this still give me an XML Parsing Error.
>
> Any thoughts on how to contain HTML within XML so it is
> correctly interperted by the browser on our mobile device
> would be greatly appreciated.
>
> Chris
>
> PS ->
> We have MBusiness client 5.7 build 63
> Windows mobile 2003 SE Version 4.21.1088
> MBusiness server - 5.7 b47 Windows


Chris M Posted on 2006-05-03 07:29:15.0Z
Sender: 1f15.44585adc.1804289383@sybase.com
From: Chris M
Newsgroups: ianywhere.public.mbusinessanywhere.general
Subject: Re: How can I have HTML within my XML DB?
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <44585bcb.1f1d.1681692777@sybase.com>
References: <4457de7d$1@forums-2-dub>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 3 May 2006 00:29:15 -0700
X-Trace: forums-1-dub 1146641355 10.22.241.41 (3 May 2006 00:29:15 -0700)
X-Original-Trace: 3 May 2006 00:29:15 -0700, 10.22.241.41
Lines: 46
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.mbusinessanywhere.general:802
Article PK: 17799

Thanks for your reply Enrico. I think we will just have to
work out some other way to display our list of items :(

Chris

> You can't and even if you could it wouldn't help. The MBA
> client doesn't understand HTML, all the HTML parsing is
> done on the server. You need to take your data and insert
> the appropriate tags into the DOM using JavaScript.
>
> Enrico
>
> <Chris M> wrote in message
> > news:44577c3b.7ec0.1681692777@sybase.com... Hi,
> >
> > I have a situation where I want to have some HTML within
> > my XML DB to assist in formatting.
> >
> > For example in my XML I am sending down to MBusiness
> > database on the device, I have the following;
> > ...NOTES="1) Stuff <BR>2) More Stuff <BR>3) Other
> Stuff"... >
> > This is not rendered correctly as I get a "XML Parsing
> > Error: not well-formed" error.
> >
> > I have then tried swapping the angle brackets for <
> > and > However, this simply renders as <BR> within the
> > html and doesn't give me any line breaks.
> >
> > I have also tried CDATA as in
> > ...NOTES="![CDATA[ 1) Stuff <BR>2) More Stuff <BR>3)
> > Other Stuff]]"...
> > although this still give me an XML Parsing Error.
> >
> > Any thoughts on how to contain HTML within XML so it is
> > correctly interperted by the browser on our mobile
> > device would be greatly appreciated.
> >
> > Chris
> >
> > PS ->
> > We have MBusiness client 5.7 build 63
> > Windows mobile 2003 SE Version 4.21.1088
> > MBusiness server - 5.7 b47 Windows
>
>


Greg Fenton Posted on 2006-05-03 13:44:16.0Z
From: Greg Fenton <greg.fenton_NOSPAM_@ianywhere.com>
Organization: iAnywhere Solutions Inc.
User-Agent: Thunderbird 1.5.0.2 (Windows/20060308)
MIME-Version: 1.0
Newsgroups: ianywhere.public.mbusinessanywhere.general
Subject: Re: How can I have HTML within my XML DB?
References: <4457de7d$1@forums-2-dub> <44585bcb.1f1d.1681692777@sybase.com>
In-Reply-To: <44585bcb.1f1d.1681692777@sybase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: gfenton-xp.sybase.com
X-Original-NNTP-Posting-Host: gfenton-xp.sybase.com
Message-ID: <4458b3b0$1@forums-1-dub>
Date: 3 May 2006 06:44:16 -0700
X-Trace: forums-1-dub 1146663856 10.25.98.184 (3 May 2006 06:44:16 -0700)
X-Original-Trace: 3 May 2006 06:44:16 -0700, gfenton-xp.sybase.com
Lines: 15
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.mbusinessanywhere.general:803
Article PK: 17803


Chris M wrote:
> Thanks for your reply Enrico. I think we will just have to
> work out some other way to display our list of items :(

Well, one possible approach if you are looking to move down raw HTML is
to use ULPod (UltraLite) instead of the XML database.

greg.fenton
--
Greg Fenton
Consultant, Solution Services, iAnywhere Solutions
--------
Visit the iAnywhere Solutions Developer Community
Whitepapers, TechDocs, Downloads
http://www.ianywhere.com/developer/


Christopher Grim Posted on 2006-05-04 22:13:12.0Z
User-Agent: Microsoft-Entourage/11.2.3.060209
Subject: Re: How can I have HTML within my XML DB?
From: Christopher Grim <chrisgrim@hotmail.com>
Newsgroups: ianywhere.public.mbusinessanywhere.general
Message-ID: <C07FCAC8.1D03%chrisgrim@hotmail.com>
Thread-Topic: How can I have HTML within my XML DB?
Thread-Index: AcZvyBTQU4jXztu7Edq2oAAKJ5RAAg==
References: <4457de7d$1@forums-2-dub> <44585bcb.1f1d.1681692777@sybase.com> <4458b3b0$1@forums-1-dub>
Mime-version: 1.0
Content-type: text/plain; charset="US-ASCII"
Content-transfer-encoding: 7bit
X-Original-NNTP-Posting-Host: macgrimreaper.sybase.com
X-Original-Trace: 4 May 2006 15:13:25 -0700, macgrimreaper.sybase.com
Lines: 37
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 4 May 2006 15:13:28 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 4 May 2006 15:13:12 -0700
X-Trace: forums-1-dub 1146780792 10.22.108.75 (4 May 2006 15:13:12 -0700)
X-Original-Trace: 4 May 2006 15:13:12 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.mbusinessanywhere.general:805
Article PK: 9081

Ulpod will allow you to send HTML, but as Enrico pointed out, the client
doesn't understand raw HTML. However, what you are trying to do is pretty
straight forward to do with JavaScript and the DOM. For example, embed the
list items in a field with a delimiter like "|":

"Stuff|More Stuff|Other Stuff"

The have a JavaScript function (pardon my stream of consciousness syntax)
that splits in into an array and loops through to add the nodes to the DOM:

Var textNode = document.getElementById("notes");
var st = "Stuff|More Stuff|Other Stuff;
var ar = st.split("|");
var notes = "";
For (x=0;x<ar.length;x++) {
textNode.innerText += (x+1).toString() + " " + ar[x].value;
// insert child node <br>
}


Hope that helps,

Chris...

On 5/3/06 6:44 AM, in article 4458b3b0$1@forums-1-dub, "Greg Fenton"

<greg.fenton_NOSPAM_@ianywhere.com> wrote:

> Chris M wrote:
>> Thanks for your reply Enrico. I think we will just have to
>> work out some other way to display our list of items :(
>
> Well, one possible approach if you are looking to move down raw HTML is
> to use ULPod (UltraLite) instead of the XML database.
>
> greg.fenton