Re: Database to Excel script...

2002-10-06 Thread Andreas Schmitz
This is complete nonsense: $xls-set_column(6, 7, 50); please read the docs: Perl/site/lib/Spreadsheet/WriteExcel/doc/WriteExcel.html#set_column_first_col_last_col -- Andreas Schmitz http://www.medialsoft.de _ _ _ _ ° _ _ _ _ _ | | ||_ | \|| || _| (_)|- | | | ||_ |_/||-||__

RE: FAQ emails now work

2002-10-06 Thread Matt Ramadanovic
I think that if we received one email per day (if there were any changes) it would be fine. -Matt -Original Message- From: Dana Lucent [mailto:[EMAIL PROTECTED]] Sent: Saturday, October 05, 2002 5:56 PM To: 'Christopher Pryce'; 'DBI Users' Subject: RE: FAQ emails now work This is a

DBD::ADO bug (Re: fetch_row array and aggregates)

2002-10-06 Thread Tim Bunce
On Fri, Oct 04, 2002 at 10:49:14AM -0500, Bill Hamilton wrote: Many thanks for you help. I did as you suggested. I wrote a smaller version of the program to cut it down to just these two columns. $oh_sel = qq/SELECT sum(s.qty_on_hand),sum(s.qty_committed) FROM bin_mat bm, stock s WHERE

Re: ***FAQ Emails now disabled***

2002-10-06 Thread Tim Bunce
On Sat, Oct 05, 2002 at 05:21:09PM -0600, Sterin, Ilya wrote: Sorry for the inconvenience, all. We thought it would be a good idea for the FAQ changes to go to the list, but guess it was too much... There's much more FAQ editing activity now then there will be in future. Plus FAQ-o-matic

Multiple SQL commands in a scripts?

2002-10-06 Thread Will
Greets Folks, I havent tried this yet, but I was wondering if it is possible to use multiple SQL commands in a list... maybe something like so... ###PREPARE AND RUN THE FIRST SQL COMMAND my $sth = $dbh-prepare(SELECT foo FROM bar); my $thing = $sth-execute(); ###PREPARE AND RUN A SECOND

Re: Multiple SQL commands in a scripts?

2002-10-06 Thread Henri Asseily
On Sun, 6 Oct 2002, Will wrote: Greets Folks, I havent tried this yet, but I was wondering if it is possible to use multiple SQL commands in a list... maybe something like so... ###PREPARE AND RUN THE FIRST SQL COMMAND my $sth = $dbh-prepare(SELECT foo FROM bar); my $thing =

RE: Multiple SQL commands in a scripts?

2002-10-06 Thread Pereira, Adrian non Unisys
yes this will work. Infact you can process data of multiple databases by separately logging onto them as long as the handles are kept separate. regards adrian -Original Message- From: Will [mailto:[EMAIL PROTECTED]] Sent: Monday, October 07, 2002 2:14 PM To: DBI Users Subject:

RE: ***FAQ Emails now disabled***

2002-10-06 Thread Ajay Gaikwad
Hi I want to unsubscribe myself from the mailing list. PLease let me know how to do it. Thanks, Ajay. -Original Message- From: Tim Bunce [mailto:[EMAIL PROTECTED]] Sent: Sunday, October 06, 2002 8:57 PM To: Sterin, Ilya Cc: '[EMAIL PROTECTED]'; '[EMAIL PROTECTED]' Subject: Re: ***FAQ

./file is not working

2002-10-06 Thread purnima nagar
Hi, I have perl scripts in a directory. I need to run those scripts almost from anywhere its being called from. For this I gave ./filename.its not working. I checked with the file permission..its 711 i.e, rwx--x--x for all the script files. Purnima.

RE: ./file is not working

2002-10-06 Thread Sterin, Ilya
Not working can relate to a gazillion of things. Please be more specific of what is not working, what happens, etc... Ilya -Original Message- From: purnima nagar To: [EMAIL PROTECTED] Sent: 10/6/02 11:49 PM Subject: ./file is not working Hi, I have perl scripts in a directory. I