From owner-freebsd-questions@FreeBSD.ORG Mon May 14 22:39:46 2007 Return-Path: X-Original-To: freebsd-questions@freebsd.org Delivered-To: freebsd-questions@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [69.147.83.52]) by hub.freebsd.org (Postfix) with ESMTP id 7E02B16A404 for ; Mon, 14 May 2007 22:39:46 +0000 (UTC) (envelope-from lauasanf@wilderness.homeip.net) Received: from mtao02.charter.net (mtao02.charter.net [209.225.8.187]) by mx1.freebsd.org (Postfix) with ESMTP id 157BF13C43E for ; Mon, 14 May 2007 22:39:45 +0000 (UTC) (envelope-from lauasanf@wilderness.homeip.net) Received: from aa08.charter.net ([10.20.200.160]) by mtao02.charter.net (InterMail vM.7.08.02.00 201-2186-121-20061213) with ESMTP id <20070514223945.UIXJ1555.mtao02.charter.net@aa08.charter.net>; Mon, 14 May 2007 18:39:45 -0400 Received: from colossus.cotharyus.net ([24.183.194.1]) by aa08.charter.net with ESMTP id <20070514223945.SISB2940.aa08.charter.net@colossus.cotharyus.net>; Mon, 14 May 2007 18:39:45 -0400 Message-ID: <4648E58E.5010908@wilderness.homeip.net> Date: Mon, 14 May 2007 17:41:18 -0500 From: Laurence Sanford User-Agent: Thunderbird 2.0.0.0 (X11/20070420) MIME-Version: 1.0 To: =?ISO-8859-2?Q?Jaros=B3aw_Staniek?= References: <46465334.6020504@iidea.pl> <46472046.8000705@wilderness.homeip.net> <715841970705140552v7d6c5b6fgbee98cf256ad05e@mail.gmail.com> <4648AD91.1000301@iidea.pl> <4648ADB3.4010002@wilderness.homeip.net> <4648D04D.7000401@iidea.pl> In-Reply-To: <4648D04D.7000401@iidea.pl> Content-Type: text/plain; charset=ISO-8859-2; format=flowed Content-Transfer-Encoding: 8bit X-Chzlrs: 0 Cc: Drew , freebsd-questions@freebsd.org Subject: Re: STABLE + KEXI 1.1.2 (koffice 1.6.2) + KDE 3.5.6 = no sql? X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Mon, 14 May 2007 22:39:46 -0000 Jarosław Staniek wrote: > Drew Sanford said the following, On 2007-05-14 20:42: >> Jarosław Staniek wrote: >>> Drew said the following, On 2007-05-14 14:52: >>>> As promised, I'm attaching a database I just threw together. It >>>> only has >>>> four entries, and one query, but clearly the query should list >>>> everything in >>>> table1. >>> >>> SELECT * FROM table1 ORDER BY "key" >>> ^^^^ >>> >>> A quick note: "key" is reservered word in sql and kexi cannot deal >>> with it yet properly by adding "" or by displayng appropriate warning. >>> >>> Could you change the column name to something neutral and try again >>> and let me know? >>> >> >> Sorry. There's a new table called table11 in there with basically the >> same data. > > There is _still_ a column called "key" in table11 you have sent me. > Remove the column and our query should work. > > Also queries that do not use the column work with table11, e.g.: > > SELECT vacation, users, date, vacation, id FROM table11 ORDER BY id; > I see where this is going. Actually, in the original db that I created, there is no conflict with "key" rather it appears to be start. However, I can specify that and get (correct) output from the queries. It looks like the problem is related specifically to using * in the select statement. Kexi keeps dropping the *.