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

2000-05-30 Thread Kyler B. Laird
On Tue, 30 May 2000 17:09:20 +1000 (EST) you wrote: I like the optional attribute. I'd like to see it do more than sit idle in the code. You don't have to do the typechecking in the 'arguments' box if you don't want. eg. in your arguments section: course="" subject="" O.k., it appears

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

2000-05-30 Thread Stuart 'Zen' Bishop
On Mon, 29 May 2000, Kyler B. Laird wrote: This is not the same functionality as is provided by the "optional" attribute. How would I use it with an integer, for example? I don't want a default value; I want the option of not having the value set at all. I like the optional attribute.

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

2000-05-29 Thread Stuart 'Zen' Bishop
On Sat, 27 May 2000, Kyler B. Laird wrote: I hope it's not documented anywhere; it doesn't work either. It *does* allow the method to run without setting the arguments, but it generates SQL like "where subject=''". Someone had a good vision when writing the documentation for the

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

2000-05-29 Thread 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

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

2000-05-29 Thread Kyler B. Laird
On Mon, 29 May 2000 21:56:33 +0200 (CEST) you wrote: 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". What's the URL for this? I'm looking through the pointers from the documentation

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

2000-05-27 Thread Kyler B. Laird
On Sat, 27 May 2000 13:07:50 +1000 (EST) you wrote: In your 'Options' box for your ZSQL method, you can specify a default value for arguments if they were not passed: subject:string = '' course_nbr: string = '' Don't know if/where it is documented. I hope it's not documented anywhere; it

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

2000-05-27 Thread Stuart 'Zen' Bishop
On Fri, 26 May 2000, Kyler B. Laird wrote: dtml-sqltest subject type=nb optional dtml-and dtml-sqltest course_nbr type=nb optional dtml-and dtml-sqltest version type=nb optional dtml-and

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

2000-05-26 Thread Kyler B. Laird
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. So...after reading