Re: Error-handling Question

2003-12-15 Thread Rudy Lippan
On Mon, 15 Dec 2003, Hardy Merrill wrote: > Paul, you normally don't care about committing or rolling > back unless you're actually updating the database by doing > either an INSERT or an UPDATE. When you're just doing > SELECT and fetches you really don't care about transaction > processing. If

Re: Apache, Oracle, Perl DBI Problems

2003-12-15 Thread Kevin Moore
Well, I've gotten past this error. There was an excessive line in my httpd.conf . Fixed it and the next problem was in my cgi script. Thanks for all the replies. :-[ Michael Nhan wrote: Hi, Are you sure the the oracle client library is readable/accessible by the web user or by user n

Signal Handling

2003-12-15 Thread Khamneian, Mahtaj
Has anyone been able to successfully implement CTRL-C signal handling in Perl DBI? If so, I'd appreciate an example. - Mahtaj Khamneian University of Missouri - ASP Phone : (573) 884-2281 1805 East Walnut

Re: Error-handling Question

2003-12-15 Thread Michael A Chase
On Mon, 15 Dec 2003 12:57:32 -0500 [EMAIL PROTECTED] wrote: > If I'm handling errors with eval {} if ($@) {} constructs, is there any > hidden gotcha to grouping several statements in a single eval if I want > any errors handled identically? For instance, can I wrap an execute > and its fetches i

DBD::Proxy::st execute failed: CallMethod: Can't bind unknown placeholder

