[Zope-DB] Zope Query Syntax

[Matthew T. Kromer]

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 
away.