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:$

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:$
0017 %
0018 
0019 
0020 curs    = exec(conn, sprintf('select objids from collections where id="%d"', cid));
0021 curs    = fetch(curs);
0022 ids     = str2num(curs.Data{1});
0023 close(curs);
0024 
0025

Generated on Mon 03-Sep-2007 12:12:34 by m2html © 2003