~ ~ I am a new Zope user and am attempting to access field names of a ~ ZSQL method. I have read and tried to use the How-To : "Access ~ the field names and fields of any arbitrary ZQSL query" by teyc. ~ The code suggested there has not worked. ~ ~ For example, when I use the code: ~ ~ <dtml-in SQL.names> ~ <dtml-let vname=sequence-item ~ vvalue="SQL()[0][_['sequence-index']]"> ~ <dtml-var vname>, ~ <dtml-var vvalue><br> ~ </dtml-let> ~ </dtml-in> ~ ~ I get the error: ~ Error Type: KeyError ~ Error Value: SQL.names ~ ~ I have nested the above code in code that references a ZSQL ~ method, as well as trying several other permutations, but nothing ~ has worked. I'm wondering if this is a name lookup problem. ~ ~ In checking this news group I see that several others have had ~ similar problems. See: ~ ~ http://zope.nipltd.com/public/lists/zope-archive.nsf/Main?SearchVi ew=++&Start=1&Count=20&SearchOrder=1&ExactMatch=&SearchOrder=1&Query=sql.nam es Can anyone tell me (us) how to correctly do this, or what mistake I (we) am making. I think i can tell you. When zope encounters something inside quotes, it generally treats it as a python expression. Python is treating what you thought was a hyphen as a minus sign and trying to subtract the variable "index" from the variable "sequence" in this line of code: <dtml-let vname=sequence-item vvalue="SQL()[0][_['sequence-index']]"> The easy solution is to name your variable sequence_item instead of sequence-item. I think there's also a way to actually name a variable sequence-item, but it involves an underscore and parens _( ) and some more funky syntax, but it's a lot easier to just stop using hyphens in variable names. hth, ~c Version information: Zope version: Zope 2.1.6 (binary release, python 1.5.2, win32-x86) Python version: 1.5.2 (#0, Jul 30 1999, 09:52:18) [MSC 32 bit (Intel)] Regards, David H. Jones Boeing Phantom Works, Mathematics and Computing Technology 425-865-6924 425-865-2964 (FAX) david.h.jones@boeing.com _______________________________________________ Zope maillist - Zope@zope.org http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )