BV Commerce Forum
»
BV Commerce Support
»
General Support
»
How to get the subfield value from xml feilds such as billingaddress in bvc_order using sql
Rank: Member
Joined: 4/5/2007(UTC)
Posts: 22
|
Dear Support:
You know in the table 'BVC_order', some feilds is using ntext type(XML) such as shippingaddress and billing address. How can I use sql (for example, stored procedure)to get these subfields value such as Firstname and lastname or address. Please give some suggestions. Thanks alot.
Have a good day!
Kevin
|
|
|
|
|
|
Rank: Member
Joined: 8/1/2007(UTC)
Posts: 310
|
Well, as a general rule, u could retrieve the complete xml, load it into an XML Document and then get teh node contents using XPath.
You might want to use XML Document's SelectSingleNode method to get the XMLNode and then do an innertext of that node to get the actual value. You can repeat that process for as many nodes / attributes u might want to. Let me know if u need help with that. I can help u get that done.
SV |
Thanks,
Satya
support @ bayquel.net
Work: +1 803 883 3226 |
|
|
|
|
|
Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.