We'll fix this in either contentObjectFind or the rule handler for the next
major release. . . 

-c

-----Original Message-----
From: David An [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 12, 2000 8:09 PM
To: [EMAIL PROTECTED]
Subject: "search properties" rule is case-sensitive


The "search properties" rule supplied with Spectra does not work with a 
case-sensitive RDBMS (like Oracle).

In the rule edit handler, the typeIDs are lcase-d ... then when they are 
passed into contentObjectFind, the lower-case typeID won't match anything.

It's a pretty simple fix: add a Ucase to line 23 of 
/allaire/spectra/rules/system/searchproperties.cfm so it reads:
        typeid = "#Ucase(attributes.stParams.typeID)#"



.. that's all!  (I'd post this to the forums too but they seem to be down).

-- David

-------------------------------------------------
David An: [EMAIL PROTECTED]
-- life through a browser --    
MINDSEYE Technology, Inc.   http://www.mindseye.com/


----------------------------------------------------------------------------
--
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.

Reply via email to