sql-ledger-users — SQL-Ledger users

Re: help with localhost please.

[Brian J. <bjo...@je...>]

That does not mean that Apache is running.  That means you've loaded the file into 
Netscape and it's being displayed - that is not the same as having it served.  You 
can use Netscape to load any document - but you want Apache to process the document 
and then serve it to your browser

OK - we think that you have Apache and PostgreSQL.
It sounds like PostgreSQL is running but not Apache

Find the file apachectl (on my machine it's under /usr/local/apache/bin and also 
under /usr/bin)

Type ./apachectl start

That should start Apache - it should say something like "httpd started"

Now try http://localhost/index.html.en and tell us if it displays a page

My guess is that we will next have to make sure that you have the correct modules 
installed 

Did you modify httpd.conf?


Wayne (inf...@pi...) wrote: 
>
>If I cd into /usr/local/Apache/htdoc and enter the command
>"netscape index.html.en ", the page that comes up
>informs me that apache is installed okay. As for the
>running of apache, the ps -ax command informs
>me that the httpd is running.
>What next?
>Wayne
>Richard Eicher II wrote:
>> Your web server is not running or installed.
>>
>> Rick
>>
>> __________________________________________________
>> Do You Yahoo!?
>> Make international calls for as low as $.04/minute with Yahoo! Messenger
>> http://phonecard.yahoo.com/

Re: help with localhost please.

[Wayne <inf...@pi...>]

I'm running Redhat 7.1 and I download the current release of
Apache, which I used a  tar file to installed. According to the RPM
query I did before installing apache , nothing of apache was installed.
Thanks for the help.
Wayne

Jonas Smedegaard wrote:

> Hi Wayne,
>
> It really sounds like you do not have apache running properly.
>
> Could you please tell a bit about your system, this makes it easier to
> guide you (it sounds like you need guiding here), as the commands you
> should run to problem solve and to configure is different from system to
> system.
>
> What is your system (Redhat, Slackware, Debian, Mandrake)?
>
> What version?
>
> Kind regards,
>
>  Jonas
>
> P.S.
>
> If you reply _below_ quoted text, and cut out irrelevant parts of quotes,
> it is easier to read :-)
>
> --
> Jonas Smedegaard <jo...@jo...> http://dr.jones.dk/~jonas/ +45 40843136
> Spiff ApS (aka. IT-guide dr. Jones ApS) <dr...@jo...> http://dr.jones.dk/
> Debian GNU/Linux <js...@de...> http://www.debian.org/ fngrprn: C02440B8
>
> YES! I found it: http://www.shibumi.org/eoti.htm (by way of ot...@jo...)

Re: help with localhost please.

[Wayne <inf...@pi...>]

If I cd into /usr/local/Apache/htdoc and enter the command
"netscape index.html.en ", the page that comes up
informs me that apache is installed okay. As for the
running of apache, the ps -ax command informs
me that the httpd is running.
What next?
Wayne


Richard Eicher II wrote:

> Your web server is not running or installed.
>
> Rick
>
> __________________________________________________
> Do You Yahoo!?
> Make international calls for as low as $.04/minute with Yahoo! Messenger
> http://phonecard.yahoo.com/

Re: Problems with sql-ledger/DBD-Pg installation

[Dr. R. J. M. <bo...@ho...>]

Andre,

Thank you for your response.  I hope that with the following and your
successful installation as reference you can help me solve my problem.

> Currently, sql-ledger only works with PostgreSQL (free open source also).
> DBD-Pg is an "interface" to PostgreSQL.

I am using PostgreSQL and DBD-Pg.

  ---- > rpm -qi postgres DBD-Pg | grep Version ----
Version : 6.5.1 Vendor: SuSE GmbH, Nuernberg, Germany
Version : 0.73  Vendor: (none)
  ---- > rpm -qi postgres DBD-Pg | grep Version ----

I created the ledgerdemo database for the sql-ledger installation.

  ---- > psql -l ----
datname   |datdba|encoding|datpath
----------+------+--------+----------
template1 |    26|       0|template1
ledgerdemo|    26|       0|ledgerdemo
(2 rows) 
  ---- > psql -l ----

  ---- > psql ledgerdemo ----
...
ledgerdemo=> select * from tax;
chart_id|rate|number
--------+----+------
   10067|0.07|
   10056|0.08|
(2 rows)
  ---- > psql ledgerdemo ----

I think that postgreSQL is listening, but I don't know the correct format.

  ---- > telnet localhost 5432 ----
Trying 127.0.0.1...
Connected to localhost.
Escape character is '^]'.
SELECT * FROM tax;
Connection closed by foreign host.
  ---- > telnet localhost 5432 ----

Unfortunately, my reading of the data at http://www.postgresql.org/ has
not helped so far.

Thanks again in advance,
-- 
Dr. Robert J. Meier
Custom Tools
mailto:rob...@co...

Re: Problems with sql-ledger/DBD-Pg installation

[Andre F. M. A. F. <and...@te...>]

Hello,
I am a newbie too. But by your configuration info, you have mySQL rdbms =

installed.
Currently, sql-ledger only works with PostgreSQL (free open source also)=
.
DBD-Pg is an "interface" to PostgreSQL.
As you try to execute a login into the database also, you fail because=20
PosgreSQL is simply not installed.
I guess that if you install www.postgresql.org you will get all up and=20
running.
There are rpm and other packages formats around.
Good luck.
Andre  Felipe

RE: sql-ledger not working - was this morning

[Brian J. <bjo...@je...>]

Reinstalled sql-ledger (wihtout touching the database) and it looks like it's 
working - weird

Anyway - didn't lose any data - I'm now testing it to make sure it doesn't die again

Brian Johnson (bjo...@je...) wrote: 
>
>That's not it - I double checked
>I know that PostgreSQL is working and is accepting
>connections
>Can someone tell me how to confirm that DBI is
>working properly - although I can't believe that
>this is the problem since it was working and I
>didn't reboot or anything - we were playing around
>with adding transactions in Accounts Recievable (I
>don't remember exactly what we were doing)
>-----Original Message-----
>From: sql...@li...
>[mailto:sql...@li...urceforge.n
>et]On Behalf Of Jim
>McLaughlin
>Sent: Tuesday, July 24, 2001 8:23 AM
>To: sql...@li...
>Subject: RE: sql-ledger not working - was this
>morning
>Looks like your file to login (login.pl) has been
>moved/deleted?
>Check the path to the perl script (Check for the
>string that is in the log
>file:
>/usr/local/apache/htdocs/sql-ledger/login.pl ).
>If it's there verify permissions on the file.
>You might also want to put the original httpd.conf
>file (before your mods
>back in place and try again).
>-----Original Message-----
>From: sql...@li...
>[mailto:sql...@li...urceforge.n
>et]On Behalf Of Brian
>Johnson
>Sent: Monday, July 23, 2001 11:27 PM
>To: sql...@sq...
>Subject: Fw: sql-ledger not working - was this
>morning
>I forgot to mention that the Apache error_log
>shows
>[Mon Jul 23 23:11:37 2001] [error] (2)No such file
>or directory: exec of
>/usr/lo
>cal/apache/htdocs/sql-ledger/login.pl failed
>[Mon Jul 23 23:11:37 2001] [error] [client
>192.168.0.42] Premature end of
>script
> headers:
>/usr/local/apache/htdocs/sql-ledger/login.pl
>Brian Johnson (bjo...@je...) wrote:
>>
>>I can';t figure out what may have happened
>>sql-ledger was working fine for weeks, then this
>morning it stops working -
>it
>>won't even display the login screen - it's like
>the server isn't processing
>the
>>perl scripts - but I have another perl program
>that is still working
>>For a while we could get it to work by reloading
>the page and then using
>the back
>>button, login, get an error, use the back button
>and we're in.  On and on
>like that
>>for every page
>>I decided to play with the httpd.conf but now I
>can't even get that to work
>>I'm still playing with httpd.conf - but any
>ideas?
>>-----
>>Brian Johnson, P. Eng.
>>Johnson Engineering Consultants
>>www.jecinc.on.ca
>-----
>Brian Johnson, P. Eng.
>Johnson Engineering Consultants
>www.jecinc.on.ca

Re: help with localhost please.

[Richard E. II <win...@ya...>]

Your web server is not running or installed.

Rick

__________________________________________________
Do You Yahoo!?
Make international calls for as low as $.04/minute with Yahoo! Messenger
http://phonecard.yahoo.com/

Re: help with localhost please.

[Jonas S. <jo...@jo...>]

On Tue, 24 Jul 2001, Wayne wrote:

> When I enter the url below, netscape thinks I'm trying to find a keyword
> and goes to netscapes home page to try and find this keyword.
> I'm really confused!!

> > >I did both ping and ifconfig and they show 127.0.0.1. I
> > >also did a chmod on all members to 777. I'm still getting
> > >the same error message. Is there somthing in Apache
> > >I have to do?
> > >Thanks for the help.

> > >> > On the installation instruction for SETUP A USER I
> > >> > get ans error.
> > >> > When I enter the URL
> > >> > http://localhost/sql-ledger/admin.pl   I get the
> > >> > error
> > >> > Netscape can not find localhost. Can some kind soul
> > >> > tell me how to let Netcape know about localhost,
> > >> > also
> > >> > could you point me to some documentation on this?

Hi Wayne,

It really sounds like you do not have apache running properly.

Could you please tell a bit about your system, this makes it easier to
guide you (it sounds like you need guiding here), as the commands you
should run to problem solve and to configure is different from system to
system.

What is your system (Redhat, Slackware, Debian, Mandrake)?

What version?


Kind regards,

 Jonas


P.S.

If you reply _below_ quoted text, and cut out irrelevant parts of quotes,
it is easier to read :-)

