RE: [Zope] Testing for NULL values in TinyTable
Are you doing <!--#var r3--> _before_ the <!--#if r3-->? Sorry, that's probably a silly question for me to ask, but I want to be sure I have my bases covered. I have had a similar sounding problem working with an Access database connected to Zope using the ZODBC connector. The problem seems to have gone away after I started using the following test: <!--#if name="_vars['sql-var-name']"--> [Do something here] <!--#/if---> This is likely more than verbose than it needs to be, but it does the trick. It looks like you are doing almost the exact same thing, except you aren't as explicit as I am being in my #if statement. My hunch is that difference is important. <!--#if sql-var-name--> just checks to see if sql-var-name exists, which it does since your ZSQL method defined it in accessing your DB. Doing <!--#if "sql-var-name"--> checks the _value_ of sql-var-name, which is probably what you really what. Oh great Zope masters, did I get that right? I will so happy if that is so... I'm new to the game so you should to take anything I say with a bit more than a grain of salt. That said I hope this is of some use to you, Zope on brave comrade! John Miller
-----Original Message----- From: Itai Tavor [SMTP:itavor@vic.bigpond.net.au] Sent: Thursday, June 03, 1999 5:43 AM To: zope@zope.org Subject: [Zope] Testing for NULL values in TinyTable
Hi,
I have a problem accessing TinyTable cells having NULL values.
In the following table:
Columns: name r1 r2 r3
Data: aaa, 1, 2, 3 bbb, 1, 2, NULL (the NULL is added by TinyTable when no value is specified for a cell)
When iterating over the table rows:
<!--#in table-->
Each cell is added to the namespace, so I can access it with <!--#var name-->, or <!--#var r1-->
The problem is that I can't deal with r3 in the 2nd row. Everything I try to do with it (like <!--#var r3-->, <!--#if r3-->) ends in a "You are not authorized to access r3" error!
Any ideas?
Thanks, Itai Tavor -- Itai Tavor -- "Je sautille, donc je suis." -- itavor@vic.bigpond.net.au -- - Kermit the Frog -- -- "What he needs now is understanding... and a confederate victory" -- -- Dr. Jacobi, Twin Peaks --
_______________________________________________ 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 )
Are you doing <!--#var r3--> _before_ the <!--#if r3-->? Sorry, that's probably a silly question for me to ask, but I want to be sure I have my bases covered.
Always good to have your bases covered. I tried the #if first, and even the #if on its own, and even that triggers the error. I also tried <!--#var r3 null=' '-->, no help.
I have had a similar sounding problem working with an Access database connected to Zope using the ZODBC connector. The problem seems to have gone away after I started using the following test: <!--#if name="_vars['sql-var-name']"--> [Do something here] <!--#/if--->
This doesn't do anything for me... maybe the _vars thing is ZODBC specific?
It looks like you are doing almost the exact same thing, except you aren't as explicit as I am being in my #if statement. My hunch is that difference is important. <!--#if sql-var-name--> just checks to see if sql-var-name exists, which it does since your ZSQL method defined it in accessing your DB. Doing <!--#if "sql-var-name"--> checks the _value_ of sql-var-name, which is probably what you really what.
Same result with <!--#if r3--> and <!--#if "r3"-->
I'm new to the game so you should to take anything I say with a bit more than a grain of salt. That said I hope this is of some use to you,
Zope on brave comrade! John Miller
Thanks, but I'm still stuck.
-----Original Message----- From: Itai Tavor [SMTP:itavor@vic.bigpond.net.au] Sent: Thursday, June 03, 1999 5:43 AM To: zope@zope.org Subject: [Zope] Testing for NULL values in TinyTable
Hi,
I have a problem accessing TinyTable cells having NULL values.
In the following table:
Columns: name r1 r2 r3
Data: aaa, 1, 2, 3 bbb, 1, 2, NULL (the NULL is added by TinyTable when no value is specified for a cell)
When iterating over the table rows:
<!--#in table-->
Each cell is added to the namespace, so I can access it with <!--#var name-->, or <!--#var r1-->
The problem is that I can't deal with r3 in the 2nd row. Everything I try to do with it (like <!--#var r3-->, <!--#if r3-->) ends in a "You are not authorized to access r3" error!
Any ideas?
Thanks, Itai Tavor -- Itai Tavor -- "Je sautille, donc je suis." -- itavor@vic.bigpond.net.au -- - Kermit the Frog -- -- "What he needs now is understanding... and a confederate victory" -- -- Dr. Jacobi, Twin Peaks --
_______________________________________________ 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 )
-- Itai Tavor -- "Je sautille, donc je suis." -- itavor@vic.bigpond.net.au -- - Kermit the Frog -- -- "What he needs now is understanding... and a confederate victory" -- -- Dr. Jacobi, Twin Peaks --
participants (2)
-
Itai Tavor -
Miller, John M.