Showing posts with label sqlxml. Show all posts
Showing posts with label sqlxml. Show all posts

Sunday, March 25, 2012

Download?

Hi gurus.
Where can I download SQLXML 3.0? I have researched but
couldnt find it? some body tall me?
http://www.microsoft.com/downloads/d...displaylang=en
--
Graeme Malcolm
Principal Technologist
Content Master Ltd.
www.contentmaster.com
"Murat YILMAZ" <anonymous@.discussions.microsoft.com> wrote in message
news:8e3601c4d390$e1a75dd0$a401280a@.phx.gbl...
Hi gurus.
Where can I download SQLXML 3.0? I have researched but
couldnt find it? some body tall me?

Wednesday, March 7, 2012

Don't use virtual directory name as part of namespace

Hi. Is it possible to configure SQLXML so that the virtual directory name is
not integrated in to the schema namespace? This is causing us problems at
deployment time. We want to deploy our SQLXML stored procedures to different
virtual directories on the same server to support separate testing
environments. But changing the virtual directory name changes the schema
namespace which means that the clients that use the stored procedures break.
McGeeky
http://mcgeeky.blogspot.com
I should add this is on SQL Server 2000!
McGeeky
http://mcgeeky.blogspot.com
"McGeeky" <anon@.anon.com> wrote in message
news:ed%23GiEq7GHA.3812@.TK2MSFTNGP02.phx.gbl...
> Hi. Is it possible to configure SQLXML so that the virtual directory name
> is not integrated in to the schema namespace? This is causing us problems
> at deployment time. We want to deploy our SQLXML stored procedures to
> different virtual directories on the same server to support separate
> testing environments. But changing the virtual directory name changes the
> schema namespace which means that the clients that use the stored
> procedures break.
> --
> McGeeky
> http://mcgeeky.blogspot.com
>
>
|||What schema namespace? Database schema, XML Schema? Some other schema?
Thanks
Michael
"McGeeky" <anon@.anon.com> wrote in message
news:upraaQq7GHA.2384@.TK2MSFTNGP04.phx.gbl...
>I should add this is on SQL Server 2000!
> --
> McGeeky
> http://mcgeeky.blogspot.com
>
> "McGeeky" <anon@.anon.com> wrote in message
> news:ed%23GiEq7GHA.3812@.TK2MSFTNGP02.phx.gbl...
>

Don't use virtual directory name as part of namespace

Hi. Is it possible to configure SQLXML so that the virtual directory name is
not integrated in to the schema namespace? This is causing us problems at
deployment time. We want to deploy our SQLXML stored procedures to different
virtual directories on the same server to support separate testing
environments. But changing the virtual directory name changes the schema
namespace which means that the clients that use the stored procedures break.
McGy
[url]http://mcgy.blogspot.com[/url]I should add this is on SQL Server 2000!
McGy
[url]http://mcgy.blogspot.com[/url]
"McGy" <anon@.anon.com> wrote in message
news:ed%23GiEq7GHA.3812@.TK2MSFTNGP02.phx.gbl...
> Hi. Is it possible to configure SQLXML so that the virtual directory name
> is not integrated in to the schema namespace? This is causing us problems
> at deployment time. We want to deploy our SQLXML stored procedures to
> different virtual directories on the same server to support separate
> testing environments. But changing the virtual directory name changes the
> schema namespace which means that the clients that use the stored
> procedures break.
> --
> McGy
> [url]http://mcgy.blogspot.com[/url]
>
>

Friday, February 17, 2012

Does XDR obey facets?

Hi,
I have a problem making XDR (SQLXML) mappings obey facets.
As example I want to apply the "whiteSpace" facet to a string in XDR:
<xsd:simpleType name="stringTrunc">
<xsd:restriction base="xsd:string" >
<xsd:whiteSpace value="collapse"/>
</xsd:restriction>
</xsd:simpleType>
<xsd:element name="title" type="stringTrunc" sql:field="title"/>
This has no effect... The title field is a 50 char field with trailing
whitespace which I want to truncate.
Can anyone help?
Cheers,
Christian
The short answer is no - the schema is used for mapping information but the
data isn't validated against the schema.
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"Christian Olsen" <cho@.NOT.AVAILABLE> wrote in message
news:%23MQYi8nXEHA.2216@.TK2MSFTNGP10.phx.gbl...
> Hi,
> I have a problem making XDR (SQLXML) mappings obey facets.
> As example I want to apply the "whiteSpace" facet to a string in XDR:
> <xsd:simpleType name="stringTrunc">
> <xsd:restriction base="xsd:string" >
> <xsd:whiteSpace value="collapse"/>
> </xsd:restriction>
> </xsd:simpleType>
> <xsd:element name="title" type="stringTrunc" sql:field="title"/>
> This has no effect... The title field is a 50 char field with trailing
> whitespace which I want to truncate.
> Can anyone help?
> Cheers,
> Christian
>
>