Change my VFP code to convert afterwards. In my case, I stored the count in a memvar to drive a loop , so I just converted it to integer via VAL(the_count)
At 06:11 PM 2007-05-01 -0400, you wrote: >Larry Bradley wrote: > > Michael, I've been bit by the mySQL count being character. It happens with > > a simple "select count(*) from table". CAST, etc doesn't fix it. > > > > I don't know if it is mySQL or the ODBC driver. > > > >Ok...that would be this case. What was your workaround? > >-- >Michael J. Babcock, MCP >MB Software Solutions, LLC >http://mbsoftwaresolutions.com >http://fabmate.com >"Work smarter, not harder, with MBSS custom software solutions!" > > > [excessive quoting removed by server] _______________________________________________ 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 This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] ** 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.