Ok, so I'm seeing something interesting. I have a field in my MSSQL which is of type TEXT. I have a query that looks like:
<cfquery name="ThreadChk"> SELECT ThreadID FROM Threads WHERE Header LIKE <cfqueryparam cfsqltype="CF_SQL_LONGVARCHAR" value="#emails.header#"> </cfquery> This query will return 0 results. Now if I change the field in the DB to be of type VARCHAR and do something like: <cfquery name="ThreadChk"> SELECT ThreadID FROM Threads WHERE Header = <cfqueryparam cfsqltype="CF_SQL_LONGVARCHAR" value="#emails.header#"> </cfquery> This returns 1 record. The #emails.header# contains some carriage returns. That is the only thing I can think of that is causing the second query to work and the first query to fail. Anyone know for sure if this is the reason, or is there something I'm missing? In the first query I tried placing the %'s around the var, but that didn't change anything. How can I compare these values if I want to keep the field as a TEXT type? Thanks, Cedric ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:195137 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