-- 
Jonas Smedegaard <jo...@jo...> http://dr.jones.dk/~jonas/ +45 40843136
Spiff ApS (aka. IT-guide dr. Jones ApS) <dr...@jo...> http://dr.jones.dk/
Debian GNU/Linux <js...@de...> http://www.debian.org/ fngrprn: C02440B8

YES! I found it: http://www.shibumi.org/eoti.htm (by way of ot...@jo...)

Re: help with localhost please.

[Wayne <inf...@pi...>]

When I enter the url below, netscape thinks I'm trying to find a keyword
and goes to netscapes home page to try and find this keyword.
I'm really confused!!
Wayne


Brian Johnson wrote:

> Have you tried just http://localhost/
> to check that Apache is running?
>
> Wayne (inf...@pi...) wrote:
> >
> >I did both ping and ifconfig and they show 127.0.0.1. I
> >also did a chmod on all members to 777. I'm still getting
> >the same error message. Is there somthing in Apache
> >I have to do?
> >Thanks for the help.
> >Wayne
> >German Duenas wrote:
> >> Check for permissions to the directories that you are
> >> trying to access. Also type ifconfig and see if it
> >> lists the loopback or 127.0.0.0 address or type ping
> >> 127.0.0.0 if it says that it can not reach addresss it
> >> means that the network was not setup. Good luck
> >> Jerry
> >> --- Wayne <inf...@pi...> wrote:
> >> > Hi,
> >> > On the installation instruction for SETUP A USER I
> >> > get ans error.
> >> > When I enter the URL
> >> > http://localhost/sql-ledger/admin.pl   I get the
> >> > error
> >> > Netscape can not find localhost. Can some kind soul
> >> > tell me how to let Netcape know about localhost,
> >> > also
> >> > could you point me to some documentation on this?
> >> > Thanks.
> >> > WAyne.
> >> >
> >> >
> >>
> >> __________________________________________________
> >> Do You Yahoo!?
> >> Make international calls for as low as $.04/minute with Yahoo! Messenger
> >> http://phonecard.yahoo.com/
>
> -----
> Brian Johnson, P. Eng.
> Johnson Engineering Consultants
> www.jecinc.on.ca

Re: help with localhost please.

[Wayne <inf...@pi...>]

When I excute the command  "ps -ax" I see the following in the list
/usr/local/Apache/httpd.
I assume that this means that apache is running. Correct
me if I'm wrong!
Wayne


Brian Johnson wrote:

