Matching OuterXML with DB Field Name ?

M

mark

For ease of example i have cutt down what i need to do to
the following

I have an xml file with 2 attributes, firstname and
lastname
I have a database with the same 2 columns

what i need to do (wont go into reasons) is cycle through
the xml file and insert the values if the outerXML
matches the DB field
.....and that is where i'm stumped

I am going to be inserting the values in the DB using a
stored procedure,

the easiest way to describe it with psuedo code is like
this

for i = 0 to xmlnode.count - 1
if outterXML = DBfieldName then
insert InnerXML to DBField
end if
Next

does that make sense? i'm having real trouble with
figuring out how i'm going to match the outterXML
with the DB field name

Any ideas?
I would love a tutorial on this or some example code
please
Thanks
Mark
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

No members online now.

Forum statistics

Threads
473,756
Messages
2,569,535
Members
45,008
Latest member
obedient dusk

Latest Threads

Top