RE: DBI and DBD

2001-08-14 Thread Sterin, Ilya
It's almost always best to upgrade. Most new releases include bug fixes, new functionality, etc..., unless there are specific problems, you should upgrade. Ilya > -Original Message- > From: Harsh Pandey [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, August 14, 2001 1:35 PM > To: [EMAIL PRO

Problem with DBI

2001-08-14 Thread Oscar Daniel Islas
Hi, How are you, i try to install the DBI in my server but i have a problems, the trace is in the next file. Oscar Daniel Islas R. 52681254 perl.log

DBI and DBD

2001-08-14 Thread Harsh Pandey
Tim/All, We have been using perl at Bristol-Myers Squibb for quite a while now. I had a small concern, We have recently moved to Oracle 8i and were facing some dead lock problems. We thought it might be DBi or DBD . So we up graded to DBI version 1.18 . --Do you recommend to Upgrade the DBD versi

Re: How to Access AutoIncrement Value ?

2001-08-14 Thread sonya
I am not a programmer. I solved my OBCD problem. I am getting all your e-mails and I do not have a clue as to how to stop them. I would love to help, but I do not have a clue about programming. I was looking for a way to fake out a microsoft upgrade into thinking I had a product that it was look

Informix error messages

2001-08-14 Thread Curt Russell Crandall
We've been noticing that often times DBD::Informix is not returning the whole error message generated by the database. For example, I received the following string in response to a char to numeric conversion error: SQL:-1213: < However in the Apache error_log, I get: FastCGI: server "/apache/

Re: insert NULL value

2001-08-14 Thread HUA, Qing
Now I remember that I've read it somewhere... Thanks for the help! It is working now. On Tue, 14 Aug 2001, Stephen Clouse wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > On Tue, Aug 14, 2001 at 02:32:04PM -0600, HUA, Qing wrote: > > I am trying to insert using the following statem

Re: insert NULL value

2001-08-14 Thread Erick Nelson
"HUA, Qing" wrote: > I am trying to insert using the following statements. Somehow, > VARCHAR NULL can be inserted, but the NUMBER NULL keeps giving me > ORA-01722: invalid number (DBD ERROR: OCIStmtExecute). > > What did I do wrong? Thanks! > > $insert = "INSERT INTO test_database (TEST_PRIOR,

Re: insert NULL value

2001-08-14 Thread Ronald J Kimball
On Tue, Aug 14, 2001 at 02:32:04PM -0600, HUA, Qing wrote: > > I am trying to insert using the following statements. Somehow, > VARCHAR NULL can be inserted, but the NUMBER NULL keeps giving me > ORA-01722: invalid number (DBD ERROR: OCIStmtExecute). > > What did I do wrong? Thanks! > > $insert

Re: insert NULL value

2001-08-14 Thread Stephen Clouse
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Tue, Aug 14, 2001 at 02:32:04PM -0600, HUA, Qing wrote: > I am trying to insert using the following statements. Somehow, > VARCHAR NULL can be inserted, but the NUMBER NULL keeps giving me > ORA-01722: invalid number (DBD ERROR: OCIStmtExecute). >

insert NULL value

2001-08-14 Thread HUA, Qing
I am trying to insert using the following statements. Somehow, VARCHAR NULL can be inserted, but the NUMBER NULL keeps giving me ORA-01722: invalid number (DBD ERROR: OCIStmtExecute). What did I do wrong? Thanks! $insert = "INSERT INTO test_database (TEST_PRIOR, TESTER_IP_ADDR, TEST_DURATION, T

NULL VALUE QUERY

2001-08-14 Thread Rozengurtel, Daniel
Hello all, I am trying to retrieve a record that may/maynot have a null value in it. this is what i am doing, however there its not really working. I can feel there is a simpler way of doing it, but unfortunately i am clueless in that sense. Can anybody make sense out of it??? Thanx a lot. PS:

Re: FW: auto commit

2001-08-14 Thread mickalo
Thanks, that's the problem, their using MYISAM tables, not Innodb or BDB table handlers so it won't work! Damn,.. guess that answer that question.. :) >> Tue, 14 Aug 2001 15:12:48 -0400, [EMAIL PROTECTED] wrote: >> >>Which version of MySQL? In the CREATE TABLE statement for members, did yo

Re: FW: auto commit

