ok :)
I have resolved this problem:
SLOT_SEARCH = BSS.execute("SELECT * FROM slot WHERE data_slot='01-04-2005' AND ((num_slot > "+str(contatore[1])+") AND (num_slot < "+str(contatore[0])+"))")
Thanks
SKORPIO-INFO ha scritto:
Hi to all,
I have the necessity to carry out a query that it must find an occurrence to me in which the date is x and that a data field is comprised between y and z
This is the example:
contatore = [20,33]
SLOT_SEARCH = BSS.execute("SELECT * FROM slot WHERE data_slot='01-04-2005' AND ((num_slot > contatore[1]) AND (num_slot < contatore[0]))")
thi is the table:
CREATE TABLE slot( id_slot INTEGER(11) PRIMARY KEY, univocal_number VARCHAR(12), data_slot VARCHAR(10), num_slot VARCHAR(5) )
the error reporting is:
DatabaseError: near "[1]": syntax error
Help Me :)
