Bob, First I would try the built in MS SQL driver, and if that still fails give the Microsoft JDBC driver a shot.
Chris -----Original Message----- From: Bob Imperial [mailto:[EMAIL PROTECTED] Sent: Thursday, May 10, 2007 8:56 AM To: CF-Talk Subject: Blob/clob issue Well . it's almost Friday and none to soon for me. I have an issue I've run into I'm hoping someone out there might have a solution for. First off I'm working with CFMX 7, MSSQL 2k on a Win 2003 Web Server and using an ODBC driver. I have an ntext field that's not returning any data to me for display, I've dumped my query and there are actually a couple of ntext fields that just return and empty string. The thing is, this ntext field displays fine in an aspx page within an old site I am rebuilding (or trying to anyway) using ColdFusion. Anyone ever run into this and more importantly, can anyone offer a solution? I've done a google or two on it with no real luck on a solution yet. Oh and the query is as simple as it gets, doing SELECT * Thanks! Tired Bob ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:277606 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
