You need to sign in to do that
Don't have an account?
Adivi
Problem with query (tested in sforce explorer too)
For example I have a case A with only one comment... Lets say the parentID='caseid' and ID='comment' for case A in the caseComment table...
Now when I query the database with individually saying
1) where parentID='caseid'
2) where ID='comment'
then the only comment is returned...
But when I do
3) select x, y, z from caseComment where parentID='caseid' and id!='comment'
It still returns the comment... This is true for some cases and not in some other cases.. I guess these ID and parentID values have leading or trailing spaces in 'comment' or 'caseid'...
Is it something I am doing wrong?.... Please HELP
Now when I query the database with individually saying
1) where parentID='caseid'
2) where ID='comment'
then the only comment is returned...
But when I do
3) select x, y, z from caseComment where parentID='caseid' and id!='comment'
It still returns the comment... This is true for some cases and not in some other cases.. I guess these ID and parentID values have leading or trailing spaces in 'comment' or 'caseid'...
Is it something I am doing wrong?.... Please HELP
Adivi
Forget about it... I was doing something wrong... sorry for the trouble...