MB Software Solutions wrote: > App written in VFP9SP1. > My O/S: WinXP Pro
Well, there you go again..... I heard that the folks who make WinXP have been seen recently consorting with Communists. > > select cname, iage, ddate from MySQLTable where iAge = ?piAge and dDate > between ?pdBegDate and ?pdEndDate > > This query works great (read: "returns data") on my local MySQL > database (on my Windows laptop); however, the same query running on my > ISP's Debian Linux box does not return any data (and yes, I've verified > the data is there). So it returns an empty cursor, right? As opposed to just returning without doing anything? (Meaning, are you sure the SQLEXEC is returning a '1'?) What about knocking the SELECT down a bit - do it without a WHERE clause, or (if that would return too many rows) a hard-coded iAge = 37. Then add iAge = ?piAge. Then add one of the two date ends (dDate > ?pdBegDate. And so on... Green? I don't think that works with your complexion. You need to see a professional. IMHO, of course. Whil _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech ** 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.
