Hi again,
I'm trying to query Transfer based on a list of user IDs that I have.
Oddly though Transfer isn't giving me the result back I expect.
Here's my code...
listOfUsers = '14750309,9179162,14750303';
tql = 'select user.id, user.milestone, user.emailFlag,
user.name
from user where user.id NOT IN (:list)';
query = application.transfer.createQuery(tql);
query.setParam('list',listOfUsers,'list');
qryUsers = application.transfer.listByQuery(query);
This should actually give me an empty recordset because I've only got
these 3 users, however the dump shows me the 2nd and 3rd result.
The SQL being generated when I try it in mySQL works fine but from my
reading up on TQL this querying against the objects (?) not the
Database but these users. These are all in the cache but still why am
I getting results when I shouldn't be?
Can I just say though I think Transfer is very cool so far :-). It's
great to see all the extra code I had before just disappear. Great
job :-)
Thanks a lot,
James
--
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
