main

main@lists.alug.org.uk

3 participants
10374 discussions

RE: [ALUG] Re: Running total from a database table - how?
by Keith Watson 22 Nov '04

22 Nov '04

Works for me! :o) Regards, Keith ____________ Sometimes the highest form of action is inaction. - Jerry Brown > -----Original Message----- > From: main-admin(a)lists.alug.org.uk > [mailto:main-admin@lists.alug.org.uk]On Behalf Of Brett Parker > Sent: 22 November 2004 16:48 > To: main(a)lists.alug.org.uk > Subject: Re: [ALUG] Re: Running total from a database table - how? > > > On Mon, Nov 22, 2004 at 04:17:56PM +0000, Chris Green wrote: > > Yes, of course, I want a report that looks like:- > > > > Date Description Amount Balance > > 01/09/04 Initial balance +1000.00 1000.00 > > 03/09/04 Stamps -14.58 985.42 > > 06/09/04 Network Card -9.99 975.43 > > 12/09/04 Interest +0.10 975.53 > > date | description | amount | balance > ----------------------------+------------------+---------+--------- > 2004-11-22 16:39:52.046068 | Starting Balance | 1000.00 | 1000.00 > 2004-11-22 16:40:11.58727 | Booze | -50.00 | 950.00 > 2004-11-22 16:40:30.539512 | Poker Winnings | 50.00 | 1000.00 > 2004-11-22 16:40:59.067902 | CD | -10.99 | 989.01 > > > > It's a little more complicated than the above but that shows the > > essentials. (I don't guarantee my arithmetic is correct) > > > The Date, Description and Amount columns are directly from > a database > > table. The Balance column needs to ba calculated as the report is > > created. > > Yup, that's how that's done... Here's the *MAGIC* ;) > > create view testwithrunningtotal as select > date,description,amount,(select sum(amount) from test as > test2 where test2.date <= test.date) as balance from test > order by date; > > select * from testwithrunningtotal; > > > OK - so it's not pretty, but it does appear to work ;) > Obviously, if you're not > really using timestamps, like I was, and you can *assume* > that your IDs are in > the right order, then sort by those for the subselect. > > If you need to be able to 'mess' with this, then you'll also > need to set up > some insert and delete rules on the view, probably ;) > > Cheers, > -- > Brett Parker > web: http://www.sommitrealweird.co.uk/ > email: iDunno(a)sommitrealweird.co.uk > > _______________________________________________ > main(a)lists.alug.org.uk > http://www.alug.org.uk/ > http://lists.alug.org.uk/mailman/listinfo/main > Unsubscribe? See message headers or the web site above! >

1 0

Running total from a database table - how?
by Chris Green 22 Nov '04

22 Nov '04

I'm steadily progressing with my conversion of my Access accounting system to a Linux based system. I've moved from using mysql to postgresql which has made a few things easier by having VIEWs in the database. Rekall seems to have most of what I need on the forms and reports front except for one thing - I can't see how to implement a 'running total' column. The Access97 report tool has a specific 'running total' column type which does exactly what I need. Rekall doesn't have anything like this (that I can see). Has anyone got any bright ideas of how I can do this, it's rather vital on things like a Bank Reconciliation report to enable me to check my accounts against the bank statement. -- Chris Green (chris(a)areti.co.uk) "Never ascribe to malice, that which can be explained by incompetence."

1 0

RE SUSE Network problem
by RICHARD FLETCHER 22 Nov '04

22 Nov '04

