:CSV: 0.22
Judging by this I am already running the latest DBD::MySQL,
though I am about 5 versions behind on the DBI module. I hope all of
this helps.
-Original Message-
From: NIPP, SCOTT V (SBCSI)
Sent: Saturday, November 04, 2006 12:02 PM
To: 'Darren Duncan'; dbi-users
AIL PROTECTED]
Sent: Saturday, November 04, 2006 3:54 AM
To: dbi-users@perl.org
Subject: Re: MySQL upgrade caused Perl coredumps...
At 10:35 PM -0600 11/3/06, NIPP, SCOTT V \(SBCSI\) wrote:
> I recently upgraded MySQL to version 5.0.4. After the upgrade,
>several of my Perl scripts
I recently upgraded MySQL to version 5.0.4. After the upgrade,
several of my Perl scripts that access the MySQL database began to fail
with "Memory fault coredump" messages. Anyone have any suggestions?
I'm hoping a simple DBI::MySQL upgrade will fix this issue. Here is the
Perl informat
I would definitely look to Oracle rather than Perl as your
culprit. I don't have anything to back this up, just a suspicion.
-Original Message-
From: Oscar Gomez [mailto:[EMAIL PROTECTED]
Sent: Friday, September 08, 2006 10:04 AM
To: dbi-users@perl.org
Subject: switching perl ver
Still banging my head into a wall... Now I am getting NULLs
inserted as expected into the database, but I am getting errors on the
compare.
my @old = $test->fetchrow_array ();
foreach $n (0..20) {
chomp($file_val = $data[$n]);
$file_val =~ s/\s*$//;
#chomp($db_va
BRIAN D (BRIAN) [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 16, 2005 10:54 AM
To: NIPP, SCOTT V (SBCSI); Ronald J Kimball; dbi-users@perl.org
Subject: RE: NULL field matching problem...
I'm guessing that when a field is empty in your CSV file, then the
method $csv->fields puts an
PROTECTED]
Web: http:\\ldsa.sbcld.sbc.com
-Original Message-
From: Ronald J Kimball [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 16, 2005 10:14 AM
To: NIPP, SCOTT V (SBCSI); dbi-users@perl.org
Subject: RE: NULL field matching problem...
NIPP, SCOTT V (SBCSI) [mailto:[EMAIL P
I am working on a script that parses a csv file. The actual
field delimiters in the file are pipes |. The problem I am running into
is that if the field is empty, then the database is getting a '0' rather
than 'NULL' as it should. The column is setup properly with NULLs
allowed and the d
.com
-----Original Message-----
From: Reidy, Ron [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 15, 2005 1:34 PM
To: NIPP, SCOTT V (SBCSI); dbi-users@perl.org
Subject: RE: Insert help...
Doesn't MySQL have the concept of a unique or primary key constraint?
If it does, why not ...
1. IN
I am working on a Perl MySQL problem. Basically, the script
parses a text file and then checks a database table to see if it needs
to be updated. If the entry is NOT in the table, it inserts the entry.
If the entry does exist, it compares the data. Assuming these data is
identical nothin
]
Web: http:\\ldsa.sbcld.sbc.com
-Original Message-
From: Wieland Pusch [mailto:[EMAIL PROTECTED]
Sent: Wednesday, September 08, 2004 3:17 AM
To: CAMPBELL, BRIAN D (BRIAN)
Cc: NIPP, SCOTT V (SBCSI); dbi-users@perl.org
Subject: Re: Large SQL statements...
Hallo BRIAN,
I like your
this
change log testing.
Thanks again for any feedback.
Scott Nipp
Phone: (214) 858-1289
E-mail: [EMAIL PROTECTED]
Web: http:\\ldsa.sbcld.sbc.com
-Original Message-
From: S P [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 16, 2004 2:27 PM
To: NIPP, SCOTT V (SBCSI); [EMAI
I am having a problem in that if a field is blank, it is getting
put into the database as a '0' rather than 'NULL'. The table is setup
to both allow NULL values in this field as well as NULL being the
default value. The problem is that on a few entries the field is
actually empty, but the
I have a database that I am working on a Perl script for to
manage. Basically, this is a database of user accounts on about 80 Unix
boxes. Most of it is working great, but I have one problem with the two
of the INSERTs. The INSERTs are putting data into a history table such
that we can m
out.
Scott Nipp
Phone: (214) 858-1289
E-mail: [EMAIL PROTECTED]
Web: http:\\ldsa.sbcld.sbc.com
-Original Message-
From: Steve Baldwin [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 14, 2004 4:02 PM
To: 'Reidy, Ron'; NIPP, SCOTT V (SBCSI); [EMAIL PROTECTED]
Subjec
I have a table that has a list of users with numeric user IDs.
The user IDs are not sequential. There are large gaps in the list of
numeric IDs. I want to pick the next unused number beginning at 3000.
How do I do this?
Thanks in advance.
Scott Nipp
Phone: (214) 858-1289
E-mai
Sent: Thursday, September 09, 2004 12:51 PM
To: [EMAIL PROTECTED]
Subject: Re: Database update module???
What database are you using. A database that supports triggers
will handle this quite nicely.
>>>NIPP, SCOTT V (SBCSI) <[EMAIL PROTECTED]> 09/08 11:47 am >>
I have created a database that has a table for the active data,
and a table that basically captures the changes to that table. The
second table has all of the same fields as the first with one extra and
that being to capture a date of the change. I know that I can write a
piece of code to
08, 2004 3:17 AM
To: CAMPBELL, BRIAN D (BRIAN)
Cc: NIPP, SCOTT V (SBCSI); [EMAIL PROTECTED]
Subject: Re: Large SQL statements...
Hallo BRIAN,
I like your solution with foreach and bind_param. Just add the prepare
like this:
$sth = $dbh->prepare("INSERT INTO AllMid_Data VALUES(?&quo
I have a table with 22 columns, and my INSERT on this table is
actually putting in data to possibly all 22 fields. My question is, is
there a better way to write this INSERT? Here's what I have:
while ($line = ) {
$csv->parse($line);
@data = $csv->fields;
$sth = $dbh->prepare(qq{IN
PROTECTED]
Sent: Tuesday, September 07, 2004 2:05 PM
To: NIPP, SCOTT V (SBCSI)
Cc: [EMAIL PROTECTED]
Subject: Re: Parsing question...
What i understood from your question is , you want to split strings that
have comma within
quotes. Forgive me if i'm wrong.
If elements of @data are re-split , yo
Phone: (214) 858-1289
E-mail: [EMAIL PROTECTED]
Web: http:\\ldsa.sbcld.sbc.com
-Original Message-
From: Jeff Zucker [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 07, 2004 1:18 PM
To: NIPP, SCOTT V (SBCSI)
Cc: [EMAIL PROTECTED]
Subject: Re: Parsing question...
Is there some reaso
This isn't specifically a DBI question, but it is a part of a
database script I am writing. I am parsing a CSV file and populating a
MySQL database table. The problem I have run into is that a couple of
lines of data have a comma in a filed that is in quotes, such as "First
part, second p
iginal Message-
From: Vinnie Lima [mailto:[EMAIL PROTECTED]
Sent: Friday, August 20, 2004 12:18 PM
To: NIPP, SCOTT V (SBCSI)
Cc: [EMAIL PROTECTED]
Subject: Re: DBD driver compile on HP...
Hmm.dont think this is going to help you at all, but i'm getting all
kinds of error on my
I know that this question has come up before. I think I have
even asked it long, long ago. Unfortunately, this is not something I do
even infrequently, more like once in a blue moon. The problem is once
again getting DBD::MySQL to compile and play nice on HP-UX. Here are
the errors I am
, SCOTT V (SBCSI); [EMAIL PROTECTED]
Subject: RE: Basic symlink question...
NIPP, SCOTT V (SBCSI) <[EMAIL PROTECTED]> wrote:
>
> I know this is not the correct forum for this question, but I
figure
> someone will know easily enough... I am attempting to use the Perl
> sy
I know this is not the correct forum for this question, but I figure
someone will know easily enough... I am attempting to use the Perl symlink
command to create/update a link on the Unix server. Below is the syntax I
am using, and not having any luck with. Any help would be most appreci
the feedback again.
Scott Nipp
Phone: (214) 858-1289
E-mail: [EMAIL PROTECTED]
Web: http:\\ldsa.sbcld.sbc.com
-Original Message-
From: David N Murray [mailto:[EMAIL PROTECTED]
Sent: Thursday, January 22, 2004 2:07 PM
To: NIPP, SCOTT V (SBCSI)
Cc: Hardy Merrill; [EMAIL PROTECTED]
Su
, January 22, 2004 2:11 PM
To: [EMAIL PROTECTED]; NIPP, SCOTT V (SBCSI)
Subject: RE: Strange matching problem...
You really need to read 'perldoc DBI' (at a command prompt) and pay
attention to how placeholders are used. See below. As Dave Murray
suggested, the Programming the Perl DBI
uot;Error updating database: ", $dbh->errstr, "\n";
Thanks again for the help.
Scott Nipp
Phone: (214) 858-1289
E-mail: [EMAIL PROTECTED]
Web: http:\\ldsa.sbcld.sbc.com
-Original Message-
From: Hardy Merrill [mailto:[EMAIL PROTECTED]
Sent: Thursday, Januar
nt: Thursday, January 22, 2004 12:22 PM
To: [EMAIL PROTECTED]; NIPP, SCOTT V (SBCSI)
Subject: Re: Strange matching problem...
My comments below as HM>>. I'll repeat one general suggestion made
previously - use placeholders :)
>>> "NIPP, SCOTT V (SBCSI)" <[EMAIL
I am working on a script to gather data about Unix user accounts.
This is going well so far and has gotten us some initial data such as almost
27000 user accounts across about 80 servers. I have built into the script
and database some checking to track changes basically capture these chang
:38 AM
-
"NIPP, SCOTT V
(SBCSI)"
&
on errors.
In the mean time, I'll start reading up on using placeholders too.
Thanks again.
Scott Nipp
Phone: (214) 858-1289
E-mail: [EMAIL PROTECTED]
Web: http:\\ldsa.sbcld.sbc.com
-----Original Message-
From: Hardy Merrill [mailto:[EMAIL PROTECTED]
Sent: Tuesday, January 20
I am working on a set of Perl scripts, along with some PHP web
pages, to help organize and automate user account creation in a large HP-UX
environment. I am currently writing a few scripts to gather all of the
existing user account data from every system and populate a couple of
database t
I was hoping for a little help in troubleshooting a problem I am
having with the DBD-Oracle module (1.14). I have set the ORACLE_HOME
variable and the Makefile creation completes. Once I try to run the make to
actually build the module it dies on me with the following output:
ld:
I am working on an application that has a database table with two
repeating fields. The table has several fields that are uniq, and the there
are two fields that occur 6 times i.e. a1, b1, a2, b2, ., a6, b6. This
table is populated and updated from a Perl script that parses a file. A
ld.sbc.com
-Original Message-
From: Ronald J Kimball [mailto:[EMAIL PROTECTED]
Sent: Tuesday, October 14, 2003 8:25 AM
To: NIPP, SCOTT V (SBCSI)
Cc: [EMAIL PROTECTED]
Subject: Re: Fetch without Execute...
On Tue, Oct 14, 2003 at 08:06:30AM -0500, NIPP, SCOTT V (SBCSI) wrote:
> I have
I have run into this problem before, but unfortunately, I can't seem
to figure out what I am doing wrong again this time... I am working on a
script to parse a data file and INSERT/UPDATE this data into a MySQL
database table. I am able to verify that the data I am dealing with is what
I
I am working on a script to parse a series of text files and insert
or update this data as appropriate into a couple of database tables. I am
stuck at a point with a couple of errors that are just confusing the hell
out of me. I keep going around in circles and I must be missing something
d ='$id'");
$query->execute();
$query->finish();
while (my $ref2 = $query->fetchrow_hashref ('NAME_lc')) {
undef $set2;
This now includes the other execute. Thanks again.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL P
I keep coming up with this error, but I AM performing an execute
prior to the fetch. I have seen some other threads on this, and have
upgraded the DBD:Mysql to the latest version on CPAN. Any ideas? Here is a
small portion of the code:
if ($rows2 == 1) {
my $vals = $test2->fetchrow_
I am working on a script to collect system information, and I have
run into a problem I cannot quite figure out. Here is the pertinent section
of code:
my $test = $dbh->prepare("SELECT id FROM fsref WHERE server ='$server' AND
fs_
name = '$fs_name'");
$test->execute ();
$rows = $te
ort. Thanks.
-Original Message-
From: William Goedicke [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 29, 2003 3:10 PM
To: NIPP, SCOTT V (SBCSI)
Cc: [EMAIL PROTECTED]
Subject: Re: Perl/MySQL script...
Dear Scott et al -
>>>>> "SCOTT" == SCOTT V NIPP writes:
Hey all... I am developing a series of scripts to collect system
information on a fairly large number of HP-UX servers. Initially, this
system information is fairly limited to filesystem information but will be
expanded over time to include other things like kernel parameter settings,
use
I am not sure if this is a Perl/DBI question specifically or not,
but here goes... I seem to remember reading somewhere that you could return
the value of an "auto-increment" field during an INSERT operation on a MySQL
database. Is this just wishful thinking on my part or does this sound
Is it possible to install the Perl DBD for MySQL on a system that
does not have MySQL installed? Basically, I am wanting for numerous servers
to be able to connect and interact with a MySQL database on another server.
Only 2 servers have MySQL installed, none of the others do. how do I ge
s
down the line.
Well, that's about all I can think of at the moment. I am sure that
I will have plenty more questions as this progresses. Thanks again for the
feedback.
-Original Message-
From: andy law (RI) [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 18, 2003 3:33 AM
To:
03 15:35:20 -0500, NIPP, SCOTT V (SBCSI) wrote:
Hi Scott
>Thanks again for all the good feedback. If anyone can recommend
a
>good book that could help me out on this I would be most
>appreciative. I
>have some MySQL reference books, but nothing that really goes into
>dat
mean time.
-Original Message-
From: David N Murray [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 10, 2003 3:21 PM
To: NIPP, SCOTT V (SBCSI)
Cc: '[EMAIL PROTECTED]'
Subject: Re: Database layout and query questions...
Some questions, that might help you answer yours:
What's t
I am currently working on developing a User Account Management
system. The environment I support currently has about 80 servers, and a
user community of several hundred. I currently have a Account Request
system that I developed running on one of my webservers and this is about to
roll in
This may or may not be obvious... Did you add the -lcl and
-lpthreads as the first in the list of libraries? I have learned from
experience they absolutely have to be the first two in the list in that
order. Also, maybe obvious, you were compiling Perl with the -lcl and
-lpthreads, right
I am not sure what is wrong with this... I pretty much copied this code
from one of the examples, but I am definitely having a problem. Thanks
again.
-Original Message-
From: Sterin, Ilya [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 02, 2002 11:12 PM
To: NIPP, SCOTT V (SB
OK... I am stuck once again. I am to pull the data from the
database and export it directly to an Excel file. Now, I am trying to
figure out the formatting... The first problem I am running into is
reformatting dates from the output of MySQL to the desired Excel format.
Here is a same
PROTECTED]]
Sent: Tuesday, October 01, 2002 11:14 AM
To: NIPP, SCOTT V (SBCSI)
Cc: '[EMAIL PROTECTED]'
Subject: Re: Database to Excel script...
Here we go:
>
> I have a MySQL database that I have a few Perl scripts working on.
> I am now looking into doing some reportin
if possible. This is also a great learning opportunity and I think that I
will have more requests in the future for generating Excel reports of this
nature.
-Original Message-
From: Sterin, Ilya [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 01, 2002 10:11 AM
To: NIPP, SCOTT V (SBCSI
I have a MySQL database that I have a few Perl scripts working on.
I am now looking into doing some reporting on these database tables. I
would really like to find a script that queries the database and the uses
the Spreadsheet::WriteExcel module to output the data directly to an Excel
fi
I am pretty sure this is supposed to reside in /etc. I know that on
our HP-UX boxes the tnsnames.ora is in /etc and we use Perl for some
database access.
-Original Message-
From: Sridhar Saragu [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 18, 2002 8:24 AM
To: [EMAIL PROT
I have a question about connecting to one of two different FTP
servers. This is a libnet question that I know if off topic, but PLEASE
help me. I have a MySQL database running and I use Perl/DBI to populate the
database. I am using libnet to FTP the data to the server, and then post
dat
Sorry for posting a slightly off topic question, but I am having
trouble figuring out how to do something basic. I have a MySQL database
that has a UNIQUE column in a table. My problem is that I need to change
the column to non-UNIQUE. I cannot figure out how to do this through the
mysq
I was able to install DBI, and DBD for MySQL under 11.0, and I will
be doing this under 11i. I am quite suprised that you are having trouble.
Please let us know of your results.
-Original Message-
From: Waldemar Zurowski [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 18, 2002 5
--Original Message-
From: NIPP, SCOTT V (SBCSI)
[mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 02, 2002 11:47 AM
To: 'Michael Ragsdale'; '[EMAIL PROTECTED]'
Cc: '[EMAIL PROTECTED]'
Subject: RE: UPDATE Statement Problem...
OK. Sorry for my being stupid. Everyon
my own. Unfortunately, I am quite
limited on time, as I am sure everyone is. Thank you all very much for the
help. Please bear with me, and I will do my best to refrain from being
thick headed. :)
-Original Message-
From: Michael Ragsdale [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April
the
database?!?! Below is the "working" UPDATE line:
$dbh->do(qq{UPDATE systems SET $set WHERE 'Name = $name'});
Not sure what is wrong now though. :(
-Original Message-----
From: NIPP, SCOTT V (SBCSI)
[mailto:[EMAIL PROTECTED]]
Sent: Tuesday, Apr
if $set;
$set .= $key . "=\'$$key\'";
}
}
Thanks again.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 02, 2002 10:40 AM
To: NIPP, SCOTT V (SBCSI)
Subject: RE: UPDATE Statement Problem...
THe problem with the update
Following another suggestion, I tried using the 'qq' quoting method
and received the following error.
DBD::mysql::db do failed: Unknown column 'harry' in 'where clause' at
sys_db_update1.pl line 41, line 81.
-----Original Message-----
From: NIPP,
an home in on the problem rather
quickly. Then I will just have to port this portion of code from my laptop
to my Unix platform.
Thanks again for all of the helpful suggestions. Almost everything
you guys have responded with so far has helped to push me along in the
correct direction.
--
). Once I get that
part figured out and going, I think I can home in on the problem rather
quickly. Then I will just have to port this portion of code from my laptop
to my Unix platform.
Thanks again for all of the helpful suggestions. Almost everything
you guys have responded with so far
;); #Just added!!!
} else {
-Original Message-
From: Tielman J de Villiers [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 02, 2002 9:39 AM
To: NIPP, SCOTT V (SBCSI)
Cc: '[EMAIL PROTECTED]'
Subject: RE: UPDATE Statement Problem...
Check how you connect -- if Autocommit is not o
Hey guys. I am still quite new to the database world and obviously
in need of help. Not sure if I am just stupid, or if there is really very
little information to be found concerning UPDATE statements. I am working
on a MySQL database with Perl 5.6.0 and the latest DBI version. I am do
70 matches
Mail list logo
