May 1, 2002 at 2:15 pm
I have created a simple vbscript that uses the XMLSQL toolkit to do bulk loads into SQLSERVER 2000.
basically the system consists of 3 files. The VB script which connects to the DB and executes SQLXMLBulkLoad. This script uses a map schema file (xml) and a data file (xml)
The issue that arrises is that one of my fields "Description" contains the "&" in some rows of data. You may say, well just change the & to & a m p ; (without spaces) and all will be dandy! BUT..the xml data file is being auto generated from a progress script that is basically dumping a progress table.
The main idea.. dump from a progress table and insert into SQLSERVER.
I currently have a system of dumping a comma-delemitted file then using isql do a bulk insert using a sql script.
I'm just testing the limits of XML and want to see if this is a better way. It seems much easier, except for the fact that you can't have a "&" in the xml document. I've heard tales of using CDATA to fix this....
is there a way to do this instead of changing the data on the dumping of the data.xml file? Can you "allow" the & to be in an XML document?
You could say aren't there other ways like SQL's DTS's....and I could get into a long disscusion about why I'm doing it the way I am, but for now.....this is how I'd like to do it.
May 1, 2002 at 4:00 pm
May 3, 2002 at 4:08 am
By default XML special characters are entitized when mapped from the database, e.g. the '<' character becomes <. Ive used the sql:use-cdata annotation which overides this behaviour. This is a boolean value which defaults to false. Typical syntax
<elementtype name="Name" content="textonly"/>
<element type "Name" sql:field="surname" sql:use-cdata="1"/>
hope that clears the fog a little
I have found it is easy to please a great many people all of the time if you do exactly what they want. Harold Macmillan 1961
I have found it is possible to please all of the people all of the time if you do exactly what they want. Harold Macmillan 1961
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply