[ILUG] MySQL & outer joins...

[John P . Looney]

 Just wondering...

 I assume that mySQL doesn't accpt the oracle syntax for an outer join -
something like (+) IIRC.

 I was trying to do:

            SELECT table1.usern as user,
                   table2.fname as folder
                   table3.comment as comment
            from table1, table2, table3
            WHERE table1.usern = 'user' and
                  (table2.ind = table1.2ind or table1.2ind = NULL) and
                  (table3.ind = table1.3ind or table1.3ind = NULL);

 The idea being that sometimes table1.2ind or table1.3ind can be null, so
I want anything taken from that table to be null. And MySQL isn't
impressed with me ;)

 Oh, BTW I got a nice new Epson Stylus 900. Prety. But it doesn't work
with ghostscript worth mentioning about. I downloaded the gimp-print
drivers, and tryed them. I then patched Ghostscript 6.0.1 with the gimp
print drivers too...and it was worse. Colour bleeding, black text is
charcoal gray, anything that is supposed to be blue or red turns out a
disheartening brown.

 Has anyone gotten one of these printers working with ghostscript ? What
sort of options did you use ? I was using:


 gs -q -dSAFER -dNOPAUSE -sDEVICE=stp -sModel=escp2-900 -r1440x720
        -sQuality='1440 x 720 DPI Highest Quality'  -dImageType=1
        -sOutputFile=/dev/lp0 file.ps

 to no avail...

Kate


-- 
The words of the unwary are apt to cause needless pain and bloody violence.
                                                        - Zen Master Greg