You can subscribe to this list here.
| 2000 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
(23) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2001 |
Jan
(68) |
Feb
(121) |
Mar
(59) |
Apr
(49) |
May
(110) |
Jun
(109) |
Jul
(146) |
Aug
(122) |
Sep
(83) |
Oct
(94) |
Nov
(90) |
Dec
(157) |
| 2002 |
Jan
(169) |
Feb
(186) |
Mar
(168) |
Apr
(353) |
May
(338) |
Jun
(278) |
Jul
(220) |
Aug
(336) |
Sep
(122) |
Oct
(183) |
Nov
(111) |
Dec
(265) |
| 2003 |
Jan
(358) |
Feb
(135) |
Mar
(343) |
Apr
(419) |
May
(277) |
Jun
(145) |
Jul
|
Aug
(134) |
Sep
(118) |
Oct
(97) |
Nov
(240) |
Dec
(293) |
| 2004 |
Jan
(412) |
Feb
(217) |
Mar
(202) |
Apr
(237) |
May
(333) |
Jun
(201) |
Jul
(303) |
Aug
(218) |
Sep
(285) |
Oct
(249) |
Nov
(248) |
Dec
(229) |
| 2005 |
Jan
(314) |
Feb
(175) |
Mar
(386) |
Apr
(223) |
May
(281) |
Jun
(230) |
Jul
(200) |
Aug
(197) |
Sep
(110) |
Oct
(243) |
Nov
(279) |
Dec
(324) |
| 2006 |
Jan
(335) |
Feb
(396) |
Mar
(383) |
Apr
(358) |
May
(375) |
Jun
(190) |
Jul
(212) |
Aug
(320) |
Sep
(358) |
Oct
(112) |
Nov
(213) |
Dec
(95) |
| 2007 |
Jan
(136) |
Feb
(104) |
Mar
(156) |
Apr
(115) |
May
(78) |
Jun
(75) |
Jul
(30) |
Aug
(35) |
Sep
(50) |
Oct
(44) |
Nov
(33) |
Dec
(35) |
| 2008 |
Jan
(90) |
Feb
(63) |
Mar
(47) |
Apr
(42) |
May
(72) |
Jun
(85) |
Jul
(25) |
Aug
(20) |
Sep
(14) |
Oct
(11) |
Nov
(25) |
Dec
(39) |
| 2009 |
Jan
(39) |
Feb
(46) |
Mar
(16) |
Apr
(27) |
May
(51) |
Jun
(66) |
Jul
(78) |
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
| 2010 |
Jan
|
Feb
|
Mar
(5) |
Apr
|
May
(4) |
Jun
|
Jul
(1) |
Aug
|
Sep
(1) |
Oct
(2) |
Nov
|
Dec
|
| 2011 |
Jan
|
Feb
(2) |
Mar
|
Apr
(3) |
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
| 2013 |
Jan
|
Feb
|
Mar
|
Apr
(1) |
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
| 2014 |
Jan
|
Feb
|
Mar
|
Apr
(1) |
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
| 2015 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
(1) |
| 2016 |
Jan
(1) |
Feb
|
Mar
|
Apr
(1) |
May
(1) |
Jun
(1) |
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
|
From: Thomas G. <to...@ad...> - 2001-12-10 13:14:34
|
On Sun, 9 Dec 2001, Phil Eldridge wrote: > I sat down before to write Linux Bash scripts for backups etc and started= =20 > to wonder: >=20 > a/ Are there any scripts supplied in the sql-ledger release (I haven't=20 > noticed any)? > b/ If not, would it be worth including some in the release? >=20 > What to others do for repeditive type tasks for sql-ledger. Hi Phil, I have tons of scripts that I use for diff things...my project=20 (originally based on Dieter's work but veered off course ;-) is located at www.sqlclinic.net You could have a look in the tarball (just download it and unpack it or use midnight commander to extract only the files you want) to=20 see if there is anything useful. In the install directory there are dump routines like this: #!/bin/sh pg_dump -a test > clinic.dat pg_dump -d test > clinic.all pg_dump -s test > clinic.sql pg_dump test > clinic.df This dumps the data in four diff formats (-a is data only, -d is proper inserts, -s is schema only and no args is everything...see man pg_dump for all options.) There are also fancier routines for database access from the shell. Have a look in /dba/usr_local_clinic for examples of how to do Q&A with a user and then run a query. HTH, Tom -------------------------------------------------------------------- Saint Vincent Catholic Medical Centers =20 -------------------------------------------------------------------- Thomas Good tomg@ { admin | q8 } .nrnet.org Programmer/Analyst Phone: 718-818-5528=20 Behavioral Health Services Fax: 718-818-5056 =20 Residential Services Mobile: 917-282-7359 =20 -------------------------------------------------------------------- /* Rekordmeister ist nur der FC Bayern M=FCnchen! */ -------------------------------------------------------------------- |
|
From: Chris W. <op...@vo...> - 2001-12-09 17:53:42
|
On Sunday 09 December 2001 04:33 am, Phil Eldridge wrote: > I sat down before to write Linux Bash scripts for backups etc and started > to wonder: > > a/ Are there any scripts supplied in the sql-ledger release (I haven't > noticed any)? > b/ If not, would it be worth including some in the release? > > What to others do for repeditive type tasks for sql-ledger. *PLEASE* Do Not write scripts in bash. Shell scripts should be written in sh. Because only on *Linux* does /bin/sh == bash. Everyone else /bin/sh == sh. This is horridly non portable. Especially if you want to include it in the release. Chris |
|
From: Phil E. <pel...@vo...> - 2001-12-09 10:34:45
|
I sat down before to write Linux Bash scripts for backups etc and started to wonder: a/ Are there any scripts supplied in the sql-ledger release (I haven't noticed any)? b/ If not, would it be worth including some in the release? What to others do for repeditive type tasks for sql-ledger. Cheers Phil |
|
From: Dieter S. <dsi...@sq...> - 2001-12-07 18:05:51
|
You setup the chart and export the chart table as insert strings without
id's. Then you add the tax and defaults section from the Default-chart. Of
course, you must change the account numbers for your COA. The sample data
is not needed.
The link codes are identifiers to build the pulldown menus and are
easily identified by module and what role they play.
i.e the fields on the AR screen
AR_amount include in menu for amount
AR_paid - " - paid
AR_tax - " - tax
AR - " - accounts receivables
Dieter Simader http://www.sql-ledger.org (780) 472-8161
DWS Systems Inc. Accounting Software Fax: 478-5281
=========== On a clear disk you can seek forever ===========
On Thu, 6 Dec 2001, Roy Smith wrote:
> Hi All
>
> I've just started looking to use SQL-Ledger, and I'm very impressed with its
> quality.
> I can't find any documentation on setting up my COA. I'm reading the sql
> scripts and can see
> most of the tasks. However I don't understand the significance of the "link"
> column.
>
> If the answer is rtfm, please let me have a link to the fm :-)
>
> kind regards
> Roy
>
>
|
|
From: Peter B. <pe...@fs...> - 2001-12-07 16:56:34
|
Hello I'm evaluating SQL-Ledger and have become a fan already and was wondering are there any plans to enhance the coding structure of SQL-Ledger to allow cost center/project reporting, does any current user have a method for doing this. I understand a new release is imminent what can we expect? I assume users have also written their own reports, is there any method for sharing this work. Thanks -- Peter Brown Accounting Manager Free Software Foundation Tel. 617 542 5942 |
|
From: Roy S. <xy...@bt...> - 2001-12-07 03:22:14
|
Hi All I've just started looking to use SQL-Ledger, and I'm very impressed with its quality. I can't find any documentation on setting up my COA. I'm reading the sql scripts and can see most of the tasks. However I don't understand the significance of the "link" column. If the answer is rtfm, please let me have a link to the fm :-) kind regards Roy |
|
From: John S S. <ad...@jo...> - 2001-12-06 07:34:45
|
Good evening everyone, I am trying to get Sql-ledger set up and running but have come to a dead stop - no doubt because I am not sure just what I should be doing. The result is a request for assistance from the Sql-ledger users list. I am using the new release of OS/2 now called eComStation and have downloaded and 'untared' the following: sql-ledger (v1.6) into \sql-ledger Perl-5.6.1 into \perl-5.6.1 Postgresql-7.1.3 into \postgresql-7.1.3 dbi-1.20 into \dbi dbd-pg-1_0 into \dbd I tried to run the dnhttpd but kept getting error messages so downloaded Apache version 1.3.20 Has anyone the time (and patience) to assist me in setting things up? If so, please contact me direct and I will supply all additional information required. I know that there are several other people on the OS/2 (sorry eCs) newsgroup who are suffering similar problems and I would be pleased to pass on any setup info that is available. Many regards John S Smith ------------------------------------------------------------------------------------------------------------------------------- ---------- Joatamon Enterprises Voice: +44 (0) 1202 734701 email: ad...@jo... Fax: +44 (0) 1202 716644 |
|
From: alta <al...@al...> - 2001-12-05 04:25:20
|
Thanks for tips from list members. This took some trial-and-error
for me, so here is a successful sequence, in case a list member might
have interest.
INSTALLATION INSTRUCTIONS: PostgreSQL and Perl DBD on SuSE 7.3
1. Install the following using YaST2:
(Suggestion: Install each line-item below in a separate YaST2
session.)
- Development/Libraries/Perl: perl-DBI
- Applications/Databases: all postgresql modules
- Development Libraries: postgresql-devl
2. Setup directories and paths for PostgreSQL:
> su - (change to root)
Setup disk directory for your db:
# mkdir /var/lib/pgsql/data
# chown postgres /var/lib/pgsql/data
- Put PostgreSQL path /usr/bin/psql into PATH in /etc/profile.local
3. Initialize the database, start it, and test it:
# /usr/local/pgsql/bin/initdb -D /var/lib/pgsql/data
# rcpostgresql start
Quick-test the server:
# su postgres
> psql -d template1
\q to exit psql
Setup another db user:
> createuser <db-user> (should matach an existing Linux user)
Shall the new user be able to create databases? (y/n) y
Shall the new user be able to create new users? (y/n) n
Note: SuSE 7.3 appears to have a Pg DBD, but I could not get it to
work,
so...
4. Verify the existence of the following, which are required for the
DBD:
- /usr/include/pgsql/libpq-fe.h
- /usr/lib/libpq.so
5. Download DBD::Pg from www.CPAN.org .
6. Expand and examine the downloaded components:
- su to the <db-user> you setup for db access, but NOT root!
- Expand DBD-Pg-1.01.tar.gz into your favorite directory.
- Read the README file.
7. Prepare for the build:
> PATH=.:$PATH
> export POSTGRES_INCLUDE=/usr/include/pgsql
> export POSTGRES_LIB=/usr/lib
8. Try the build:
> perl Makefile.PL
> make
- Verify no errors from the make.
> make test
- Verify all "ok" from the make test.
9. Do the final DBD install:
> su - (and cd back to the build directory, if necessary)
# make install
DBD-Pg is installed!
--
Reed White - ALTA RESEARCH - www.alta-research.com
Phone: 877-360-2582 - Email: al...@al...
|
|
From: Qaexl <qa...@ne...> - 2001-12-04 02:40:08
|
On Mon, Dec 03, 2001 at 01:28:29PM -0500, Jim McLaughlin wrote: > Is there some form of cash drawer support within this module? No. This is the web-based version of the POS. The client doesn't have a cash machine, and I am not familiar with cash register drivers or what they would entail. Since this person's wholesale and internet orders far exceed his retail, he doesn't really mind. Here's a demo, guys: https://next-horizons.com/devel-bin/dynamation/login.pl Use the username "demo1" and leave the password blank. NOTE: I put the "Dynamation" name as part of the ASP effort I'm programming. By no means am I attempting to co-opt the hard work of the SQL-ledger developers. The "dynamation" stuff won't include just SQL-ledger though -- I'm going to be glueing the phpGroupWare together along with a couple custom applications (using an external authentication adapter, so then I can glue other "modules" together :-) and the appropriate links back to the SQL-ledger.org website and all. Regardless, here's a URL for the source: http://next-horizons.com/devel/dynamation-0.5.tgz THIS IS FOR PRIVATE RELEASE, and just for the curious -- I WOULD like to see that POS module, though.:-) Normal GPL applies, sure, but I have no intention of starting a fork. Oh yeah, that and I never expected anyone to be seriously interested in it, so it's not going to be internationalized, either. I'll work on that in the next few days. I put this module together by squishing two other modules together... Nothing fancy. I think it's the IS.pl and the CT.pl. Don't quote me on that. This was about a month ago, and I just downed two shots of rum ;-) The module actually has one access point, if you look at the top that says "POS - start". It starts with a search on the customer database. I had to modify the SL backend modules in order that the customer search can search the phone numbers as well. You might think this is crazy, but I've talked with a few retail shops who actually use that to index their customers. It's easier to speak a series of numbers than to spell out your name. Now, once you do the search and you don't find the customer, there's a link to add a customer. Either way, once you select the customer or add a new one, THEN it would automatically go to the Invoice screen. Gone is the drop-down box of the customer list. And yeah, this client has about 10,000 existing customers ... heheheh, I'd be amused if the staff had to navigate those customers through that interface ;-) Once that's done, you go on and can do other things. WARNING: I have NOT put in the "change" functionality. I am not entirely sure how to do that... other than to add a radio button: (*) Make change ( ) Add to store credit account ( ) Add to sell price What do you guys think? Where does the money from "change" supposed to go, or you're not supposed to post it to the invoice? How is it generally-accepted to work, anyone? I am anxious to get a hold of the 1.8.0 because the customer has a need for different payment types, including checks ... AND credit cards, money orders, and the whole nine-yards. I do NOT want to duplicate efforts. One other modification I might be doing is seperating out the contact information, and consolidating the Vendor/Customer stuff. Why? This allows importing this client's data easier. Heck, he wrote a customer Dbase III <boggle!!> and, due to it's fixed-length record ASCII, uncompressed datafiles, there's about 890 MB of data for the past three years of business. But I digress. Having seperate contact database would make adapting some outside program, say, phpGroupWare far easier. I digress. The duplicate work that would go into 1.8.0, I don't want to repeat, but ya know, if I can't get to it, I'll just have to do that. -- -Qaexl- |
|
From: Dieter S. <dsi...@sq...> - 2001-12-04 00:21:02
|
setup a postgres user and grant select rights GRANT SELECT ON <all the SQL-Ledger tables> TO username The user will still have access to the edit function but can't add, change or delete anything. Dieter Simader http://www.sql-ledger.org (780) 472-8161 DWS Systems Inc. Accounting Software Fax: 478-5281 =========== On a clear disk you can seek forever =========== On Mon, 3 Dec 2001, Eric Brown wrote: > Hello, > > I've been using the SQL-Ledger 1.6.9 release for a month and it's great. > Now that I have my information in the PostgresSQL database I would > like others to view the information. My problem is permissions. I want > the users to be able to run reports in the inventory section but not have > the edit function. Can anyone point me in the right direction? Is the > permissions set in PostgresSQL or SQL-Ledger? > > Thank you, > > Eric Brown > er...@ex... > > |
|
From: Jonas S. <jo...@jo...> - 2001-12-04 00:17:54
|
On Mon, 3 Dec 2001, Eric Brown wrote: > I've been using the SQL-Ledger 1.6.9 release for a month and it's > great. Now that I have my information in the PostgresSQL database I > would like others to view the information. My problem is permissions. > I want the users to be able to run reports in the inventory section > but not have the edit function. Can anyone point me in the right > direction? Is the permissions set in PostgresSQL or SQL-Ledger? Beware that current default authentication is _very_ weak and can be circumvented merely by faking URL's. You probably don't want public access to your SQL-Ledger site unless you change authentication/authorization somehow. (don't tell anyone that mine is public currently...) - Jonas -- Jonas Smedegaard (+45 40843136) http://dr.jones.dk/~jonas/ Spiff ApS (= IT-guide dr. Jones ApS) http://dr.jones.dk/ Debian GNU/Linux developer http://people.debian.org/~js/ |
|
From: Eric B. <er...@ex...> - 2001-12-03 23:49:34
|
Hello, I've been using the SQL-Ledger 1.6.9 release for a month and it's great. Now that I have my information in the PostgresSQL database I would like others to view the information. My problem is permissions. I want the users to be able to run reports in the inventory section but not have the edit function. Can anyone point me in the right direction? Is the permissions set in PostgresSQL or SQL-Ledger? Thank you, Eric Brown er...@ex... |
|
From: John S. <js...@im...> - 2001-12-03 20:25:52
|
Dieter has said the code is 99% ready and awaiting incorporation of foreign currency code and final testing. He put up 1.8.0 screenshots to make us all drool. >I was looking at the sql ledger web site, in particular the following >screen shot > >http://www.sql-lwww.edger.org/feature/receipts.png > >It looks like it was possible to log multiple part payments to an >invoice. > >When i go to receipts and enter a date and a sum of money against a >particular invoice, it will only allow me to make one entry. If i try to >submit a second payment to the same invoice (a week later), it >replaces the original. > >Am i missing something? Is there a way to record multiple payments to a >single invoice? Sure you are. So are we, but don't fret. Hopefully Dieter will take pity on us and release 1.8.0 soon. Cheers John Christian Stoddart Caracas - Venezuela |
|
From: Jim M. <jim...@wo...> - 2001-12-03 18:28:14
|
Is there some form of cash drawer support within this module? > -----Original Message----- > From: sql...@li... > [mailto:sql...@li...]On Behalf Of Qaexl > Sent: Sunday, December 02, 2001 12:03 PM > To: sql...@li... > Subject: Re: OFF TOPIC: HTML Submit via ENTER key: how to get name/value > pairs... > > > I think it has to do with the browser type. IE has no problem with > this, whereas, Netscape does have a problem with it. > > On Sat, Dec 01, 2001 at 04:53:39PM -0500, David Ratte wrote: > > HOWEVER, this does not work unless you type in the number and > click the OK > > button with the mouse. Apparently if you press enter when a > text field has > > focus, the name/value pairs are not submitted. > > -- > -Qaexl- > > |
|
From: Jim M. <jim...@wo...> - 2001-12-03 18:25:43
|
We're very interested in the POS module. Is that available or are there some screen shots? > -----Original Message----- > From: sql...@li... > [mailto:sql...@li...]On Behalf Of Qaexl > Sent: Sunday, December 02, 2001 1:35 PM > To: sql...@li... > Subject: Version 1.8.0 and features > > > Hi > > I noticed that on the website, the features listed some things in > 1.8.0. When will that be ready? I was going to implement a few things > (like the checking account payment stuff) ... is there a way I can a > hold of the prerelease (perhaps through CVS) so I can submit the POS > module I wrote against version 1.6.9. > > -- > -Qaexl- > |
|
From: Ned L. <ne...@ma...> - 2001-12-03 03:46:51
|
I was looking at the sql ledger web site, in particular the following screen shot http://www.sql-lwww.edger.org/feature/receipts.png It looks like it was possible to log multiple part payments to an invoice. When i go to receipts and enter a date and a sum of money against a particular invoice, it will only allow me to make one entry. If i try to submit a second payment to the same invoice (a week later), it replaces the original. Am i missing something? Is there a way to record multiple payments to a single invoice? Ned |
|
From: alta <al...@al...> - 2001-12-03 02:24:58
|
Hello ...
I'm at the stage of creating the database, but get an error (in http
error log) saying that the admin.pl script failed at line 77.
This is at a "require". I inserted a warn statement, and find that
the "require" must be failing on the following file, which has
wide-open read permissions:
/usr/local/www/sql-ledger/bin/mozilla/admin.pl
My entries in the SQL-Ledger Accounting / Database Admin screen:
Host: (nothing)
Port: (nothing)
Database Administrator: postgres
Password: (postgres user password)
Connect to: template1
Does this look right?
However, it fails in the same way, regardless of what is in the above
fields.
The PostgreSQL, just installed from the SuSE 7.3 disk, seems to work.
For example, I can create a db with psql, etc. I changed all the
permissions as per the sql-ledger installation instructions.
Any suggestions?
Thanks ... Reed
--
Reed White - ALTA RESEARCH - www.alta-research.com
Phone: 877-360-2582 - Email: al...@al...
|
|
From: Qaexl <qa...@ne...> - 2001-12-02 17:07:08
|
Hi I noticed that on the website, the features listed some things in 1.8.0. When will that be ready? I was going to implement a few things (like the checking account payment stuff) ... is there a way I can a hold of the prerelease (perhaps through CVS) so I can submit the POS module I wrote against version 1.6.9. -- -Qaexl- |
|
From: Qaexl <qa...@ne...> - 2001-12-02 15:34:20
|
I think it has to do with the browser type. IE has no problem with this, whereas, Netscape does have a problem with it. On Sat, Dec 01, 2001 at 04:53:39PM -0500, David Ratte wrote: > HOWEVER, this does not work unless you type in the number and click the OK > button with the mouse. Apparently if you press enter when a text field has > focus, the name/value pairs are not submitted. -- -Qaexl- |
|
From: David R. <dr...@su...> - 2001-12-01 21:49:58
|
Hello all,
I'm working on an add-on module for sql ledger to quickly do inventory cycle
counts. Here's a quick intro to my setup:
[this is long, if I don't explain what I am doing, one tends to get responses
like Why would you want to do that... just do this!]
1. I'm using the RECORD_ID for the bin number, together with a new field CODE
for "grouping", in this way I can group special items together. the code is
basically a shelf identifier such that proper storage conditions might be
observed i.e. "R" (refrigerated items) kept cold, while "E" static-sensitive
stuff needs not be in the fridge ;)
2. This also allows that any new items go at the end of the shelf, and i
don't have to move anything (I'm lazy that way)
3. I've barcoded all my bins (with a quick ODBC to M$ Access, create a
report, and the help of Avery labels) to look like this:
B A R C O D E
R 10104
PARTNUMBER
4. This make pulling an average Bill of Materials of 60-75 items take about
7-10 minutes vs. my old way of storing bins by part number and having to hunt.
Now I want to speed up cycle counts so here's where my barcodes come into
play.
I've duplicated and modified ic.pl (new module so as not to have issues with
upgrades) and stripped it down such that it now says
Type Bin Number or Scan Barcode ____________________ <OK>
My barcode scanner works through keyboard input, so that no special
drivers/etc are required. It has the capability of adding ENTER to the end of
the code number for submission.
HOWEVER, this does not work unless you type in the number and click the OK
button with the mouse. Apparently if you press enter when a text field has
focus, the name/value pairs are not submitted.
ERROR: Action not defined! and a check of the environment variables
QUERY_STRING= null
But I'm figuring that there must be some trick to this - without resorting to
java or script, as many websites are able to do this (see home.netscape.com,
lycos.com, etc.)
SO, for anyone who hasn't dozed off by now and might have some insight - any
help is appreciated.
Thanks in advance...
Dave Ratte
Superior Circuit Technologies, Inc.
321-254-4201 x 204
|
|
From: alta <al...@al...> - 2001-11-30 22:41:33
|
I just installed SuSE 7.3, PostgreSQL, DBI, DBD, etc., and am now attempting to install sql-ledger. I did "initdb -D /var/lib/pgsql/data" from user "postgres", and ran "/usr/bin/pg_ctl -D /var/lib/pgsql/data -l logfile start", and the database server appears to be running. Because I did not know the "postgres" user password, I created a new one so that I would be able to enter a password in the admin.pl screen. However, from the sql-ledger admin.pl screen, when I click "Create Database", I get the error message "Internal Server Error". The user was "postgres" and connect to "template1". The postgre log indicates the server is running. The web server error log says: "Compilation failed in require at /usr/local/www/sql-ledger/admin.pl line 77. [Fri Nov 30 14:30:44 2001] [error] [client 127.0.0.1] Premature end of script headers: /usr/local/www/sql-ledger/admin.pl" Help appreciated! Thanks ... Reed -- Reed White - ALTA RESEARCH - www.alta-research.com Phone: 877-360-2582 - Email: al...@al... |
|
From: Jim M. <jim...@wo...> - 2001-11-30 19:05:13
|
What did you decide for the POS implementation? Did the POS code get uploaded? > -----Original Message----- > From: sql...@li... > [mailto:sql...@li...]On Behalf Of Qaexl > Sent: Monday, November 05, 2001 6:54 PM > To: sql...@li... > Subject: Invoice number > > > Hey there, > > I'm in the middle of creating a couple modules for this client. One > of them is a Point-of-Sales module that's a mishmash of the ct.pl and > is.pl modules. More like a "wizard" to make it easier for the POS > staff. (I'll upload it somewhere if anyone's interested, once I'm > done). Going through there, though, I noticed that the invoice number > doesn't use a sequence, but rather a chunk of Perl code that > determines the last known invoice number, then increments it from > there. > > While this client won't have more than one POS terminal any time soon, > I am concerned about this if there ever were. The liklihood of two > people creating duplicate invoice number is slim to none -- but, I'd > like to hear the developer's opinion on this. It is my understanding > that the COMMIT command insures that there's no possibility of this > happening. Wouldn't it be safer to use a sequence instead? > > -- > -Qaexl- > > |
|
From: <ga...@es...> - 2001-11-30 03:37:11
|
I'd check three things 1) Did you create a user? 2) Did you create a database? Is it named in all lower caps? 3) Did you attach the database to the user? The error you've got sounds like one of the above is missing. -Gary At 12:20 AM 11/29/2001 -0600, sql...@fi... wrote: >Howdy! I am getting an internal server error when I invoke the login.pl script. >It comes up with a > >Can't locate /usr/local/www/sql-ledger/users/test2.conf at SL/User.pm line 115. >Compilation failed in require at /usr/local/www/sql-ledger/login.pl line 77. >[Thu Nov 29 23:25:33 2001] [error] [client 127.0.0.1] Premature end of script headers: /usr/local/www/sql-ledger/login.pl > >error in the httpd error-log. > >Seems as if it is unable? to create the users conf file on initial login. I have >checked the directories on the web server, and I am able to login as su nobody >and put files in the users directory. > >The admin front-end seems to be working correctly though. I was able to add a >user and create/delete databases just fine. The file is not in the users >directory after I have created a user. I am able to edit the user after I have >created them, so I figured that the .conf file is created upon initial login. > >It's redhat 7.1 with stock apache and stock perl. > >Thanks, > >Steve > > > |
|
From: Roderick A. A. <raa...@ti...> - 2001-11-29 22:25:33
|
On Thu, 29 Nov 2001 sql...@fi... wrote:
> Seems as if it is unable? to create the users conf file on initial
> login. I have checked the directories on the web server, and I am
> able to login as su nobody and put files in the users directory.
> It's redhat 7.1 with stock apache and stock perl.
Check the ownership on the directory. I believe the stock Redhat 7.1
runs the webserver as apache instead of nobody. You'll have to change
the directories to reflect this difference.
Rod
--
Let Accuracy Triumph Over Victory
Zetetic Institute
"David's Sling"
Marc Stiegler
|
|
From: Flemming Ø. <fle...@br...> - 2001-11-29 20:44:43
|
Hello. Can anyone tell me what kind of folder the database is safe in. I have Sql-ledger on Mandrake 8,1 Thank you Best regards Flemming Øst Mail: Fle...@br... |