> I believe this means that your web server is not running
>
> Port 80 is the port that your web server normally monitors
>
> There are hundreds of ports for each IP address
>
> Wayne (inf...@pi...) wrote:
> >
> >Hi again,
> >The path to my httpd is "/usr/local/Apache/bin/httpd",
> >do I have to tell any module where my httpd is?
> >When I enter the command, "telnet localhost 80" I get this error-
> >Trying 127.0.01...
> >telnet: Unable to connect to remote host: connection refuse
> >When I do ping IP address 127.0.0.1 shows up.
> >When I do ifconfig address 127.0.0.1 shows up.
> >Can anyone give me some more suggestion on
> > what I should  be looking for?
> >TIA.
> >Wayne
> >Anders Wallenquist wrote:
> >> Wayne wrote:
> >>
> >> >I did both ping and ifconfig and they show 127.0.0.1. I
> >> >also did a chmod on all members to 777. I'm still getting
> >> >the same error message. Is there somthing in Apache
> >> >I have to do?
> >> >Thanks for the help.
> >> >Wayne
> >> >
> >>
> >> Have you checked your apache/httpd?
> >>
> >> /etc/rc.d/init.d/httpd restart  # Does a restart of apache (stop and
> >> then start)
> >>
> >> telnet localhost 80  # Gives you direct access thru http-protocol GET /
> >> and so on...
> >>
> >> http://127.0.0.1/sql-ledger/admin.pl  # in netscape forces netscape to
> >> not use /etc/hosts or dns
> >>
> >> /aw
>
> -----
> Brian Johnson, P. Eng.
> Johnson Engineering Consultants
> www.jecinc.on.ca

RE: sql-ledger not working - was this morning

[Brian J. <bjo...@je...>]

That's not it - I double checked

I know that PostgreSQL is working and is accepting
connections

Can someone tell me how to confirm that DBI is
working properly - although I can't believe that
this is the problem since it was working and I
didn't reboot or anything - we were playing around
with adding transactions in Accounts Recievable (I
don't remember exactly what we were doing)



-----Original Message-----
From: sql...@li...
[mailto:sql...@li...urceforge.n
et]On Behalf Of Jim
McLaughlin
Sent: Tuesday, July 24, 2001 8:23 AM
To: sql...@li...
Subject: RE: sql-ledger not working - was this
morning


Looks like your file to login (login.pl) has been
moved/deleted?
Check the path to the perl script (Check for the
string that is in the log
file:
/usr/local/apache/htdocs/sql-ledger/login.pl ).
If it's there verify permissions on the file.
You might also want to put the original httpd.conf
file (before your mods
back in place and try again).

-----Original Message-----
From: sql...@li...
[mailto:sql...@li...urceforge.n
et]On Behalf Of Brian
Johnson
Sent: Monday, July 23, 2001 11:27 PM
To: sql...@sq...
Subject: Fw: sql-ledger not working - was this
morning


I forgot to mention that the Apache error_log
shows

[Mon Jul 23 23:11:37 2001] [error] (2)No such file
or directory: exec of
/usr/lo
cal/apache/htdocs/sql-ledger/login.pl failed
[Mon Jul 23 23:11:37 2001] [error] [client
192.168.0.42] Premature end of
script
 headers:
/usr/local/apache/htdocs/sql-ledger/login.pl

Brian Johnson (bjo...@je...) wrote:
>
>I can';t figure out what may have happened
>sql-ledger was working fine for weeks, then this
morning it stops working -
it
>won't even display the login screen - it's like
the server isn't processing
the
>perl scripts - but I have another perl program
that is still working
>For a while we could get it to work by reloading
the page and then using
the back
>button, login, get an error, use the back button
and we're in.  On and on
like that
>for every page
>I decided to play with the httpd.conf but now I
can't even get that to work
>I'm still playing with httpd.conf - but any
ideas?
>-----
>Brian Johnson, P. Eng.
>Johnson Engineering Consultants
>www.jecinc.on.ca

-----
Brian Johnson, P. Eng.
Johnson Engineering Consultants
www.jecinc.on.ca

Re: help with localhost please.

[Brian J. <bjo...@je...>]

I believe this means that your web server is not running

Port 80 is the port that your web server normally monitors

There are hundreds of ports for each IP address


Wayne (inf...@pi...) wrote: 
>
>Hi again,
>The path to my httpd is "/usr/local/Apache/bin/httpd",
>do I have to tell any module where my httpd is?
>When I enter the command, "telnet localhost 80" I get this error-
>Trying 127.0.01...
>telnet: Unable to connect to remote host: connection refuse
>When I do ping IP address 127.0.0.1 shows up.
>When I do ifconfig address 127.0.0.1 shows up.
>Can anyone give me some more suggestion on
> what I should  be looking for?
>TIA.
>Wayne
>Anders Wallenquist wrote:
>> Wayne wrote:
>>
>> >I did both ping and ifconfig and they show 127.0.0.1. I
>> >also did a chmod on all members to 777. I'm still getting
>> >the same error message. Is there somthing in Apache
>> >I have to do?
>> >Thanks for the help.
>> >Wayne
>> >
>>
>> Have you checked your apache/httpd?
>>
>> /etc/rc.d/init.d/httpd restart  # Does a restart of apache (stop and
>> then start)
>>
>> telnet localhost 80  # Gives you direct access thru http-protocol GET /
>> and so on...
>>
>> http://127.0.0.1/sql-ledger/admin.pl  # in netscape forces netscape to
>> not use /etc/hosts or dns
>>
>> /aw

