Jason: You know what, I remember using that exact thing years ago for
something. So yeah, if there isn't something simple, I'll do that. Thanks for
the reminder!
Karen
-----Original Message-----
From: Kramer, Jason <[email protected]>
To: [email protected] <[email protected]>
Sent: Thu, Nov 10, 2022 1:58 pm
Subject: RE: [RBASE-L] - A "null" variable image
<!--#yiv8881077546 filtered {}#yiv8881077546 filtered {}#yiv8881077546
p.yiv8881077546MsoNormal, #yiv8881077546 li.yiv8881077546MsoNormal,
#yiv8881077546 div.yiv8881077546MsoNormal
{margin:0in;font-size:11.0pt;font-family:"Calibri", sans-serif;}#yiv8881077546
a:link, #yiv8881077546 span.yiv8881077546MsoHyperlink
{color:blue;text-decoration:underline;}#yiv8881077546
span.yiv8881077546EmailStyle19 {font-family:"Calibri",
sans-serif;color:windowtext;}#yiv8881077546 .yiv8881077546MsoChpDefault
{font-family:"Calibri", sans-serif;}#yiv8881077546 filtered {}#yiv8881077546
div.yiv8881077546WordSection1 {}-->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
| |
| 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] |
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
[email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/1588128635.1982897.1668106391324%40mail.yahoo.com.
--
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.
--
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/1823449882.1985585.1668106846035%40mail.yahoo.com.
