[Tutor] CSV file processing...

[Spencer Parker]

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>
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 <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."
>
> _______________________________________________________
>



-- 
Spencer Parker
_______________________________________________________

"if you can't go to heaven, may you at least die in Ireland."

_______________________________________________________
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mail.python.org/pipermail/tutor/attachments/20080324/4cda9a59/attachment.htm