You need to tell the param "type" that it is a list (ditto for "list").
http://docs.transfer-orm.com/wiki/Transfer_Query_Language.cfm#Query.setParam(name%2C_[value]%2C_[type]%2C_[list]%2C_[isNull])] http://docs.transfer-orm.com/html/transferapi/transfer/com/tql/Query.html#setParam() Mark On Fri, Jan 9, 2009 at 9:10 PM, Salvatore FUSTO <[email protected]> wrote: > 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 > > > > > > -- E: [email protected] W: www.compoundtheory.com --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
