unsuscribe

2001-06-11 Thread Peter Csoma
unsuscribe

a novice question

2001-06-11 Thread thapa damar
Hi, every body, I am a novice perl user, tyring to write some CGI scripts in Perl to maintain some database on the webserver. I have a table called test in mydb database with the following field structure ( I am using Postgresql 6.5.2 under Redhat Linux 6.2): firstname char(10

DBI and DBD::Informix between Unix and windows

2001-06-11 Thread Mahdi A. Sbeih
Hi All, I am now writing a Perl DBI script to access Informix database using DBD::Informix, everything is working fine with me on Unix ( script and db server on the same Unix box, what about if I want to implement the same script on Windows NT to connect to Informix server on NT also? What I need

RE: DBI and DBD::Informix between Unix and windows

2001-06-11 Thread Priest, Darryl - BALTO
You'll need to install the Perl, hopefully from ActiveState, and DBI and DBD::Informix on the NT machine. I've never done a connection to an Informix database on an NT machine but to connect to database on a Unix machine, you'll have to install the Informix connectivity software, which you should

RE: DBI and DBD::Informix between Unix and windows

2001-06-11 Thread Mahdi A. Sbeih
Thanks Darrtl for helpful information, What I have, is Informix server on NT box, I want to put the script I have on the same machine, so why I need to make ODBC connection, when I implemented this same case on Unix - Solaris - I was able to run the script without any problem at all Also, is the

RE: DBI and DBD::Informix between Unix and windows

2001-06-11 Thread Priest, Darryl - BALTO
I've never connected to an Informix database on NT, so I'm not positive of the steps you'd need. For the modules, you should be able to get them from PPM. You do not want to compile them yourself, unless you have to. Check out www.activestate.com for more info on PPM. -Darryl -Original Mess

RE: unsuscribe

2001-06-11 Thread Sterin, Ilya
Send email to [EMAIL PROTECTED], and anyone else out there that will be unsubscribing in the near future, take note. Ilya Sterin -Original Message- From: Peter Csoma To: [EMAIL PROTECTED] Sent: 6/11/01 3:30 AM Subject: unsuscribe unsuscribe

RE: DBI and DBD::Informix between Unix and windows

2001-06-11 Thread Sterin, Ilya
No special version, DBD's are cross platform as are majority of all perl modules. You don't need Visual C++ compiler if you use ActiveState perl. Use the ppm utility to download and install DBI and DBD::*. Search the docs (ActiveState) for ppm. Ilya Sterin -Original Message- From: Mahd

Who is not counting right here?

2001-06-11 Thread Bart Lateur
I am stumped. I prepare an SQL statement, print it out for checks, and call it with five parameters. Here's the code and the printout: print STDERR "$sth->{Statement}\n\t$chap, $pgo, $t1o, $t2o, $tid\n"; $sth->execute($chap, $pgo, $t1o, $t2o, $tid); --> I get the response back (partly t

Re: Who is not counting right here?

2001-06-11 Thread Bart Lateur
On Mon, 11 Jun 2001 16:39:42 +0200, Bart Lateur wrote: >print STDERR "$sth->{Statement}\n\t$chap, $pgo, $t1o, $t2o, $tid\n"; >$sth->execute($chap, $pgo, $t1o, $t2o, $tid); >I get the response back (partly translated into English): > >UPDATE HEADINGS SET CHAPTER=?, ORDER_PG=?, ORDER_TYPE_

Re: Who is not counting right here?

2001-06-11 Thread Bart Lateur
On Mon, 11 Jun 2001 16:39:42 +0200, Bart Lateur wrote: >DBD::ODBC::st execute failed: [Microsoft][ODBC Microsoft Access-driver] >Not enough parameters. The expected count is: 6. (SQL-07001)(DBD: >st_execute/SQLExecute err=-1) > >Huh? 6? I count only 5 question marks... What is going on? I found

WIllfully Clueless 'unsuscribe'ers

2001-06-11 Thread Michael A. Chase
I tried to post a response to the most recent 'unsuscribe' request with unsubscribe correctly spelled. It was bounced by the mailserver with instructions for unsubscribing. My suspicion is that the reason we are seeing so many messages titled unsuscribe is that those 'people' first tried sending

Re: WIllfully Clueless 'unsuscribe'ers

2001-06-11 Thread Michael Wendel
unscribe is very very common if they're not catching that one yet. - Original Message - From: "Michael A. Chase" <[EMAIL PROTECTED]> To: "Sterin, Ilya" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Monday, June 11, 2001 2:44 PM Subject: WIllfully Clueless 'unsuscribe'ers > I tried to p

DBI upgrade

2001-06-11 Thread Anthony Scott
Do I need to upgrade the DBI software for Oracle 8.1.7 support? I'm current running DBI-1.13. Anthony Scott

RE: WIllfully Clueless 'unsuscribe'ers

2001-06-11 Thread Sterin, Ilya
unscript, unscribe, take me off, etc... I don't think there is an end, but I know that they definitely read the email to have enough (sense if that's what you should call it) to send this message with the misspelled unsubscribe. It would probably take me twice as long to figure out that I should

Re: WIllfully Clueless 'unsuscribe'ers

2001-06-11 Thread Bart Lateur
On Mon, 11 Jun 2001 11:44:59 -0700, Michael A. Chase wrote: >My suspicion is that the reason we are seeing so many messages titled >unsuscribe is that those 'people' first tried sending a message with >unsubscribe spelled correctly, got the bounce message, ignored it, and then >sent another messa

RE: DBI upgrade

2001-06-11 Thread Sterin, Ilya
Well it definitely wouldn't be bad move to upgrade to DBI 1.18, but for Oracle 8+, compile DBD::Oracle with OCI8, for Win32 use ppm to install DBD::Oracle8 Ilya Sterin -Original Message- From: Anthony Scott Cc: [EMAIL PROTECTED] Sent: 6/11/01 1:11 PM Subject: DBI upgrade Do I need to u

RE: WIllfully Clueless 'unsuscribe'ers

2001-06-11 Thread Sterin, Ilya
subscribe (vi) to ~ to sth (magazine etc) su(b)scribirse {or} abonarse a algo; (opinion) compartir la opinión sobre algo; ~d capital (Comm) capital m suscrito Don't know Spanish, but I don't see suscribe anywhere in your given source. I don't think Michael is accusing them of being evil, but rath

Re: DBI upgrade

2001-06-11 Thread Anthony Scott
Let me re-phrase it I'm currectly running Oracle 8.1.5 with the following env. Unix Platform DBD-Oracle-1.03 DBI-1.13 perl 5.00503 Do I need to upgrade the DBI/DBD software to support 8.1.7? Anthony Scott "Sterin, Ilya" wrote: > > Well it definitely wouldn't be bad move to upgrade to DBI

Re: WIllfully Clueless 'unsuscribe'ers

2001-06-11 Thread Bart Lateur
On Mon, 11 Jun 2001 13:23:16 -0600, Sterin, Ilya wrote: >subscribe (vi) to ~ to sth >(magazine etc) su(b)scribirse {or} abonarse a algo; >(opinion) compartir la opinión sobre algo; >~d capital (Comm) capital m suscrito > >Don't know Spanish, but I don't see suscribe anywhere in your given source.

Re: Who is not counting right here?

2001-06-11 Thread Thomas A . Lowery
> Just as an experiment, I added an extra parameter in the execute call: As an additional experiment, try using DBD::ADO instead of DBD::ODBC. Sometimes Access stored queries require a parameter that DBI doesn't know about. Tom On Mon, Jun 11, 2001 at 05:45:22PM +0200, Bart Lateur wrote: > On

RE: DBI upgrade

2001-06-11 Thread Sterin, Ilya
As I said, you need to compile (in your case recompile) DBD::Oracle with the Oracle 8 libs, that's it, although it would be a good thing to upgrade the DBI and DBD also, although you don't have to. Ilya Sterin -Original Message- From: Anthony Scott To: Sterin, Ilya Cc: '[EMAIL PROTECTED]

Re: DBI-Pg-1.00 installation issues

2001-06-11 Thread Michael A Mayo
- Original Message - From: "John Gehman" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> > Postgres 6.5.3-6, DBI 1.18, and trying to > build DBD-Pg-1.00. I've got all the postgres RPMs installed off of the > disk except for jdbc, python, and tcl (which I don't expect to need), > and DBI appear

