Re: Help confirm a MySQL ODBC bug

2007-08-10 Thread MB Software Solutions
Steve Ellenoff wrote: > Thanks for the tip about the option string Ted, I hadn't realized you > could specify it, cool! > I use option=131609 from Bob Lee's MySQL examples from years ago. His website is 1amsoftware.com -- Michael J. Babcock, MCP MB Software Solutions, LLC http://mbsoftwares

Re: Help confirm a MySQL ODBC bug

2007-08-10 Thread Steve Ellenoff
>Yeah, there's lots of options, and it's worth looking at what your >version of VFP is expecting and how you want the various types of >fields to be translated. I was aware of the options, but I had always used the MySQL ODBC GUI to set them up, I hadn't realized you could put that in as part of

Re: Data Strategy

2007-08-10 Thread Ted Roche
On 8/9/07, Mark Stanton <[EMAIL PROTECTED]> wrote: > Ok, so you've both (Ed & Ted) put more or less the same scenario. Great minds? Or guys who've just been hanging around a long, long time? > Of course, I'd still like an answer to my previous question. If this > is really not doable and views c

Re: Help confirm a MySQL ODBC bug

2007-08-10 Thread Ted Roche
On 8/10/07, Steve Ellenoff <[EMAIL PROTECTED]> wrote: > > I would concur. Do you know the best method to report this bug to be > fixed quickly as a conversion I'm doing requires a LONGTEXT field? > The only communications I've had with the MySQL folks is through their forums. You may want to test

RE: [OT] Mexican migrant workers in Canada

2007-08-10 Thread Michael Madigan
When did I say I was against birth control? Let these monkeys wrap on a rubber and there wouldn't be any problems. Why do we have to have irrisponsible behavior? Of course having their children is much better than killing them, but they shouldn't be conceived in the first place. What responsibl

Re: [NF] The Music Genome Project

2007-08-10 Thread Andy Davies
Andrew Davies  MBCS CITP   - AndyD    8-)# "Jean Laeremans"

Re: Data Strategy

2007-08-10 Thread Andy Davies
>my preset views are a structural necessity, >and it's then a case of adding the filtering to those. >But how? >Mark CursorAdapters ?? Andrew Davies  MBCS CITP   - AndyD    8-)# ** Manchester City Council supports Smokefr

Re: [NF] The Music Genome Project

2007-08-10 Thread Jean Laeremans
On 8/10/07, Andy Davies <[EMAIL PROTECTED]> wrote: > works for me in the UK - > perhaps not surprisingly it bombed on Cecilia Bartoli but had no problems > with Crystal Gayle ! > Don't make my brown eyes blue ? A+ jml ___ Post Messages to: ProFox@leafe

Re: Help confirm a MySQL ODBC bug

2007-08-10 Thread Ted Roche
On 8/10/07, MB Software Solutions <[EMAIL PROTECTED]> wrote: > Ted Roche wrote: > > I'm running MySQL ODBC Driver 3.51.12.0 against MySQL 4.1.20. > > > I'm using MySQL 5 now. I enjoy the addition of stored procedures! Yep, that was an older scratch system I had sitting around that was easy to con

Re: Help confirm a MySQL ODBC bug

2007-08-10 Thread MB Software Solutions
Ted Roche wrote: > I'm running MySQL ODBC Driver 3.51.12.0 against MySQL 4.1.20. > I'm using MySQL 5 now. I enjoy the addition of stored procedures! -- Michael J. Babcock, MCP MB Software Solutions, LLC http://mbsoftwaresolutions.com http://fabmate.com "Work smarter, not harder, with MBSS cu

Re: Help confirm a MySQL ODBC bug

2007-08-10 Thread Ted Roche
On 8/10/07, Steve Ellenoff <[EMAIL PROTECTED]> wrote: > Thanks for the tip about the option string Ted, I hadn't realized you > could specify it, cool! Yeah, there's lots of options, and it's worth looking at what your version of VFP is expecting and how you want the various types of fields to be

RE: Help confirm a MySQL ODBC bug

