MYSQL_GETUSERID gets the user ID number corresponding to the given user name. Usage: [userid,dbuser] = mysql_getUserID(conn) M Hewitson 24-05-07 $Id: mysql_getUserID.html,v 1.1 2007/06/08 14:15:10 hewitson Exp $
0001 function [userid,dbuser] = mysql_getUserID(conn) 0002 0003 % MYSQL_GETUSERID gets the user ID number corresponding to the given user 0004 % name. 0005 % 0006 % Usage: [userid,dbuser] = mysql_getUserID(conn) 0007 % 0008 % M Hewitson 24-05-07 0009 % 0010 % $Id: mysql_getUserID.html,v 1.1 2007/06/08 14:15:10 hewitson Exp $ 0011 % 0012 0013 dbuser = getappdata(0, 'mysql_user'); 0014 q = sprintf('select id from AOusers where name="%s"', dbuser); 0015 curs = exec(conn, q); 0016 curs = fetch(curs); 0017 userid = curs.Data{1}; 0018 close(curs); 0019 0020 % END