Mailing List Archive


Back to the month index Back to the list index
Dann Cohen (Dann_Cohen@BigFoot.com)
Mon, 10 Nov 1997 21:27:37 -0500 

Message-Id: <01BCEE35.8BC74120@DynamicPPP-161.HIP.CAM.ORG>
From: Dann Cohen <Dann_Cohen@BigFoot.com>
Subject: HELP !!!
Date: Mon, 10 Nov 1997 21:27:37 -0500

Can someone help me ...

I'm having this error when I load my html page

W3-mSQL Error! - yacc stack overflow near ")"

Thanks in advance
From randyk@ccsales.com Tue Nov 11 00:32:59 1997
Received: from ns1.hiper.net (ns1.hiper.net [207.137.172.11])
        by services.bunyip.com (8.8.5/8.8.5) with ESMTP id AAA20220
        for <msql-list@services.bunyip.com>; Tue, 11 Nov 1997 00:32:56 -0500 (EST)
Received: from ntrkcasa (pool43.hiper.net [207.137.172.43])
        by ns1.hiper.net (8.8.5/8.8.5) with SMTP id VAA14144
        for <msql-list@services.bunyip.com>; Mon, 10 Nov 1997 21:48:59 GMT
Message-Id: <3.0.3.32.19971110213227.00c8b7f0@ccsales.com>
X-Sender: randyk@ccsales.com
X-Mailer: QUALCOMM Windows Eudora Pro Version 3.0.3 (32)
Date: Mon, 10 Nov 1997 21:32:27 -0800
To: Multiple recipients of list <msql-list@services.bunyip.com>
From: "Randy A. Katz" <randyk@ccsales.com>
Subject: CASE INSENSITIVE SEARCHES v2.03
Mime-Version: 1.0
Content-Type: text/plain; charset="us-ascii"

Hello,

I was doing a case insensitive search by SELECT * from tablename WHERE
fieldname LIKE '[Dd][Aa][Tt][Aa]' in version 1.0.16. Now in v2.03 it
doesn't seem to find anything.

In the FAQ it states that something like upper() / lower() would be
included in mSQL version 2...how is everyone doing this now???

Thanx,
Randy Katz
From lfini@arcetri.astro.it Tue Nov 11 02:25:57 1997
Received: from hercules.arcetri.astro.it (maciste.arcetri.astro.it [150.217.21.1])
        by services.bunyip.com (8.8.5/8.8.5) with ESMTP id CAA21743
        for <msql-list@services.bunyip.com>; Tue, 11 Nov 1997 02:25:55 -0500 (EST)
Received: from lfini (lfini [150.217.21.7]) by hercules.arcetri.astro.it (8.7.1/8.7.1) with SMTP id IAA08414; Tue, 11 Nov 1997 08:24:51 +0100 (MET)
Date: Tue, 11 Nov 1997 09:28:06 +0100 (MET)
From: Luca Fini <lfini@arcetri.astro.it>
X-Sender: X-Sender: lfini@lfini
To: "Randy A. Katz" <randyk@ccsales.com>
cc: Multiple recipients of list <msql-list@services.bunyip.com>
Subject: Re: CASE INSENSITIVE SEARCHES v2.03
In-Reply-To: <3.0.3.32.19971110213227.00c8b7f0@ccsales.com>
Message-ID: <Pine.LNX.3.95.971111092410.3620C-100000@lfini>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII

On Tue, 11 Nov 1997, Randy A. Katz wrote:

> Hello,
>
> I was doing a case insensitive search by SELECT * from tablename WHERE
> fieldname LIKE '[Dd][Aa][Tt][Aa]' in version 1.0.16. Now in v2.03 it
> doesn't seem to find anything.
The LIKE clause needs the SQL syntax for search strings. The above syntax
iss used for regular expressions instead. MSQL 2 provides a CLIKE clause
for case insensitive search and a RLIKE for unix like regular expressions
 
> > In the FAQ it states that something like upper() / lower() would be
> included in mSQL version 2...how is everyone doing this now???

MSQL 2.0.3 to my knowledge doesn't provide upper() / lower() or
similar functions.
Cheers,
                        l.f.

--------------------------------------------------------------------------
       -- ) Luca Fini Tel: +39 55 2752 307
 ___ |\ Osservatorio Astrofisico di Arcetri Fax: +39 55 2752 292
/ | | |\_ L.go E.Fermi, 5 o-----------------------------------------
(___|___//___) 50125 Firenze / WWW: http://www.arcetri.astro.it/~lfini
 (_) (_) Italia / e-mail: lfini@arcetri.astro.it
-----------------------------o--------------------------------------------