DBI test failed

2003-06-27 Thread Volpe, Joseph
Title: DBI test failed Test 12 of t/03handle failed during my pre-installation of the DBI. I haven't done make install yet. It looks like all other tests were successful. I've attached the documentation requested in the README. Sorry, but I'm not familiar enough with perl to have a clue

dbupdate

2003-06-27 Thread Berglund, Rex
I'm changing code that used DBUtils::Informix to use DBUtils::Oracle, but the update isn't working, any suggestions?

Windows compile stink

2003-06-27 Thread Dara M Kusic
Please, if you could help. How do I avoid the following error, that 'cl' is not a recognized command: transcript below C:\Perl\lib\DBI\DBI-1.37nmake Microsoft (R) Program Maintenance Utility Version 1.50 Copyright (c) Microsoft Corp 1988-94. All rights reserved. rem rem

RE: Windows compile stink

2003-06-27 Thread Tim Johnson
This is not really an error per se. What it is telling you is that you don't have a compiler installed. What are you trying to compile? Usually there is a pre-compiled Win32 module out there somewhere if it is compatible. -Original Message- From: Dara M Kusic To: [EMAIL PROTECTED]

Re: Rounding errors storing numbers in MySQL text fields using DBI

2003-06-27 Thread Robbie Armour
Hi everyone Sorry will not be able to pursue suggestions until Monday. Robbie _ Sign-up for a FREE BT Broadband connection today! http://www.msn.co.uk/specials/btbroadband

DBD-DB2 and HPUX 11.0 Memory Windows (db2win) connect problems

2003-06-27 Thread Craig Sharp
Our DB2 instance runs in Memory Windows on HP-UX 11.00. Is there a way to connect to the instance in mem windows with DBD-DB2? I am not able to connect with the DBI connect string: $dbh = DBI-connect(DBI:DB2:isdev); The database errors on the connect. Thanks, Craig

Running Stored Queries

2003-06-27 Thread Ronnie Cruickshank
Can anyone tell me if DBI can run Oracle stored procedures and if so how? I'm not familiar with Oracle but I have a requirement to write a script which will be ran in a UNIX cron. This script will run a querie that is part of a package which is stored on the Oracle DB. The normal method of

RE: Running Stored Queries

2003-06-27 Thread Gold, Samuel (Contractor)
look for stored procedures in the perl docs. Here is an example. $sth_tbs_mode = $dbh-prepare(BEGIN SCOTT.BACKUP.BEGIN_BK(?); END;); where Scott is the owner of the package. the package name is backup and the procedure is begin_bk. Thanks, Sam Gold -Original Message- From: Ronnie

RE: Running Stored Queries

2003-06-27 Thread Helck, Timothy
Also look up the bind_param_inout method if your stored procedure uses an out parameter. -Original Message- From: Gold, Samuel (Contractor) [mailto:[EMAIL PROTECTED] Sent: Friday, June 27, 2003 7:48 AM To: 'Ronnie Cruickshank'; [EMAIL PROTECTED] Subject: RE: Running Stored Queries

statment

2003-06-27 Thread anthony
Ok, I'm horribly tired with SQL I don't know why I'm getting a bad sql statment I tried these, but i really don't see the error $mbx=DBI-connect(dbi:mysql:$db3,$db3log,$db3pass) || ErrTemp::Connect($DBI::errstr); $get=$mbx-prepare(SELECT ip,title FROM $ttable2 WHERE open = ?); $get-execute(0);

RE: statment

2003-06-27 Thread Igor Korolev
Maybe open is a reserved word ? Try SELECT t.ip,t.title FROM $ttable2i t WHERE t.open = ? -Original Message- From: anthony [mailto:[EMAIL PROTECTED] Sent: Friday, June 27, 2003 9:23 AM To: [EMAIL PROTECTED] Subject: statment Ok, I'm horribly tired with SQL I don't know why I'm getting

Re: statment

2003-06-27 Thread Ronald J Kimball
On Fri, Jun 27, 2003 at 04:22:51PM +0200, anthony wrote: Ok, I'm horribly tired with SQL I don't know why I'm getting a bad sql statment I tried these, but i really don't see the error $mbx=DBI-connect(dbi:mysql:$db3,$db3log,$db3pass) || ErrTemp::Connect($DBI::errstr);

Re: statment

2003-06-27 Thread anthony
sorry, i realized that the variable $ttable2 was empty. Sorry again Anthohny

DBI-1.37 and DBD-Ingres

2003-06-27 Thread David Coulthart
We recently migrated our site from DBI-1.21 to 1.37 and have noticed that our DBD::Ingres installation broke. We were running DBD::Ingres-0.32, but I also attempted to upgrade to 0.36 and am having the same problem during make test. The problem relates to using do() to execute a statement. From

question about inserting a record

2003-06-27 Thread Grace Huang
Hi, I use the following statement to insert records (which are not in the real table) from temp table to real table, but it gives me error message. The statement I use is: $copySQL = INSERT INTO $tblReal (SearchID, Score) SELECT SearchID, Score FROM $tempTBL WHERE SearchID NOT IN (SELECT

Re: error compiling DBD::mysql

2003-06-27 Thread Rudy Lippan
On Thu, 26 Jun 2003 [EMAIL PROTECTED] wrote: It gives me Illegal character in prototype for main::ErrMsg : @_ at t/lib.pl line 254. The line it is complaining about is: sub ErrMsg (@_) { print (@_); } I tried backing up from 1.2218 to 1.2217 and 1.2216 but same problem.

Win32::ODBC problem when using Apache

2003-06-27 Thread Aman Raheja
Hi All I am running the following script. Using ODBC for the first time snip #!D:\Perl\bin\perl use Win32::ODBC; use DBI; use CGI qw(:standard); use CGI::Carp qw(fatalsToBrowser); my $dbh = new Win32::ODBC(dBASE Files) or die Win32::ODBC::Error(); /snip I get the following error in the

Win32::ODBC probem when using apache

2003-06-27 Thread Aman Raheja
Hi All I am running the following script. Using ODBC for the first time snip #!D:\Perl\bin\perl use Win32::ODBC; use DBI; use CGI qw(:standard); use CGI::Carp qw(fatalsToBrowser); my $dbh = new Win32::ODBC(dBASE Files) or die Win32::ODBC::Error(); /snip I get the following error in the

Re: Running Stored Queries

2003-06-27 Thread Michael A Chase
On Fri, 27 Jun 2003 10:45:42 +0100 Ronnie Cruickshank [EMAIL PROTECTED] wrote: Can anyone tell me if DBI can run Oracle stored procedures and if so how? I'm not familiar with Oracle but I have a requirement to write a script which will be ran in a UNIX cron. This script will run a querie

Re: Running Stored Queries

2003-06-27 Thread Andy Hassall
Michael A Chase wrote: On Fri, 27 Jun 2003 10:45:42 +0100 Ronnie Cruickshank [EMAIL PROTECTED] wrote: reference to exec there In SQL*Plus, EXECUTE can be used to execute single statements like procedure calls. I'm not sure where you found 'exec'. FYI, SQL*Plus accepts EXEC as an