|
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 .
|
|
|
|
|
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 
GuimaSun
www.nexsun.com.br
NEXSUN TechZone
|
|
|
|
|
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)
|
|
|
|
|
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
|
|
|
|
|
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 ...
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.)
|
|
|
|
|
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.  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
|
|
|
|
|
|
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
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 
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
|
|
|
|
|
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
--
|
|
|
|
|
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.
|
|
|
|
|
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
|
|
|
|
|
hi there,
I seriously doubt there is CSS support for this. Wait for CSS3  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.)
|
|
|
|
|
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.
|
|
|
|
|
hi,
dotnetquery wrote:
But I am currently using IE-6
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 
<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.)
|
|
|
|
|
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.
|
|
|
|
|
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  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 
dotnetquery wrote:
Also I want to have images as Headers and footers instead of text.
 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 
David
Never forget: "Stay kul and happy" (I.A.)
|
|
|
|
|
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[^]
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.)
|
|
|
|
|
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.
|
|
|
|
|
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
|
|
|
|
|
Thanks Phil,
It worked. Thanks a lot for this.
|
|
|
|
|
The scheme, which is out in a file, can be redefined by the XML document itself. I guess what unsettles me about this is it allows the sender to redefine what is valid. My database may not be able to store the additional properties added by the redefined scheme, but both the sending parser and receiving parser will accept the new properties because embedded in the XML document is a redefine section. I have no control over what the sender may redefine.
Am I misunderstanding something here? Is this a good thing?
thanks
|
|
|
|
|
I have a project for someone familiar with using XML Native Databases. I need to extract data from an XML file that drives one piece of equipment and insert it into an existing TXT file that drives another piece of equipment. Both files are generated simulatneously by my design software to drive competing pieces of equipment but the XML file is richer and has more data. Is this the appropriate forum to find a programmer who might be interested in completing this project?
Steve Bumbalough
WallPanelDesign,LLC
|
|
|
|
|
HOW to get start with xml parser.
|
|
|
|
|
Google?
Now seriously. Do you want to write your own parser or use some already created parser? If first one is the case, read up about parsers... e.g. here on CP like http://www.codeproject.com/cpp/yard-xml-parser.asp[^] or others. You may want to study XML spec. (http://www.w3.org/TR/2004/REC-xml-20040204/[^])
If latter, give more info please, like what parser do you want to use, in what language and what features do you need. CP/Google will help you as well.
Does it help? You can allways ask for more...
p.s. more keywords ( not only obvious "XML, Parser") are "Token, Grammar"
I'd love to help you more, but these days I am struggling with my own HTML parser (and with math, but this is different story ), so I don't spent so much time here now... hopefully somebody else will help you more (hey Phil, it's time to show off :->)
best regards
David 'DNH' Nohejl
Never forget: "Stay kul and happy" (I.A.)
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
