Re: [transfer-dev] No records returned: CF7 and oracle

2011-01-04 Thread Pedro Bezunartea López
Hi Mark, So in the debug output - when you see the Transfer generated SQL, how many rows does it return? None. The table actually has just one row, that I dump using the transfer.list(...Session) query. But none using the listByQuery method (after the proper setParam, of course), or

Re: [transfer-dev] No records returned: CF7 and oracle

2011-01-04 Thread Mark Mandel
So that doesn't make sense... If the sql debug says that nothing is returned, but it returns values when you copy and paste it into a sql editor? Is that right? Mark On 04/01/2011 9:59 PM, Pedro Bezunartea López pe...@bezunartea.net wrote: Hi Mark, So in the debug output - when you see the

[transfer-dev] Re: No records returned: CF7 and oracle

2011-01-04 Thread pedrobl
This is getting weirder and weirder. I modified the table and transfer config changing the field name to session_token, instead of token. No luck, same results. I then tried to see the sql being sent to oracle when using listByProperty, and readByProperty. To do this I modified transfer

[transfer-dev] Re: No records returned: CF7 and oracle SOLVED

2011-01-04 Thread pedrobl
I found it!!! The problem was that the token field was defined as CHAR 36, and the token generated was 35 characters long. The token was being stored with an space at the end. What I still don't understand is why when transfer runs the query select PERSON_ID from NW_SESSIONS where SESSION_TOKEN