For...each .value on selected columns SOLVED
Good morning/afternoon, ... everyone, and happy Australia day to Australian people
Trying to make a self-made XML export
looks like I must amend this code without touching my database
this is just an extract of course, you don't need everything I guess:
I'm actually and with success getting :
<nameofthefield1>itsvalue</nameofthefield1>
<nameofthefield2>itsvalue</nameofthefield2>
...
the problem is that this method export ALL fields (=all columns) from the query/table to my final file.
I want to select only a few of them.
Why? to make a special layout that can look like this:
<nameofthefield1>itsvalue</nameofthefield1>
<othercodenotrelatedtothetable> ... </othercodenotrelatedtothetable>
<nameofthefield2>itsvalue</nameofthefield2>
has anyone able to show me a solution? This is not a popular question on the internet.
Many thanks in advance
Chris
Good morning/afternoon, ... everyone, and happy Australia day to Australian people
Trying to make a self-made XML export
looks like I must amend this code without touching my database
this is just an extract of course, you don't need everything I guess:
Code:
For Each fld In rs.Fields
Print #1, "<"; fld.Name; ">"; fld.value; "</"; fld.Name; ">"
Next fld
I'm actually and with success getting :
<nameofthefield1>itsvalue</nameofthefield1>
<nameofthefield2>itsvalue</nameofthefield2>
...
the problem is that this method export ALL fields (=all columns) from the query/table to my final file.
I want to select only a few of them.
Why? to make a special layout that can look like this:
<nameofthefield1>itsvalue</nameofthefield1>
<othercodenotrelatedtothetable> ... </othercodenotrelatedtothetable>
<nameofthefield2>itsvalue</nameofthefield2>
has anyone able to show me a solution? This is not a popular question on the internet.
Many thanks in advance
Chris
Last edited: