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