Re: [webmin-l] Custom Mysql

[Jamie C. <jca...@we...>]

Hi Grant,
The SQL custom commands use a ? to indicate a parameter, which is standard with SQL. The first parameter in the command will replace the first ? and so on ..

 - Jamie

-----Original Message-----

From:  "Grant Peel" <gp...@th...>
Subj:  [webmin-l] Custom Mysql
Date:  Fri 30 Dec 2005 3:16 am
Size:  1017 bytes
To:  <web...@li...>

Hi all,

FOrgive me if this has been covered somewhere else, but how does one use 
parameters in the custom->sql commands section?

I keep getting errore like these:

Executing SQL command SET par1=$INPUT; SET par2=$FIELD; SELECT user, 
password, domain, ip, host_machine FROM clients WHERE domain LIKE @par1; ..
.. execution error : called with 1 bind variables when 0 are needed



I get them even if I don't use the 'set' variables parm. I have tried every 
escape sequence I can think of.



-GRant






-------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc. Do you grep through log files
for problems?  Stop!  Download the new AJAX search engine that makes
searching your log files as easy as surfing the  web.  DOWNLOAD SPLUNK!
http://ads.osdn.com/?ad_id=7637&alloc_id=16865&op=click
-
Forwarded by the Webmin mailing list at web...@li...
To remove yourself from this list, go to
http://lists.sourceforge.net/lists/listinfo/webadmin-list