You could create a blank image and name it something like NoImage.png and then
use IFNULL in your query to load it in place of nulls. SELECT
…(IFNULL(fieldname,’NoImage.png’,fieldname))…. This does not directly solve
your problem but it is a low effort way around it.
Thanks,
Jason
[University of Delaware]
Jason Kramer
Computing Support Specialist II
University Archives and Records Management
002E Pearson Hall, 125 Academy St, Newark DE 19716-4399
University of Delaware
302-831-3127 | fax:302-831-6903
[email protected]<mailto:[email protected]>
From: 'Karen Tellef' via RBASE-L <[email protected]>
Sent: Thursday, November 10, 2022 1:53 PM
To: [email protected]
Subject: [RBASE-L] - A "null" variable image
Hopefully I can explain this. I have attached a print-screen because my
embedded images don't show in the list emails.
Each part we print on this report can have unlimited (or no) photos saved on
disk. We will print no more than 4 on the page, so I am pulling 4 random
photos into my text variables (vfilename1, 2, 3, 4), and Variable Images are
located.
Works great except when I have null variables. As shown on the attached,
vFilename1 and vFilename2 have values and print the photos just fine. But
variables vFilename3 and vFilename4 are NULL (as shown below, my null setting
is actually ' ' when printing but I changed to -0- to show you the list).
The null ones have that weird white/red thing. I'm wondering if I am missing a
setting for these. I know I can write code to make controls invisible, but I
was hoping I'm missing something simple.
Any clues for me?
Karen
Variable = Value Type
------------------------------ ------------------------------
-------
vFilename1 = F:\Quality\123773-A.jpg TEXT
vFilename2 = F:\Quality\123773-B.jpg TEXT
vFilename3 = -0- TEXT
vFilename4 = -0- TEXT
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google Groups
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to
[email protected]<mailto:[email protected]>.
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/1588128635.1982897.1668106391324%40mail.yahoo.com<https://groups.google.com/d/msgid/rbase-l/1588128635.1982897.1668106391324%40mail.yahoo.com?utm_medium=email&utm_source=footer>.
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google Groups
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/PH7PR10MB62049AC319B990ABBFF57D41BA019%40PH7PR10MB6204.namprd10.prod.outlook.com.