-----
Brian Johnson, P. Eng.
Johnson Engineering Consultants
www.jecinc.on.ca

Re: help with localhost please.

[Wayne <inf...@pi...>]

Hi again,
The path to my httpd is "/usr/local/Apache/bin/httpd",
do I have to tell any module where my httpd is?
When I enter the command, "telnet localhost 80" I get this error-
Trying 127.0.01...
telnet: Unable to connect to remote host: connection refuse
When I do ping IP address 127.0.0.1 shows up.
When I do ifconfig address 127.0.0.1 shows up.
Can anyone give me some more suggestion on
 what I should  be looking for?
TIA.
Wayne


Anders Wallenquist wrote:

> Wayne wrote:
>
> >I did both ping and ifconfig and they show 127.0.0.1. I
> >also did a chmod on all members to 777. I'm still getting
> >the same error message. Is there somthing in Apache
> >I have to do?
> >Thanks for the help.
> >Wayne
> >
>
> Have you checked your apache/httpd?
>
> /etc/rc.d/init.d/httpd restart  # Does a restart of apache (stop and
> then start)
>
> telnet localhost 80  # Gives you direct access thru http-protocol GET /
> and so on...
>
> http://127.0.0.1/sql-ledger/admin.pl  # in netscape forces netscape to
> not use /etc/hosts or dns
>
> /aw

RE: sql-ledger not working - was this morning

[Jim M. <jim...@wo...>]

Looks like your file to login (login.pl) has been moved/deleted?
Check the path to the perl script (Check for the string that is in the log
file: /usr/local/apache/htdocs/sql-ledger/login.pl ).
If it's there verify permissions on the file.
You might also want to put the original httpd.conf file (before your mods
back in place and try again).

-----Original Message-----
From: sql...@li...
[mailto:sql...@li...]On Behalf Of Brian
Johnson
Sent: Monday, July 23, 2001 11:27 PM
To: sql...@sq...
Subject: Fw: sql-ledger not working - was this morning


I forgot to mention that the Apache error_log shows

[Mon Jul 23 23:11:37 2001] [error] (2)No such file or directory: exec of
/usr/lo
cal/apache/htdocs/sql-ledger/login.pl failed
[Mon Jul 23 23:11:37 2001] [error] [client 192.168.0.42] Premature end of
script
 headers: /usr/local/apache/htdocs/sql-ledger/login.pl

Brian Johnson (bjo...@je...) wrote:
>
>I can';t figure out what may have happened
>sql-ledger was working fine for weeks, then this morning it stops working -
it
>won't even display the login screen - it's like the server isn't processing
the
>perl scripts - but I have another perl program that is still working
>For a while we could get it to work by reloading the page and then using
the back
>button, login, get an error, use the back button and we're in.  On and on
like that
>for every page
>I decided to play with the httpd.conf but now I can't even get that to work
>I'm still playing with httpd.conf - but any ideas?
>-----
>Brian Johnson, P. Eng.
>Johnson Engineering Consultants
>www.jecinc.on.ca

-----
Brian Johnson, P. Eng.
Johnson Engineering Consultants
www.jecinc.on.ca

Problems with sql-ledger/DBD-Pg installation

[Dr. R. J. M. <bo...@ho...>]

Accountants,

