Re: send dataset as a parameter
From: D.W. Warlock (no.spam_at_no.spam.org)
Date: 02/26/05
- Next message: clintonG: "Re: Accessing .NET components from Dreamweaver?"
- Previous message: IPGrunt: "Re: BIG WARNING - validation controls appear to be ignored."
- In reply to: Scott M.: "Re: send dataset as a parameter"
- Next in thread: Wilco Bauwer: "Re: send dataset as a parameter"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 25 Feb 2005 17:03:54 -0800
Scott M. wrote:
> You can absolutely pass text (in whatever form you like: plain text, html,
> xml, etc.). But if you pass XML as a parameter to a SP, then you find
> yourself in the same boat as if you passed a DataSet in terms of dealing
> with the XML. Will the DB know what XPath is?
Yes, SQL Server 2000/2005 (also MSDE) can utilize both XPath and XML. I
believe that Oracle 9i and up can also handle XPath/XML. Other RDBMSs
that can: FireBird (1.3x and above), MySql(limited support in the 4.x.x
versions).
>
> Can you do XPath queries on a DB?
>
>
> "Wilco Bauwer" <wilcob@gmail.com> wrote in message
> news:1109368785.577054.73100@f14g2000cwb.googlegroups.com...
>
>>If you insist, you could have a text parameter in your stored
>>procedure. You could pass the xml as text, and in the SP use OPENXML to
>>intepret the text as xml. At that point, you can do xpath queries, etc.
>>
>
>
>
- Next message: clintonG: "Re: Accessing .NET components from Dreamweaver?"
- Previous message: IPGrunt: "Re: BIG WARNING - validation controls appear to be ignored."
- In reply to: Scott M.: "Re: send dataset as a parameter"
- Next in thread: Wilco Bauwer: "Re: send dataset as a parameter"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
