Python and MySQL 4.1

From: webdsine (webdsine_at_yahoo.ca)
Date: 10/31/04


Date: Sun, 31 Oct 2004 03:43:16 -0000
To: python-list@python.org


Hello. I just upgrade to MySQL 4.1 from 4.0, and I'm having trouble
retrieving text from the DB in the proper format using the MySQLdb
module in Python. All text fields that are retrieved are in this
format:

array('c', 'Whatever is in the field')

The only data that's not displayed in that format are enum values, and
when I was still in v4.0 only 'Whatever is in the field' is
retrieved.

Are there any quick fixes? I've completed my Python application
already, so I don't really want to go in and mess with the source code
if I don't need to.

Thanks in advance.



Relevant Pages

  • RE: Problem displaying Currency on form
    ... Ensure that the CustPrice text box Format Property is set to "Currency." ... Change the VBA code assigning the value to the text box so that it's ... > which I am retrieving and displaying on a form. ...
    (microsoft.public.access.forms)
  • RE: Problem displaying Currency on form
    ... > Change the VBA code assigning the value to the text box so that it's ... > explicitly the Currency data type. ... >> I have currency fields set up on my table (with the correct Currency format) ... >> which I am retrieving and displaying on a form. ...
    (microsoft.public.access.forms)
  • Re: Report Data Not pulling in
    ... In what format? ... If by "pulling in" you simply mean retrieving from tables based on criteria, ... Larry Linson ...
    (microsoft.public.access.reports)
  • Re: Python and MySQL 4.1
    ... > retrieving text from the DB in the proper format using the MySQLdb ... > module in Python. ...
    (comp.lang.python)
  • RE: date format
    ... How are u retrieving it in the first place that you get the wrong format? ... "Abbott" wrote: ... >> R. Thomas ...
    (microsoft.public.dotnet.framework.adonet)