Thank you for the reply,
I solved my problem with a mix of tql, tql custom tags, and a bunch of cfif's.
Not really nice code but it works.
I tried to do the tql with conditions , but does not look like it can compare
values to other things then a column, hence the bunch of cfifs.
where (
:myvalue is null
or mycoilumn = :myvalue
)
id = -1;
Query.setParam("myvalue", id, "numeric", false, #iif(id lt 0,true,false)#);
Is there any way to do this in a simular way, to prevent all my cfif's, since I
get great many quert plans generated for each possible query that way?
Sorry for my poor norwegian english =)
-Bjarte
________________________________________
Fra: [email protected] [[email protected]] på
vegne av Brian Kotek [[email protected]]
Sendt: 27. mars 2009 17:12
Til: [email protected]
Emne: [transfer-dev] Re: listBypropertyMap between linked objects
I believe you'll need to use TQL. This goes beyond what listByPropertyMap is
meant to do.
On Fri, Mar 27, 2009 at 9:55 AM, Bjarte BB. Bore
<[email protected]<mailto:[email protected]>> wrote:
Hi, this might be a bit newbie question.
Is there a way to do a listBypropertyMap between linked objects?
I have a dynamically created property map, that has keys between three tables
(Member,Member_person,Member_club).
The property map is dynamically created after validating the search options
(age, club, type, etc) and only the keys that are validated will be in the map.
Is there a way to do this, without having to use tql ?
------------------------------------
Bjarte Bore
Developer
Tlf: 51 88 44 00 - Faks: 51 88 44 01
[email protected]<mailto:[email protected]> Flintegata 2, 4016 Stavanger
www.inbusiness.no<http://www.inbusiness.no>
www.i-tools.no<http://www.i-tools.no>
Before printing, think about the environment
--~--~---------~--~----~------------~-------~--~----~
Before posting questions to the group please read:
http://groups.google.com/group/transfer-dev/web/how-to-ask-support-questions-on-transfer
You received this message because you are subscribed to the Google Groups
"transfer-dev" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/transfer-dev?hl=en
-~----------~----~----~----~------~----~------~--~---