2007-08-10 Thread Dave Crozier
Brian, Substitute the following after the Browse: cStr=Replicate("Hello12345",300) lcExec=[Insert Into mysqlbug Values (20, "Hello", "There", ?cStr)] If loSPT.Execute(lcExec) > 0 * lcExec=[select * from mysqlbug] If loSPT.Execute(lcExec) > 0 * Browse * Endi

Re: Help confirm a MySQL ODBC bug

2007-08-10 Thread Ted Roche
On 8/9/07, Steve Ellenoff <[EMAIL PROTECTED]> wrote: > Can some of you who have access to MySQL run the following code > (below) and post back your results, along with your version of the > ODBC driver (including sub revision #) & MySQL Engine. > Hi, Steve: Little buglet in your code, you hard-co

RE: [OT] Mexican migrant workers in Canada

2007-08-10 Thread Kristyne McDaniel
Hi Vince! > Does not follow. Plenty of American families with 4 kids who aren't > poverty stricken. I know, I was one of them. What's your > second guess? I am the first in 4 children from my mother. We were not poverty stricken but had plenty of issues over her 'mothering' period. Frankly,

Re: Updated version of VFPCompression - Password Protection

2007-08-10 Thread Alan Bourke
Yeah, I do. Thanks for the headsup! ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com

Re: Replacement for ODBC in Vista

2007-08-10 Thread Alan Bourke
ODBC appears to be present and correct in my Vista ... ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archiv

Re: Help confirm a MySQL ODBC bug

2007-08-10 Thread Steve Ellenoff
>You may want to test the .18 release. They indicate a number of >problems are fixed with SQLColumns, which is what ODBC is using >internally to query the data structure and determine field sizes: > >http://forums.mysql.com/read.php?37,166267,166267#msg-166267 Yes I had great hopes for the .18 re

Re: Data Strategy

2007-08-10 Thread MB Software Solutions
Steve Ellenoff wrote: >> I'm guessing I may have recreated the wheel with my approach vs. CAs, >> but after hearing from Ed that CAs had issues with MySQL from his pov, >> that was enough for me to steer clear of them. However, I know other >> guys who seem to swear by them now. >> > > I also

Re: Data Strategy

2007-08-10 Thread Steve Ellenoff
>I'm guessing I may have recreated the wheel with my approach vs. CAs, >but after hearing from Ed that CAs had issues with MySQL from his pov, >that was enough for me to steer clear of them. However, I know other >guys who seem to swear by them now. I also tried CA's when I started with MySQL an

Re: Data Strategy

2007-08-10 Thread MB Software Solutions
Andy Davies wrote: >> my preset views are a structural necessity, >> and it's then a case of adding the filtering to those. >> But how? >> Mark >> > > CursorAdapters ?? > I'm guessing I may have recreated the wheel with my approach vs. CAs, but after hearing from Ed that CAs had issues wi

RE: Help confirm a MySQL ODBC bug

2007-08-10 Thread mrgmhale
> I ran into something where the newest > ODBC driver > on a varchar field was padding out the characters to the full > field length. That is NOT a bug, the target value is padded to match the length of the field in the target cursor. I ran into this about 8 or 9 years ago when I was writing a v

RE: [OT] Mexican migrant workers in Canada

2007-08-10 Thread Kristyne McDaniel
Madigan, > I guess it never occurred to Senor Teddy that having > four children might be the cause of his poverty. It is only recent history that believes four children is a lot of children. My father was one of 11 children. I am one of four children -- six if you count the step children Kristyn

RE: Help confirm a MySQL ODBC bug

2007-08-10 Thread Brian Erickson
Same thing happed to me. The longtext cam back as c(255). I am running a mysql 5.0.32 on Debian. My odbc driver version number is: 3.51.14.00. I hope that helps. Brian Erickson mailto:[EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf O

Re: [NF] The Music Genome Project

2007-08-10 Thread Andy Davies
works for me in the UK - perhaps not surprisingly it bombed on Cecilia Bartoli but had no problems with Crystal Gayle ! see also: www.pristineclassical.com Andrew Davies  MBCS CITP   - AndyD    8-)# ** Manchester City Co

Multiuser conflicts using SPT?

2007-08-10 Thread Steve Ellenoff
Sorry if the answer is obvious, but how are conflicts handled when not using TABLEUPDATE() in VFP, ie, if you are rolling your own UPDATE SQL commands and firing them back to the server? I assume the problem is minimized if the code that generates your UPDATE is only sending changed fields, but

Re: Data Strategy

2007-08-10 Thread MB Software Solutions
Ted Roche wrote: > It sounds like you're expecting views to be an entire data manager > layer. That's not what they do. MS tried to create one with > cursoradaptors; I think they missed several important points. Doug > Hennig added some great functionality to them in 8.0 and 9.0, but I > never got

[NF] GoDaddy REALLY SUCKS!!!

2007-08-10 Thread Chet Gardiner
I'm trying to transfer a domain to someone else. I followed their instructions -- doesn't work. I tried emailing them -- they'll get back to me in 24 hours... I tried calling their tech support (ha-ha) number -- can't get connected... I tried calling their sales number -- got an Indian voice --

Re: [NF] The Music Genome Project

2007-08-10 Thread Jean Laeremans
On 8/10/07, Andy Davies <[EMAIL PROTECTED]> wrote: > > > Andrew Davies MBCS CITP > - AndyD 8-)# > > > > "Jean Laeremans" > @gmail.com> cc: > Sent by:Subject: Re: [NF] The