2001-08-14 Thread wsheldah
Which version of MySQL? In the CREATE TABLE statement for members, did you specify the table type that uses transactions? (Can't remember what it is right this second.) Does your actual code execute more than one statement inside the transaction? If not, there's not much point to using it.

FW: auto commit

2001-08-14 Thread gordon . dewis
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 14, 2001 12:49 To: [EMAIL PROTECTED] Subject: Re: auto commit On Tue, 14 Aug 2001 12:26:39 -0400, [EMAIL PROTECTED] wrote: >>You don't mention which database, which might make a difference. M

Re: Win32 distribution for DBI/DBD

2001-08-14 Thread RAJANATH TADIKONDA
You need to search in Activestate if it is for Win32, I am wondering how did you search for that did you searched for DBD-Oracle Using PPm? - Original Message - From: Sanjay Perl Sent: Tuesday, August 14, 2001 11:31 AM To: [EMAIL PROTECTED] Subject: Win32 distribution for DBI/DBD I

RE: DBI sql parsing - possible bug

2001-08-14 Thread Scott T. Hildreth
Sorry I don't have a lot of time right this moment to investigate further, taking a quick glance at the code, if (in_literal) { /* check if literal ends but keep quotes in literal */ if (*src == in_literal && *(src-1) != '\\') { in_literal = 0; } *dest++ = *src++; contin

RE: DBI sql parsing - possible bug

2001-08-14 Thread Scott T. Hildreth
Actually the preparsing is done by the DBD's. Look at the dbd_preparse() function in dbdimp.c file under DBD::PG dist. On 15-Aug-01 Anar R Guliev wrote: > Dear Sir, > > I've found your email in the DBI's perldoc. > > So, what i found seems to be a bug of sql-parsing > Here is a fragment of t

Win32 distribution for DBI/DBD

2001-08-14 Thread Sanjay Perl
I am trying to locate a pre-compiled version of DBI (1.19) and DBD-Oracle (latest) for the Win32 platform and have had no success so far. Does anyone have any additional information about this, or could point me in the rigth direction? Thanks, Sanjay __

DBI sql parsing - possible bug

2001-08-14 Thread Anar R Guliev
Dear Sir, I've found your email in the DBI's perldoc. So, what i found seems to be a bug of sql-parsing Here is a fragment of tracing: dbd_st_preparse: statement = >select * from dirs_items1 where dirid like ?||'\\_\%' escape '\\' and lang=?< dbd_preparse scanned 1 distinct placeholders O

FW: delete with DBI and DBD::DB2

2001-08-14 Thread Matthew Johnson
Is there a perl DB2 group where I can post my question? -Original Message- From: Matthew Johnson Sent: Monday, August 13, 2001 9:32 PM To: '[EMAIL PROTECTED] ' Subject: delete with DBI and DBD::DB2 Hello, I'm using DBI with DBD::DB2 connecting to a DB2 database(who'd a thought) [snip,

oraperl

2001-08-14 Thread Praveen Kolanu
Hi, We are migrated our Oracle7.0 to Oracle8.1.6, The perl programs were written using oraperl.pm script to connect to database, and now we are trying to install Oracle DBD:DBI modules, Is it going to be smooth transition? any ideas? Our old perl programs are going to work? Pl . let me know. Th

RE: auto commit

2001-08-14 Thread gordon . dewis
You don't mention which database, which might make a difference. The finish() after the UPDATE won't do what you think it will. It should only be used after a SELECT query. The cheetah book talks about it on p. 117. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]

Re: auto commit

2001-08-14 Thread mickalo
Here is a very trimmed down sample snip: $dbh->do('LOCK TABLE members WRITE'); $dbh->do('begin'); $query = qq|UPDATE members SET payment = ? WHERE username = ?|; $sth = $dbh->prepare($query); $sth->execute($pay,$user); $sth->finish() if $sth; $dbh->do('commit'); $dbh->do('UNLOCK TABLE'); $dbh-

Re: DBI 1.19 installation errors (make -j3)

2001-08-14 Thread Tim Bunce
On Tue, Aug 14, 2001 at 04:45:10PM +0200, Ton Verhagen wrote: > Dear All, > > I am experiencing some problems installing DBI-1.19 on a clean RH7.1 system > running perl-5.6.1 > make: *** No rule to make target `blib/arch/auto/DBI/Driver.xst', needed by > `Perl.xsi'. Stop. > make: *** Waiting

RE: auto commit

2001-08-14 Thread gordon . dewis
Can you provide some code? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 14, 2001 10:02 To: [EMAIL PROTECTED] Subject: auto commit Hello All, When setting AutoCommit => 0, with transactions, does anything else need to be set to disable Auto

