% GETUSERID gets the user ID number corresponding to the given user name.%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%% DESCRIPTION: GETUSERID gets the user ID number corresponding to the% user name that connected to the MySQL database.%% CALL: userid = getUserID(conn)%% VERSION: $Id: getUserID.m,v 1.1 2008/08/08 11:51:12 ingo Exp $%% HISTORY: 24-05-2007 M Hewitson% Creation%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%function [userid,dbuser] = getUserID(varargin) userid = []; conn = varargin{1}; if nargin > 1 username = varargin{2}; else username = char(conn.getUsername); end try if ~conn.isConnected conn.openConnection; end if conn.isConnected q = sprintf('select id from users where username="%s"', username); results = conn.query(q); while results.next userid = str2num(char(results.getString(1))); end end dbuser = conn.getUsername; catch warning('!!! Unable to retrieve user ID.'); endend