Re: Help confirm a MySQL ODBC bug

2007-08-10 Thread Steve Ellenoff
Thanks for the tip about the option string Ted, I hadn't realized you could specify it, cool! How could I have avoided hard coding the database name? So did you try the example and get the proper results? At 08:17 AM 8/10/2007, you wrote: >On 8/9/07, Steve Ellenoff <[EMAIL PROTECTED]> wrote: >

Re: Multiuser conflicts using SPT?

2007-08-10 Thread Ted Roche
On 8/10/07, Steve Ellenoff <[EMAIL PROTECTED]> wrote: > Sorry if the answer is obvious, but how are conflicts handled when > not using TABLEUPDATE() in VFP, ie, if you are rolling your own > UPDATE SQL commands and firing them back to the server? I assume the > problem is minimized if the code tha

Re: Multiuser conflicts using SPT?

2007-08-10 Thread MB Software Solutions
Steve Ellenoff wrote: > Sorry if the answer is obvious, but how are conflicts handled when > not using TABLEUPDATE() in VFP, ie, if you are rolling your own > UPDATE SQL commands and firing them back to the server? I assume the > problem is minimized if the code that generates your UPDATE is onl

RE: [OT] Mexican migrant workers in Canada

2007-08-10 Thread Kristyne McDaniel
Vince, > A) He could have been impoverished before having 4 (or any) > kids. 6 can > starve as cheaply as 2. This is the same guy that doesn't want any abortions. With no abortions and no birth control, many of us would have 6+ children. Children are our future. No matter if they come from an

Re: [NF] GoDaddy REALLY SUCKS!!!

2007-08-10 Thread Derek Kalweit
> I'm trying to transfer a domain to someone else. > > I followed their instructions -- doesn't work. > > I tried emailing them -- they'll get back to me in 24 hours... > > I tried calling their tech support (ha-ha) number -- can't get connected... > > I tried calling their sales number -- got an I

Re: [NF] GoDaddy REALLY SUCKS!!!

2007-08-10 Thread MB Software Solutions
Chet Gardiner wrote: > I'm trying to transfer a domain to someone else. > > I followed their instructions -- doesn't work. > > I tried emailing them -- they'll get back to me in 24 hours... > > I tried calling their tech support (ha-ha) number -- can't get connected... > > I tried calling their sal

[NF] SCO loses!

2007-08-10 Thread Ted Roche
http://www.groklaw.net/article.php?story=20070810165237718 -- Ted Roche Ted Roche & Associates, LLC http://www.tedroche.com ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of th

