Hi,
CFA_CONTENTOBJECTFIND includes _contentobjectfind_bp.cfm.
Looking at that code, I am proposing to make the changes of moving the '='
next to the cfqueryparam for integer, numeric, and datetime. Adding a 'LIKE'
before char's and longchar's cfqueryparam.
Is there any reason why Allaire coded it like they did or is it safe to make
the changes?
Proposed code included:
============================================================================
================
( p.propertyname = <cfqueryparam value="#thisPropertyName#"
cfSQLType="CF_SQL_VARCHAR">
and p.#thisDataType#data
<cfswitch expression = "#thisDataType#">
<cfcase value="integer">
= <cfqueryparam value="#thisValue#"
cfSQLType="CF_SQL_INTEGER">
</cfcase>
<cfcase value="numeric,datetime">
<cfset thisValue = 0 + thisValue>
= <cfqueryparam value="#thisValue#"
cfSQLType="CF_SQL_NUMERIC">
</cfcase>
<cfcase value="char">
LIKE <cfqueryparam
value="#Replace(thisValue,"*","%","ALL")#" cfSQLType="CF_SQL_VARCHAR">
</cfcase>
<cfcase value="longchar">
LIKE <cfqueryparam
value="#Replace(thisValue,"*","%","ALL")#" cfSQLType="CF_SQL_LONGVARCHAR">
</cfcase>
</cfswitch>
)
============================================================================
================
Cheers,
Jon
--
Jonathan Lim [EMAIL PROTECTED]
Netdecisions http://www.netdecisions.co.uk/
------------------------------------------------------------------------------
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/spectra_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
