python & mysql probelm

[james blair]

Hi
I am having a problem executing following query:
cursor.execute("select * from projects where projectid between '%s'
and '%s'"%(id1,id2))
But say if i have projectid's from 1 to 20 in database & if i give the
project range 1 to 2 then it gives me the result 1,2,11,12,13,14.....
When I execute this query in mysql i.e
select * from projects where projectid between 1 and 2,I get the
correct result.
I also tried doing
cursor.execute("select * from projects where projectid between '%s'
and '%s'"%(int(id1),int(id2))
but no success
What should I do??
Regards,
James

[wes weston]

james blair wrote:

Hi
I am having a problem executing following query:
cursor.execute("select * from projects where projectid between '%s'
and '%s'"%(id1,id2))
But say if i have projectid's from 1 to 20 in database & if i give the
project range 1 to 2 then it gives me the result 1,2,11,12,13,14.....
When I execute this query in mysql i.e
select * from projects where projectid between 1 and 2,I get the
correct result.
I also tried doing
cursor.execute("select * from projects where projectid between '%s'
and '%s'"%(int(id1),int(id2))
but no success
What should I do??
Regards,
James

James,
As strings 11 is less than 2. Are your fields strings
or ints? If you change them from strings to ints, mysql
will make the translation.
wes