RE: [NF] GoDaddy REALLY SUCKS!!!

2007-08-10 Thread Jeff Johnson
> -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > On Behalf Of MB Software Solutions > Sent: Friday, August 10, 2007 2:49 PM > To: [EMAIL PROTECTED] > Subject: Re: [NF] GoDaddy REALLY SUCKS!!! > > Chet Gardiner wrote: > > I'm trying to transfer a domain to someone

Re: [OT] Mexican migrant workers in Canada

2007-08-10 Thread Ricardo Aráoz
Kristyne McDaniel wrote: > Madigan, > >> I guess it never occurred to Senor Teddy that having >> four children might be the cause of his poverty. > > It is only recent history that believes four children is a lot of children. > My father was one of 11 children. I am one of four children -- six if

Re: [OT] Mexican migrant workers in Canada

2007-08-10 Thread Ricardo Aráoz
Michael Madigan wrote: > When did I say I was against birth control? Let these > monkeys wrap on a rubber and there wouldn't be any > problems. Soon the Chinese will start selling their US bonds. Then dollar will plummet and US will fall. Then I will be telling you monkeys to wrap on a rubber

RE: Multiuser conflicts using SPT?

2007-08-10 Thread Stephen the Cook
Steve Ellenoff <> wrote: > Sorry if the answer is obvious, but how are conflicts handled when > not using TABLEUPDATE() in VFP, ie, if you are rolling your own > UPDATE SQL commands and firing them back to the server? I assume the > problem is minimized if the code that generates your UPDATE is onl

[OT] Mexican migrant workers in Canada

2007-08-10 Thread richmondeagle
>Soon the Chinese will start selling their US bonds. Then dollar will >plummet and US will fall. Then I will be telling you monkeys to wrap on >a rubber. and to put a shirt over your wet backs. That would be rather foolish of them. If the dollar falls, the price of their goods would rise. T

RE: [NF] GoDaddy REALLY SUCKS!!!

2007-08-10 Thread Stephen the Cook
Chet Gardiner <> wrote: > I'm trying to transfer a domain to someone else. > > I followed their instructions -- doesn't work. > > I tried emailing them -- they'll get back to me in 24 hours... > > I tried calling their tech support (ha-ha) number -- can't get > connected... > > I tried calling

[NF] GoDaddy REALLY SUCKS!!!

2007-08-10 Thread richmondeagle
>My experiences with them in the past have been very good, very pleasant, >and very US-based! That was about a year ago? Chet -- there's a >conspiracy against you perpetrated by right wing conserative emissaries >of Bill Gates personal entourage at M$. >GoDaddy is based in Scottsdale Arizona

Re: [NF] SCO loses!

2007-08-10 Thread Vince Teachout
Yehaw! ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox T

Multiple sql commands to MySQL with a single SQLEXEC()?

2007-08-10 Thread Steve Ellenoff
Has anyone had success doing this? I tried sending two commands separated by a ; (which is the default MySQL delimiter iirc), and it always gives an odbc syntax error. Am I missing something obvious? Thanks Steve ___ Post Messages to: ProFox@leafe.

Re: Multiuser conflicts using SPT?

2007-08-10 Thread Steve Ellenoff
>"Update using PK and Changed Fields" just like the option for views: > >UPDATE Customer SET LastName = "Jones" WHERE Customer.id = 37 and >LastName="Smith" > >Fails if someone else has already updated the record so that the ID=37 >and LastName="Smith" is not a match. Interesting approach. So in

Re: [OT] Mexican migrant workers in Canada

2007-08-10 Thread Vince Teachout
Ricardo Aráoz wrote: > Michael Madigan wrote: > >> What responsible man gets a woman pregnant who can't >> support them? >> Do you know this guy? Do you know what his financial situation was at the time? How do you know he wasn't well off at the time he had the kids? What do you think

Re: Multiuser conflicts using SPT?

