This is Interesting: Free Magazines for Graphics designers and webmasters  


Home > Archive > Microsoft XML > March 2005 > Data Binding Question





You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author Data Binding Question
gadrin7@aol.com

2005-03-25, 6:34 pm

I saw an article that shows how to bind XML on an HTML page into a
table. Great. It works and I understand it.

It also mentioned that you could bind the attribute values of a node to
display. However I couldn't get it to work. (no examples of course.)

Is that correct ?

if the XML looks like:
<root>
<node name="Joe Blow" age="27" />
<node name="Jim Smith" age="37" />
<node name="Jon White" age="26" />
</root>

how to bind the attribute values into an HTML table?

Joe Fawcett

2005-03-25, 6:34 pm

<gadrin7@aol.com> wrote in message
news:1111779417.050512.239060@g14g2000cwa.googlegroups.com...
>I saw an article that shows how to bind XML on an HTML page into a
> table. Great. It works and I understand it.
>
> It also mentioned that you could bind the attribute values of a node to
> display. However I couldn't get it to work. (no examples of course.)
>
> Is that correct ?
>
> if the XML looks like:
> <root>
> <node name="Joe Blow" age="27" />
> <node name="Jim Smith" age="37" />
> <node name="Jon White" age="26" />
> </root>
>
> how to bind the attribute values into an HTML table?
>

The data provider doesn't understand attributes directly. The above is turned
into a tabular element style form:
<root>
<node><name>Joe Blow</name><age>27</age></node>
....
</root>

--

Joe (MVP - XML)

https://mvp.support.microsoft.com/p...E8-8741D22D17A5



gadrin7@aol.com

2005-03-25, 11:18 pm

so the article/help file I read was just being, uh, *generous* in its
claims ? ;)

well that doesn't do me any good.

thanks for your help.

Joe Fawcett

2005-03-26, 7:18 am

<gadrin7@aol.com> wrote in message
news:1111795057.903259.150600@z14g2000cwz.googlegroups.com...
> so the article/help file I read was just being, uh, *generous* in its
> claims ? ;)
>
> well that doesn't do me any good.
>
> thanks for your help.
>

No you can do it sometimes, try this article (I was looking for this last night
but couldn't find it):
http://www.creativyst.com/cgi-bin/Y...=display&num=23

and this:

http://www.creativyst.com/Doc/Artic...lT/XMLhtmlT.htm


--

Joe (MVP - XML)

https://mvp.support.microsoft.com/p...E8-8741D22D17A5


gadrin7@aol.com

2005-03-26, 6:46 pm

ok, very interesting.

the only problem using $Text that I see, is that my nodes have more
than one attribute.

I"m wondering if this will work on an ADO recordset that's persisted to
XML. Only one way to find out!

You wouldn't happen to know if there's an XSL or XSLT or DOM method of
converting ADO persisted XML to Excel 2003 XML? (in either version).

Anyway thanks for your time and patience.

Joe Fawcett

2005-03-29, 7:29 am

<gadrin7@aol.com> wrote in message
news:1111859954.118429.92430@o13g2000cwo.googlegroups.com...
> ok, very interesting.
>
> the only problem using $Text that I see, is that my nodes have more
> than one attribute.
>
> I"m wondering if this will work on an ADO recordset that's persisted to
> XML. Only one way to find out!
>
> You wouldn't happen to know if there's an XSL or XSLT or DOM method of
> converting ADO persisted XML to Excel 2003 XML? (in either version).
>
> Anyway thanks for your time and patience.
>

I don't know if there's a built in method, you could write your own
transform. Maybe better to ask in one of the Excel groups.

--

Joe (MVP - XML)

https://mvp.support.microsoft.com/p...E8-8741D22D17A5


Sponsored Links


Copyright 2003 - 2008 forum4designers.com  Software forum  Computer Hardware reviews