Re: ZSQL + MySQL + sqltest + list

Matthew Fairclough <[email protected]>
Newsgroups gmane.comp.web.zope.database
Message-ID <[email protected]>
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 <[email protected]>:

> 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
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.