-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi Gary, > > SELECT "place" You have forgotten: , SELECT "place", ... > CASE WHEN "place" = 0 THEN 'image0.png' WHEN "place" = 1 THEN > 'image1.png' WHEN "place" = 2 THEN 'image2.png' WHEN "place" = 3 > THEN 'image3.png' WHEN "place" >= 4 THEN 'image4.png' END "ribbon" > FROM "Results"
With ' ' will be input text. It isn't an image, which could be shown. Save the images by a form in a separate table "images". You will get the image you want, if you start a subselect for it. SELECT "place", CASE WHEN "place" = 0 THEN (SELECT "image" FROM "image" WHERE "ID" = 0) WHEN "place" = 1 THEN (SELECT "image" FROM "image" WHERE "ID" = 1) WHEN "place" = 2 THEN (SELECT "image" FROM "image" WHERE "ID" = 2) WHEN "place" = 3 THEN (SELECT "image" FROM "image" WHERE "ID" = 3) WHEN "place" >= 4 THEN (SELECT "image" FROM "image" WHERE "ID" = 4) END AS "ribbon" FROM "Results" Regards Robert -----BEGIN PGP SIGNATURE----- Version: GnuPG v2 iQIcBAEBAgAGBQJX++4ZAAoJELDKYwaoS9AI+QEP/jUfg1Cwf7YdC7IikOt+xEWo dWFdiRMCpP8suxymm6CIZ+gAWaC8HiokAIn9M3ynGdw+Pq86SQhO2yGOkYIYO8LW LAO2LRT0gToOdjJgGB2g8+qYZmF5tV8Tr8z7sli9TrL8h0Rs1cKkS490JrmOS38M 6/xkqAEFk5zC+n70rpZRq2qmnJ/kZ+OgATu9Qmf2ojnC4ItR46vKny3z6Z1mXCHU VT9DHagE0+kykFOgARffmugfvKNPHZNknaYuuF9LOig0ah6uK/+MhnB5Lp4gE8G6 H2p06RFSnKy6e4gw16Z+KB/5E/wLO5RQE2UKeP5npKLJuUG+N5gpMRJvuF50jwsr MBNsLzMmZnSuh24CLclsOOAJ1jDf6aC6LJf2R18NK91R9vCihpixBJ3S7BNRF+/f ZrMYVgKkaE1F+o56rEvPk4RYJUvtZb+hHZUf/jgfA1NU2S1FNLAtj+oB1xFVPuD+ 0KSKM3ML4n2vmS/IBuDS1XcoGYC/zU9uA4ugTsPqhQA+bmfZJGKKFwlqIux3PKUz Vq+I7JvxzLgjJZ+tNWZ0bcuq4+5vs5ffMLXxCdeVPIm37PnIVAvPsic2ErdcKnDc 6ykrhS2vpU+rFi0fD+BFZedgB+YHFaUFWrQbZz1cdeKuzHAwk4SKiYsq5SzijI0l gsnZ266aXuWu5cwYOVjz =U3qe -----END PGP SIGNATURE----- -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted