Errors is make test on solaris

2003-03-17 Thread Nasir Khan
Hi, I am having problems in installing DBI on solaris. I am attaching the logs as asked for n README. There are certain errors in t/* tests. Since I am new to Perl it would be great if some one helped me. Thanks in advance Nasir __ Do you Yahoo!?

Re: shortcuts for common placeholder idioms...

2003-03-17 Thread Moritz von Schweinitz
better late than never.. i'd just like to recommend some more hash-friendly routines for these kind of operations. i know that they are relativly tricial to code, but would make it all seem more natural for the beginners, methinks. something like $dbh-hash_do(INSERT INTO table (?) VALUES (?),

Re: making DBD::mysql on fetch on fetch()

2003-03-17 Thread Paul DuBois
At 21:17 -0600 3/16/03, Moritz von Schweinitz wrote: hi, all. i always thought that the (one of the) whole purpose of the prepare/execute/fetch trinity was to let the db-server do all the things a db-server's supposed to do, and then return a row at a time (some cache-optimizations inbetween,

DBI and ODBC and field types

2003-03-17 Thread Jeff Thies
I have an Access database. I've been defining field types as varchar(32). This works, although Access doesn't appear to have a varchar, it has a text. Does DBI do the translations or does Access understand varchar? Also (perhaps off topic, but of great concern to me): I'm getting these

RE: DBI and ODBC and field types

2003-03-17 Thread Jeff Urlwin
I have an Access database. I've been defining field types as varchar(32). This works, although Access doesn't appear to have a varchar, it has a text. Does DBI do the translations or does Access understand varchar? No. DBI doesn't, nor does DBD::ODBC. You need to use the type_info(),

DynaLoader error on Pg 7.3.1

2003-03-17 Thread Thomas Good
Hi. Perl 5.6.0 and Perl 5.8.0 DBD-Pg 1.21 on DBI 1.28 and 1.30 Pg 7.3.1 Linux 2.2.19 (slackware 8.0) Pg 7.2 ran fine on same perl tandems, both boxes. Now we are barfing with Pg 7.3.1 Odd as 7.3.1 with same perl tandem runs fine on slackware 8.1 with 2.4.x kernel When I call the

Perl DBI MySQL Apache

2003-03-17 Thread Nedjari
Hi, Mysql is on an Apache server. I created a database called 'yeast' by typing the command from my machine (connecting on another server): Synopsis: mysql - p -h 'server_name' -P 'port_number' -e 'create database yeast' (it works). The next step is to load the database with data. This is

Re: making DBD::mysql on fetch on fetch()

2003-03-17 Thread Moritz von Schweinitz
Paul DuBois wrote: At 21:17 -0600 3/16/03, Moritz von Schweinitz wrote: hi, all. i always thought that the (one of the) whole purpose of the prepare/execute/fetch trinity was to let the db-server do all the things a db-server's supposed to do, and then return a row at a time (some

Re: Perl DBI MySQL Apache

2003-03-17 Thread Paul Boutros
Try posting this also on the bioperl mailing list: [EMAIL PROTECTED] Paul On Mon, 17 Mar 2003, Nedjari wrote: Hi, Mysql is on an Apache server. I created a database called 'yeast' by typing the command from my machine (connecting on another server): Synopsis: mysql - p -h

Re: shortcuts for common placeholder idioms...

2003-03-17 Thread Michael A Chase
On Mon, 17 Mar 2003 05:07:36 -0600 Moritz von Schweinitz [EMAIL PROTECTED] wrote: i'd just like to recommend some more hash-friendly routines for these kind of operations. i know that they are relativly tricial to code, but would make it all seem more natural for the beginners, methinks.

Re: shortcuts for common placeholder idioms...

2003-03-17 Thread Tim Bunce
On Mon, Mar 17, 2003 at 12:04:22PM -0800, Michael A Chase wrote: On Mon, 17 Mar 2003 05:07:36 -0600 Moritz von Schweinitz [EMAIL PROTECTED] wrote: i'd just like to recommend some more hash-friendly routines for these kind of operations. i know that they are relativly tricial to code, but

Re: shortcuts for common placeholder idioms...

2003-03-17 Thread Michael A Chase
On Mon, 17 Mar 2003 20:49:49 + Tim Bunce [EMAIL PROTECTED] wrote: On Mon, Mar 17, 2003 at 12:04:22PM -0800, Michael A Chase wrote: Spliting into separate prepare and execute stages and using placeholders would allow prepare once and execute many times and allow the subroutines to be

Re: Perl DBI MySQL Apache

2003-03-17 Thread Wiggins d'Anconia
Nedjari wrote: I created a database called 'yeast' by typing the command from my machine (connecting on another server): Synopsis: mysql - p -h 'server_name' -P 'port_number' -e 'create database yeast' (it works). Here you connect to a remote host. But in the following code (what is your

Re: Strange security problem...

2003-03-17 Thread Jared Still
The real problem here is that you even have password embedded in your scripts to start with. Not a good idea. Jared On Friday 28 February 2003 17:21, Cory Rau wrote: I was messing around at home with a test web server (Windows 2000 Professional, Apache and ActivePerl (all the latest

Re: Strange security problem...

2003-03-17 Thread Jonathan Leffler
Jared Still wrote: The real problem here is that you even have password embedded in your scripts to start with. Not a good idea. True. On Friday 28 February 2003 17:21, Cory Rau wrote: I was messing around at home with a test web server (Windows 2000 Professional, Apache and ActivePerl (all