Use correct capitalization on SQL statements
otherwise, SQLite seems to return the wrong data types ?!?
Signed-off-by: Mike Haben <michael.haben@btinternet.com>
diff --git a/openbsc/src/db.c b/openbsc/src/db.c
index 45e950b..45c55af 100644
--- a/openbsc/src/db.c
+++ b/openbsc/src/db.c
@@ -264,15 +264,15 @@
static int get_equipment_by_subscr(struct gsm_subscriber *subscr)
{
dbi_result result;
- char *string;
+ const char *string;
unsigned int cm1;
const unsigned char *cm2, *cm3;
struct gsm_equipment *equip = &subscr->equipment;
result = dbi_conn_queryf(conn,
- "SELECT equipment.* FROM equipment,equipmentwatch "
- "WHERE equipmentwatch.equipment_id=equipment.id "
- "AND equipmentwatch.subscriber_id = %llu "
+ "SELECT equipment.* FROM Equipment,EquipmentWatch "
+ "WHERE EquipmentWatch.equipment_id=Equipment.id "
+ "AND EquipmentWatch.subscriber_id = %llu "
"ORDER BY updated DESC", subscr->id);
if (!result)
return -EIO;