Thanks for the replies helping me to sort out this problem. few answers to questions asked. While the reinstall goes on! ( going to look at the SAMBA config files before i start the samba server this time. see if anything changes in there. slow way of doing things but i'm learning all the time! when i tried to find other computers with smb://IP, konquorer just sat there and did nothing for a while and then came back with the same message. (network unreachable) (found the "internet server" though with its static IP) my apologies to not getting back Laurie: >Check DNS, dhcp and WINS. >Do smbclient and/or smbmount work? If not, what are the synptoms? being the floundering newbie that i said i was this made my head pop! i did have a look in the control centre and alas "play with" (not check) dchp, DNS and wins. For some reason this killed konquorer and my ability to browse anything including email :-( hence the reinstall (getting really good at that now!). smbclient/smb mount will take some more investigation by me as i dont know what to do with them (I assume they are console commands). might be up and running this afternoon with a fresh beast to slaughter. I somehow think that i'll be back with other symptoms later. thankyou all for now i'll be in touch..... Fletch. ___________________________________________________________ Moving house? Beach bar in Thailand? New Wardrobe? Win £10k with Yahoo! Mail to make your dream a reality. Get Yahoo! Mail www.yahoo.co.uk/10k

1 0

SUSE 9.1 SAMBA NETWORK ERROR.
by RICHARD FLETCHER 22 Nov '04

22 Nov '04

This is probably a really simple one but as a floundering newbie, I is really stuck now. I'm was running SUSE 9.1 after a fresh install and all was OK. The install included ALL available packages that came with SUSE 9.1. My Linux box was the only one in a sea of Win XP machines on our network but I was able to see them and browse their shares with confidence using konqueror. I did ALL of the on-line updates with YAST and all was still OK. I then Enabled the SAMBA Server/client in YAST so the they could browse my shares and it went all pear shaped. I am now unable to browse the network using konqueror as I used to be able to do. After clicking on the "windows network" icon as I always have i get the following message. "Internal Error Please send a full bug report at http://bugs.kde.org Unknown error condition in stat: Network is unreachable" It is reachable though. Our proxy server has a fixed IP and I am able to browse its files if I put "smb://IP ADDRESS" in the address bar. The other WIN XP boxes in the network are using DHCP and I'm unable to find them. The thing is that after an extensive google search for the answer and finding several different "definate causes" for the problem, none of them work and I am still no nearer to stopping all the WIN XP moomins from laughing at my sorry attempts at running a different OS. It seems like there are a lot of people out there with the same problem but no-one knows how to sort this. I feel thick. I hope someone can help me.... my brain hurts :-( Fletch ___________________________________________________________ Moving house? Beach bar in Thailand? New Wardrobe? Win £10k with Yahoo! Mail to make your dream a reality. Get Yahoo! Mail www.yahoo.co.uk/10k

3 2

Weekly IRC reminder
by Neill Newman 22 Nov '04

22 Nov '04

This is the automated ALUG IRC meeting reminder sent to remind you that there is an IRC meeting tonight (Monday) at 8.00pm. The meeting takes place on the irc server irc.alug.org.uk in the #alug channel. Most IRC clients should allow you to get there with the commands "/server irc.alug.org.uk" and "/join #alug". Popular IRC clients include tkirc, bitchx, xchat and EPIC on Unix, and Mirc under windows. Here are some links to help you get started with irc. Unix http://www.xchat.org/ http://freshmeat.net/ http://www.epicsol.org/ Windows http://www.mirc.com (loads of help with irc for newbies!)

1 0

Linux
by Jeremy Dales 18 Nov '04

18 Nov '04

As requested, I'll try and outline why I am interested in Linux, along with a few first impressions, although I am certainly not a technical person, so I am more interested in what it does rather than how it does it. I like the idea of Linux being open source - in fact I would say it is something I believe in quite strongly, and I used several open source applications while I was running Windows. I was also fed up with the numerous security flaws I encountered in every version of Windows I used, and despite the best protection around, was still plagued with spam, spyware, trojans and viruses. It seems that Linux, for whatever reason, has largely avoided this. If I have a concern about using Linux, it is less to do with it as an operating system and more to do with my inability to comprehend it. While I suspect that this is not uncommon in the first week of use, I have to say that it has seemed fiendishly complicated to do even very basic things like install applications or get the hardware configured - this has necessitated ploughing through long lines of unfathomable code of the kind I usually try to avoid. I am hoping that I will either become used to it, or more likely, that having got the system set up the way I like it, I can have as little to do with opening the terminal window as possible. In short, I'm looking for a smooth and reliable graphical interface that is simple to use, relatively secure, and has the additional benefit of being open source. Jeremy

5 11

mysql users question
by Chris Green 18 Nov '04

18 Nov '04

How do I delete a mysql user? ... and how do I stop a mysql user requiring a password? -- Chris Green (chris(a)areti.co.uk) "Never ascribe to malice, that which can be explained by incompetence."

3 5

SuSE 9.1 and flash cards
by Wayne Stallwood 18 Nov '04

18 Nov '04

I am sure this topic has come up before, but I can't find a solution in the archives. Running SuSE 9.1 I would like the same automount functionality for my multi format card reader as SuSE/KDE provides for CD/DVD drives. I have a "My Computer" icon on my desktop, inside that I have an icon for each removable drive on my system. If I insert a CD/DVD with data content then it is mounted and a konq file browser window appears on the desktop. Is it possible to get the same functionality for a USB card reader (each card type appears as a different device) I can mount various card types at will using the mount command, but I have to tail /var/log/messages to check what device that card is assigned to and then manually mount/unmount it. After I have that bit working I would really like it to detect a card insertion without me having to detach/reattach the reader from the USB ports. But I am not even sure if that last bit is possible. Anyone fixed this ? Wayne

1 2

Fonts without X
by Richard Lewis 15 Nov '04

15 Nov '04

Hello ALUG, I'm just working on adding a PDF 'data sheet' function to one of my databases. (Served using PHP and the FPDF class <http://www.fpdf.org/>). At the moment it doesn't work because it can't find any fonts (even with names like "Times") and, of course, the obvious answer is to install some. The Debian package for FPDF suggests installing 'ttf2pt1'. This package depends on a whole load (~20MB, OK not that much) of packages from X which I'm slightly reluctant to install because the machine is supposed to be a web/database server, not an X server. It doesn't, of course, need an X server and maybe (suggestions?) I'm being silly by not wanting to install 'xfree86-common', 'xlibs', etc. (I just don't like the idea of X clutter everywhere). So, can anyone suggest a way of installing a nice selection of fonts without any X packages or will someone reassure me that installing X packages (not server) is not something to worry about? ;-) Cheers, Richard -- Richard Lewis richardlewis(a)fastmail.co.uk

2 1

[ALUG Announce]Debian Bug squashing in Cambridge, November 27th to 28th
by MJ Ray 15 Nov '04

15 Nov '04

ALUG Announce Please send announcements to Announce(a)lists.alug.org.uk Unsub, change settings via http://lists.alug.org.uk/mailman/listinfo/announce ----- Maybe we can discuss this at Syleham on the 28th too? ---------- Forwarded message ---------- Date: 2004-11-11 16:53:05 +0000 From: Steve McIntyre <steve(a)einval.com> Subject: [Debian-uk] Bug squashing in Cambridge, November 27th to 28th Guys, we can't let the Germans and Australians have all the fun! Let's get together in Cambridge and show them how to close those bugs. If we all pull together, we can get the RC bugs killed and help make sarge a great (if late) release. Everyone's welcome to join us in person, and we'll be active on irc.oftc.net, #debian-uk too if you want to help but can't make it physically. If you want to come either day, please let me know. There's even (limited) crash space available. See the wiki page at http://wiki.earth.li/DebianBugSquashPartyNov2004 Location: 87 Kendal Way, Cambridge CB4 1LP (aka my house, as usual) Equipment: We have wired and wireless networking, a full local mirror and several architectures. Bring a laptop, power cables and ethernet cables if you need them. I hope to see you there... -- Steve McIntyre, Cambridge, UK. steve(a)einval.com "It's actually quite entertaining to watch ag129 prop his foot up on the desk so he can get a better aim." [ seen in ucam.chat ] -- MJR/slef My Opinion Only and not of any group I know Creative copyleft computing - http://www.ttllp.co.uk/ Unsolicited attachments to the pipex address deleted Will HLF fund tree-killings? http://www.thewalks.co.uk/ ----- Send discussion replies to main(a)lists.alug.org.uk (Reply-To set) Unsub, change settings via http://lists.alug.org.uk/mailman/listinfo/announce

1 0

Jump to page:

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

2005

2004

2003

2002

2001

2000

1999

1998

1997

main