Apex Code Development You need to sign in to do that
Don't have an account?
stcforce weird soql results - please help
I inserted five events (subject = '1','2', etc). I searched on a) a set created using the ids of these b) a list of events.
In either case, i searched for events where id was in the set/list, recieved a correct number of records back, but they were all duplicates of the first event inserted. The following is the log for a debug statement of the set of ids, the query using these ids, and the results using a debug statement. any thoughts?
13:08:56.044 (2044220000)|USER_DEBUG|[78]|DEBUG|{00U90000003I98MEAS, 00U90000003I98NEAS, 00U90000003I98OEAS, 00U90000003I9C0EAK, 00U90000003I9C1EAK}
13:08:56.044 (2044288000)|SOQL_EXECUTE_BEGIN|[79]|Aggregations:0|select e.id, e.subject, e.whatid, e.whoid,
e.startdatetime from event e where e.id in:events
13:08:56.046 (2046644000)|SOQL_EXECUTE_END|[79]|Rows:5
13:08:56.046 (2046773000)|USER_DEBUG|[81]|DEBUG|subject: 1, id:00U90000003I98MEAS, whatid:0019000000A7orkAAB, whoid:true, 0039000000A7FiFAAV, starting: 2012-01-30 04:08:56
13:08:56.046 (2046840000)|USER_DEBUG|[81]|DEBUG|subject: 1, id:00U90000003I98MEAS, whatid:0019000000A7orkAAB, whoid:true, 0039000000A7FiFAAV, starting: 2012-01-30 04:08:56
(the remaining rows are the same)
could you post up more of the debugger and posible some code.