[Zope-DB] ZSQL + MySQL + sqltest + list

[Matthew Fairclough]

Chris,

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.

Regards,

Matthew.

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?
>
> cheers,
>
> Chris
>
> --
> Simplistix - Content Management, Zope & Python Consulting
>             - http://www.simplistix.co.uk
>
>


--
Matthew Fairclough