Try this <!--#in dBcall--> <!--#if "newName == name"--> <!--#call "REQUEST.set('titleTrue', 'true')"--> <!--#else--> <!--#call "REQUEST.set('titleTrue', 'false')"--> <!--#/if--> <!--#else-> it failed, no records <!--#/in--> HTH Phil phil@philh.org ----- Original Message ----- From: Phil Grove <phil.grove@flg21.com> To: <zope@zope.org> Sent: Thursday, July 01, 1999 9:56 AM Subject: [Zope] Detecting empty SQL call
Hi all,
Can anyone tell me how to detect if the call to a mySQL database returns an empty recordset as my code causes an error if the SQL returns an empty recordset.
This is what i am currently using:
<!--#in dBcall--> <!--#if "newName == name"--> <!--#call "REQUEST.set('titleTrue', 'true')"--> <!--#else--> <!--#call "REQUEST.set('titleTrue', 'false')"--> <!--#/if--> <!--#/in-->
i have tried various <!--#if --> statement, but it doesn't seem to make any difference.
Any advice?
P.
---------------------------------------------------------------------
Phil Grove phil.grove@flg21.com Web Development 0113 2949494 flg21 http://www.flg21.com
---------------------------------------------------------------------
_______________________________________________ Zope maillist - Zope@zope.org http://www.zope.org/mailman/listinfo/zope
(For developer-specific issues, use the companion list, zope-dev@zope.org - http://www.zope.org/mailman/listinfo/zope-dev )