Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

help on xml schema Expand / Collapse
Author
Message
Posted Saturday, March 7, 2009 10:50 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, June 13, 2014 12:52 PM
Points: 10, Visits: 210
code snippet:
CREATE XML SCHEMA COLLECTION MovieSchema AS N'
<xs:schema xmlns="http://schemas.sqlservercentral.com/MovieSchema"
xmlns:xs="http://www.w3.org/2001/XMLSchema">



























';
GO

this works well but i'm unable to add schema for a attribute called "status" to element "releaseDate".

I'm able to add disctype,category to element "film", can anybody suggest/help what i'm missing with.


Thanks in advance.


  Post Attachments 
movieschema.txt (8 views, 1.11 KB)
Post #670940
Posted Saturday, March 7, 2009 8:59 PM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Thursday, December 4, 2014 7:52 AM
Points: 9,294, Visits: 9,495
We cannot see most of you schema, because the security on these forums will filter out most text that looks like XML or HTML. Please post your XML as an attached file, either as TXT or a ZIP.

-- RBarryYoung, (302)375-0451 blog: MovingSQL.com, Twitter: @RBarryYoung
Proactive Performance Solutions, Inc.
"Performance is our middle name."
Post #671047
Posted Monday, March 9, 2009 7:43 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, June 13, 2014 12:52 PM
Points: 10, Visits: 210
pls see the schema attached
Post #671486
Posted Monday, March 9, 2009 8:36 AM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Thursday, December 4, 2014 7:52 AM
Points: 9,294, Visits: 9,495
What have you tried? And what has happened when you tried it? (tell us the error message if there is one)

-- RBarryYoung, (302)375-0451 blog: MovingSQL.com, Twitter: @RBarryYoung
Proactive Performance Solutions, Inc.
"Performance is our middle name."
Post #671562
Posted Monday, March 9, 2009 8:50 AM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Thursday, December 4, 2014 7:52 AM
Points: 9,294, Visits: 9,495
By the way, If you really want to put the XML in your post, you can use one of the following methods:

* Replace all "<" and ">" with "[" and "]"

* Replace all "<" and ">" with "& lt;" and "& gt;" (except no space)

* use the Simple-Talk prettifier here: http://extras.sqlservercentral.com/prettifier/prettifier.aspx


-- RBarryYoung, (302)375-0451 blog: MovingSQL.com, Twitter: @RBarryYoung
Proactive Performance Solutions, Inc.
"Performance is our middle name."
Post #671583
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse