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