Re: [sqlite] Sub-Select

Jakub Adamek schrieb: Michael, it is because SQLite 3.1.3 changed (or has errors in, it is a matter of opinion) the column naming. Try Thanks a lot - it works! Bye Michael

Re: [sqlite] thoughts on a web-based front end to sqlite3 db?

> Ease of learning is a plus as I need to get > something basic up and > running fairly fast. I've heard good things about > Python in that respect. > Does anyone have alternative suggestions, or if you > agree that Python Is > Good, would you suggest using APSW, pysqlite, or > something else?

Re: [sqlite] write invoices

Jan Ekström said: > I have created a small sqlite3-database with three tables. When I have > done > my qeuries I want to write invoices based upon my data. In what direction > do > I turn. Where can I find open source free programs for this purpose. > Windows > Home Edition. Where you turn

Re: [sqlite] Sub-Select

Michael, it is because SQLite 3.1.3 changed (or has errors in, it is a matter of opinion) the column naming. Try >> SELECT max(Sendung) >> FROM >> (SELECT S.Sendung AS Sendung >> FROM Auftrag AS A, >> Sendung AS S >> WHERE(A.PosyDat = 1 AND A.PosyDat = S.PosyDat) AND >>

[sqlite] write invoices

I have created a small sqlite3-database with three tables. When I have done my qeuries I want to write invoices based upon my data. In what direction do I turn. Where can I find open source free programs for this purpose. Windows Home Edition. Jan Ekström

Re: [sqlite] thoughts on a web-based front end to sqlite3 db?

On Tue, 8 Mar 2005 09:17:40 -0500 (EST), Clay Dowling <[EMAIL PROTECTED]> wrote: > > So, I was wondering if any of the more opinionated among you would care > > to suggest an interface language. It'll be on a Linux box, presumably > > running apache although I'm open to alternatives. The app

Re: [sqlite] thoughts on a web-based front end to sqlite3 db?

[EMAIL PROTECTED] (Eli Burke) writes: > I've been working on a project using sqlite3 since last fall. At the time, > I knew that it would need a web-based front-end eventually. I have a very > small bit of experience with PHP, and I assumed that PHP would support > sqlite3 sooner or later. Well,

Re: [sqlite] thoughts on a web-based front end to sqlite3 db?

Eli Burke said: > So, I was wondering if any of the more opinionated among you would care > to suggest an interface language. It'll be on a Linux box, presumably > running apache although I'm open to alternatives. The app itself uses > sqlite3 for scheduling jobs and storing job data, so the web

Re: [sqlite] Sub-Select

Hi, sorry... I forgot I get the error "no such column: Sub.Sendung" So I guess/hope it's only a "syntax error" with my SQL - my SQL-Skills are rather bad ;-( Thanks, Michael All, could someone please tell me why this query doesn't work with 3.1.3 (with 3.0.8 it works): SELECT

Re: [sqlite] Good Graphical Tool for 3.x

Sorry for the delay. Yes it should run on linux, at least it does on my box. Could you provide the link which setup.tcl is missing (or a screenshot from the error). I know those error windows are a little bit strange ... Or you try it from an other linux machine. May be it is a network issue.

[sqlite] Sub-Select

All, could someone please tell me why this query doesn't work with 3.1.3 (with 3.0.8 it works): SELECT max(Sub.Sendung) FROM (SELECT S.Sendung FROM Auftrag AS A, Sendung AS S WHERE(A.PosyDat = 1 AND A.PosyDat = S.PosyDat) AND (A.PosyNId = 6 AND A.PosyNId =