App written in VFP9SP1. My O/S: WinXP Pro MySQL database local version is 4.0.13-nt. MySQL web database version is 4.1.15-Debian_1-log. MyODBC driver version is MySQL ODBC 3.51. These SQL statements are stored in a local DBF lookup table and retrieved for SPT execution on the fly. Other: I'm wearing green today and I like pumpkin pie. <g>
Problem: I have a SPT that is something like this using private variables for the '?' variables below: 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). Suggestions (if sufficient information posted above)? My "Plan B" is to have the ?variables substituted/manipulated somehow prior to the SQLEXEC so that the actual values get embedded literally in the SPT. Thanks, --Michael -- 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: [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.
