hi,

first of all sorry for the trivial question.

 

I want to install postmodern with Allegro CL 8.0 Free express edition but i could not succeed.
I think there is a problem with asdf/asdf-install library but i am not sure.

What may be the reason?

Thank you in advance.

 

On 17/08/07, Jens Teich <info@jensteich.de> wrote:

Marijn Haverbeke wrote:
> So could you give me the error message? That might give me a chance to
> figure out what the problem is.
>
> Cheers,
> Marijn

Here are two queries which should produce the same result

WEBCAT 36 > (postmodern:with-connection ("web_access" "web_access" "***" "localhost")
             (postmodern:query
              (:select 'pmw.wert
               :from (:as 'projekt-merkmale-werte 'pmw)
                     (:as 'projekt-elemente       'pe)
               :where (:and
                       (:= 'pmw.guid-produkt 'pe.guid-objekt)
                       (:= 'pe.guid "rzt732819vlurc5827955302wwxz8b")
                       (:= 'pmw.merkmal-id "MID1008519")
                       (:= 'pmw.lang-id "de")))))
(("30 N") ("30 N") ("30 N") ("30 N"))

WEBCAT 37 > (postmodern:with-connection ("web_access" "web_access" "***" "localhost")
             (postmodern:query
              (:select 'pmw.wert
               :from (:as 'projekt-merkmale-werte 'pmw)
               :inner-join (:as 'projekt-elemente       'pe)
               :on         (:= ' pmw.guid-produkt 'pe.guid-objekt)
               :where (:and
                       (:= 'pe.guid "rzt732819vlurc5827955302wwxz8b")
                       (:= 'pmw.merkmal-id "MID1008519")
                       (:= 'pmw.lang-id "de")))))

Error: Database error 42601: syntax error at or near "on"
Query: (SELECT pmw.wert FROM projekt_merkmale_werte AS pmw INNER JOIN projekt_elemente AS pe ON ( pmw.guid_produkt = pe.guid_objekt), projekt_elemente AS pe, on, (pmw.guid_produkt = pe.guid_objekt) WHERE ((pe.guid = 'rzt732819vlurc5827955302wwxz8b') and (pmw.merkmal_id = 'MID1008519') and (pmw.lang_id = 'de')))

Jens
_______________________________________________
postmodern-devel mailing list
postmodern-devel@common-lisp.net
http://common-lisp.net/cgi-bin/mailman/listinfo/postmodern-devel