On Fri, Sep 3, 2010 at 9:25 AM, Richard Arts <arts.rich...@gmail.com> wrote:
> These are also mere suggestions. > > The statements you use in your print statement and the one you use to > feed the cursor differ slightly. The latter is missing quotes around > your search criterium. > > Isn't it possible to fetch results row by row and see if the missing > row is in the set? That way you can get a better feeling about the > nature of the error. > Well, I just tried, out of curiosity, inserting 0 instead of 1 and guess what? It shows up. So by simply changing that my problem is solved...but I sure as heck would like to know why! > > > cursor.execute('insert into spreadsheets values (Null, %s, 0, %s, 0, > Null)', (client, prod)) > > Out of curiosity, why would you want to insert null values in id > fields? That's a disaster waiting to happen. > Hardly. This is the standard way of inserting into auto_increment fields. That triggers the auto_increment! That makes it much easier to insert the correct value of the field. beno
-- http://mail.python.org/mailman/listinfo/python-list