Hey Everyone,
I d/L Build 291 and installed it. had no problems with the install. I decided to try the reports again and having only users see only their data. I saw nothing, so I decided to look at the $strSQL in the report, and this is what is echoed to me:
select `orderDetailID`, `orderMasterID`, `customerID`, `customer`, `name`, `branchID`, `departmentID`, `newRenew`, `orderDate`, `issnID`, `title`, `updatePrice`, `discount`, `rateID`, `term`, `circulation`, `list`, `rate`, `postage`, `quantity`, `issues`, `amount`, `remit` From `orderDetail` where 0='812125' ORDER BY 2 ASC, 1 ASC, 12 ASC
Where the 0=`812125` should say customerID=`812125`, so I still can not use the reports for my users.
Just wanted to report what I found..
Thanks
Mike
PS.. Keep up the good work, I know you will solve this problem soon enough
