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
