Yes, that sounds like a winner idea. I can't tell a Boolean from a stat when their all numbers. I do all the number crunching in fox pro (win/loss, home/visitor, conference) and then rank the teams by category for power points. Then I upload the new game scores and stats to my site (mysql). It definitely picks a lot of the upsets. I will rewrite the logic in the off season. Thanks, Gary Jeurink
-----Original Message----- From: Man-wai Chang [mailto:[email protected]] Sent: Thursday, October 24, 2013 7:01 AM To: [email protected] Cc: [email protected] Subject: Re: mysql workbench I rather use a char(1) field with values ("Y"."N") for logical value. That would make update errors visible and data recovery easier. On 10/23/13, Gary Jeurink <[email protected]> wrote: > to mysql data transfers. I still have to change all the .t. and .f. to 1 > and 0 along with reformatting the dates using word macro's but over all I'm > really happy with it. -- .~. Might, Courage, Vision. SINCERITY! / v \ 64-bit Ubuntu 9.10 (Linux kernel 2.6.39.3) /( _ )\ http://sites.google.com/site/changmw ^ ^ May the Force and farces be with you! _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/1ADE4766590749D2BA7A9813C0992D5C@OwnerPC ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.

