diff options
author | Harald Welte <laforge@gnumonks.org> | 2009-09-26 18:54:59 +0200 |
---|---|---|
committer | Harald Welte <laforge@gnumonks.org> | 2009-09-26 18:54:59 +0200 |
commit | 55726d73d7d563d4ef83ba6b2d3a69bbbfdd8517 (patch) | |
tree | 3cf139841c4dd0d9a5855951620a0c2bdece68a4 /openbsc/src/db.c | |
parent | 196d0528ff8a4a887168efe436ddf059e5b9561e (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.c | 8 |
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; |