XML / XSL

MS Access to oracle thro XML . How to do it

10-Mar-05 2:03

hi,

your XML is not even valid! According to XML spec.[^] you have to escape & as "&", or write it only in CDATA or comment.

In .Net Framawork, you can use

<a href="http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/frlrfsystemwebhttpserverutilityclasshtmlencodetopic1.asp">HttpServerUtility.HtmlEncode</a>[<a target=_blank title='New Window' href="http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/frlrfsystemwebhttpserverutilityclasshtmlencodetopic1.asp">^</a>]

from System.Web namespace.

Solution in our case is something like

tmp_Message = System.Web.HttpServerUtility.htmlEncode("Joe&&&&&&&&&&&redroom");

vinu.netguy wrote:
can i get any function to check, if a given string is a proper xml or not in C#

AFAIK you have to write your own.

best regards,
David 'DNH' Nohejl

Never forget: "Stay kul and happy" (I.A.)

XML Error..

vinu.netguy9-Mar-05 20:41

vinu.netguy

9-Mar-05 20:41

Hi XML buddies,

I had an xml like "<pu><name>Joe&&&&&&&<age>redroom"

when i am tried with the code in c# as,
1.
tmp_Message = "<pu><name>Joe&&&&&&&&&&&<age>redroom";
XmlDocument xXD = new XmlDocument();
xXD.LoadXml(tmp_Message);

it is throwing error.

2.
can i get any function to check, if a given string is a proper xml or not in C#

please..... help me ..!!!! in solving this error.

regards,
vinu

Member 17406158-Mar-05 7:48

Member 1740615

8-Mar-05 7:48

I want to convert MS Access database to Oracle & an xml file should b created in the converion process . So the process should b MS Access ---> XMl ---> Oracle. Can some 1 giv the code in vb.net .

Best performance binary encoding

GuimaSun8-Mar-05 7:39

GuimaSun

8-Mar-05 7:39

Do exist a better way to encode binary data inside XML than using base64 ?
I need to encode binary data from Visual C++ 6.0 environment.

Thanks for any help Smile | :)

GuimaSun
www.nexsun.com.br
NEXSUN TechZone

Process XML from inside XML

Adam Gritt7-Mar-05 7:51

Adam Gritt

7-Mar-05 7:51

I am having an issue. I need to perform an xslt on an xml document however the document contains xml encoded inside the xml (see sample below). I need to know how to pull out the inner xml so I can parse it from inside an xslt transform. Any help is greatly appreciated.

(code)

<?xml version="1.0" encoding="utf-8" ?>
<Thomson.Financial.T1Link.APIResponse>
<Variable Name="_result" Value="<ALL_RESULTS request="10054"><SEQUENCE id="1"><BETALink_XMLResponse><HeaderInfo RecordCount="1" /><Warnings /><Data><row><BetaLinkUserId>895288</BetaLinkUserId><FirmNo>990</FirmNo><SubNo>990</SubNo><EntityKey>39172390-D9FC-4B4D-9744-8B168F0B3842</EntityKey></row></Data></BETALink_XMLResponse></SEQUENCE></ALL_RESULTS>" Value_Type="System.String" />
<Variable Name="_errors" Value="<ALL_RESULTS request="10054"><SEQUENCE id="1"></SEQUENCE></ALL_RESULTS>" Value_Type="System.String" />
<Variable Name="_warnings" Value="<ALL_RESULTS request="10054"><SEQUENCE id="1"><Warnings /></SEQUENCE></ALL_RESULTS>" Value_Type="System.String" />
</Thomson.Financial.T1Link.APIResponse>

(/code)

Phil Hobgen7-Mar-05 20:25

7-Mar-05 20:25

Hi,

As it appears here, your xml is not valid. The "<" character cannot appear within an atribute value, unless you escape it as < Also you have " charaters embedded within an attribute value that uses the same " character to enclose the attribute value, you could escape the inner quotes as "

You need to fix the xml before you can look at the xslt. Are you able to change the xml structure?

If the attribute must contain xml, then you will have to escape the appropriate characters, after that you will be able to use the value-of element to retrieve the escaped xml. At that point, I guess you would need to 'un-escape' it.

Sounds complicated...

Good Luck,

Cheers

Phil Hobgen
barbari.co.uk
Southampton, UK

DavidNohejl8-Mar-05 9:23

8-Mar-05 9:23

Phil (barbari) wrote:
As it appears here, your xml is not valid.

Didn't he write "the document contains xml encoded inside the xml". I'd guess it is escaped. But my English is self-thought ( in computer terminology), so word "encode" has only one meaning to me ... Smile | :)

Phil (barbari) wrote:
You need to fix the xml before you can look at the xslt.

