Skip site navigation (1) Skip section navigation (2)

table_to_xml command isn't working

From: "Luigi Pirillo" <luigi(dot)pirillo(at)sky-team(dot)it>
To: <pgsql-odbc(at)postgresql(dot)org>
Subject: table_to_xml command isn't working
Date: 2007-11-27 15:51:54
Message-ID: 20071127154814.1D3562E0033@postgresql.org (view raw or flat)
Thread:
Lists: pgsql-odbc
Hello,

 

I have registered an odbc entry (named xfpdb) on my Windows XP Pro machine
using PosgreSQL Ansi vers. 8.02.05 (my db server is 8.3 beta 1).

Using a simple VB 6.0 code, I have tried to connect to it and return some
XML information using ADO as in the following:

 

    ..

    cn.Open "Provider=MSDASQL.1;Persist Security Info=False;Data
Source=xfpdb"

    rs.Open "select * from table_to_xml('""Versions""', true, true, '')", cn


    MsgBox rs.Fields(0).Value

    ..

 

The returned XML string appears truncated, as shown below:

----------------------------------------------------------------------------
---------------------------

<Versions xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">

 

  <Version_Id>962</Version_Id>

  <Version>0.0.0.0</Version>

  <Process_Id>600</Process_Id>

  <CreatedDateTime>2007-11-13T11:19:28.20</CreatedDateTime>

</Versions>

 

<Versions xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">

 

  <Version_Id>963</Version_Id>

  <Version>0.0.0.1</Version>

  <Process_Id>600</Process_Id>

  <CreatedDateTime>2007-11-13T11:19:38.50</CreatedDateTime>

</Versions>

 

<Versions xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">

 

  <Version_Id>964</Version_Id>

  <Version>0.0.0.2</Version>

  <Process_Id>600</Process_Id>

  <CreatedDateTime>2007-11-13T11:19:38.50</CreatedDateTime>

</Versions>

 

<Versions xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">

 

  <Version_Id>965</Version_Id>

  <Version>0.0.0.3</Version>

  <Process_Id>600</Process_Id>

  <CreatedDateTime>2007-11-13T11:19:38.50</C                    @  

----------------------------------------------------------------------------
---------------------------

 

Same result using Labview 8.2.1 and its database connectivity tool.

 

But if I try to execute the query directly using pg Admin III, the XML
output is correct, as shown below:

 

----------------------------------------------------------------------------
---------------------------

<Versions xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">

 

  <Version_Id>962</Version_Id>

  <Version>0.0.0.0</Version>

  <Process_Id>600</Process_Id>

  <CreatedDateTime>2007-11-13T11:19:28.20</CreatedDateTime>

</Versions>

 

<Versions xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">

 

  <Version_Id>963</Version_Id>

  <Version>0.0.0.1</Version>

  <Process_Id>600</Process_Id>

  <CreatedDateTime>2007-11-13T11:19:38.50</CreatedDateTime>

</Versions>

 

<Versions xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">

 

  <Version_Id>964</Version_Id>

  <Version>0.0.0.2</Version>

  <Process_Id>600</Process_Id>

  <CreatedDateTime>2007-11-13T11:19:38.50</CreatedDateTime>

</Versions>

 

<Versions xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">

 

  <Version_Id>965</Version_Id>

  <Version>0.0.0.3</Version>

  <Process_Id>600</Process_Id>

  <CreatedDateTime>2007-11-13T11:19:38.50</CreatedDateTime>

</Versions>

----------------------------------------------------------------------------
---------------------------

 

Can anyone help me?

 

Thanks in advance,

 

Luigi 

 

 

 

 

 

Responses

pgsql-odbc by date

Next:From: Hiroshi InoueDate: 2007-11-28 03:28:59
Subject: Re: table_to_xml command isn't working
Previous:From: claudia.amorimDate: 2007-11-27 12:09:25
Subject: "Invalid Pointer Operation" while reading tuples

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group