I am a newbie trying to install sql-ledger.  I've successfully used admin.pl,
but login.pl still fails.  Any help would be appreciated.

	sql-ledger-1.4.12
	perlmod-1.0
		w3mir-1.0.8
		mod_perl-1.21
	mysqclnt-3.22.27
	mysqldev-3.22.27
	DBD-Pg-0.73

At this time, when I get http://localhost/sql-ledger/login.pl
it reports "Internal Server Error".

   Do you know why it cannot load Pg?
   Do you know what I need to do install DBD-Pg?
   Do you know what I can read to learn to install DBD-Pg?

	---- /var/log/http.error_log ----
...
install_driver(Pg) failed:
 Can't load '/usr/lib/perl5/site_perl/5.005/i586-linux/auto/DBD/Pg/Pg.so'
  for module DBD::Pg:
   libpq.so.1: cannot open shared object file:
    No such file or directory at
     /usr/lib/perl5/5.00503/i586-linux/DynaLoader.pm line 169.
 at (eval 1) line 3
 at SL/User.pm line 110
[Mon Jul 23 23:54:14 2001] [error] [client 127.0.0.1]
 Premature end of script headers:
  /opt/packages/sql-ledger-1.4.12/sql-ledger/login.pl
	---- /var/log/http.error_log ----

---- > ls -l /usr/lib/perl5/site_perl/5.005/i586-linux/auto/DBD/Pg/Pg.so ----
   -rwxr-xr-x 1 root root 35666 Oct 31 1998
    /usr/lib/perl5/site_perl/5.005/i586-linux/auto/DBD/Pg/Pg.so
---- > ls -l /usr/lib/perl5/site_perl/5.005/i586-linux/auto/DBD/Pg/Pg.so ----

Thanks in advance,
-- 
Dr. Robert J. Meier
Custom Tools
mailto:rob...@co...

Fw: sql-ledger not working - was this morning

[Brian J. <bjo...@je...>]

I forgot to mention that the Apache error_log shows

[Mon Jul 23 23:11:37 2001] [error] (2)No such file or directory: exec of /usr/lo
cal/apache/htdocs/sql-ledger/login.pl failed
[Mon Jul 23 23:11:37 2001] [error] [client 192.168.0.42] Premature end of script
 headers: /usr/local/apache/htdocs/sql-ledger/login.pl       

Brian Johnson (bjo...@je...) wrote: 
>
>I can';t figure out what may have happened
>sql-ledger was working fine for weeks, then this morning it stops working - it
>won't even display the login screen - it's like the server isn't processing the
>perl scripts - but I have another perl program that is still working
>For a while we could get it to work by reloading the page and then using the back
>button, login, get an error, use the back button and we're in.  On and on like that
>for every page
>I decided to play with the httpd.conf but now I can't even get that to work
>I'm still playing with httpd.conf - but any ideas?
>-----
>Brian Johnson, P. Eng.
>Johnson Engineering Consultants
>www.jecinc.on.ca

-----
Brian Johnson, P. Eng.
Johnson Engineering Consultants
www.jecinc.on.ca

sql-ledger not working - was this morning

[Brian J. <bjo...@je...>]

I can';t figure out what may have happened

sql-ledger was working fine for weeks, then this morning it stops working - it 
won't even display the login screen - it's like the server isn't processing the 
perl scripts - but I have another perl program that is still working

For a while we could get it to work by reloading the page and then using the back 
button, login, get an error, use the back button and we're in.  On and on like that 
for every page

I decided to play with the httpd.conf but now I can't even get that to work

I'm still playing with httpd.conf - but any ideas?

-----
Brian Johnson, P. Eng.
Johnson Engineering Consultants
www.jecinc.on.ca

Re: Archive material

[Dieter S. <dsi...@sq...>]

The complete archive is available at

http://www.geocrawler.com/lists/3/SourceForge/7966/0/

the link is also listed on the SQL-Ledger website.


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, 23 Jul 2001, Allen Thompson wrote:

> Hello all,
> 
> I have been archiving requests for help etc. for this forum almost since I
> discovered SQL ledger about October last year.
> 
> If anyone would like copies of these please let me know. There are almost
> 700 messages BTW.
> 
> Best regards,
> 
> Allen Thompson