Phil (barbari) wrote:
Sounds complicated...

agree. I think it's plain bad xml structure. I'd move "inner" xml out of attribute. Attributes are not meant to contain hierarchical things... Use them for atomic data seems the best way to me. I'd move that xml to CDATA element inside current variable or what element is was.

other ideas?

David

Never forget: "Stay kul and happy" (I.A.)

Phil Hobgen8-Mar-05 10:20

8-Mar-05 10:20

Hi,

dnh wrote:
Didn't he write "the document contains xml encoded inside the xml". I'd guess it is escaped. But my English is self-thought ( in computer terminology), so word "encode" has only one meaning to me ...

You're probably right. D'Oh! | :doh:

I must admit to having been somewhat surprised to see xml like that.

dnh wrote:
other ideas?
Not really. If the xml structure can be changed then a CDATA section sounds like just the right approach.

Cheers

Phil Hobgen
barbari.co.uk
Southampton, UK

DavidNohejl8-Mar-05 9:24

8-Mar-05 9:24

see http://www.codeproject.com/script/comments/forums.asp?forumid=3421&select=1055340&df=100#xx1055340xx[^]

Never forget: "Stay kul and happy" (I.A.)

Phil Hobgen8-Mar-05 12:08

Passing XmlDocument from VB .NET to VC++

8-Mar-05 12:08

Hi,

Having a bit more of a think....

If you are working to a schema, and the format of the xml currently in Value is not clearly definable then, if you can change the schema, you could just use an xs:any element (with maxOccurs="unbounded") to define the nested xml but place it within the Variable element.
If there is no schema then you could just move the xml as above anyway, with no worries about schema changes.
So there is no need for a CDATA section really.
Of course in either case you may be exchanging this data with someone else, who you may or may not be able to get agreement with Smile | :)

If you can't move the 'encoded' xml, and presuming it is all properly escaped, I think maybe the place to start is to select the Value attribute into a variable. This would contain a tree fragment that you can perform all the usual xslt stuff on. For instance you could set up a template with a match of ALL_RESULTS, you could call the template with apply-templates with a select on the variable you have created. If that doesn't work then perhaps you could pass the variable into a param of the template and process it that way.

I dont think it matters that the source for the variable is text containing < as opposed to < etc, the xslt processor can't tell the diference, I think Big Grin | :-D

Sorry I dont have time to test out the theory - I would be interested to hear how you get this to work..

Cheers

Phil Hobgen
barbari.co.uk
Southampton, UK

alfonx28-Feb-05 9:00

alfonx

28-Feb-05 9:00

Hi,

I tested some code but have no clue how to communicate XMLDocument (DOM) to C++ DLL.
Basically, I have xml files parsed and encapsulated in XmlDocument class in VB NET.
Aside, I have a C++ DLL that expects Xml Documents. I work in C++ with MSXML2::IXMLDOMDocument2 class. Maybe it is caused by non matching classes (VB versus VC++), but have no clue to handle the problem.

Many thanks for your help,

Alx

--

Page Header/Footer in HTML

dotnetquery27-Feb-05 20:18

27-Feb-05 20:18

Is there a way to put Page Header and Footer in an HTML file. Whie viewing the file it may or may not be displayed, but while printing it should be displayed on each and every page. How to do it. PLease if any suggesstions.

Phil Hobgen28-Feb-05 8:10

28-Feb-05 8:10

Hi,

This is really something that you probably need to do using CSS, with an alternate stylesheet - CSS2 has some support for print layout and there are moves to improve on this, but I'm not sure what the current browsers support.

You could do it with XSLT (if your source is XML), and generate different pages for browsing/printing, but this would be v. complex I suspect. You could even use XSLF for generating a PDF for strict layour printing, I would think this can get even more complex. Unless you're really in to XSL ....

I think your best bet is to have a search for articles on css printing.

Cheers

Phil Hobgen
barbari.co.uk
Southampton, UK

DavidNohejl28-Feb-05 8:17

28-Feb-05 8:17

hi there,
I seriously doubt there is CSS support for this. Wait for CSS3 Wink | ;)

Well, assuming you have similar structure for all your pages (let say it starts with paragraph of CSS class MyP), you can easily specify something like

<br />
@media print {<br />
 MyP:before{<br />
    content:'header';<br />
    position:absolute;<br />
    left:0;<br />
    top:0;<br />
    }<br />
}<br />

For details look at w3c.org...
hope it helps
David

Never forget: "Stay kul and happy" (I.A.)

dotnetquery28-Feb-05 21:36

28-Feb-05 21:36

Hi,

Thnaks for ur valuable guidance. But I am currently using IE-6 and I am trying out something like:

