RE: mysql workbench

2013-10-27 Thread Gary Jeurink
@leafe.com Subject: Re: mysql workbench On Fri, Oct 25, 2013 at 6:49 PM, Gary Jeurink g.jeur...@charter.net wrote: Thanks for your reply but the False = 0 / N / .F. True = 1 / Y / .T. .. is over my head is that associate array? My biggest block today is how to set the value of a date variable

RE: mysql workbench

2013-10-27 Thread Gary Jeurink
: Friday, October 25, 2013 6:49 PM To: 'ProFox Email List' Subject: RE: mysql workbench I'm in class learning how to use quickbooks, so I went ahead and figured it out Here you go ?php $curdate=date('Y/m/d'); $firstdate=date_create_from_format(j-M-Y,27-Aug-2013); echo date_format($firstdate,Y/m/d

RE: mysql workbench

2013-10-27 Thread Virgil Bierschwale
- From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Gary Jeurink Sent: Sunday, October 27, 2013 1:08 PM To: 'ProFox Email List' Subject: RE: mysql workbench Thanks... Ted corrected my previous version and your solution should work too. Is it a problem that curDate uses slashes

RE: mysql workbench

2013-10-27 Thread Virgil Bierschwale
Jeurink Sent: Sunday, October 27, 2013 1:08 PM To: 'ProFox Email List' Subject: RE: mysql workbench Thanks... Ted corrected my previous version and your solution should work too. Is it a problem that curDate uses slashes and the rest uses dashes. It's the firstDate that keeps getting flagged. Gary

RE: mysql workbench

2013-10-25 Thread Gary Jeurink
). 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:chan...@gmail.com] Sent: Thursday, October 24, 2013 7:01 AM To: profox@leafe.com Cc: profoxt...@leafe.com Subject: Re: mysql workbench I

Re: mysql workbench

2013-10-25 Thread Stephen Russell
On Fri, Oct 25, 2013 at 10:58 AM, Gary Jeurink g.jeur...@charter.netwrote: 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

RE: mysql workbench

2013-10-25 Thread Gary Jeurink
Russell [mailto:srussell...@gmail.com] Sent: Friday, October 25, 2013 11:32 AM To: ProFox Email List Subject: Re: mysql workbench On Fri, Oct 25, 2013 at 10:58 AM, Gary Jeurink g.jeur...@charter.netwrote: Yes, that sounds like a winner idea. I can't tell a Boolean from a stat when their all

Re: mysql workbench

2013-10-25 Thread Ted Roche
On Fri, Oct 25, 2013 at 6:49 PM, Gary Jeurink g.jeur...@charter.net wrote: Thanks for your reply but the False = 0 / N / .F. True = 1 / Y / .T. .. is over my head is that associate array? My biggest block today is how to set the value of a date variable without a syntax error in PHP

RE: mysql workbench

2013-10-25 Thread Virgil Bierschwale
. Virgil N5IVV -Original Message- From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Gary Jeurink Sent: Friday, October 25, 2013 5:49 PM To: 'ProFox Email List' Subject: RE: mysql workbench Thanks for your reply but the False = 0 / N / .F. True = 1 / Y / .T. .. is over my head

RE: mysql workbench

2013-10-25 Thread Virgil Bierschwale
is actually used. -Original Message- From: Virgil Bierschwale [mailto:vbier...@gmail.com] Sent: Friday, October 25, 2013 6:16 PM To: 'ProFox Email List' Subject: RE: mysql workbench Sorry, I've been busy with my own stuff and didn't see that you were still working on this ?php $curdate=date

Re: mysql workbench

2013-10-24 Thread Man-wai Chang
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 g.jeur...@charter.net wrote: to mysql data transfers. I still have to change all the .t. and .f. to 1 and 0 along with reformatting the

Re: mysql workbench

2013-10-24 Thread MB Software Solutions, LLC
On 10/24/2013 8:01 AM, Man-wai Chang wrote: 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 g.jeur...@charter.net wrote: to mysql data transfers. I still have to change all the .t. and

Re: mysql workbench

2013-10-24 Thread Stephen Russell
On Thu, Oct 24, 2013 at 1:29 PM, MB Software Solutions, LLC mbsoftwaresoluti...@mbsoftwaresolutions.com wrote: On 10/24/2013 8:01 AM, Man-wai Chang wrote: 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

RE: mysql workbench

2013-10-24 Thread Gary Jeurink
To: profox@leafe.com Subject: RE: mysql workbench Gary Jeurink wrote on 2013-10-22: I have been playing with MYSQL WORKBENCH for several months. My main difficulty was in believing that the on line help at godaddy were some sort of super geeks. They are not. Once your data bases are set up

Re: mysql workbench

2013-10-24 Thread MB Software Solutions, LLC
On 10/24/2013 2:46 PM, Stephen Russell wrote: There is no bit or binary data type? Yes there is. MySQL has a bit type. -- Mike Babcock, MCP MB Software Solutions, LLC President, Chief Software Architect http://mbsoftwaresolutions.com http://fabmate.com http://twitter.com/mbabcock16

Re: mysql workbench

2013-10-24 Thread Stephen Russell
On Thu, Oct 24, 2013 at 2:24 PM, MB Software Solutions, LLC mbsoftwaresoluti...@mbsoftwaresolutions.com wrote: On 10/24/2013 2:46 PM, Stephen Russell wrote: There is no bit or binary data type? Yes there is. MySQL has a bit type. --- Why not use the proper data

Re: mysql workbench

2013-10-24 Thread MB Software Solutions, LLC
On 10/24/2013 3:32 PM, Stephen Russell wrote: On Thu, Oct 24, 2013 at 2:24 PM, MB Software Solutions, LLC mbsoftwaresoluti...@mbsoftwaresolutions.com wrote: On 10/24/2013 2:46 PM, Stephen Russell wrote: There is no bit or binary data type? Yes there is. MySQL has a bit type.

Re: mysql workbench

2013-10-24 Thread Stephen Russell
On Thu, Oct 24, 2013 at 2:35 PM, MB Software Solutions, LLC mbsoftwaresoluti...@mbsoftwaresolutions.com wrote: Why not use the proper data version. Hence why I asked how Y or N was better. --- Bingo! -- Stephen Russell Sr. Analyst Ring Container Technology

RE: mysql workbench

2013-10-22 Thread Tracy Pearson
Gary Jeurink wrote on 2013-10-22: I have been playing with MYSQL WORKBENCH for several months. My main difficulty was in believing that the on line help at godaddy were some sort of super geeks. They are not. Once your data bases are set up correctly, then the work bench program (free),