[Reactor for CF] Conditional Load()..?

[Sal Valverde]

Hi folks, Im sure this is a stupid question, but I'm having a hard time wrapping my head around this issue. What Im trying to do is load a record object based off of a conditional statement... so for instance: I have one form field value that I pass, but two table fields I want to check that value against before loading the record object... Example: <cfset var email = arguments.event.getValue("email") /> <cfset userRecord = reactor.createRecord("table").load(column1 = #email# OR column2 = #email#) /> Obviously the OR operator is something theoretical, but essentially this is what I wanna pull off. I know you can pass multiple name/value pair params to the load method, but that essentially does an AND. Can someone give me a hand, I'm open to criticism if this question deserves a drop kick and removed from the mailing list? haha ;( thanks sal -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- Reactor for ColdFusion Mailing List reactor@doughughes.net Archives at: http://www.mail-archive.com/reactor%40doughughes.net/ -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --