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.yo...@gmail.com>: > 2010/1/29 BOBÁK Szabolcs <szabolcs.bo...@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
_______________________________________________ Tutor maillist - Tutor@python.org To unsubscribe or change subscription options: http://mail.python.org/mailman/listinfo/tutor
