Hi all, i’m trying to get a list by query, but I’ve a proble: my code fragment
is:
<cfset myStr = "FROM User WHERE User.userNL = :nl AND User.userType IN (:type)
AND userLang IN (:lang)"/>
<cfset mySql = variables.transfer.createQuery(myStr)/>
<cfset mySql.setParam("NL",TRUE,"boolean")>
<cfset mySql.setParam("type",userType,"String")>
<cfset mySql.setParam("lang",userLang,"String")>
<cfset myQ = variables.transfer.listByQuery(mySql)>
nl is a flag in user table, active or not, userLang is a list of languages,
userType is a list of types; if I have userType = “1”, userLang = “IT”, I get a
recordset of user matching, i.e. actives, type =1 and lang=IT, but if I try
with userType = “1,2”, and/or userlang = “IT,US” , I always get an empty
recordset, no records
is this a mistake, or may be a bug?
Regrards
salvatore
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
