fixed password issue for commission queries