XML and SQL related question!!


    Sponsored Links


  • 1. Just one book for 70-340
    I've done the 70-315 and 70-320 exams and for both exams I've used the Que books written by Kalani. I plan to do the 70-340 exam and was wondering, is there a one-stop book that I can study from for the exam? >From what i've seen most people recommend more than one book... Thanks
  • 2. Practice exams vs Real exam questions (70-305)
    I want to know whether the practice exams are like the real exams and the score per question. I'm preparing to take exam 70 - 305 and I'm using MCAD/MCSD self paced training kit for exam 70-305/315. -- Okoronkwo Chinedu Crazy About Learning
  • 3. Book 70-330
    Could someone suggest me the best book available in the market for 70-330 --------------------------- IT Consultant Microsoft Technologies
  • 4. 2003 or 2005?
    I'm new to Visual Studio. I'd like to know if it's worthwhile to learn Visual Studio.NET 2003 first before learning VS2005? Or, should I just jump to VS2005 and disregard VS.NET 2003?

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 46 guest