You are viewing a plain text version of this content. The canonical link for it is here.
Posted to embperl@perl.apache.org by "Boyd, David" <db...@nisys.com> on 2001/09/27 20:31:39 UTC
Shortcommings of DBIx
I notice a short comming of DBIx (unless some one knows of a work around for
it).
I create a simple search: select incident_key, note1 as title from
incident;
I then wanted to display this information in a table so I did the following.
<table align='center' class='tablemain' border='0' width='800'>
<tr>
<th width='15%' align='center'>Incident ID</th>
<th align='center'>Title</th>
</tr>
<tr>
<td width='15%' class='tdinfo' align='left'><a href='[+
Server_Root() +]/irs/html/IRS_Incident_Summary.phtml?IncidentKey=[+
$assignedRS[$row][$col] +]'>[+ $assignedRS[$row][$col] +]</a></td>
<td class='tdinfo' align='left'>[+ $assignedRS[$row][$col]
+]</td>
</tr>
</table>
But, nothing displayed. It turns out that if there is something missing
from a column, then nothing gets displayed. That is note1 is not required
to entered by the user, but I want to display it if it is there.
Anyone else run into this?
---------------------------------------------------------------------
To unsubscribe, e-mail: embperl-unsubscribe@perl.apache.org
For additional commands, e-mail: embperl-help@perl.apache.org
Re: Shortcommings of DBIx
Posted by Kee Hinckley <na...@somewhere.com>.
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
At 10:06 PM +0200 10/2/01, Gerald Richter wrote:
> > But, nothing displayed. It turns out that if there is something missing
>> from a column, then nothing gets displayed. That is note1 is not required
>> to entered by the user, but I want to display it if it is there.
>>
>> Anyone else run into this?
>>
>
>Yes, you should be able to find it in the mailing list archives...
>
>The dynamic tables features of Embperl detected the end of the table/row
>when an expression, which contains $rwo/$col is undefined. This is the case
>when the column contains NULL.
I actually answered this offline, because I didn't have time to
check. But if you run into this, just do the following.
[+ $foo[$row] || ' ' +]
and the expression won't fail. Obviously you shouldn't do this on
all the fields in a row, but if you have some which are allowed to be
null, this will work.
- --
Kee Hinckley - Somewhere.Com, LLC
http://consulting.somewhere.com/
nazgul@somewhere.com (or ...!alice!nazgul for time travelers :-)
I'm not sure which upsets me more: that people are so unwilling to accept
responsibility for their own actions, or that they are so eager to regulate
everyone else's.
-----BEGIN PGP SIGNATURE-----
Version: PGP Personal Security 7.0.3
iQA/AwUBO7ygBCZsPfdw+r2CEQIUcQCbBn6r41lVw42cYuwU9ZU+gXPC9VwAoNNf
fjwnuZjiaNSqOCKZdIL1zLOL
=Ktet
-----END PGP SIGNATURE-----
---------------------------------------------------------------------
To unsubscribe, e-mail: embperl-unsubscribe@perl.apache.org
For additional commands, e-mail: embperl-help@perl.apache.org
Re: Shortcommings of DBIx
Posted by Gerald Richter <ri...@ecos.de>.
>
> But, nothing displayed. It turns out that if there is something missing
> from a column, then nothing gets displayed. That is note1 is not required
> to entered by the user, but I want to display it if it is there.
>
> Anyone else run into this?
>
Yes, you should be able to find it in the mailing list archives...
The dynamic tables features of Embperl detected the end of the table/row
when an expression, which contains $rwo/$col is undefined. This is the case
when the column contains NULL.
Gerald
-------------------------------------------------------------
Gerald Richter ecos electronic communication services gmbh
Internetconnect * Webserver/-design/-datenbanken * Consulting
Post: Tulpenstrasse 5 D-55276 Dienheim b. Mainz
E-Mail: richter@ecos.de Voice: +49 6133 925131
WWW: http://www.ecos.de Fax: +49 6133 925152
-------------------------------------------------------------
---------------------------------------------------------------------
To unsubscribe, e-mail: embperl-unsubscribe@perl.apache.org
For additional commands, e-mail: embperl-help@perl.apache.org