;;;; Programmer: Kevin M. Rosenberg
;;;; Date Started: Apr 2000
;;;;
-;;;; $Id: sql.lisp,v 1.6 2002/10/18 03:57:39 kevin Exp $
+;;;; $Id: sql.lisp,v 1.7 2002/10/18 05:18:43 kevin Exp $
;;;;
;;;; This file, part of UMLisp, is
;;;; Copyright (c) 2000-2002 by Kevin M. Rosenberg, M.D.
(defun mutex-sql-query (cmd &key (types :auto))
(with-mutex-sql (conn)
(sql-query cmd conn :types types)))
-
-(defun find-usrl-all ()
- (let ((usrls '())
- (tuples (mutex-sql-query "select SAB,SRL from USRL order by SAB desc")))
- (dolist (tuple tuples)
- (push (make-instance 'usrl :sab (nth 0 tuple)
- :srl (ensure-integer (nth 1 tuple))) usrls))
- usrls))
-
-