I'm confused - I'm looking at the code right now (of a pure Spectra 1.01
box) and it already has the LIKE in there (like I thought I remembered it
did).
=======================================================================
Raymond Camden, Cold Fusion Jedi Master for Syntegra (www.syntegra.com)
Allaire Certified Instructor and Member of Team Allaire
Email : [EMAIL PROTECTED]
ICQ UIN : 3679482
"My ally is the Force, and a powerful ally it is." - Yoda
> -----Original Message-----
> From: Jonathan Lim [mailto:[EMAIL PROTECTED]]
> Sent: Monday, August 14, 2000 2:00 PM
> To: [EMAIL PROTECTED]
> Subject: CFA_CONTENTOBJECTFIND alterations
>
>
> 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.
------------------------------------------------------------------------------
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.
