If you are doing this in a Oracle database, you have to search clobs using the dbms_lob functions
I have not had to do this in a long time, so I have not done it with cfqueryparam, this is how you do it without cfqueryparam SELECT * FROM lob_tab Where dbms_lob.instr(clob_content,'#clob_content#') The only time I have used cfqueryparam when playing with CLOBs lately is on inserts or updates, which works like your sample code, but if I had to guess, I would say you would use cfqueryparam like this SELECT * FROM lob_tab Where dbms_lob.instr(clob_content,'<cfqueryparam type="cf_sql_clob" value="#clob_content#">') But this might work better (depending on your data); will definately be slower SELECT * FROM lob_tab Where dbms_lob.instr(lower(clob_content),'<cfqueryparam type="cf_sql_clob" value="#lcase(clob_content)#">') HTH, M On Dec 11, 3:30 pm, Manno <[email protected]> wrote: > I am having trouble output text string with the CLOB contraint. > I enable the option in the admin, set the query param to recognize it > but it gives me this error. > If anyone has any idea on this subject i could use the help. > Error > inconsistent datatypes: expected - got CLOB > > SELECT * > 12 : FROM lob_tab > 13 : Where clob_content = <cfqueryPARAM value = "#clob_content#" > CFSQLType = "CF_SQL_CLOB"> > 14 : </cfquery> > > Thanks > Manuel --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the "Houston ColdFusion Users' Group" discussion list. To unsubscribe, send email to [email protected] For more options, visit http://groups.google.com/group/houcfug?hl=en -~----------~----~----~----~------~----~------~--~---