2007-08-10 Thread MB Software Solutions
Steve Ellenoff wrote: >> "Update using PK and Changed Fields" just like the option for views: >> >> UPDATE Customer SET LastName = "Jones" WHERE Customer.id = 37 and >> LastName="Smith" >> >> Fails if someone else has already updated the record so that the ID=37 >> and LastName="Smith" is not a mat

Re: Multiuser conflicts using SPT?

2007-08-10 Thread Steve Ellenoff
No...everyone who attempts to make their change after the 1st person has >changed it (assuming they all checked out the data at the same time) >losesnot just the last guy. I wasn't thinking beyond the 2 person example, but yeah, that's what I meant, everyone loses but the 1st guy. _

Re: [NF] GoDaddy REALLY SUCKS!!!

2007-08-10 Thread Chet Gardiner
I live in Arizona too... Of course, I'm in the "liberal" bastion of Tucson rather than East-East-LA-Phoenix... Jeff Johnson wrote: >> -Original Message- >> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] >> On Behalf Of MB Software Solutions >> Sent: Friday, August 10, 2007 2:49 PM >

Re: [OT] Mexican migrant workers in Canada

2007-08-10 Thread Michael Madigan
Sure, that's why he's picking vegetables. I'm sure if you lose your well-paying job, you'll be picking vegetables too. Responsible people have children they can afford. This is why Mexico is such a crappy country. --- Vince Teachout <[EMAIL PROTECTED]> wrote: > Ricardo Aráoz wrote: > > Micha

Re: [NF] GoDaddy REALLY SUCKS!!!

2007-08-10 Thread Michael Madigan
It's Bush's fault. --- Chet Gardiner <[EMAIL PROTECTED]> wrote: > I live in Arizona too... > > Of course, I'm in the "liberal" bastion of Tucson > rather than > East-East-LA-Phoenix... > > > Jeff Johnson wrote: > >> -Original Message- > >> From: [EMAIL PROTECTED] > [mailto:[EMAIL PRO

Re: [NF] GoDaddy REALLY SUCKS!!!

2007-08-10 Thread Chet Gardiner
"Is it your karma?" I doubt it. I got the site when an ex music-partner of mine was down and out, saved it for him and am trying to transfer it back into his hands now that he's doing better. That gets you "good points" in heaven, right? They're asking for numbers that they imply they've sent

Re: [OT] Mexican migrant workers in Canada

2007-08-10 Thread Pete Theisen
On Friday 10 August 2007 18:18, Vince Teachout wrote: > Do you know this guy? Do you know what his financial situation was at > the time? How do you know he wasn't well off at the time he had the > kids? What do you think he should do? Kill off the kids if he loses > his job? Never have kids,

Re: [NF] GoDaddy REALLY SUCKS!!!

2007-08-10 Thread Steve Ellenoff
I've used them for awhile and haven't had much complaints, but not much need to deal with them either, so I can't say but it wouldn't surprise me that you're having issues. At 05:10 PM 8/10/2007, you wrote: >I'm trying to transfer a domain to someone else. > >I followed their instructions -- doe

Re: [NF] GoDaddy REALLY SUCKS!!!

2007-08-10 Thread Chet Gardiner
"conspiracy against you perpetrated by right wing conservative emissaries" Don't look now, but that same bunch is perpetrating the same conspiracy against you... :-) MB Software Solutions wrote: > Chet Gardiner wrote: > >> I'm trying to transfer a domain to someone else. >> >> I followed

Re: [NF] GoDaddy REALLY SUCKS!!!

2007-08-10 Thread Chet Gardiner
Ah, so that's where they're pissing away my money instead of a decent web presence... [EMAIL PROTECTED] wrote: >> My experiences with them in the past have been very good, very pleasant, >> and very US-based! That was about a year ago? Chet -- there's a >> conspiracy against you perpetrated

Re: [NF] GoDaddy REALLY SUCKS!!!

2007-08-10 Thread MB Software Solutions
Chet Gardiner wrote: > "conspiracy against you perpetrated by right wing conservative emissaries" > > Don't look now, but that same bunch is perpetrating the same conspiracy > against you... :-) > That group must include my wife's bitch attorney then, who calls me evil and greedy for wantin