Re: FreeTDS module Error

2001-08-14 Thread Michael Peppler
Piyush Avichal writes: > Hello, > > I am trying to build the DBD::FreeTDS module for Perl, but > I am encountering and error when I do the perl makefile.pl > command : DBD::FreeTDS is dead (I guess it should really be removed from CPAN...) Try downloading the FreeTDS libraries (http://www

Re: Sybase.dll Load Error

2001-08-14 Thread Michael Peppler
Falk writes: > Hi, > I used to use DBD:Oracle and it worked fine. > I'm using ActivePerl 5.6.1. > Now I switched to DBD:Sybase. I installed the Sybase module via > ActiveState > ppm. > So far ok. > When I tried to execute a perl script connecting to a sybase db I get > the > error that t

FreeTDS module Error

2001-08-14 Thread Piyush Avichal
Hello, I am trying to build the DBD::FreeTDS module for Perl, but I am encountering and error when I do the perl makefile.pl command : Died at makefile.pl line 47. %RMS-F-SYN, file specification syntax error Line 47 happens to be : die unless -e "$dbidir/DBIXS.h"; I have installed DBI 1.19 a

Sybase.dll Load Error

2001-08-14 Thread Falk
Hi, I used to use DBD:Oracle and it worked fine. I'm using ActivePerl 5.6.1. Now I switched to DBD:Sybase. I installed the Sybase module via ActiveState ppm. So far ok. When I tried to execute a perl script connecting to a sybase db I get the error that the dynaLoader.pm can't load the Sybase.dll.

DBD/DBI pre-compiled for Win32

2001-08-14 Thread Sanjay Perl
I am trying to locate pre-compiled packages for the Win32 platform (Windows 2000 + ActiveState Perl), for the latest versions of DBI (1.19) and DBD-Oracle. The ActiveState module archives only contain version 1.14 of the DBI module. Any ideas/leads? TIA Sanjay _

Re: Optimizing Postgres selects

2001-08-14 Thread Alex Pilosov
Your problem is your database structure. Instead of putting things into 500 tables, you should merge them into 1 table. This is not a perl question, its a database design question. -alex On Mon, 13 Aug 2001, Evan Zane Macosko wrote: > Hi everyone, > > > I am use Perl:DBI to interface to a Po

auto commit

2001-08-14 Thread mickalo
Hello All, When setting AutoCommit => 0, with transactions, does anything else need to be set to disable Autocommit? It seems that the Autocommit => 0 is being ignored in our script. If it's set to '0' is still seems to process the queries with or without invoking the $dbh->{'commit'} and no erro

Re: Method "func" cannot be called?

2001-08-14 Thread wsheldah
Why are you explicitly calling DBI->install_driver? According to the DBI docs, it gets called implicitly by DBI->connect. You might try to do a $dbh->ping both after the DBI->connect and after the DBI->install_driver lines, to verify that the connection is working. It's clear that $dbh isn't

Re: Method "func" cannot be called?

2001-08-14 Thread Ronald J Kimball
On Tue, Aug 14, 2001 at 06:38:06AM -0700, Vuillemot, Ward W wrote: > I am receiving the following error: > Can't call method "func" on an undefined value at >C:\Inetpub\scripts\convertOptran.pl line 382, line 532. > > And the offending line of code is marked by ' <-- BAD CODE!

Method "func" cannot be called?

2001-08-14 Thread Vuillemot, Ward W
I am receiving the following error: Can't call method "func" on an undefined value at C:\Inetpub\scripts\convertOptran.pl line 382, line 532. And the offending line of code is marked by ' <-- BAD CODE! BAD!'. I checked the passed arguments, which all check out. I do not

Re: Optimizing Postgres selects

2001-08-14 Thread wsheldah
Forgot to mention maintaining an index on the orf column in each table to speed up the order by, and running VACUUM ANALYZE on a table any time it changes substantially, or at appropriate intervals. Is it possible to make orf an integer if it isn't already? Remember that the index will slow do

Re: Removing duplicate records - OT

2001-08-14 Thread Ronald J Kimball
On Tue, Aug 14, 2001 at 11:12:23AM +1000, Neil Lunn wrote: > Use something like this as the record source for items with duplicate email > addresses: > > select * > from table > where email in ( > select email > from table > group by email > having count(*) > 1) > > and delete every sec

Re: can't log into proxy

2001-08-14 Thread Hardy Merrill
Are you sure 1. The proxy daemon is up and running? 2. you can connect from the "new" script machine to the database server machine? Try telneting from the "new" script machine to the dbi proxy port on the database server - if dbiproxy is running, your telnet on the script mach

RE: Removing duplicate records - OT

2001-08-14 Thread Neil Lunn
>-Original Message- >From: Bart Lateur [mailto:[EMAIL PROTECTED]] >Sent: Tuesday, August 14, 2001 8:30 PM >To: [EMAIL PROTECTED] >Subject: Re: Removing duplicate records - OT > > >On Tue, 14 Aug 2001 11:12:23 +1000, Neil Lunn wrote: > >>Use something like this as the record source for item

RE: SQL Statement - Selecting details if they exist if not...

2001-08-14 Thread Neil Lunn
>-Original Message- >From: Jon Barker [mailto:[EMAIL PROTECTED]] >Sent: Tuesday, August 14, 2001 8:28 PM >To: [EMAIL PROTECTED]; [EMAIL PROTECTED] >Subject: Re: SQL Statement - Selecting details if they exist if not... > > > >I'm not completely sure I understand you but:- > >select * fro

DBI 1-19 Installation

2001-08-14 Thread Piyush Avichal
Hello, I have just attempted to build and install DBI-1-19 for Perl. I am running Perl 5.6.1 on VAX/VMS 7.1 using MMK 3.9.2 and using DEC C 5.5. Whilst doing the MMK and the MMK Install I got the following messages in both: Can't open output file [.blib.man1]dbiproxy.pl.rno as stdout %RMS-F-SYN

Re: DBD::Sybase and DBD::Oracle inconsistency

2001-08-14 Thread Tim Bunce
On Mon, Aug 13, 2001 at 10:49:33AM -0700, Tim Harsch wrote: > True. > > And it makes no matter to me cause I understand that, and probably no matter > to most because they get it too, but what about the people that don't > understand that or first timers that are learning DBI and they learn that

Re: SQL Statement - Selecting details if they exist if not...

2001-08-14 Thread Jon Barker
I'm not completely sure I understand you but:- select * from Jobs left outer join Users on Jobs.JobID=Users.JobID; Should give all the jobs, with null user data where there isn't a user associated with a job. Jon > Hiya all, > > I have (for illustration purposes) two tables in an ODBC datab

Re: Removing duplicate records - OT

2001-08-14 Thread Bart Lateur
On Tue, 14 Aug 2001 11:12:23 +1000, Neil Lunn wrote: >Use something like this as the record source for items with duplicate email >addresses: > >select * >from table >where email in ( > select email > from table > group by email > having count(*) > 1) > >and delete every second record. Next

SQL Statement - Selecting details if they exist if not...

2001-08-14 Thread Richard Chiswell
Hiya all, I have (for illustration purposes) two tables in an ODBC database: Table 'Jobs'=JobID,JobDescription,JobDate Table 'Users'=UserName,JobID,LastViewedDate Basically I want to select all JobID's and JobDescriptions from Jobs where the user has a 'lastvieweddate' within the last 10 days.

can't log into proxy

2001-08-14 Thread Jan-Hendrik Petersen
hi there I am using the dbi proxy. there are two scripts that work on the same mashine with the proxy. now I copy the scripts to another server and try to connect. all I got was the following message Cannot log in to DBI::ProxyServer: Cannot connect: Bad file descriptor at /usr/lib/perl5/site

Interbase lob field on the web

2001-08-14 Thread alex.tesi
Hi i have a problem printing a lob field containing an image. The database i use is Interbase 6.0 I have a blob/lob field with a gif image inside an i like to print this image on the web. Can you help me? Bye Alessandro

RE: rollback

2001-08-14 Thread Neil Lunn
>-Original Message- >From: Konstantin [mailto:[EMAIL PROTECTED]] >Sent: Tuesday, August 14, 2001 5:38 PM >To: [EMAIL PROTECTED] >Subject: rollback > > >Hi. > >I'm trying to use the rollback function but I get the error: You've been moved to dbi-users where this sort of enquiry belongs.

Sybase.dll Load Error

2001-08-14 Thread Falk
Hi, I used to use DBD:Oracle and it worked fine. I'm using ActivePerl 5.6.1. Now I switched to DBD:Sybase. I installed the Sybase module via ActiveState ppm. So far ok. When I tried to execute a perl script connecting to a sybase db I get the error that the dynaLoader.pm can't load the Sybase.dll.