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

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.

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

Replies are listed 'Best First'.
Re^5: [Windows / SQL Server / ODBC / DBI / DBD] How to access XML data type columns by mje (Curate) on Jul 22, 2010 at 10:46 UTC
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.	[reply]
Re^5: [Windows / SQL Server / ODBC / DBI / DBD] How to access XML data type columns by gaggio (Friar) on Jul 22, 2010 at 11:00 UTC
You got it!	[reply]
Re^6: [Windows / SQL Server / ODBC / DBI / DBD] How to access XML data type columns by mje (Curate) on Jul 22, 2010 at 11:04 UTC
Could you clarify as this may be a bug. You got no error or warning at all, you got no rows and you had not disabled PrintError/RaiseError but simply increasing LongReadLen returned a row?	[reply]