Hello all:
I am trying to use the mysql command to retrieve information from a mysql
database.
my example here was formed from using the wiki reference to using the
mysql command.
The problem is with the fetch command.
Here is the macro code:
Mysql(QueryString=SELECT\ ivr-password\ from\ users\
[EMAIL PROTECTED] wrote:
Hello all:
The problem is with the fetch command.
Here is the macro code:
Mysql(QueryString=SELECT\ ivr-password\ from\ users\ where\
ivr-id=${userid}) Mysql(Query r ${connid} ${QueryString})
Mysql(Fetch fetchid ${r} dbuserpass)
Mysql(Clear ${resultid})
Hi.. .and thank you for your help.
I just tried your example.. and yes it did return what i wanted (with my
information)
One thing I need to add here i'm using mysql-realtime configuration.
So when I'm running using mysql extensions I get this:
-- Executing MYSQL(IAX2/[EMAIL
[EMAIL PROTECTED] wrote:
-- Executing MYSQL(IAX2/[EMAIL PROTECTED]:4569-13, Fetch
fetchid ivr_password)
-- Executing MYSQL(IAX2/[EMAIL PROTECTED]:4569-15, Fetch
fetchid 6 ivr_password) in new stack
I don't see the 6 in the realtime extensions debug. Did you forget the
${}
The information that is below is from the CLI window.
the # for ${resultid} only appears if you using the .conf file. If you
realtime with mysql resultid has no value and thus is blank.
I have copied and pasted exact same line from the .conf file to the
appdata field in mysql and i get the same
Hmm..that sounds like a bug to me. Sounds like the parser isn't working on
that variable. Let me give it a go tomorrow and if I can reproduce what you
get then we can open a bug. (Its much better to open a bug when someone else
can verify it.)
-Matthew
The information that is below is from the