[Tutor] CSV file processing...
inthefridge at gmail.com
Mon Mar 24 17:54:17 CET 2008
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 <inthefridge at gmail.com>
> 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
> On Mon, Mar 24, 2008 at 10:30 AM, Kent Johnson <kent37 at tds.net> 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."
"if you can't go to heaven, may you at least die in Ireland."
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the Tutor