And now tell us, which part of your problem relates to SQLite? :)
-- Martins From: SKORPIO-INFO [EMAIL PROTECTED] Date: Fri, 1 Apr 2005 15:17:56 +0300 To: [email protected] Subject: Re: [sqlite] Query select.... > 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 :) > > > > > > >
