[Tutor] sqlite query problem

[BOBÁK Szabolcs]

Dear Hugo,

  Thank you for your fast help and the sharp eyes.
I was almost hopeless.
It is working now, but only with the first formula, and I also voted to the
third one, so I will try a little bit more.

Thank you very much!

2010. január 29. 17:53 Hugo Arts írta, <hugo.yoshi at gmail.com>:

> 2010/1/29 BOBÁK Szabolcs <szabolcs.bobak at gmail.com>:
> >
> > This also works, but this not:
> > sql_command_stat = 'SELECT COUNT(lastmoddate) FROM
> > '+sql_tablename_orig+'WHERE lastmoddate < '+str(lastmod_date1)
> > sql_cursor.execute(sql_command_stat)
> >
> > This was my original try, but tried various in various formula.
> > sql_command_stat = 'SELECT COUNT(lastmoddate) FROM
> > '+sql_tablename_orig+'WHERE lastmoddate < %d'
> > sql_cursor.execute(sql_command_stat, %lastmod_date1)
> >
> > sql_command_stat = 'SELECT COUNT(lastmoddate) FROM
> > '+sql_tablename_orig+'WHERE lastmoddate < (?)'
> > sql_cursor.execute(sql_command_stat, (lastmod_date1))
> >
> > But always the same error message:
> > sqlite3.OperationalError: near "<": syntax error
> > File "C:\python\stat.py", line 42, in <module>
> > sql_cursor.execute(sql_command_stat)
> >
> > From the three attempt I concluded that it's the same if I pass the
> variable
> > value as a string or an integer (maybe I am wrong).
>
> Your error isn't where you expect it to be. Let's take a look at the
> string you're actually passing:
>
> >>> sql_tablename_orig = 'pyfilestat_drive_e_2010_01_27_16_48_31'
> >>> sql_command_stat = 'SELECT COUNT(lastmoddate) FROM
> '+sql_tablename_orig+'WHERE lastmoddate < %d'
> >>> sql_command_stat
> 'SELECT COUNT(lastmoddate) FROM
> pyfilestat_drive_e_2010_01_27_16_48_31WHERE lastmoddate < %d'
>
> well, hello. we seem to be having a missing space, right in between
> the table name and 'WHERE.'
>
> Also, you should use the third form, using the parameters argument of
> execute(). it's the only secure one.
>
> Hugo
>



-- 
Bobák Szabolcs
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.python.org/pipermail/tutor/attachments/20100129/c5501652/attachment.htm>