GilbertLiddell
Member
- Joined
- May 4, 2007
- Messages
- 8
- Programming Experience
- Beginner
Hi
I've been tearing hair out with this now for quite some time
We have xml data (<?xml version="1.0" encoding="utf-16") held in an SQL Server 2000 image field. When I view the data through ebiz 2000 everything looks fine.
I need to read the xml held in the image field, locate a specific tag and update another field in that row based on the tags value, problem is I can't get the xml out of SQL Server to read it.
Any (relevant) suggestions folks would be appreciated.
I've been tearing hair out with this now for quite some time
We have xml data (<?xml version="1.0" encoding="utf-16") held in an SQL Server 2000 image field. When I view the data through ebiz 2000 everything looks fine.
I need to read the xml held in the image field, locate a specific tag and update another field in that row based on the tags value, problem is I can't get the xml out of SQL Server to read it.
Any (relevant) suggestions folks would be appreciated.