[Zope-dev] Z SQL: "optional" isn't?

[Dieter Maurer]

Kyler B. Laird writes:
 > I'd like to build a Z SQL method for *many*
 > people to use to list courses that we offer.
 > I don't want to require that all queries
 > using it understand all of the columns, but
 > I do want to be able to modify the query in
 > many ways.
 > 
 > This works only if I provide at least an empty
 > string for all values.  If I don't provide a
 > value at all for one of the arguments, I get
 > 	Error, Bad Request: ['version'] 
You want to use "default values" in your SQL method argument list.

The details are described in "ZSQL/ZSQL.2.5.2.html".

You already got this advice. You failed, because you used
the wrong kind of quotes (i.e. single rather than double quotes).
Quote from "ZSQL2.5.2.html":

> See Database method input argument format: Argument name and type are
> separated by a colon. A equal sign separates the default value from
> the name and type. The default value is a string representation of the
> desired value. If the default value contains spaces, or is an empty
> string, then it must be surrounded by double quotes.)

> Pattern:    name:type="default"

Dieter