🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: borland.public.vdbase.data.sql
Article #141

Re: Length Limit of Filter String?

#141
From: Thomas Preston
Date: Thu, 21 Jan 1999 00:00
36 lines
1618 bytes
I was encountering an error in a complex filter string that had the
format . . .

form.rowset1.filter=(this=that OR that=this) AND (thisthing=thatthing
OR thatthing=thisthing) AND (a=1 OR a=2 OR b=1 OR b=2 OR c=1 OR c=2 OR
d=1 OR d=2 OR e=1 OR e=2 OR f=1 OR f=2 OR g=1 OR g=2 OR h=1 OR h=2 OR
i=1 OR i=2) AND (theother=this OR this=theother)

The problem was in the longest segment (a=1 . . .).  I think that
there must be a limit to the number of arguments contained within
parens.  Anyway . . . I resolved the issue by modifying the form
(splitting the controls).

In other words . . . WHEN ALL ELSE FAILS, MANIPULATE THE DATA.

Tom Preston
tgp@compuserve.com

On Wed, 20 Jan 1999 14:49:30 +0800, "Geoff S. Wass" <gswass@ibm.net>
wrote:

>Tom,
>
>It will be 512, 1024, 2048 or 4096 - I don't know at all but these
>numbers seem to be associated with other limits in the mists of my mind.
>I know 4096 is the longest line you can have, but I don't know if it is
>the longest filter string. Why do you ask?
>
>--
>Geoff Wass
>Kuala Lumpur, Malaysia
>
>
>=>=> More dBASE info at http://members.theglobe.com/Geoff_Wass <=<=
>
>
Technical Details
Message-ID: <36a771af.9942236@forums.borland.com>
Path: arc1-ca.pugleaf.net!unknown!not-for-mail
References: <36a4afb3.62426926@forums.borland.com> <36A57C79.42E3DFBA@ibm.net>

Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ff5a1,3a53f38599f8e07c
X-Google-Attributes: gidff5a1,public
From: Thomas Preston
Subject: Re: Length Limit of Filter String?
Date: 1999/01/21
Message-ID: <36a771af.9942236@forums.borland.com>
X-Deja-AN: 435314534
References: <36a4afb3.62426926@forums.borland.com> <36A57C79.42E3DFBA@ibm.net>
Organization: Another Netscape Collabra Server User
Newsgroups: borland.public.vdbase.data.sql