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 Me

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.

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

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 tabl

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 you.

duplicating tables

2001-07-31 Thread 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. -- Tom McDonough Be a better dad! Visit http://www.dadsden.net/

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: Ho

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: 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, bu

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 Make

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 compil