I took out the quotes around the second part of the INSERT statement and that made it work fine.
On Mon, Mar 24, 2008 at 10:49 AM, Spencer Parker <[EMAIL PROTECTED]> wrote: > Okay...so I don't know what I was missing...but I copied the code from a > file I had without the loop in it...now it works just fine...I'm going > through to see what changed right now...thanks for the help...it is > appreciated... > > > On Mon, Mar 24, 2008 at 10:30 AM, Kent Johnson <[EMAIL PROTECTED]> wrote: > > > Spencer Parker wrote: > > > I am pretty sure it is trying to tell me that the data I have is not > > > matching up with the columns I have in mysql. > > > > Yes, I think so. > > > > > > The output I get from the print next is this: > > > > > > ['test.test.net <http://test.test.net>', '15:33:59', 'x86_64', '8', > > '9', > > > '1', '4', '0', '0', '0', '0', '5', '4', '0.0', '12495360', '818688', > > > '0', '36', 'core.none.com <http://core.none.com>', '0.', '0.', '', '', > > > '', ''] > > > > > > I have 25 columns in my MySQL database and it appears to be grabbing > > 25 > > > items. > > > > Does it print any more lines, for example a line with no data that would > > look like > > [] > > ? > > > > How many values are in the row of input? What is your current code? The > > last one you posted seems to have an incorrect indent, the co.execute() > > doesn't look like it is inside the loop. > > > > Kent > > > > > > -- > Spencer Parker > _______________________________________________________ > > "if you can't go to heaven, may you at least die in Ireland." > > _______________________________________________________ > -- Spencer Parker _______________________________________________________ "if you can't go to heaven, may you at least die in Ireland." _______________________________________________________
_______________________________________________ Tutor maillist - [email protected] http://mail.python.org/mailman/listinfo/tutor
