aboutsummaryrefslogtreecommitdiffstats
path: root/openbsc/src/db.c
diff options
context:
space:
mode:
authorHarald Welte <laforge@gnumonks.org>2009-09-26 18:54:59 +0200
committerHarald Welte <laforge@gnumonks.org>2009-09-26 18:54:59 +0200
commit55726d73d7d563d4ef83ba6b2d3a69bbbfdd8517 (patch)
tree3cf139841c4dd0d9a5855951620a0c2bdece68a4 /openbsc/src/db.c
parent196d0528ff8a4a887168efe436ddf059e5b9561e (diff)
Use correct capitalization on SQL statements
otherwise, SQLite seems to return the wrong data types ?!? Signed-off-by: Mike Haben <michael.haben@btinternet.com>
Diffstat (limited to 'openbsc/src/db.c')
-rw-r--r--openbsc/src/db.c8
1 files changed, 4 insertions, 4 deletions
diff --git a/openbsc/src/db.c b/openbsc/src/db.c
index 45e950b6f..45c55aff9 100644
--- a/openbsc/src/db.c
+++ b/openbsc/src/db.c
@@ -264,15 +264,15 @@ struct gsm_subscriber* db_create_subscriber(struct gsm_network *net, char *imsi)
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;