Home > m > mysql > mysql_getUserID.m

mysql_getUserID

PURPOSE ^

MYSQL_GETUSERID gets the user ID number corresponding to the given user

SYNOPSIS ^

function [userid,dbuser] = mysql_getUserID(conn)

DESCRIPTION ^

 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 $

CROSS-REFERENCE INFORMATION ^

This function calls: This function is called by:

SOURCE CODE ^

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

Generated on Fri 08-Jun-2007 16:09:11 by m2html © 2003