Try ERPNext Buy Support Partners Foundation

Some help in SQL query

frappe.db.sql(""“select name from tabSerial No where name between (%s) and (%s); “””,(start) (end))
where start and end are two strings which have the serial_no names.
But it is giving an error like
Unicode Object not available
Hope Anyone helps…

I think between does not work strings comparison. You can use “>=” and “<=” operator for checking a range of serial nos.

frappe.db.sql("""select name from `tabSerial No` 
where name between %s and %s """,(start, end))

Thank You It Worked

I tried this script to my report script and I get this error


This is the report

please help me !