postmodern-devel

postmodern-devel@common-lisp.net

252 discussions

[postmodern-devel] :set arguments
by Haris 06 Feb '11

06 Feb '11

(sql (:insert-into 'kupci :set (:raw (if (/= (length (parameter "ime")) 0) (sql ('ime (parameter "ime"))))))) For this I get an error: Invalid amount of :set arguments passed to insert-into sql operator Why is that ? Thanks

2 4

[postmodern-devel] Release 1.17
by Marijn Haverbeke 02 Feb '11

02 Feb '11

Most users are probably already using the git HEAD (which is pretty safe, since I don't push many wild experimental patches), but I just released a new version. The important changes are: * Fixes day-of-week in simple-date. * Makes the :plist query format actually work. * Adds sql-escape as an exported symbol for client code that needs to escape stuff. * Adds support for multi-dimensional arrays. * Adds the *ignore-unknown-columns* configuration variable. Cheers, Marijn

1 0

[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

← Newer
1
...
5
6
7
8
9
10
11
...
26
Older →

Jump to page:

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

postmodern-devel