This is a hunch, I remember it was a problem in cf5 w/spectra. In your select statement put the wddx column at the end. More specifically put all blob/clob fields at the end of your sql select statement.
Also try the different oracle drivers (odbc, oracle type4, merant type 4 - ships with cf enterprise) they all treat clob/blob fields a little differently. Hth, ----nimer -----Original Message----- From: Aidan Whitehall [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 13, 2003 10:07 AM To: CF-Talk Subject: RE: Red Sky, Oracle 9i, WDDX and ODBC > What about using the Oracle native drivers ? I tried that on the development machine, but then a different query on the home page threw an error (figured it wasn't a good sign). Plus, the production server is only Professional, not Enterprise (AFAIK, no native Oracle drivers for Professional). -- Aidan Whitehall <mailto:[EMAIL PROTECTED]> Macromedia ColdFusion Developer Fairbanks Environmental Ltd +44 (0)1695 51775 Queen's Awards Winner 2003 <http://www.fairbanks.co.uk/go/awards> ________________________________________________________________________ This e-mail has been scanned for all viruses by Star Internet. The service is powered by MessageLabs. For more information on a proactive anti-virus service working around the clock, around the globe, visit: http://www.star.net.uk ________________________________________________________________________ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
