Re: Sending DBI data to PDF?

2002-09-06 Thread Bodo Eing
Herbold, John W. wrote: Has anybody done anything with sending data from DBI calls to PDF files? Thanks ! John W. Herbold Jr. IS Specialist/DBA I have done that sucessfully by stuffing data retrieved with DBI into LaTeX templates and piping the result through pdflatex. Most other

Re: Is the while (...) syntax in AnyData fail-fast?

2002-07-12 Thread Bodo Eing
On 11 Jul 2002, at 15:02, Jeff Zucker wrote: Pomin Wu wrote: When accessing CSV with AnyData as a tie hash, I found that although the Cwhile (my $row = each %$table) syntax is valuable, it Clast as soon as I try to modify the table inside the loop, for ex. Cdelete $table-{key};. Or

Re: TeleMagic - MS Access

2002-07-08 Thread Bodo Eing
On 8 Jul 2002, at 18:03, PARLEY,JON (HP-MountainView,e wrote: Is there any way to use DBI to move data in TeleMagic Database [DOS based v14.5] (dBase III+ compatible data file structures) to MS Access? What DBDs do I need? Can anyone provide a skeleton for doing this? Thanks.

Re: Freeing memory [getting even more OT]

2002-02-27 Thread Bodo Eing
- From: Bodo Eing [EMAIL PROTECTED] To: Shao, Chunning [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Friday, February 22, 2002 8:07 PM Subject: Re: Freeing memory [getting even more OT] chunning, see below AFAIK unused memory is not returned to the system from Perl

Re: Freeing memory [getting even more OT]

2002-02-22 Thread Bodo Eing
chunning, see below AFAIK unused memory is not returned to the system from Perl processes. A workaround is to fork() out the memory consuming steps into a child process, the memory of which is freed when the child exits. HTH Bodo Could you give us examples how to do it? I have the

RE: Freeing memory.

2002-02-21 Thread Bodo Eing
On 21 Feb 2002, at 9:06, Shao, Chunning wrote: AFAIK unused memory is not returned to the system from Perl processes. A workaround is to fork() out the memory consuming steps into a child process, the memory of which is freed when the child exits. HTH Bodo Could you give us

Re: Unexpected behavior with AUTOCOMMIT

2002-02-18 Thread Bodo Eing
On 18 Feb 2002, at 9:04, Thomas, Eldho wrote: When I use, $dbh = DBI-connect(dbi:Informix:database, {PrintError = 1, AutoCommit = 0}); the transaction doesn't seem to start and all the updates are committed immediately and a commit or rollback statement gives a Not In Transaction error.

Re: Please help on dbh problem

2002-02-14 Thread Bodo Eing
On 13 Feb 2002, at 20:21, Richard C Rossy wrote: My config script points to the same server for mysql. How do I get the add.pl script to point to the server where mysql is. Config file: sub configure { # CGI CONFIGURATION VARIABLES

Re: Still need help?? Please

2002-02-14 Thread Bodo Eing
On 14 Feb 2002, at 12:13, Richard C Rossy wrote: Ok I can't seem to get this. Now is it possible to have MySQL on a other computer and run the script. In other words the perl script is on foo.com and MySQL database is on foo2.com. What is need to make the script work. What I have in the

Re: fetchrow_array problem

2002-02-09 Thread Bodo Eing
Ashwini, hi, I have a perl script here which fetches data from the mysql database using the fetchrow_array method. I have this script running on 2 different machines. unfortunately this fetchrow_array call works on one machine and not on another. I used the rows calls to check how many

Re: Create database redux

2002-02-07 Thread Bodo Eing
Glen, Whoops! Misspoke there the first time... I asked Is it possible without using the ODBC administrator? I meant, is it possible to create the databases in perl instead of first creating them in Access? Glen I think the 'cheat' posted in response to your original post was a

Re: Comparing Tables (MySQL) against arrays

2001-07-19 Thread Bodo Eing
Bodo Eing [EMAIL PROTECTED]

Re: MSAccess

2001-07-17 Thread Bodo Eing
Date sent: Mon, 16 Jul 2001 14:46:00 -0700 (PDT) From: Pallavi Patil [EMAIL PROTECTED] Subject:MSAccess To: [EMAIL PROTECTED] Pallavi, I want to get data from HTML form and save it into MSAccess. On my server, I will

Re: DBI and HTML Display

2001-07-16 Thread Bodo Eing
] Dr. med. Bodo Eing Institut fuer Medizinische Mikrobiologie Klinische Virologie v.-Stauffenbergstr. 36 48151 Muenster Germany Phone: ++49 251 7793 111 Fax: ++49 251 7793-104

Re: Regexp / Sql-perl problem.

2001-07-12 Thread Bodo Eing
Date sent: Thu, 12 Jul 2001 13:01:42 +0200 From: Nicolas JOURDEN [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject:Regexp / Sql-perl problem. Hi guys, I'have an SQL database with a lot of email and name.. from user who

Re: (Fwd) .MDX

2001-07-09 Thread Bodo Eing
Date sent: Sat, 7 Jul 2001 20:28:27 +0100 From: Tim Bunce [EMAIL PROTECTED] To: [EMAIL PROTECTED] Copies to: [EMAIL PROTECTED] Subject:(Fwd) .MDX Organization: Paul Ingram Group, Software Systems, +44 1 483

Re: Array problem

2001-07-06 Thread Bodo Eing
Subject:Array problem To: [EMAIL PROTECTED] From: Chris Saunders [EMAIL PROTECTED] Date sent: Fri, 6 Jul 2001 15:08:36 + This might not strictly be a DBI problem so I apologise in advance. I'm writing an enquiry form and

Re: specifying types with bind columns

2001-07-06 Thread Bodo Eing
From: [EMAIL PROTECTED] (Isaac) To: [EMAIL PROTECTED] Subject:specifying types with bind columns Date sent: Thu, 5 Jul 2001 12:05:56 -0700 Isaac I was hoping someone could give me the right syntax for specifying what type of

Re: HELP, HELP, HELP

2001-06-19 Thread Bodo Eing
Date sent: Mon, 18 Jun 2001 20:46:37 -0500 From: Aguztyn Garcia-Cruz [EMAIL PROTECTED] Organization: Internet Cancun To: [EMAIL PROTECTED] Subject:HELP, HELP, HELP Aguztyn, What am I doing WRONG I do not know

Re: HELP, HELP, HELP

2001-06-19 Thread Bodo Eing
From: Bodo Eing [EMAIL PROTECTED] To: [EMAIL PROTECTED], Aguztyn Garcia-Cruz [EMAIL PROTECTED] Date sent: Tue, 19 Jun 2001 12:31:42 +0200 Subject:Re: HELP, HELP, HELP Priority: normal Aguztyn, What am I doing

Re: RE: In Need of a Miracle...WAS:Re: Pg Connection WOES on DEADLINE!

2001-06-01 Thread Bodo Eing
to the documentation of DO is equivalent to saying: for $urow (@updates) { $presql=$urow-[1]; $sql=qq{$presql}; ^^^ Arrgghh!!! Read the chapter entitled qq{What's wrong with always quoting $vars?} in perlfaq4. Bodo Dr. med. Bodo Eing Institut fuer Medizinische Mikrobiologie Klinische Virologie v

Re: quotes, quotes, quotes...

2001-05-31 Thread Bodo Eing
\n; sleep 1; $sth-execute ($month, $day, $time, $logged_host, $service, $description); } $dbh-disconnect (); close(LOG); Dr. med. Bodo Eing Institut fuer Medizinische Mikrobiologie Klinische Virologie v.-Stauffenbergstr. 36 48151 Muenster Germany Phone: ++49 251 7793 111

Re: Copy records from other database.

2001-05-29 Thread Bodo Eing
Date sent: Tue, 29 May 2001 12:23:47 +0700 From: Krung Saengpole [EMAIL PROTECTED] Send reply to: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject:Copy records from other database. Hi all, I want to transfer record

Re: table info question

2001-05-22 Thread Bodo Eing
the statement handle attributes chapter in the DBI documentation. I assume, BTW, that some of the database handle attributes will be also interesting for you, like $dbh-tables or $dbh- table_info etc.. Bodo Dr. med. Bodo Eing Institut fuer Medizinische Mikrobiologie Klinische Virologie v

Re: Accessing unix from windows

2001-05-17 Thread Bodo Eing
PROTECTED] Dr. med. Bodo Eing Institut fuer Medizinische Mikrobiologie Klinische Virologie v.-Stauffenbergstr. 36 48151 Muenster Germany Phone: ++49 251 7793 111 Fax: ++49 251 7793-104

Re: Oracle SELECTS (again)

2001-05-15 Thread Bodo Eing
on? Hope someone can shed some light. ot so sure if I could... Bodo [EMAIL PROTECTED] Dr. med. Bodo Eing Institut fuer Medizinische Mikrobiologie Klinische Virologie v.-Stauffenbergstr. 36 48151 Muenster Germany Phone: ++49 251 7793 111 Fax: ++49 251 7793-104

Re: fetchrow_hashref

2001-05-15 Thread Bodo Eing
Date sent: Mon, 14 May 2001 16:41:41 -0500 From: Gerg Carmack [EMAIL PROTECTED] To: dbi-users [EMAIL PROTECTED] Subject:Re: fetchrow_hashref Jonas Askås wrote: I want to to this: $SQL = SELECT * FROM members; my $sth =

Re: dbi connecting prob -

2001-05-15 Thread Bodo Eing
let me connect HTH Bodo [EMAIL PROTECTED] Dr. med. Bodo Eing Institut fuer Medizinische Mikrobiologie Klinische Virologie v.-Stauffenbergstr. 36 48151 Muenster Germany Phone: ++49 251 7793 111 Fax: ++49 251 7793-104

RE: basic stuff

2001-05-14 Thread Bodo Eing
Date sent: Mon, 14 May 2001 11:42:49 +0300 (EEST) From: Nick Chirca [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject:RE: basic stuff Nick, I cannot answer the complete question (especially that STDIN stuff, but When I am

Re: Oracle CLOBs through DBI through CGI.pm don't work?

2001-05-10 Thread Bodo Eing
Does print $params{-id}; really print your isolate ID entered into the form? If you are new to CGI.pm, perhaps you mean someting like $query-params('id') ? Bodo Dr. med. Bodo Eing Institut fuer Medizinische Mikrobiologie Klinische Virologie v.-Stauffenbergstr. 36 48151 Muenster Germany Phone

RE: Problem with DBI and Access newbie

2001-05-10 Thread Bodo Eing
are not correctly converted, neither when directly interpolating values into the SQL statement, nor when using placeholders. I have to explicitly bind_param()s, and here I am still struggling to find out the most portable data types... Bodo [EMAIL PROTECTED] Dr. med. Bodo Eing Institut fuer Medizinische

RE: executing atomic transactions in DBI

2001-05-08 Thread Bodo Eing
From: Neil Lunn [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject:RE: executing atomic transactions in DBI Date sent: Tue, 8 May 2001 13:38:33 +1000 Neil, meanwhile I have performed some experiments and found out that I

RE: executing atomic transactions in DBI

2001-05-07 Thread Bodo Eing
. med. Bodo Eing Institut fuer Medizinische Mikrobiologie Klinische Virologie v.-Stauffenbergstr. 36 48151 Muenster Germany Phone: ++49 251 7793 111 Fax: ++49 251 7793-104

RE: How to add Date records to MS ACCESS

2001-04-27 Thread Bodo Eing
'). BTW, what about storing your dates as long integers and leaving the conversion from input and to formatted output to the application level ? Bodo [EMAIL PROTECTED] Dr. med. Bodo Eing Institut fuer Medizinische Mikrobiologie Klinische Virologie v.-Stauffenbergstr. 36 48151 Muenster Germany Phone

Re: (Fwd) Can't call method execute error undefined value

2001-03-05 Thread Bodo Eing
Date sent: Mon, 5 Mar 2001 10:04:44 -0800 (PST) From: Luis Colon [EMAIL PROTECTED] Subject:Re: (Fwd) "Can't call method execute" error "undefined value" To: Bodo Eing [EMAIL PROTECTED], [EMAIL PROTECTED]

Re: DBD::MySQL _ListDBs function for 3.23

2001-02-16 Thread Bodo Eing
Date sent: Fri, 16 Feb 2001 10:42:30 -0600 From: Mike Ford [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject:DBD::MySQL _ListDBs function for 3.23 Mike, I was doing some tests last night and I wanted to compare the databases on

Re: problem

2001-02-14 Thread Bodo Eing
Date sent: Wed, 14 Feb 2001 12:22:42 +0100 From: Bart Boogaerts [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject:problem boogie, i want to install the dbi for my mysql, perl on apache on a win 2000 or win 98 machine. i