2003-12-15 Thread murali
Greetings!! We are using ActivePerl 5.6.1 (Build 635) & DBI (1.27) Proxy running on MS Windows to connect to SQL Server from Solaris. Even though the following SQL query succeeds in MS SQL Query Analyzer, Via DBI Proxy the following query returns an error: my $sth = $dbh->prepare( "s

DBD Oracle would not install on solaris

2003-12-15 Thread Naqvi Zahid - znaqvi
Sorry for the re-post but I didn't get any attention the first time around. I am trying to build DBD::Oracle on a Solaris 7 machine and keep running into make errors. I have read all the readme files and tried Google search for matching errors but no sucess so far. The logs as requested in the REA

PL/SQL table to Perl array

2003-12-15 Thread Sudhahar . Thiagarajan
I am trying to use Perl to call a packaged stored procedure that returns a PL/SQL array (PL/SQL table). Is there anything special I need to do with bind_param_inout to have it populate my perl array? Anyway I tried ora_type=>ORS_RSET but which only works for ref cursors not with PL/SQL tables. T

DBD::ODBC 1.06 problem to build 64 bit on HP_UX

2003-12-15 Thread Vassiliy Truskov
Hello, everybody. I'm trying to build 64 bit DBD::ODBC version 1.06 on HP_UX and have an error: LD_RUN_PATH="/disk1/driver_manager/64/odbcsdk/lib" /usr/bin/ld -b +vnocompatwarnings -L/usr/local/lib ODBC.o dbdimp.o -o blib/arch/auto/DBD/ODBC/ODBC.sl -L/disk1/driver_manager/64/odbcsdk

Re: Error-handling Question

2003-12-15 Thread Hardy Merrill
[EMAIL PROTECTED] [EMAIL PROTECTED] wrote: > Howdy, > > If I'm handling errors with > eval {} if ($@) {} > constructs, is there any hidden gotcha to grouping several statements in a > single eval if I want any errors handled identically? For instance, can I wrap > an execute and its fetches int

Re: Error-handling Question

2003-12-15 Thread Rudy Lippan
On Mon, 15 Dec 2003 [EMAIL PROTECTED] wrote: > Howdy, > > If I'm handling errors with eval {} if ($@) {} constructs, is there any > hidden gotcha to grouping several statements in a single eval if I want > any errors handled identically? For instance, can I wrap an execute and > its fetches into

Error-handling Question

2003-12-15 Thread paul . boutros
Howdy, If I'm handling errors with eval {} if ($@) {} constructs, is there any hidden gotcha to grouping several statements in a single eval if I want any errors handled identically? For instance, can I wrap an execute and its fetches into one eval, as below, or is this something I should be w

Re: Generating query from CGI forms

2003-12-15 Thread Hardy Merrill
Wojciech Pietron [EMAIL PROTECTED] wrote: > Hi, > > there is a CGI form that enables users obtain information from library. > We have a set of books (1st table), their authors (2nd table), readers' > opinions about the book (3rd table), errata of the book (4rd table). > > Typical queries: > - sh

Re: Selects to MS SQL Server 2000

2003-12-15 Thread Tim Bunce
Use trace. Tim. On Mon, Dec 15, 2003 at 03:34:46PM +0100, Marcus Willemsen wrote: > Hi everybody, > > > I managed to establish a connection with Microsofts SQL Server 2000 > using DBI without any problems. My only problem is SELECTing textfields > from the database. A query like: > ---Snippet--

Re: Selects to MS SQL Server 2000

2003-12-15 Thread Hardy Merrill
Marcus Willemsen [EMAIL PROTECTED] wrote: > Hello Hardy, > > Thanks for your reply, > > > Does it find the row if you select one of the other columns > > in that table besides the textfield? > > Yes, using the same query with other fields it finds most of the other > fields (varchars, ints, tiny

RE: Selects to MS SQL Server 2000

2003-12-15 Thread Marcus Willemsen
Hello Hardy, Thanks for your reply, > Does it find the row if you select one of the other columns > in that table besides the textfield? Yes, using the same query with other fields it finds most of the other fields (varchars, ints, tinyints). Althought some are not returned, eg. a timestamp fiel

Re: Selects to MS SQL Server 2000

2003-12-15 Thread Jeffrey . Seger
Somewhere in the back of my head there is an idea that the hash key is case sensitive. Try reversing the case (upper if you are using lower now). Jeff Seger Fairchild Semiconductor [EMAIL PROTECTED] "Marcus Willemsen" <[EMAIL PRO

Re: Selects to MS SQL Server 2000

2003-12-15 Thread Hardy Merrill
Marcus Willemsen [EMAIL PROTECTED] wrote: > Hi everybody, > > > I managed to establish a connection with Microsofts SQL Server 2000 > using DBI without any problems. My only problem is SELECTing textfields > from the database. A query like: > ---Snippet--- > my $sth = $dbh->prepare("SELECT [textf

Generating query from CGI forms

2003-12-15 Thread Wojciech Pietron
Hi, there is a CGI form that enables users obtain information from library. We have a set of books (1st table), their authors (2nd table), readers' opinions about the book (3rd table), errata of the book (4rd table). Typical queries: - show records with a title 'xxx', - show records whose author

Selects to MS SQL Server 2000

2003-12-15 Thread Marcus Willemsen
Hi everybody, I managed to establish a connection with Microsofts SQL Server 2000 using DBI without any problems. My only problem is SELECTing textfields from the database. A query like: ---Snippet--- my $sth = $dbh->prepare("SELECT [textfield] FROM [database].[dbo].[table] WHERE [id] = 3315"); $

Re: DynaLoader.pm

2003-12-15 Thread Michal Kurowski
[EMAIL PROTECTED] [EMAIL PROTECTED] wrote: > Hi, > What is the latest version of DynaLoader.pm available? > Is that module available in perl release v5.6.1 for Solaris OS 5.9 > > Please clarify. The wrong list, but ... perl -MDynaLoader -e 'print $DynaLoader::VERSION . "\n";' /usr/perl5/5.6.1/b

DynaLoader.pm

2003-12-15 Thread SDeenadayalan
Hi, What is the latest version of DynaLoader.pm available? Is that module available in perl release v5.6.1 for Solaris OS 5.9 Please clarify. Regards, Sridharan

ANNOUNCE: DBD::ADO 2.83

2003-12-15 Thread Steffen Goeldner
file: $CPAN/authors/id/S/SG/SGOELDNER/DBD-ADO-2.83.tar.gz size: 43932 bytes md5: 326867bda2962248b58ce9a372644efb Changes: Added notes about Unicode support thanks to Stefan Ram and Jan Dubois. Rearranged some tests. Installed ADO-specific method ado_open_schema(). Steffen