Manuel, what are the datatypes for the other columns in the table? Is there an easier column to use for your selection? I try to avoid using CLOBs in my "where" clause.
-CPC On Thu, Dec 11, 2008 at 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 -~----------~----~----~----~------~----~------~--~---
