[Zope-DB] Zope Query Syntax

Matthew T. Kromer matt@zope.com
Thu, 19 Dec 2002 08:56:34 -0500

Gareth Evans wrote:

>hi I've now changed the syntax after your good advice to be
>select e.trap, e.datestamp, e.trapoid, e.trapfull, e.target,
>e.enterprise, e.community,e.generictrap, e.version, e.severity, v.var,
>v.num from snmp_trap_entry as e, snmp_trap_vars as v where e.auto=v.auto
>and e.auto=4
>i still get a zope failure
>Site Error
>An error was encountered while publishing this resource. 
>Document Template Parse Error
>Voyager Error
>Voyager has encountered an error while publishing this resource.
>Error Type: Document Template Parse Error
>Error Value: No name given, for tag <dtml-var var null="">, on line 47
>of <string>

I  think haveing a name "var" is probalby bad  -- I'd select it as 
"select var as variable" or something and that will probably make it go