|
From: Jamie C. <jca...@we...> - 2005-12-29 22:22:23
|
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 |