Are you putting the value in single quotes? -- Fred direct/sms +1 (336) 439-3733
> On Aug 7, 2019, at 07:47, arish haque <[email protected]> wrote: > > Hi all, > I am querying mysql db inside routing block in kamailio.cfg > > ERROR: db_mysql [km_dbase.c:128]: db_mysql_submit_query(): driver error on > query: Unknown column '8d77' in 'where clause' (1054) > Aug 7 18:09:22 localhost /usr/local/sbin/kamailio[25333]: ERROR: <core> > [db_query.c:181]: db_do_raw_query(): error while submitting query > Aug 7 18:09:22 localhost /usr/local/sbin/kamailio[25333]: ERROR: sqlops > [sql_api.c:265]: sql_do_query(): cannot do the query [select * from > vca_asterisk where front_id=8d77] > > I'm getting the above error message when, variable front_id=8d77 is > alphanumeric. > It's working fine when front_id is pure numeric. eg: front_id=877 > Database column front_id is VARCHAR(255). > > Any suggestions to solve this error? > > Thanks, > Arish > > > > _______________________________________________ > Kamailio (SER) - Users Mailing List > [email protected] > https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users _______________________________________________ Kamailio (SER) - Users Mailing List [email protected] https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
