You can set "Maximum rows to retrieve" at Advanced tab in ZSQLMethod. <spamfilter2@mupp.net> wrote: > When doing a select from a mySQL that should redurn over 4000 lines, only > the first 1000 seems to get listed. How do i make the call return the entire > range of hits? -- cheeseshop