Is it possible to select more than one field of the type "text" using
CF, OLEDB, and MSSQL 2000?

I can select one text field just fine:
SELECT id, realtext2 FROM dbo.testview

But when I try two or more:
SELECT id, realtext2, realtext FROM dbo.testview
              ^^         ^^
I get:
Error Diagnostic Information
OLEDB Error Code = 0
No such interface supported

What's the scoop? I'm almost ready to go back to ODBC -- I've had too
many problems with OLEDB.

Thanks,
Jamie
_

______________________________________________________________________
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Reply via email to