From 5f3405aaffc334fc55c027623aec300f82a5512c Mon Sep 17 00:00:00 2001 From: Sebastian Reichel Date: Fri, 13 Jul 2012 20:43:38 +0200 Subject: fix SQL query, which fetches price information --- invoice/generate-invoice.py | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'invoice') diff --git a/invoice/generate-invoice.py b/invoice/generate-invoice.py index 176ac4b..7460817 100755 --- a/invoice/generate-invoice.py +++ b/invoice/generate-invoice.py @@ -38,7 +38,7 @@ def get_price_info(product, timestamp, member = True): if not member: field = "guestprice" - c.execute("SELECT "+ field +" FROM prices WHERE product = ? AND valid_from <= ? ORDER BY valid_from ASC LIMIT 1;", (product,timestamp,)) + c.execute("SELECT "+ field +" FROM prices WHERE product = ? AND valid_from <= ? ORDER BY valid_from DESC LIMIT 1;", (product,timestamp,)) for row in c: result = int(row[0]) -- cgit v1.2.3