Webmaster Forum / Perl / DBI Library / April 2008

I'm getting the following when trying to test out my Sybperl install:
   Can't locate loadable object for module Sybase::CTlib in @INC
I'm using Sybperl 2.18 on Solaris 10, with ASE 15.0.2.  I was able to
build it ok, (finally) but it appears it doesn't know where CTlib is

I having trouble using placeholders (named and numerical), using DBD::ODBC
connecting to Teradata. I cant easily use ordinary '?', as I refer to the
same placeholder several times in the SQL. For example, this is the
statement I prepare (a contrived example):

I've been forced to upgrade a server to Activestate Perl 5.10 on Win2K
because of new module that does not appear to be available under
earlier versions.
A big complication is that the machine is behind a firewall, and PPM

With Oracle having finally come out with native Intel drivers for  
MacOS, I tried to install these to get rid of having to use a Rosetta-
ized version of perl to run Oracle things through, but kept running  
into a problem where sometimes bind variables would work, and  

I installed Sybperl 2.18 on Sun Solaris 10 box. The installation was not
clean - when I ran "make test" command, some of the tests failed. But
"make install" did not produce any errors.
Sybase client 2.15.1, which I installed on the same Sun box, works fine

The DBI needs to sort the keys in %$attr for connect_cached and
prepare_cached to ensure a canonical cache key is generated.
Currently this is done in perl and is relatively expensive:
   my @attr_keys = ($attr) ? sort keys %$attr : ();

I've got one table (A) with a has_a relationship to another table (B).  I'd
like to add another column to table A that is the foreign key for a record
in table B.
I tried to simply add the column and then put another has_a relationship in

I've posted the following questions to dbi-dev.
The short version is that I was hoping to have a way to manage the
"inactiveDestory" property on DBI drivers which can not work across fork
(e.g., DBD::Sybase). I've got a suggestion from Tim Bunce, which will

I apologize if this is redundant as I know there have been previous
posts regarding this issue.  However, I have not been able to find any
resolution in any of those posts.
Here are my versions of the various components :

I try to fetch column information from a mysql database, but I got the
following error :
DBD::mysql::db column_info failed: Incorrect database name '' at
./indexes.pl line 17.

I got the OCI Libraries installed and got the make file to getgenerated without any issues. Now I am encountering the below errortrying to run the makefile
$ make
gcc -c -IC:/oracle/product/9.2.0/client_2/oci/include-IC:/oracle/product/9.2 ...

With DBI 1.602 and DBD::Sybase 1.08 I get:
Can't locate object method "DELETE" via package "DBI::st"
on the second selectrow_array call.
If I replace $sth with $sql in the selectrow_array calls, then it

Hello all experts !
I need to log every INSERT, UPDATE and DELETE queries even when using
placeholders. Here some code:
$sql = "UPDATE users SET `name`=? WHERE ìd`=1;";

I'm trying to figure out the best way to build an heirarchial categorystructure kinda like you'd find on yahoo or ebay.  Basically I amcreating a number of items and I am going to tie each item via a linktable to another link table that defines the categories and subcategories.

Hello list
I'm running a Catalyst site under fast CGI and I see lots of this  
sort of thing in the error logs:
Subroutine CDBI::Db::Table::sql_count_search_where redefined at /usr/