<style type="text/css">
@page
{
margin: 10%;
@page-top
{
margin-right: 5%;
text-align: right;
content: "Header";
}
}
</style>

Now I want that this text "<b>Header</b>" should be printed as header on each and every page as header. Now do we need to say class="@page" or something like that to apply this style sheet. Help.

DavidNohejl2-Mar-05 0:38

2-Mar-05 0:38

hi,

dotnetquery wrote:
But I am currently using IE-6
D'Oh! | :doh:

I start to think that I completely misunderstood your problem... Are you talking about same header & footer as where IE shows page number, filename etc.? AFAK that's not HTML or CSS thing... I guess it's browser feature... Possibly there is script / ActiveX or something... quick Google search found this[^]

keep your eye on this thread[^]

As for your CSS style, there is CSS that appears to work for me (in FF)- it should add text to the beginning of every page... anyway I don't know if this is what you are looking for. Nevermind, IE appereantly does NOT support it Cry | :((

<style type="text/css">

     body:before
    {
      content: "Header";
      font-weight:bold;
      position:absolute;
      left:0;
      top:0;
    }
</style>

best regards,
David

Never forget: "Stay kul and happy" (I.A.)

dotnetquery2-Mar-05 1:41

2-Mar-05 1:41

Hi,

I tried implementing this code in my file containing a table with data spanning two pages. But when I tried to view the print preview of it, it showed me header only on the first page and not every page. If I modify the tag as body:after, the text moves to the last after the table gets finished and not on every page. Also is it possible to modify the text that we can modify from page setup, with the help of scripts or ActiveX. Also I want to have images as Headers and footers instead of text.

DavidNohejl2-Mar-05 2:18

2-Mar-05 2:18

dotnetquery wrote:
I tried implementing this code in my file containing a table with data spanning two pages. But when I tried to view the print preview of it, it showed me header only on the first page and not every page. If I modify the tag as body:after, the text moves to the last after the table gets finished and not on every page

yeah, that's actually expected result Blush | :O

As I admited in last post, I misunderstood your intention.. was more thinking about web page footer (page= like file/document) and missed part "should be displayed on each and every page." IMO that's not job for current CSS.

dotnetquery wrote:
Also is it possible to modify the text that we can modify from page setup, with the help of scripts or ActiveX.

I belive it is. try google or MSDN, since we are talking about IE features here. I don't have experiences with it Frown | :(

dotnetquery wrote:
Also I want to have images as Headers and footers instead of text.

OMG | :OMG:

Have you seen it somewhere? I doubt it is possible...
I still don't have a clear picture of what you are doing, maybe you should consider other formats then HTML...

p.s you see that? two more posts and we'll get 2000th Cool | :cool:

David

Never forget: "Stay kul and happy" (I.A.)

Abuhijleh5-Mar-05 23:24

Abuhijleh

5-Mar-05 23:24

You can do that with CSS2
you have to use the media type, Define a media type of 'Print' for the header and footer and set visibility: none

you can find a full details http://www.w3schools.com/css/css_mediatypes.asp

clickety police

DavidNohejl6-Mar-05 1:35

Display Image from XML source

6-Mar-05 1:35

clickety[^]

Also, I got impression that he wants to set header/footer like IE does - you know, place where is url and page title etc. - visible in page preview mode.

sorry, I had to steal 2000th post:->

David

Never forget: "Stay kul and happy" (I.A.)

dotnetquery27-Feb-05 18:13

Re: Display Image from XML source

27-Feb-05 18:13

Hi All,

I am trying to display an image in an HTML page by inserting an IMG tag and specifying the SRC attribute in it. Now the source of the image is specified in the XML file but in the format

url('http://www.somewebsite/image/myimage.jpg')

now when I tried to insert the value of the element from the XML file it gdoes not displayes the image as it does not recognises the url keyword. I also tried it with style="behaviour:url('')" but it is not working. Is it possible to display the image.

Phil Hobgen28-Feb-05 8:38

Re: Display Image from XML source

28-Feb-05 8:38

Hi,

If you are saying that you have some xml that is a bit like either :
<sometag>url('http://www.somewebsite/image/myimage.jpg')</sometag>
or :
<sometag someattr="url('http://www.somewebsite/image/myimage.jpg')" />

If you are using XSLT then you could trim the outer parts of the string using a combination of string functions from: string-length(), substring(), substring-before(), and substring-after()
or maybe just two consecutive calls to translate() would do it.

You could just output the value of whats left over into the src attribute

This probably isn't very efficient (string functions), if you have to do it a lot, but if thats whats in the xml you might have to resort to something like this.

Cheers

Phil Hobgen
barbari.co.uk
Southampton, UK

dotnetquery28-Feb-05 18:14