Whil Hentzen (Pro*) wrote: > > Well, there you go again..... I heard that the folks who make WinXP have > been seen recently consorting with Communists. > Now hey, don't talk about Chet that way....Senator McCarthy's legacy shouldn't continue, Whil! <g>
> >> 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'?) > Correct. > 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... > Kevin's TEXTMERGE idea seems to have fit the bill perfectly, so no need for that...but thanks anyway! > Green? I don't think that works with your complexion. You need to see a > professional. IMHO, of course. > Oh there's no doubt about that...hopefully the Doc will give me the script when I see him tomorrow! ;-) Can't wait for this year to be over....it's not been memorable for me! -- Michael J. Babcock, MCP MB Software Solutions, LLC http://mbsoftwaresolutions.com http://fabmate.com "Work smarter, not harder, with MBSS custom software solutions!" _______________________________________________ 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 ** 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.