Try enclosing in single quotes. ie.
SELECT name from contacts where tel like '%${number}'
Jon Farmer
Telford, Shropshire, UK
----- Original Message ----
From: Garth van Sittert <[EMAIL PROTECTED]>
To: Asterisk Users Mailing List - Non-Commercial Discussion
<asterisk-users@lists.digium.com>
Sent: Monday, 4 December, 2006 12:38:07 PM
Subject: [asterisk-users] MySQL cmd % pattern matching
Hi All
Does anyone know how to use the MySQL cmd in Asterisk with LIKE and % in
the query?
I have:
exten => s,5,Set(query=SELECT name from contacts where tel like
%${number})
exten => s,6,MySQL(Connect connid hostname username password dbname)
exten => s,7,MySQL(Query resultid ${connid} ${query})
But there seems to be a problem with the % sign and I don't know how to
hash it out.
It works without the % sign.
Thanks
Kind Regards
Garth
_______________________________________________
--Bandwidth and Colocation provided by Easynews.com --
asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
http://lists.digium.com/mailman/listinfo/asterisk-users
___________________________________________________________
All new Yahoo! Mail "The new Interface is stunning in its simplicity and ease
of use." - PC Magazine
http://uk.docs.yahoo.com/nowyoucan.html
_______________________________________________
--Bandwidth and Colocation provided by Easynews.com --
asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
http://lists.digium.com/mailman/listinfo/asterisk-users