Does the $dbh->tables() work with DB2

2001-06-11 Thread Warden, Ronald MCF:EX
Hello, I am attempting to use the $dbh->tables() function to get a list of all of the tables that I am allowed to look at. It fails! joshua % table_list.pl Name "main::DBI" used only once: possible typo at table_list.pl line 30. DBD::DB2::db tables failed: [IBM][CLI Driver][DB2] SQL0104N An un

RE: How can I get insert_id from DBD::Oracle?

2001-06-11 Thread Steven Baldwin
Actually, if you are using Oracle 8 or higher, you can use the RETURNING clause of a DML statement to give you any column. The syntax is something like this .. : $insJR = $dbh -> prepare (q ( INSERT INTOIIJobRun (IIJobID, StartTimeStamp) VALUES (:jobid, pkg_Calc.Now) RETURNI

perl data structure for Oracle "index-by table"

2001-06-11 Thread Marty Keane
Hello dbi users, I'm trying to convert an oracle pl/sql script to perl dbi using MySQL. pl/sql(oracle's procedural language extensions for SQL) uses a data type(table) called an "index-by table". It gives you an integer index into your result set(once loaded into this structure) so that your rec

Apache::DBI / DBD::Oracle error

2001-06-11 Thread Eric Kolve
I recently upgraded to DBI 1.18 + DBD::Oracle 1.07 and upon restarts with mod_perl, I get the following error: DBD::Oracle::db rollback failed: Error while trying to retrieve text for error ORA-03113 (DBD ERROR: OCITransRollback) at /usr/lib/perl5/site_perl/5.005/Apache/DBI.pm line 153. I am run