Mailing List Archive


Back to the month index Back to the list index
Joern Krueger (jkrueger@muenster.de)
Thu, 08 Apr 1999 08:36:38 +0200 

Message-ID: <370C4E76.828EB7A9@muenster.de>
Date: Thu, 08 Apr 1999 08:36:38 +0200
From: Joern Krueger <jkrueger@muenster.de>
Subject: New Lite functions

Hello,

what about an "iso-latin -> HTML Entity and back" function?
(i.e. "<" to "&lt;") Currently I use my own lite.lib to
convert national characters to their Entitys, but this is
not very fast. 

-- 
Bye, Joern
From bambi@Hughes.com.au  Thu Apr  8 02:52:14 1999
Received: from sonic.fan.net.au (sonic.fan.net.au [203.20.92.3])
	by services.bunyip.com (8.8.5/8.8.5) with ESMTP id CAA05957
	for <msql-list@services.bunyip.com>; Thu, 8 Apr 1999 02:52:13 -0400 (EDT)
Received: from fawn.Hughes.com.au (fawn.hughes.com.au [203.23.133.33])
	by sonic.fan.net.au (8.9.1/8.9.1) with ESMTP id QAA09773;
	Thu, 8 Apr 1999 16:52:10 +1000 (EST)
Received: from localhost (Received: from localhost (hughes@localhost)
	by fawn.Hughes.com.au (8.8.7/8.8.5) with SMTP id QAA06506;
	Thu, 8 Apr 1999 16:52:11 +1000 (EST)
X-Authentication-Warning: fawn.hughes.com.au: hughes owned process doing -bs
Date: Thu, 8 Apr 1999 16:52:10 +1000 (EST)
From: "David J. Hughes" <bambi@Hughes.com.au>
To: Pablo Molinero Fernandez <molinero@stanford.edu>
cc: Multiple recipients of list <msql-list@services.bunyip.com>
Subject: Re: mSQL 2.0.8 and perl
In-Reply-To: <Pine.HPP.3.96.990407230309.7498F-100000@yuba.stanford.edu>
Message-ID: <Pine.BSF.3.96.990408165021.469A-100000@fawn.hughes.com.au>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII

On Thu, 8 Apr 1999, Pablo Molinero Fernandez wrote:

> Table      = people
>  +-------------------+-------+--------+----------+-----+
>  | Field             | Type  | Length | Not Null | Key |
>  +-------------------+-------+--------+----------+-----+
>  | PERSON_ID         | int   |      4 |     N    | N   |
>  | NAME              | text  |     80 |     N    | N   |

> DBD::mSQL::st execute failed: Invalid field type 'TEXT' (type 6) in sort
> at SQL_DB.pm line 623 [this is the line of the prepare], &lt;MFH&gt; chunk
> 1.

The error says it all.  You are using ORDER BY on a TEXT field.  If you
redefine the table and use a CHAR field for NAME you'll be fine.  This
query may have worked in 2.0.4.1 only because the error wasn't being
trapped and the results would have been quite random (or even a core dump
in some situations).

Bambi
...