7:30 – 3:30 VISIBILITY

• Working from home today. When the roads melt, I’ll see if I can go install the PPM update from yesterday
• Installing xampp – done. Worked the first time. Sooooooooooooooooooooo nice.
• Working on a version of DbTable that tries to match a java data type to the sql data type. Done, at least for the types that Flex likes.
• Walked through the concept of views into infinite data with Mike.
• Installed the new PPM. When I updated the DB, I got some errors:
  • On the 10th item (UPDATE direct_cites SET contract_id = [SELECT uid FROM contracts WHERE direct_cites.contract_number = contracts.contract_number )], and the 13th item (UPDATE funding_requests SET project_id = [SELECT uid FROM projects WHERE funding_requests.project_number = projects.project_number )] I got the following error:
  • ERROR 1242 (21000): Subquery returns more than 1 row
  • I left it as is since things appeared to be working. Worst case I can roll it back to just before I made the change.