r4793: Auto commit for Debian build
authorKevin M. Rosenberg <kevin@rosenberg.net>
Sun, 4 May 2003 01:42:20 +0000 (01:42 +0000)
committerKevin M. Rosenberg <kevin@rosenberg.net>
Sun, 4 May 2003 01:42:20 +0000 (01:42 +0000)
sql-classes.lisp

index 1e12f97e142f4d84904a87d0ec91392d5302f6eb..086b5cdfe749f3c5ae6ad2de98328c3be7ced700 100644 (file)
@@ -7,7 +7,7 @@
 ;;;; Author:        Kevin M. Rosenberg
 ;;;; Date Started:  Apr 2000
 ;;;;
-;;;; $Id: sql-classes.lisp,v 1.66 2003/05/04 01:39:04 kevin Exp $
+;;;; $Id: sql-classes.lisp,v 1.67 2003/05/04 01:42:20 kevin Exp $
 ;;;;
 ;;;; This file, part of UMLisp, is
 ;;;;    Copyright (c) 2000-2002 by Kevin M. Rosenberg, M.D.
@@ -102,7 +102,7 @@ is OBJNAME from TABLE where WHERE-NAME field = WHERE-VALUE with FIELDS"
         (%%lrl (format nil " and ~:@(~A~)<=" lrl))
         (%%where (when where-name
                    (format nil " where ~:@(~A~)~A" where-name
-                         (if like " like " "=")))))
+                         (if like " like " "")))))
     `(concatenate
       'string
       ,%%fields
@@ -114,11 +114,11 @@ is OBJNAME from TABLE where WHERE-NAME field = WHERE-VALUE with FIELDS"
                    (format nil ,(if like "'%~A%'" "'~A'") ,where-value)))
              `((typecase ,where-value
                  (number
-                  (write-to-string ,where-value))
+                  (concatenate 'string "=" (write-to-string ,where-value)))
                  (null
                   " is null")
                  (t
-                  (format nil ,(if like "'%~A%'" "'~A'") ,where-value)))))
+                  (format nil ,(if like "'%~A%'" "'=~A'") ,where-value)))))
       (if ,srl (concatenate 'string ,%%lrl (write-to-string ,srl)) "")
       ,@(when %%order (list %%order))
       ,@(when single (list " limit 1")))))