DBI on Win2k

2001-07-31 Thread denis
Hi all, I have installed ActivePerl on windows 2000 and want to install and configure DBI module. After running perl MakeFile.pl, it requires to run make I think, make is for Linux platform and not for Windows. What should i need to run ?? If i require that utility to be downloaded from

RE: DBI on Win2k

2001-07-31 Thread Neil Lunn
Use ppm for ActiveState perl. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 31, 2001 3:34 PM To: [EMAIL PROTECTED] Subject: DBI on Win2k Hi all, I have installed ActivePerl on windows 2000 and want to install and configure DBI module.

RE: DBI on Win2k

2001-07-31 Thread Steve Howard
If you are trying to compile (make) you must have Visual C++ installed (The same compiler as was used to install Activestate. I assume you are using Activestate if you did not have to use nmake to compile the basic Perl). It is easier to use PPM like has been suggested to you, but if you do

Re: Environmental Variables and DBD-Pg-1.01

2001-07-31 Thread Aguztyn Garcia-Cruz
You Need to Setup those variables at prompt type: $export POSTGRES_LIB=/path/to/lib $export POSTGRES_INCLUDE=/path/to/include that's all eg: on my server the path is POSTGRES_LIB=/usr/lib/pgsql POSTGRES_INCLUDE=/usr/include/pgsgl check Your's Lauren Buell escribió: When I try to perl

Re: Environmental Variables and DBD-Pg-1.01

2001-07-31 Thread Richard Poole
On Mon, Jul 30, 2001 at 03:06:59PM -0700, Lauren Buell wrote: When I try to perl Makefile.PL, I am always instructed to set the environmental variables POSTGRES_LIB and POSTGRES_INCLUDE. I have read the instructions posted for others with similar problems and attempted these solutions, but I

How to input decimal places

2001-07-31 Thread Isaac
Hello, I am trying to insert into a field called thismonth some values. They are things like: 21.65 and 34.75 and 56.233 When I do the insert the values in my Access 2000 database are rounded to 22, 35 and 56. Here is my code: $upd = $dbh-prepare( qq{update Customers set ThisMonth = ? where

RE: How to input decimal places

2001-07-31 Thread Sterin, Ilya
Well SQL_INTEGER should give you a hint. Integers are rounded. Try not using the bind hint and just use $upd-bind_param( 1, $gigabytesTOTAL, SQL_INTEGER); to see what happens. Ilya -Original Message- From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: 07/31/2001 10:30 AM Subject:

RE: duplicating tables

2001-07-31 Thread Sterin, Ilya
By writting a script you mean writting DBI code, I guess. If you don't want to write script, than your question does not belong on the DBI users list. It would take some simple SQL to create a table based on another table, but again if you don't want to write script that's not the answer for

Re: duplicating tables

2001-07-31 Thread Jeff Zucker
From: Tom McDonough Is there a simple command which wil duplicate a table without writing a script? I'm want to do this first in DBD:CSV and then in DBD:mySQL. In DBD::CSV, a table is just a file, so you would use 'cp' (or whatever your system's file copy command is) to duplicate a table.

perl-5.6.1 on IRIX 6.5

2001-07-31 Thread John C. Hardt
i have tried and failed to get perl-5.6.1 compiled on IRIX 6.5, trying both gcc-2.95.3 and the IRIX C compiler. can anyone point me at documentation or tell me how you were able to get it to compile? i have gotten perl-5.6.1 to compile on both Solaris 2.6 and HPUX 10.20. thanks! -john

DBD::CSV and compressed files

2001-07-31 Thread Stacy Mader
Hi all, Is there a method for using DBD::CSV on compressed files? I could decomress first and then use SQL magick, but it there is a way, I'd be interested to hear... Regards, Stacy Mader.

RE: :CSV and compressed files

2001-07-31 Thread Sterin, Ilya
What compressed files. Compressed with what gzip, zip, etc...??? I don't think build in functionality for reading binary compression formats needs to be build in to any module. There are modules that allow you to uncompress first, then you can process through DBD::CSV. Ilya -Original