That is? excuse but creed not to have understood your participation... :)
However I have resolved my problem that was a syntax error of which
I did not succeed to understand of the reason then but....... I have resolved
Hi Max
Martins Mozeiko ha scritto:
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 :)
