Re: [libreoffice-users] loading a database with images

-----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+unsubscribe@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