Beefy Boxes and Bandwidth Generously Provided by pair Networks
Think about Loose Coupling
 
PerlMonks  

Re^2: [Windows / SQL Server / ODBC / DBI / DBD] How to access XML data type columns

by gaggio (Friar)
on Jul 22, 2010 at 00:45 UTC ( #850746=note: print w/ replies, xml ) Need Help??


in reply to Re: [Windows / SQL Server / ODBC / DBI / DBD] How to access XML data type columns
in thread [Windows / SQL Server / ODBC / DBI / DBD] How to access XML data type columns

Thank you for the DBI_TRACE tip.

After having enabled tracing, I easily found what the problem was: the default LongReadLen of 80 was not sufficient to grab the full XML strings, resulting in the abortion of the query.

Solved!!!


Comment on Re^2: [Windows / SQL Server / ODBC / DBI / DBD] How to access XML data type columns
Re^3: [Windows / SQL Server / ODBC / DBI / DBD] How to access XML data type columns
by mje (Deacon) on Jul 22, 2010 at 06:47 UTC

    Glad you are working although I might have pointed at LongReadLen myself if you hadn't given the impression you were getting no data back at all for that column.

      Except that he wasn't getting any data back. The LongTruncOk was false, so the query failed returning no rows.

      Jenda
      Enoch was right!
      Enjoy the last years of Rome.

        ok, so LongTruncOk was false but unless the OP had also disabled PrintError and RaiseError he should have got a "String data, right truncation" error. The only point I was attempting to make was that a little bit more information here would not have hurt.

        You got it!

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://850746]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others having an uproarious good time at the Monastery: (5)
As of 2014-07-12 01:28 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    When choosing user names for websites, I prefer to use:








    Results (238 votes), past polls