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 07, 2009 10:50 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, January 09, 2013 6:19 AM
Points: 10, Visits: 203
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 07, 2009 8:59 PM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Friday, March 28, 2014 2:25 PM
Points: 9,902, Visits: 9,479
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 09, 2009 7:43 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, January 09, 2013 6:19 AM
Points: 10, Visits: 203
pls see the schema attached
Post #671486
Posted Monday, March 09, 2009 8:36 AM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Friday, March 28, 2014 2:25 PM
Points: 9,902, Visits: 9,479
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 09, 2009 8:50 AM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Friday, March 28, 2014 2:25 PM
Points: 9,902, Visits: 9,479
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