I'm sorry for multiple threads.
This subject was total misunderstanding by me.
The thing that was confusing me was that if I don't
enter a search term into the search field then it would not return
that record even if some of the fields match.
The right way is a dynamic query like this:
(sql (:select '* :from 'kupci :where
(:and
(:raw (if (parameter "ime") (sql (:like 'ime
(concat-string "%" (parameter "ime") "%"))))))
(:raw (if (parameter "prezime") (sql (:like
'prezime (concat-string "%" (parameter "prezime") "%"))))))))
I first have to check is the search term even
entered into the search field.
It finally works.
_______________________________________________
postmodern-devel mailing list
postmodern-devel@common-lisp.net
http://common-lisp.net/cgi-bin/mailman/listinfo/postmodern-devel