Re: Pasting text into SQL-Ledger's invoice description field

[Dieter S. <dsi...@sq...>]

Hi Mike!

Instead of 
<input name="description_$i" value=$form->{"description_$i"} size=35>
 you use
<textarea name="description_$i" rows=2 cols=35 nowrap>
  $form->{"description_$i"}
</textarea>

You can use any html tags in the text to control how it will look like on
the invoice.

I would also adjust the rows to the number of lines the text will take up
in a 35 character column space and expand and shrink the field 
dynamically.

The description field is a text field and can hold about 8k of data.


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 Sun, 22 Jul 2001, Michael Bush wrote:

> Hi Dieter:
> 
> What are the downsides of changing the Description field from text to 
> textarea?  If ok, how would you recommend making the change?
> 
> Regards,
> 
> Mike Bush
> 

Re: Archive material

[Allen T. <al...@do...>]

If you require this material please send an email to:

al...@do...

with the words 'Archive Request' in the subject line and I will send the
info to you. Please ensure your email address is in the 'Reply To'

Best regards,

Allen Thompson
Head of IT

Dormy Limited
Battersea Road, Heaton Mersey
Stockport, Cheshire, SK4 3EN, UK
Tel: +44 (0)161 432 9451
Mob: +44 (0)7970 562042
Fax: +44 (0)161 431 8442
Visit us online: http://www.dormy.co.uk
Mailto: al...@do...
----- Original Message -----
From: "John Stoddart" <js...@im...>
To: <sql...@li...>
Sent: 23 July 2001 15:52
Subject: Re: Archive material


> Hello Allen,
>
> I'm now looking through the documentation with a view to possibly
> improving/reforming/clarifying/rewriting and this might be extremely
> helpful.
>
> Thanks very much,
>
>
> John Stodart
> Caracas - Venezuela
>
> >Hello all,
> >
> >I have been archiving requests for help etc. for this forum almost since
I
> >discovered SQL ledger about October last year.
> >
> >If anyone would like copies of these please let me know. There are almost
> >700 messages BTW.
> >
> >Best regards,
> >
> >Allen Thompson
> >Head of IT
> >
> >Dormy Limited
> >Battersea Road, Heaton Mersey
> >Stockport, Cheshire, SK4 3EN, UK
> >Tel: +44 (0)161 432 9451
> >Mob: +44 (0)7970 562042
> >Fax: +44 (0)161 431 8442
> >Visit us online: http://www.dormy.co.uk
>
>
> _____________________________________________________________________
> This message has been checked for all known viruses by UUNET delivered
> through the MessageLabs Virus Control Centre. For further information
visit
> http://www.uk.uu.net/products/security/virus/
>
>

Re: Archive material

[John S. <js...@im...>]

Hello Allen,

I'm now looking through the documentation with a view to possibly 
improving/reforming/clarifying/rewriting and this might be extremely 
helpful.

Thanks very much,


John Stodart
Caracas - Venezuela

>Hello all,
>
>I have been archiving requests for help etc. for this forum almost since I
>discovered SQL ledger about October last year.
>
>If anyone would like copies of these please let me know. There are almost
>700 messages BTW.
>
>Best regards,
>
>Allen Thompson
>Head of IT
>
>Dormy Limited
>Battersea Road, Heaton Mersey
>Stockport, Cheshire, SK4 3EN, UK
>Tel: +44 (0)161 432 9451
>Mob: +44 (0)7970 562042
>Fax: +44 (0)161 431 8442
>Visit us online: http://www.dormy.co.uk

Archive material

[Allen T. <al...@do...>]

Hello all,

I have been archiving requests for help etc. for this forum almost since I
discovered SQL ledger about October last year.

If anyone would like copies of these please let me know. There are almost
700 messages BTW.

Best regards,

Allen Thompson
Head of IT

Dormy Limited
Battersea Road, Heaton Mersey
Stockport, Cheshire, SK4 3EN, UK
Tel: +44 (0)161 432 9451
Mob: +44 (0)7970 562042
Fax: +44 (0)161 431 8442
Visit us online: http://www.dormy.co.uk
Mailto: al...@do...
----- Original Message -----
From: "Brian Johnson" <bjo...@je...>
To: <sql...@li...>
Sent: 23 July 2001 15:04
Subject: Re: help with localhost please.


