Posted By: Ray (Keep on the sunny side) on 'CZdatabases'
Title:     Pes
Date:      Tue Aug  8 06:21:13 2000


Ahojte,

tak ze si po ranu kouknu na Psa a co nevidim

   Chyba v SQL: SELECT distinct clanek.cid,nazev,dat_publ,pozice FROM clanek,
   clrubrel WHERE (clrubrel.rid = 0) AND (clrubrel.prid = 0) AND
   (clrubrel.pprid = 0) AND (clrubrel.cid = clanek.cid) AND (clanek.web = 4)
   AND (clanek.stav >= 40) AND (clanek.stav != 99) AND (clanek.dat_publ <
   '2000-08-09 00:00:00') AND typ=1 ORDER BY dat_publ DESC, pozice ASC

Skoda, ze neprilozili schema, takhle neni moc jasny, kde ta chyba je :)))

  Ray

Search the boards