Manuel, Sorry, I have never run across this specific issue before, but I will mention that I have had odd errors in the past with various database drivers and older versions of ColdFusion with cfqueryparam. What version of MSSQL are you using? What version of coldfusion?
Also, this isn't exactly what you are asking for, but if you are using MS SQL Server 2005, Microsoft introduced the varchar(MAX) datatype which can store just as much text as CLOB, but it can be referenced like a regular varchar field. If you are on 2005 and have complete control of the DB, this may be an option to consider. Hope this helps in some way! -- Ken 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 -~----------~----~----~----~------~----~------~--~---
