From 9933fa3041681062c104cb9459f4d8c5d111c810 Mon Sep 17 00:00:00 2001 From: "Kevin M. Rosenberg" Date: Sat, 3 May 2003 19:53:59 +0000 Subject: [PATCH] r4753: Auto commit for Debian build --- sql-classes.lisp | 32 ++++++++++++++++---------------- 1 file changed, 16 insertions(+), 16 deletions(-) diff --git a/sql-classes.lisp b/sql-classes.lisp index 54be40c..08d16cf 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.26 2003/05/03 19:52:04 kevin Exp $ +;;;; $Id: sql-classes.lisp,v 1.27 2003/05/03 19:53:59 kevin Exp $ ;;;; ;;;; This file, part of UMLisp, is ;;;; Copyright (c) 2000-2002 by Kevin M. Rosenberg, M.D. @@ -61,21 +61,21 @@ is OBJNAME from TABLE where WHERE-NAME field = WHERE-VALUE with FIELDS" (let* ((%%fields (format nil "select ~A~{~:@(~A~)~^,~}" (if distinct "distinct " "") (quote fields))) (%%order (if order (format nil " order by ~{~:@(~A~) ~(~A~)~^,~}" order) ""))) - (concatenate - 'string - (format nil "select ~A from ~:@(~A~)" ,%%fields ,table) - (if ,where-name - (format nil - (if (stringp ,where-value) - (if like - " where ~A like '%~A%'" - " where ~A='~A'") - " where ~A=~A") - ,where-name ,where-value) - "") - (if ,srl (format nil " and ~:@(~A~) <= ~D" ,lrlname ,srl) "") - ,%%order - (if ,single " limit 1" ""))) + `(concatenate + 'string + (format nil "select ~A from ~:@(~A~)" ,%%fields ,table) + (if ,where-name + (format nil + (if (stringp ,where-value) + (if like + " where ~A like '%~A%'" + " where ~A='~A'") + " where ~A=~A") + ,where-name ,where-value) + "") + (if ,srl (format nil " and ~:@(~A~) <= ~D" ,lrlname ,srl) "") + ,%%order + (if ,single " limit 1" "")))) (defun query-string (table fields &optional srl where-name where-value &key (lrlname "KCUILRL") single distinct order like) -- 2.34.1