Home > m > mysql > mysql_getObjIds.m

mysql_getObjIds

PURPOSE ^

MYSQL_GETOBJIDS gets a list of object ids from a given collection id.

SYNOPSIS ^

function ids = mysql_getObjIds(conn, cid)

DESCRIPTION ^

 MYSQL_GETOBJIDS gets a list of object ids from a given collection id.
 
 Usage: ids = mysql_getObjIds(conn,cid);
 
 Inputs:
     conn - a database connection object
     cid  - a collection id
 
 Outputs:
     ids  - a list of object ids
 
 M Hewitson 30-08-07
 
 $Id: mysql_getObjIds.m,v 1.3 2008/02/22 09:25:18 hewitson Exp $

CROSS-REFERENCE INFORMATION ^

This function calls: This function is called by:

SOURCE CODE ^

0001 function ids = mysql_getObjIds(conn, cid)
0002 
0003 % MYSQL_GETOBJIDS gets a list of object ids from a given collection id.
0004 %
0005 % Usage: ids = mysql_getObjIds(conn,cid);
0006 %
0007 % Inputs:
0008 %     conn - a database connection object
0009 %     cid  - a collection id
0010 %
0011 % Outputs:
0012 %     ids  - a list of object ids
0013 %
0014 % M Hewitson 30-08-07
0015 %
0016 % $Id: mysql_getObjIds.m,v 1.3 2008/02/22 09:25:18 hewitson Exp $
0017 %
0018 
0019 try
0020   curs    = exec(conn, sprintf('select obj_ids from collections where id="%d"', cid));
0021   curs    = fetch(curs);
0022   ids     = str2num(curs.Data{1});
0023   close(curs);
0024 catch
0025   error('### Unable to determine object IDs from collection ID. Server returned %s', curs.Message);
0026 end
0027 
0028

Generated on Mon 31-Mar-2008 13:54:54 by m2html © 2003