January 2011 - postmodern-devel - mailman3.common-lisp.net

[postmodern-devel] query
by Haris 30 Jan '11

30 Jan '11

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.

1 0

[postmodern-devel] query
by Haris 30 Jan '11

30 Jan '11

I got it. I have to :or it with :is-null, like this: (sql (:select '* :from 'table :where (:or (:like 'field "%something%") (:is-null 'field))))

2 1

[postmodern-devel] query
by Haris 30 Jan '11

30 Jan '11

I know what are you talking about, I read the Practical Common Lisp, I'm reading On lisp now but I didn't read all the Postmodern docs. (I know now what :raw does) What I really want is when the field is null to return true. (:is-null 'field) and what now ? Is there an expression "true" in sql ? I should subscribe myself to a sql newsgroup.

1 0

[postmodern-devel] query
by Haris 29 Jan '11

29 Jan '11

I made query like this: (sql (:select '* :from 'kupci :where (:and (:raw (if 'ime (sql (:like 'ime (concat-string "%" (parameter "ime") "%"))) t)) (:raw (if 'prezime (sql (:like 'prezime (concat-string "%" (parameter "prezime") %"))) t))))) but it doesn't work. For example, if (:like ...) for 'ime field passes and 'prezime field is null, record will not be selected. Is the test (if 'prezime ...) ok to test that the field is not null ? Or do I have to do something like (if (/= 'prezime nil) ...) ?

2 1

[postmodern-devel] query
by Haris 28 Jan '11

28 Jan '11

Hi. I made a query like this: (sql (:select '* :from 'kupci :where (:and (:like 'ime (concat-string "%" (parameter "ime") "%")) (:like 'prezime (concat-string "%" (parameter "prezime") "%")))) I want not to apply "like" if the field in database entry is empty (null). Is there some predefined way to do this or I have to program it myself ? (parameter is a hunchentoot parameter after submitting a form) Thanks

2 1

[postmodern-devel] Date format of alist(s)
by Phil Marneweck 28 Jan '11

28 Jan '11

Hi Postmodern is returning dates like this (:DATE-OF-TERMINATION .255611203200) all of a sudden instead of simpledate objects or date string. What did I change to get this behavior or is it a setting in postgresql that has changed? Regards

3 5

[postmodern-devel] plists
by Haris 26 Jan '11

26 Jan '11

git clone http://marijnhaverbeke.nl/git/postmodern :plists works ok now. Thanks

1 0

[postmodern-devel] syncing the socket
by Andy Chambers 26 Jan '11

26 Jan '11

Hi, My bulk copier is somewhat working now but the next time I try to issue a query on the same connection (using cl-postgres:exec-query), I'm getting "Unexpected message received: Z". I thought that putting a "try-to-sync" after sending my CopyDone message should prevent this but apparently it doesn't. Any ideas what's going on? -- Andy Chambers

2 1

[postmodern-devel] plists
by Haris 26 Jan '11

26 Jan '11

I tried git clone https://github.com/marijnh/Postmodern/commit/1627b8a8f8d19181112ba9d6b9eb54… but it doesn't work. What exactly should I write to get this from git ?

2 1

[postmodern-devel] plists
by Haris 26 Jan '11

26 Jan '11

Hi. I tried (query "select * from table1;" :plists) but I get: Error: Undefined operator NIL in form (NIL (CL-POSTGRES:EXEC-QUERY *DATABASE* "select * from table1;" (QUOTE POSTMODERN::SYMBOL-PLIST-ROW-READER))) What does that mean ? I'm using Lispworks/Windows. I also tried (query "select * from table1;" :alists) and that works ok. > I was living in Zagreb ... I'm from Zagreb too.

4 4