dave, thank you. I have enable the long text retrieval setting but i am still getting the SQL error " Data Access Error Unknown Data Access Error. " from the CF server when it runs the CF query in my action page. My query is very simple, as follow" select Cust_Info from company where Cust_id = 10; Cust_info is defined as a CLOB in the oracle table Company. thanks On Mon, 14 May 2001 10:12:02 -0400 Dave Watts wrote: >> I read this article and it is talking about CF settings button in >> the DSN setting screen. I logged onto my CF server administrator and >> could not find the DSN setting screen. Anyone knows where and how >> to do the setting ? > >The "DSN setting" screen is what you see when you edit any one of your data >sources in the CF Administrator. For example, if it's an ODBC data source, >you select "ODBC" from the left menu bar, then you click on the appropriate >data source. You'll then see the "DSN setting" screen for that data source. >At the bottom, you'll see a button labeled "CF Settings". > >Dave Watts, CTO, Fig Leaf Software >http://www.figleaf.com/ >voice: (202) 797-5496 >fax: (202) 797-5444 > > -------------------------------------------------------------------------- Global Internet phone calls, voicemail, fax, e-mail and instant messaging. Sign-up today at http://www.hotvoice.com ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