> Have you tried just http://localhost/
> to check that Apache is running?
>
>
> Wayne (inf...@pi...) wrote:
> >
> >I did both ping and ifconfig and they show 127.0.0.1. I
> >also did a chmod on all members to 777. I'm still getting
> >the same error message. Is there somthing in Apache
> >I have to do?
> >Thanks for the help.
> >Wayne
> >German Duenas wrote:
> >> Check for permissions to the directories that you are
> >> trying to access. Also type ifconfig and see if it
> >> lists the loopback or 127.0.0.0 address or type ping
> >> 127.0.0.0 if it says that it can not reach addresss it
> >> means that the network was not setup. Good luck
> >> Jerry
> >> --- Wayne <inf...@pi...> wrote:
> >> > Hi,
> >> > On the installation instruction for SETUP A USER I
> >> > get ans error.
> >> > When I enter the URL
> >> > http://localhost/sql-ledger/admin.pl   I get the
> >> > error
> >> > Netscape can not find localhost. Can some kind soul
> >> > tell me how to let Netcape know about localhost,
> >> > also
> >> > could you point me to some documentation on this?
> >> > Thanks.
> >> > WAyne.
> >> >
> >> >
> >>
> >> __________________________________________________
> >> Do You Yahoo!?
> >> Make international calls for as low as $.04/minute with Yahoo!
Messenger
> >> http://phonecard.yahoo.com/
>
> -----
> Brian Johnson, P. Eng.
> Johnson Engineering Consultants
> www.jecinc.on.ca
>
>
> _____________________________________________________________________
> This message has been checked for all known viruses by UUNET delivered
> through the MessageLabs Virus Control Centre. For further information
visit
> http://www.uk.uu.net/products/security/virus/
>
>

Re: help with localhost please.

[Anders W. <aw...@kr...>]

Wayne wrote:

>I did both ping and ifconfig and they show 127.0.0.1. I
>also did a chmod on all members to 777. I'm still getting
>the same error message. Is there somthing in Apache
>I have to do?
>Thanks for the help.
>Wayne
>

Have you checked your apache/httpd?

/etc/rc.d/init.d/httpd restart  # Does a restart of apache (stop and 
then start)

telnet localhost 80  # Gives you direct access thru http-protocol GET / 
and so on...

http://127.0.0.1/sql-ledger/admin.pl  # in netscape forces netscape to 
not use /etc/hosts or dns

/aw

Paroll + Time billing

[Brian J. <bjo...@je...>]

Is anyone already working on payroll or time billing?

I'm going to start with time billing and I want to coordinate efforts if possible



-----
Brian Johnson, P. Eng.
Johnson Engineering Consultants
www.jecinc.on.ca

Re: help with localhost please.

[Brian J. <bjo...@je...>]

Have you tried just http://localhost/
to check that Apache is running?


Wayne (inf...@pi...) wrote: 
>
>I did both ping and ifconfig and they show 127.0.0.1. I
>also did a chmod on all members to 777. I'm still getting
>the same error message. Is there somthing in Apache
>I have to do?
>Thanks for the help.
>Wayne
>German Duenas wrote:
>> Check for permissions to the directories that you are
>> trying to access. Also type ifconfig and see if it
>> lists the loopback or 127.0.0.0 address or type ping
>> 127.0.0.0 if it says that it can not reach addresss it
>> means that the network was not setup. Good luck
>> Jerry
>> --- Wayne <inf...@pi...> wrote:
>> > Hi,
>> > On the installation instruction for SETUP A USER I
>> > get ans error.
>> > When I enter the URL
>> > http://localhost/sql-ledger/admin.pl   I get the
>> > error
>> > Netscape can not find localhost. Can some kind soul
>> > tell me how to let Netcape know about localhost,
>> > also
>> > could you point me to some documentation on this?
>> > Thanks.
>> > WAyne.
>> >
>> >
>>
>> __________________________________________________
>> Do You Yahoo!?
>> Make international calls for as low as $.04/minute with Yahoo! Messenger
>> http://phonecard.yahoo.com/

-----
Brian Johnson, P. Eng.
Johnson Engineering Consultants
www.jecinc.on.ca