RE: query of query - clob error

2007-05-18 Thread Bob Imperial
Just a shot in the dark here, did you enable that setting in the cf administrator and have you tried listing the specific fields that are in fact CLOB/BLOB last in your query? I ran into a slightly different issue but somewhat similar a week or so ago and doing this solved my issue. HTH Bob

Re: query of query - clob error

2007-05-18 Thread daniel kessler
Just a shot in the dark here, did you enable that setting in the cf administrator I don't have access to CFAdministrator because I'm in a shared hosting environment here where the IT of the University does all the server tasks. What setting needs to be enabled? I can do QofQ, but just not with

Re: query of query - clob error

2007-05-18 Thread daniel kessler
Just a shot in the dark here, did you enable that setting in the cf administrator and have you tried listing the specific fields that are in fact CLOB/BLOB last in your query? I ran into a slightly different issue but somewhat similar a week or so ago and doing this solved my issue. Yes, I did

RE: query of query - clob error

2007-05-18 Thread Bob Imperial
). BLOB -- Enable binary large object retrieval (BLOB). Long Text Buffer (chr) Blob Buffer(bytes) Bob -Original Message- From: daniel kessler [mailto:[EMAIL PROTECTED] Sent: Friday, May 18, 2007 9:34 AM To: CF-Talk Subject: Re: query of query - clob error Just

Re: query of query - clob error

2007-05-18 Thread daniel kessler
I can retrieve CLOBs fine. I just can't Query of Query them, and then only if I specify them directly instead of a *. Do you think this'll help then? It appears to just enable CLOBs at all. These settings are found under the advanced setting tab when you register your datasource. Not sure what