When I try to run a script I get an error that is listed below. This script
works on another server. I have DBI 1-14 loaded BUT the mysql.pm file that
the error is moaning about only appears to be in the following directories.
Any help would be appriciated.
/root/.cpan/build/Msql-Mysql-modules-
Dear enginer,
I am chinese.
Now I want to set up DBI module, but when I entered the cmd "perl Makefile.PL",
I get the following result:
*** Note:
The optional PlRPC-modules (RPC::PlServer etc) are not installed.
If you want to use the DBD::Proxy driver and DBI::ProxyServer
m
Hello All,
I know this is more of a Perl question then DBI, but I posted this a couple of
days ago the one the Perl list without any results. What I am trying to do is
limit a search result to 5 per page. Below is the bulk of the script minus all
the HTML stuff. If someone maybe to lend some assi
We've helped you a few times I can remember with non DBI related questions.
Please be kind to send your questions to the appropriate list.
Thanks.
Ilya Sterin
-Original Message-
From: Dong, Xiaoxia [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 19, 2001 4:45 PM
To: [EMAIL PROTECTED]
Sub
I'm having a problem with DBI-1.14 on my Linux setup. I run `perl
Makefile.PL`, then `make`, then `make test`, and the test fails. The verbose
`make test` outputs the following:
make test TEST_VERBOSE=1 output --
t/proxy.Starting server: /usr/local/bin/perl -
Alzabo is a program and a module, with two core functions. Its first use
is as a data modelling tool. Through either a schema creation interface or
a perl program, you can create a set of schema, table, column, etc.
objects to represent your data model. Alzabo is also capable of reverse
engineerin
Warren,
Yes, you are right! I removed 'col_names' and the script still
worked.
Regards,
Stacy.
> Hello All,
>
> I was able to get the script to work by explicitly adding a record
> separator ('^M' in vi) at the end of each line - didn't have to define
> the column names. I got here b
Ron Savage wrote:
>
> Stacy
>
> DBI 1.14
> Text::CSV_XS 0.22
> SQL::Statement 0.1017
> DBD::CSV 0.1025
>
> The latter 3 were installed a few minutes ago :-).
>
> weather.dat:
> -><8-
>
>Date&Time,MaxWSpd,AvgWSpd,WindDir,AirPres,RainBkt,RelHumd,OutTemp,InsTemp,MsrTemp,FocTemp,XtrTemp
>
I tested your script on solaris 2.7, Oracle 8.1.7, and perl 5.6.0.
Works fine here. Does simply connecting and disconnecting (using DBI)
work?
Tom
(environment listed below)
[tlowery@rain tlowery]$ perl -w core.pl
Trying to open the ref cursor...
These are the results from the ref cursor:
TEST
Hi all,
I appear to have solved my problem with dealing with CSV files: here is my solution
code:
#!/usr/local/bin/perl -w
use DBI;
($infile) = @ARGV;
my $dbh = DBI->connect("DBI:CSV:");
$dbh->{'csv_tables'}->{'weather'} =
{
'eol' => "\n",
'file' => "$infile",
'col_nam
Paul,
Very quickly, assuming you have made a connection to the database: to insert
data, a very very simple example:
To select data:
my $sql_statement = "SELECT lastname, firstname, title FROM Tablename ORDER
BY lastname desc, title";
my $sth = $dbh->prepare($sql_statement);
my ($last, $
Hello
I am new to this new group I have desing several static website and I am now going
to try an website with an install databse it will be a ms Access database. My question
to this group is "Where can I find some samples of source code for add records and
listing records" Again thank f
I actually use dbd::odbc quite often to access an Access database (Although
I am usually migrating something OFF of the Access database rather than
using Access). It's not really any trick. You need to set up a DSN in your
ODBC Data Sources. That is very easy if you are on an MS platform (Just In
Hi
Surely a simple solution is to write start and end times for each step to a
log file?
By the way - this is a DBI list not for general Perl questions - and I
notice you are cross posting: this is generally deprecated. :)
David Billingham
- Original Message -
From: "Ted Hilts" <[EMAI
Ted,
Have you tried the date-calc module available for PERL? You should be able
to do this with this module, and some good programming on your part.
Steve Howard
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Ted
Hilts
Sent: Monday, March 19, 2001 10:4
You are right, this is _not_ a DBI problem.
Run 'perldoc File::Find' and read the fine manual.
--
Mac :})
** I normally forward private database questions to the DBI mail lists. **
Give a hobbit a fish and he'll eat fish for a day.
Give a hobbit a ring and he'll eat fish for an age.
- Origin
This is NOT a DBI question, rather it is a perl question. Maybe somebody
can help me.
I use the find -type d -print >aa.txt
then open aa.txt
$dir =
when use this to check to see if it is directory, it always return
undef.
return undef unless -d $dir;
i print out $dir, which is corr
On Mon, Mar 19, 2001 at 09:41:33PM -0700, Ted Hilts wrote:
> This is my second perl problem.
Before we get to number three, please be aware that [EMAIL PROTECTED] is
for discussing DBI, Perl's DataBase Interface, not for general Perl
problems. Your questions would be more appropriate in the news
Use gettimeofday/tv_interval on systems where it's implemented:
my $t = [gettimeofday];
# do whatever ...
my $time_taken = tv_interval($t);
print "Seconds to do : $time_taken\n";
Steve Sapovits
Global Sports Interactive
Work Email: [EMAIL PROTECTED]
Home Email: [EMAIL PROTECTED]
Wo
This is my second perl problem.
I have this ftp routine and want to be able to measure the time
associated with each step in the routine. You can see a routine snippet
on the list where I submitted the first problem and it is called Perl
Problem.
Before each $ftp step I want to be able to set u
I have a ftp upload routine written in perl that I run from with a LAN
and out onto the internet via a gateway/firewall machine and the perl
routine occasionally hangs or develops a socket problem. Most of the
time it works fine but there are times it doesn't and I want to be able
to work around
Microsoft provides ODBC drivers for Access. That should mean you can use
DBD::ODBC with DBI to work with Access. Exactly how useful this is for you
depends on you platform.
Without knowing what you have already tried, and what problems you had, it
will be difficult for anyone on the list to mak
Unless you have access to a similar system with a C compiler, you won't be
able to build a kit to upload. If you do have a similar system, you will
first have to build perl with the same settings then build DBI and
DBD::mysql.
--
Mac :})
** I normally forward private database questions to the DB
- Forwarded message from Victor Sokov <[EMAIL PROTECTED]> -
Date: Fri, 16 Mar 2001 19:47:56 +0100
From: Victor Sokov <[EMAIL PROTECTED]>
To: "Tim.Bunce" <[EMAIL PROTECTED]>
Subject: Question MySQL
Hi Tim,
soory to disturb you, just a short question.
My hosting service (www.f2s.com) suppo
Has anyone seen core dumps when disconnecting after closing an Oracle ref
cursor?
We're trying to use the new feature introduced in DBD::Oracle 1.05, as
specified in the Changes file:
> Added ability to pass existing DBD::Oracle select statement handle
>(cursor) back _into_ Oracle as a ref
Hi Steven, this is a known problem. I've been making the fix available on
request until I get a chance to make it officially available. Here it is:
(See attached file: DBD-DB2-0.74b.tar.gz)
Regards,
Robert
"Steven N. Hirsch" <[EMAIL PROTECTED]> on 17/03/2001 12:43:47 PM
Please respond to "St
26 matches
Mail list logo
