From owner-freebsd-questions@FreeBSD.ORG Mon May 14 21:09:23 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 77D1616A400 for ; Mon, 14 May 2007 21:09:23 +0000 (UTC) (envelope-from js@iidea.pl) Received: from openoffice.home.net.pl (openoffice.home.net.pl [62.129.241.178]) by mx1.freebsd.org (Postfix) with ESMTP id 35FAC13C458 for ; Mon, 14 May 2007 21:09:23 +0000 (UTC) (envelope-from js@iidea.pl) Received: from [10.0.0.6] (cnj199.neoplus.adsl.tpnet.pl [83.31.163.199]) by openoffice.home.net.pl (Postfix) with ESMTP id B42EB3C4003; Mon, 14 May 2007 23:05:57 +0200 (CEST) Message-ID: <4648D04D.7000401@iidea.pl> Date: Mon, 14 May 2007 23:10:37 +0200 From: =?ISO-8859-2?Q?Jaros=B3aw_Staniek?= Organization: OpenOffice Polska User-Agent: Mozilla/5.0 (X11; U; Linux i686; pl-PL; rv:1.6) Gecko/20050929 MIME-Version: 1.0 To: Drew Sanford References: <46465334.6020504@iidea.pl> <46472046.8000705@wilderness.homeip.net> <715841970705140552v7d6c5b6fgbee98cf256ad05e@mail.gmail.com> <4648AD91.1000301@iidea.pl> <4648ADB3.4010002@wilderness.homeip.net> In-Reply-To: <4648ADB3.4010002@wilderness.homeip.net> Content-Type: text/plain; charset=ISO-8859-2; format=flowed Content-Transfer-Encoding: quoted-printable 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 21:09:23 -0000 Drew Sanford said the following, On 2007-05-14 20:42: > Jaros=B3aw 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=20 >>> everything in >>> table1. >> >> SELECT * FROM table1 ORDER BY "key" >> ^^^^ >> >> A quick note: "key" is reservered word in sql and kexi cannot deal=20 >> with it yet properly by adding "" or by displayng appropriate warning.= >> >> Could you change the column name to something neutral and try again=20 >> and let me know? >> >=20 > Sorry. There's a new table called table11 in there with basically the=20 > same data. There is _still_ a column called "key" in table11 you have sent me. Remov= e the=20 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; --=20 regards / pozdrawiam, Jaroslaw Staniek Sponsored by OpenOffice Polska (http://www.openoffice.com.pl/en) to wor= k on Kexi & KOffice: http://www.kexi.pl/en, http://www.koffice.org KDE3 & KDE4 Libraries for MS Windows: http://kdelibs.com, http://www.kd= e.org