[Zope-DB] ZSQL + MySQL + sqltest + list
faircloughm at easp.com.au
Wed Apr 5 04:39:11 EDT 2006
Thanks for your help.
Basically I just want to limit the result to a number of entries based on Id.
As there are several Id's I'm trying for "... where catId IN (x, y, z)".
I could just use a variable that is a list (through REQUEST) but I would like to
ensure the argument is an integer, hence sqltest.
Quoting Chris Withers <chris at simplistix.co.uk>:
> Matthew Fairclough wrote:
> > Hi,
> > Really frustrated by this.
> No need to tell us twice ;-)
> > <dtml-sqltest catId type=int multiple>
> type=int is for int's only, you're talking about a list of ints...
> > I want catId to be a list: ie [4, 6, 8].
> Hmm, dunno what sqltest does... what are you actually looking to do here?
> Simplistix - Content Management, Zope & Python Consulting
> - http://www.simplistix.co.uk
More information about the Zope-DB