well you were kind of right, but as far as Transfer is concerned there is no designerKey column in widget. Its in the designer object. just a different way of thinking.
On Dec 23, 3:42 pm, Ken Cummins <[email protected]> wrote: > Ah! Thank you! I don't know why I brain-froze on using a join. I > was dead-set on a simple query on the column, rather than working > within Transfer's world-view. > > On Dec 23, 2:37 pm, Sean Coyne <[email protected]> wrote: > > > you need to join it to the designer so > > > "from widgets.widget join widgets.designer where designer.key = :dKey" > > > assuming your object is named designer > > > Sean > > > On Dec 23, 3:32 pm, Ken Cummins <[email protected]> wrote: > > > > OK, I tried some TQL tomfoolery, and I've been slapped down... > > > > myQuery = getTransfer().CreateQuery("from widgets.widget where > > > designerkey = :dkey"); > > > myQuery.setParam("dkey", GetAuthUser(), "numeric"); > > > myList = getTransfer().listByQuery(myQuery); > > > > And I get a complaint that "The 2 parameter of the Left function, > > > which is now -1, must be a positive integer"... > > > > On Dec 23, 2:06 pm, Ken Cummins <[email protected]> wrote: > > > > > It there an easy way to filter a query based on a value of a m2o key? > > > > > I'd like to be able to listByProperty("widget", "widget.designerkey", > > > > userID) to get all the widgets designed by the user. > > > > > But because designerkey is defined as a m2o foreign key, it throws > > > > errors. > > > > > What basic piece of information am I missing? What first-day-on-the- > > > > job insight am I blind to? > > > > > Ken --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