Re: Multiuser conflicts using SPT?

2007-08-10 Thread MB Software Solutions
Steve Ellenoff wrote: > No...everyone who attempts to make their change after the 1st person has > >> changed it (assuming they all checked out the data at the same time) >> losesnot just the last guy. >> > > I wasn't thinking beyond the 2 person example, but yeah, that's what > I mean

Re: Multiuser conflicts using SPT?

2007-08-10 Thread Ted Roche
On 8/10/07, MB Software Solutions <[EMAIL PROTECTED]> wrote: > In the examples I've seen, you then deal with it and ask the user if > s/he wants to overwrite the current values anyway. Then you force it > through by pkey only and not changed values. ... or refresh the display and let them decide

[NF] GoDaddy really sucks... at least one time, on one side, in Scotland

2007-08-10 Thread Whil Hentzen (Pro*)
Chet, Chet, Chet. Let's not let a single instance of a bad customer experience color an entire company. It would be impossible for any company to bat 100% Except Quantas, who has never lost an airplane, but one would think they're due, huh. I've been using GoDaddy for years, for upwards of

RE: [NF] GoDaddy really sucks... at least one time, on one side, in Scotland

2007-08-10 Thread John Harvey
Yep, what he said. I've had good service with all the domains I've registered with Godaddy too. And besides, they have a pretty good Super Bowl commercial, as I recall. JH -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Whil Hentzen (Pro*) Sent: Friday, A

Re: [NF] GoDaddy REALLY SUCKS!!!

2007-08-10 Thread Man-wai Chang
Chet Gardiner wrote: > I'm trying to transfer a domain to someone else. http://www.dyndns.org -- @~@http://changmw.homeip.net / v \ May the Force and Farce be with you! Linux 2.6.22.2 /( _ )\ (Xubuntu 7.04) 10:28:01 up 21:14 0 users ^ ^load average: 0.05 0.04 0.00 news://news.3h

Re: [NF] GoDaddy really sucks... at least one time, on one side, in Scotland

2007-08-10 Thread Man-wai Chang
http://www.dyndns.org -- @~@http://changmw.homeip.net / v \ May the Force and Farce be with you! Linux 2.6.22.2 /( _ )\ (Xubuntu 7.04) 10:28:01 up 21:14 0 users ^ ^load average: 0.05 0.04 0.00 news://news.3home.net news://news.hkpcug.org news://news.newsgroup.com.hk __

Re: [OT] Mexican migrant workers in Canada

2007-08-10 Thread Pete Theisen
On Friday 10 August 2007 18:26, Michael Madigan wrote: > Sure, that's why he's picking vegetables. > > I'm sure if you lose your well-paying job, you'll be > picking vegetables too. Hi Michael! I have picked a LOT of vegetables, planted them, cultivated them, fertilized them and sold them. Farmi

Re: [NF] SCO loses!

2007-08-10 Thread Man-wai Chang
> http://www.groklaw.net/article.php?story=20070810165237718 I remembered Caldera OpenLinux -- my first contact with linux. :) -- @~@http://changmw.homeip.net / v \ May the Force and Farce be with you! Linux 2.6.22.2 /( _ )\ (Xubuntu 7.04) 11:13:01 up 21:59 0 users ^ ^load avera

Re: [NF] GoDaddy REALLY SUCKS!!!

2007-08-10 Thread Michael Madigan
Women attorneys should have their penises cut off. --- MB Software Solutions <[EMAIL PROTECTED]> wrote: > Chet Gardiner wrote: > > "conspiracy against you perpetrated by right wing > conservative emissaries" > > > > Don't look now, but that same bunch is > perpetrating the same conspiracy > > a

RE: [NF] GoDaddy REALLY SUCKS!!!

2007-08-10 Thread Kristyne McDaniel
Michael, > That group must include my wife's bitch attorney then, who > calls me evil > and greedy for wanting a 50% fair share split of the house > equity. I'd > swear that b*tch is a card-carrying fembot. My first ex-husband got 2/3 of the house equity when it sold because he refused to si