PROBLEM WITH HYPHEN (-) IN XML ELEMENT NODE
-
HI, I HAVE A XML FILE WITH HYPHEN(-) IN SOME ITS ELEMENTS FOR EXAMPLE <NAME> <FIRST-NAME>JOHN </FIRST-NAME> <LAST-NAME>MILLER </LAST-NAME> <AGE>25 <AGE> </NAME> I ALSO HAVE XSD FILE VALIDATING THIS XML FILE AND WHEN I BULKINSERT IT IN MY DATABASE ELEMENT NAMES WITH HYPHEN ARE NOT INSERTING <FIRST-NAME>JOHN </FIRST-NAME> , <LAST-NAME>MILLER </LAST-NAME> WHERE AS NON-HYPHEN ELEMENTS <AGE>25 <AGE> INSERTED FINE. HOW CAN I VALIDTE THE HYPHENATED ELEMENTS WITH MY XSD AND THEN INSERT INTO DATABASE. PLS HELP
sai krishna
-
HI, I HAVE A XML FILE WITH HYPHEN(-) IN SOME ITS ELEMENTS FOR EXAMPLE <NAME> <FIRST-NAME>JOHN </FIRST-NAME> <LAST-NAME>MILLER </LAST-NAME> <AGE>25 <AGE> </NAME> I ALSO HAVE XSD FILE VALIDATING THIS XML FILE AND WHEN I BULKINSERT IT IN MY DATABASE ELEMENT NAMES WITH HYPHEN ARE NOT INSERTING <FIRST-NAME>JOHN </FIRST-NAME> , <LAST-NAME>MILLER </LAST-NAME> WHERE AS NON-HYPHEN ELEMENTS <AGE>25 <AGE> INSERTED FINE. HOW CAN I VALIDTE THE HYPHENATED ELEMENTS WITH MY XSD AND THEN INSERT INTO DATABASE. PLS HELP
sai krishna
The validation is obviously not a problem - it's that your database doesn't allow/have fields with hyphens? How are you inserting into the database?
Java, Basic, who cares - it's all a bunch of tree-hugging hippy cr*p
-
The validation is obviously not a problem - it's that your database doesn't allow/have fields with hyphens? How are you inserting into the database?
Java, Basic, who cares - it's all a bunch of tree-hugging hippy cr*p
HI STUART DOOTSON , THANKS FOR REPLYING MY DATABASE IS SQLSERVER AND I AM BULK INSERTING MY XML FILE USING SQLXML3.0 FRAMEWORK . IHAVE A VB SCRIPT LIKE OBJECT.Execute "MYSCHEMA.XSD" , "MYXMLFILE.xml" AM ASLO MAPPING MY XML TAGS WITH SQLSERVER TABLE NAME IN MY XSD FILE <xsd:element name="FIRST-NAME" sql:relation="FIRSTNAME" > xsd:complexType .................... .......................... </xsd:complexType> </xsd:element>
sai krishna