From 46b75306328d38e10180bdedd123d7140e7e49dd Mon Sep 17 00:00:00 2001 From: "Kevin M. Rosenberg" Date: Fri, 16 May 2003 08:34:00 +0000 Subject: [PATCH] r4971: Auto commit for Debian build --- sql-classes.lisp | 17 ++++++++++------- 1 file changed, 10 insertions(+), 7 deletions(-) diff --git a/sql-classes.lisp b/sql-classes.lisp index 02182f6..5c6ddea 100644 --- a/sql-classes.lisp +++ b/sql-classes.lisp @@ -7,7 +7,7 @@ ;;;; Author: Kevin M. Rosenberg ;;;; Date Started: Apr 2000 ;;;; -;;;; $Id: sql-classes.lisp,v 1.82 2003/05/16 03:10:18 kevin Exp $ +;;;; $Id: sql-classes.lisp,v 1.83 2003/05/16 08:34:00 kevin Exp $ ;;;; ;;;; This file, part of UMLisp, is ;;;; Copyright (c) 2000-2002 by Kevin M. Rosenberg, M.D. @@ -463,14 +463,17 @@ is OBJNAME from TABLE where WHERE-NAME field = WHERE-VALUE with FIELDS" (ensure-cui-integer cui) (ensure-lui-integer lui) (ensure-sui-integer sui) - (let ((ls (format nil "select CODE,ATN,SAB,ATV from MRSAT where "))) + (let ((ls "select CODE,ATN,SAB,ATV from MRSAT where ")) (cond - (sui (string-append ls (format nil "KCUISUI=~D" (make-cuisui cui sui)))) - (lui (string-append ls (format nil "KCUILUI=~D and sui=0" - (make-cuilui cui lui)))) - (t (string-append ls (format nil "cui=~D and lui=0 and sui=0" cui)))) + (sui (string-append ls "KCUISUI=" + (integer-string (make-cuisui cui sui) 14))) + (lui (string-append ls "KCUILUI=" + (integer-string (make-cuilui cui lui) 14) + " and sui=0")) + (t (string-append ls "cui=" (prefixed-fixnum-string cui nil 7) + " and lui=0 and sui=0"))) (when srl - (string-append ls (format nil " and KSRL <= ~D" srl))) + (string-append ls " and KSRL<=" (prefixed-fixnum-string srl nil 3))) (loop for tuple in (mutex-sql-query ls) collect (destructuring-bind (code atn sab atv) tuple (make-instance 'usat :code code :atn atn :sab sab :atv atv))))) -- 2.34.1