XML and SQL related question!!


    Sponsored Links


  • 1. Exam 70-310 - Books
    Hi all, Can anyone recommend 2 or 3 good books in preparation for the above exam. Is the MCAD Self Paced .NET Core Requirements a must?? Ideally I'd like at least one book with lots detail as I don't know a great deal when it comes to XML Web Services. I was thinking of purchasing the Exam Cram2 book for this exam - any comments? I don't want any e-books thanks ;-) Barry
  • 2. mcp(315)
    Hi can somebody tell me where can i get practice papers for certification exam paper code 315(web applications) and how many ques are asked total time is there any negative marking also
  • 3. 70-316: About "User Services" and channels?
    I was taking a practice exam and I had several detailed questions about "User Services" and channels. However, I did a search of the html version of the Microsoft prep. book and can not find any discussions of these topics. Did I miss this in one of the chapters or is the MS book incomplete? Thanks

XML and SQL related question!!

Postby Anitha » Fri, 09 Apr 2004 02:51:40 GMT

Hi all,

I have a question.

I have an XML file containing data for a relation. Using 
this I need to update the database that has a Parent 
table and a Child table and the primary key in my Parent 
is an Identity. What method do I have to use and how??


Similar Threads:

1.Many XML related questions on 70-315?

Are there  many XML related questions on 70-315 exam?

2.XML related question

I'm working on an application that I'd like to add XML support to in
order to communicate with another app on a remote server. The other
side already has the data I need in XML files ready to be recieved by
my end. The problem is that it's in a specific schema-type (cXML).

So far, I have my end recieving the datafeed, decrypting the XML, and
storing it in a string. However, when I load it into an XmlDocument
type (I'm using C#, by the way), I get invalid markup errors. The
problem is that the schema type being used by the other side defines
various tag syntax in the dtd (which is referenced in the DOCTYPE
declaration) that don't parse as generic XML.

Is there an elegant approach to this that is supported in the standard
.Net library? Looking around MSDN so far has proved fruitless.
Basically, I need a way to tell the document object about the specific
schema. I'm not entirely sure this is even possible with the .Net
framework. Perhaps I need to create a custom class for this document

3.XML schema question, possibly related to xs:any

4.A newbe has a question relating to XML::Simple

The xml file is
<?xml version="1.0" encoding="UTF-8"?>
<Field1>Column 1</Field1>
<Field2>Column 2</Field2>
<Field3>Column 3</Field3>
<Field4>Column 4</Field4>
<Field1>Column 1</Field1>
<Field2>Column 2</Field2>
<Field3>Column 3</Field3>
<Field4>Column 4</Field4>

And the Code so far is

use strict;
use warnings;

use XML::Simple;

my $data = XMLin('data.xml', forcearray=>1);

for my $data (@{$data->{data}})
    foreach (qw(Field4))
        print $data->{$_}->[0], "\n";
    if ($data{"Field4"} eq "Column 4")
        print "match = ", $data->{$_}->[0], "\n";

Which isn't working but giving me errors.

My ultimate goal is to be to examine text within each Field.  What has been
missing in all of the write ups I've seen is how to get to identify an
individual field and get access to the text contained in it.  Can I set a
variable equal to the text? Or how do I test for a match against the text?

Bruce Bowen

5.An XML-related Question

Simple question:

Is it possible to import DTD XML schemas into Dreamweaver 8?

6. convert sql tables with parent-child keys relating a nested structure into a nested xml file

7. newB question: related tables question

8. Question and search for ODBC related postgreSQL questions

Return to mcad


Who is online

Users browsing this forum: No registered users and 33 guest