<HTML>
<HEAD>
<TITLE>ARSperl Manual - ars_GetListSQL</TITLE>
</HEAD>
<BODY BGCOLOR="#FFFFFF">
<H2><CODE>ars_GetListSQL(ctrl, sqlCommand, maxRetriev=AR_NO_MAX_LIST_RETRIEVE)</CODE></H2>
Execute the given sqlCommand on the database that the server is attached to.
sqlCommand executes with privs associated with the ARAdmin database user.
<P> See also:
<A HREF="ds_getlistsql_hash.html">GetListSQL Hash Values</A>.
<P>
<DL>
<DT><B>On success</B><DD>
Returns a HASH.
<DT><B>On failure</B><DD>
Returns undef.
</DL>
<P>Example:
<PRE>
($a = ars_GetListSQL($ctrl, "select name, schemaid, nextid from arschema")) ||
die "$ars_errstr";
</PRE>
<I>ars_GetListSQL was introduced in version 1.5 of ARSperl</I>
<P>
<HR WIDTH="30%">
<P>
<A HREF="toc.html"><IMG ALT="<--" SRC="arrow.gif" ALIGN=CENTER> Table of Contents </A>
<p>
<address>
Last changes to this page 21st July 1997 by jcmurphy@arsperl.org<BR>
© J.C.Murphy, J.W.Murphy 1997 arsperl@arsperl.org
</address>
</BODY>
</HTML>