Afficher un message
Vieux 21/02/2008, 15h57   #6
Tom Cloyd
Aucun Avatar
 
Messages: n/a
Hébergeur:
Par défaut Re: beginner's problem with sqlite3

Serg, Peter - thank you very much. This is such an amazing list. One
gets back so much . To an amateur like me, that's very encouraging.
Onward!...

Tom
(Bellingham, Washington, USA)

Peter Hickman wrote:
> Tom Cloyd wrote:
>> db.execute( 'INSERT INTO newsheap(datecol titlecol urlcol summarycol)
>> VALUES(date title url summary)' )

>
>
> I would have written the sql with a few commas and a semi colon.
>
> INSERT INTO newsheap (datecol, titlecol, urlcol, summarycol) VALUES
> (date, title, url, summary);
>
> Pretty sure that's the error
>
>



--

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ~~~~~~~~~~~
Tom Cloyd, MS MA, LMHC
Private practice Psychotherapist
Bellingham, Washington, U.S.A: (360) 920-1226
<< tc@tomcloyd.com >> (email)
<< TomCloyd.com >> (website & psychotherapy weblog)
<< sleightmind.wordpress.com >> (mental health issues weblog)
<< directpathdesign.com >> (web site design & consultation)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ~~~~~~~~~~~


  Réponse avec citation
 
Page generated in 0,04714 seconds with 9 queries