raw_input(prompt)
> if cursor.execute('SELECT * FROM photos WHERE Tag LIKE ?',[keyword]):
> print cursor.fetchall()
> else:
> cursor.execute('SELECT * FROM photos WHERE Date LIKE ?', [keyword])
> print cursor.fetchall()
>
> Any ideas and
> thanks in
klia schrieb:
klia wrote:
Hey guys;
I am trying to develop a tiny program using python to search inside sqlite
database with file extension is .db in which the program will ask users to
enter their search query and base on that it will retrieve the results But
I need the program to have som
FROM photos WHERE Tag LIKE ?',[keyword]):
>cursor.execute('SELECT * FROM photos WHERE Date LIKE ?', [keyword])
* indicates all fields in the selected records, so you need to
change the * to the field that contains the name of the photo. For example:
if cursor.execu
gt; Reply
>
thank you man, it worked perfectly but one more thing;
when i print rows it retrieves the whole rows of info which i don't need, i
need just to retrieve the name of the photo.
so how am i gonna do that?
--
View this message in context:
http://www.nabble.com/pysqlite-smart-
En Mon, 23 Feb 2009 06:17:41 -0200, klia
escribió:
I need the program to have some smartness in search mechanism in which
the
program will guess that the user is looking for these key words in the
database.
so far i came up with this but the search ain't smart, i have to write
the
full
e:
cursor.execute('SELECT * FROM photos WHERE Date LIKE ?', [keyword])
print cursor.fetchall()
Any ideas and
thanks in advance
Reply
--
View this message in context:
http://www.nabble.com/pysqlite-smart-search-tp22157116p22157116.html
Sent from the Python - python-list mailing list ar
