RE: DBI Install

2004-08-04 Thread Johnson, Shaunn
--howdy: --wouldn't it be better if you went to http://www.sunfreeware.com --and snagged a compiler (gcc works, i believe) - i'm sure you'll use it --for other stuff in the future anyways ... --*shrug* --just my $0.02 cents ... -X -Original Message- From: Witzke, Rob [mailto:[EMAIL

perl / unixODBC and Oracle 9i

2004-05-19 Thread Johnson, Shaunn
Howdy: I'm running Perl 5.8.x on RHEL ver. 3 and I am trying to connect to Oracle 9i (both the database and the Application Server's repository). With Perl 5.6.1, I used DBI and Oracle:DBD and things worked well, with Perl 5.8.x, the readme docs for the DBD module says that it is incompatible

Oracle:DBD and perl 5.8.0

2004-05-07 Thread Johnson, Shaunn
Howdy: I have been trying to install Oracle:DBD 1.14 or 1.15 with perl 5.8.0 and after adding different paths to compensate for the missing Config.pm, et al, it finally said, '... this isn't 5.6.0' and the process stopped. Is there a version of Oracle:DBD that will compile with 5.8.0 or do I

RE: Oracle:DBD and perl 5.8.0 - SV

2004-05-07 Thread Johnson, Shaunn
--belay that last transmission - i --*have* to roll back to perl 5.6.x. --sorry to jump the gun. -X --original post-- Is there a version of Oracle:DBD that will compile with 5.8.0 or do I have to rollback to 5.6.1?

installing perl 5.6.1

2004-05-07 Thread Johnson, Shaunn
Howdy: I'm trying to install 5.6.1 on RHEL version 3 from source. After looking at google for some problems related to the build-in and command errors, I get to the point where I need to make / make test. At the end, I get the following error: [snip] DB_File.xs: In function `ParseOpenInfo':

procedure entry point slcvs2ptr message

2004-01-28 Thread Johnson, Shaunn
Howdy: Not sure if this is a duplicate message - sorry in advance if it is. I want to use Perl to connect to an Oracle 9i database on Windows 200x and have installed DBI v. 1.37 on my NT workstation. I am getting a message like so when I run the script: [snip] The procedure entry point

change modified date?

2004-01-28 Thread Johnson, Shaunn
Howdy: Is there a perl module that can change the modified date of a file in Windows (or, Linux)? On my Linux box, I'm testing the 'touch -m' method, but it isn't working very well. I have no idea what there is for Windows. Perhaps there is a perl method instead? Thanks! -X

porting to windows NT

2004-01-23 Thread Johnson, Shaunn
Howdy: I want to move my perl script from Linux to Windows NT. The Linux script connects to Oracle via the DBI modules I have installed. I want to do the same on NT, but I'm not sure if the connection strings / values are the same. In the linux script: [snip] use strict; use diagnostics; use

get list of files in subdirectories?

2003-12-23 Thread Johnson, Shaunn
Howdy: I'd like to get a list of files in a directory and also in it's subdirectory - but I don't know how far the subdirectory goes. I can do a directory like so: [snip] #my $localdir=cwd; my $localdir=/ddrive/db2_text/; chdir $localdir; opendir (DIR, $localdir) or die can nae access D drive:

Perl and MS Access

2003-12-04 Thread Johnson, Shaunn
Howdy: I think I've seen it, but I don't know where - Isn't there a method to use Perl to connect to some MS Access database and extract the data into some other format (say, text). I've done it with Oracle and PostgreSQL ... I don't know if MS Access is too different (mostly because I live and

RE: trying again....

2003-11-13 Thread Johnson, Shaunn
--howdy: --not sure i follow, but i have a few questions for --you: * you want to connect to the database and do, what, exactly? show the data in html? * you have a list of people in the database, perhaps, that you want to email? what platform? not that it really matters ... windows,

explain regex statement?

2003-10-02 Thread Johnson, Shaunn
Howdy: I have a statement and I'm trying to see if I understand what it is really is doing (not my code). The code does this: [snip] result ~ '^ *-?[0-9]+[.]?[0-9]* *\$' [/snip] I break out the meaning as this: [snip example] ^ = beginning of line plus a white space *- = everything up to,

ora2pg - questions

2003-09-24 Thread Johnson, Shaunn
Howdy: Sorry for posting, but I couldn't get much info from the PostgreSQL group. I have a question about the Oracle to PostgreSQL perl script (ora2pg.pl). Running PostgreSQL 7.2 and Oracle 9.2.0.1 on RedHat Linux 7.2. I'm trying to use the Ora2pg.pl script that I found on the PostgreSQL

DBD:Pg place holder errors

2003-09-18 Thread Johnson, Shaunn
Howdy: I have a script where I connect from Oracle 9 to PostgreSQL 7.2.x and insert new records. It seems to work for about 200 or so records, but, fails (I was able to capture this message) [error] Uncaught exception from user code: Placeholder :0 invalid, placeholders must be = 1 at

breaking the loop

2003-09-16 Thread Johnson, Shaunn
Howdy: I'm trying to find the best solution for breaking out of a loop when editing a list of files. I have a script that: * gets a list of files * opens the files with a 'foreach $f(@list)' * does a 'while { ... } close (FILE)' The script works, but if I run it, it loops continually and

regex question

2003-09-12 Thread Johnson, Shaunn
Howdy: Is it possible to use regex to replace the first n characters of a line? There are no unique markers or items to map by in these files ... some lines could start with number or whatever (special characters, white space, alpha, etc). If so, how? Thanks! -X

how to return all rows selected in subroutine?

2003-08-29 Thread Johnson, Shaunn
Howdy: I am trying to return an array of all records in the subroutine below. I want to hold all of that info in one location so that I can use it (each row and each column of said row) later in a program. In the $sql part, I had the 'selectrow_array'; as was noted to me in another email, it

grep with ftp

2003-08-28 Thread Johnson, Shaunn
Howdy: I'm looking for information that will let me open an ftp connection and grep / search for files and then FTP them back to me. I saw something about FTP and macros, but the other articles about Net::FTP got me to believe you can do this with Perl. If so, is Net::FTP the route the go?

count tuples for Oracle?

2003-08-28 Thread Johnson, Shaunn
Howdy: With the PostgreSQL DBI, you can get a number of tuples (with ntuples) from some previously SQL query. For example, I have : [snip] use Pg; . . . sub getcols { my($table)[EMAIL PROTECTED]; return doquery('find rows', SELECT a1.attname, a1.attnotnull, a1.attnum, t.typname,

returning proper info from subroutines

2003-08-27 Thread Johnson, Shaunn
Howdy: I have a script where I want to * connect to database * create a subroutine where it executes and returns the value of the SQL * pass that value to another area to check and IF statement * continue with program I am having problems trying to figure out if the SQL is actually being

RE: returning proper info from subroutines

2003-08-27 Thread Johnson, Shaunn
--Thanks for the reply: --I think I'm well on my way, but, I'm looking --at the results and the 'Programming the PERL DBI' --book and it says that selectrow_array returns the --value of the first field. --selectall_arrayref and selectcol_arrayref --doesn't seem to help. --how can I return all

RE: returning proper info from subroutines

2003-08-27 Thread Johnson, Shaunn
--Howdy: --Sorry, I should have added more detail in --my reply. When I did the posted suggestion, --I only got one column, but if I ran the SQL --by hand, I got them all. --But in the example below, you list out the --variables and then get the entire row. --I thought I could just pull in the

problems replacing a pattern in file

2003-07-08 Thread Johnson, Shaunn
Howdy: I have a script where I'd like to open a bunch of files, search for a pattern and replace it with another. What I am getting is not quite what I expected. I get almost everything, but I'm getting a bit more at the end. [snip script] #!/usr/bin/perl -w use strict; use warnings; use

RE: problems replacing a pattern in file

2003-07-08 Thread Johnson, Shaunn
Thanks for the reply: Are you sure that the problem isn't in the 'for' loop? It seems odd that I have eight files in the directory and eight counts of the (100) at the end of the lines. I am going to try something with the for loop and see if that gets me anywhere. Thanks again for that shorter

RE: problems replacing a pattern in file

2003-07-08 Thread Johnson, Shaunn
Thanks for the reply. I will try that (modifying the for loop). I also tried to figure out if it was just the loop, or the replacement text that was giving me problems. For example, I changed my $new_ptrn to equal 'foo' and things worked okay. When I changed the $new_ptrn to equal 'character

how to remove last comma in file?

2003-07-02 Thread Johnson, Shaunn
Howdy: First off, many thanks to all (esp. R. Dixon and T. Lowery) for the help with the 'using table_info()' thread. I'm just about done with that script, but I have one tiny problem. In my SECOND while loop, I place a comma (,) at the end so that when the *.ddl files are built, it looks just

using table_info()

2003-07-01 Thread Johnson, Shaunn
Howdy: I would like to use the table_info() method for getting database / table metadata from a database. In this case, PostgreSQL 7.2.x. I am reading the Programming the Perl DBI book and I am using the following for my script to get a list of tables and get *some* information. [snip]

Q: get table info

2003-06-26 Thread Johnson, Shaunn
Howdy: I am trying to write a script to get table info from PostgreSQL. Basically, I want to generate a list of tables from a sub function and pass that and then use that returned variable and put it inside a NEW sql loop and create more output files based. My problem is (and I'm sure there are

dbi: Pg and Oracle 9i

2003-06-25 Thread Johnson, Shaunn
Howdy: At the risk of sounding silly, does anyone know of a way to export data from PostgreSQL to Oracle via perl featuring DBI? Background: I'm running PostgreSQL 7.2.1 on RedHat Linux 7.2 and I have Oracle 9i on the same box. PostgreSQL is dying and the tool to dump the data (pg_dump) no

DBD:Oracle driver problem

2003-06-25 Thread Johnson, Shaunn
Howdy: I am trying to re-install the Oracle driver for perl and run a script to connect and select from the database. I think I installed everything okay, but I am having the following problems: When I run the test.pl in the DBD-Oracle-1.14 directory, I get: [snip script] [EMAIL PROTECTED]

RE: example of placeholders

2003-06-17 Thread Johnson, Shaunn
--howdy. --i think i am getting closer to solving this, but --i have ran into a problem. --the below program works to the point where it --will return the data, but not ALL of the data. --for example, i get only about 50 or so lines when --if i do the queries by hand, i get over 200 with

RE: example of placeholders

2003-06-17 Thread Johnson, Shaunn
. --that's what i have so far. --suggestions? thanks! -X -Original Message- From: K Old To: Johnson, Shaunn Sent: 6/17/03 10:56 AM Subject: RE: example of placeholders Shaunn, Can you give a description of what you are trying to do step by step. I'm very familiar with Pg and do many complex

RE: system function

2003-06-16 Thread Johnson, Shaunn
--hrm. --would use Cwd; --work for you? i know that i had --silly problems like this and decided --it try that just to make sure i was --where i *thought* i was directory wise ... -X -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, June 16, 2003

examples of place holders

2003-06-16 Thread Johnson, Shaunn
Howdy: Can someone give me an example of using place holders with the DBI module? I am trying to use the results of one query and embed that into another query later. For example: the result of the first query (say, select distinct user_name from t_table) should go into the second (say select

RE: examples of place holders

2003-06-16 Thread Johnson, Shaunn
: Monday, June 16, 2003 4:31 PM To: Johnson, Shaunn Cc: beginners_perl (E-mail) Subject: Re: examples of place holders Johnson, Shaunn [EMAIL PROTECTED] writes: Howdy: Can someone give me an example of using place holders with the DBI module? I am trying to use the results of one query

faster way to remove characters?

2003-06-09 Thread Johnson, Shaunn
Howdy: I have this bit of code (below) and I'm wondering if there is a quicker way to remove some odd-ball characters from very large text files (large would be about the 200M or so). [snip code] #!/usr/bin/perl #$_ =~ s/\cM\n/\n/g; while () { $_ =~

RE: faster way to remove characters?

2003-06-09 Thread Johnson, Shaunn
it --goes. --thanks again! -X -Original Message- From: Jenda Krynicky [mailto:[EMAIL PROTECTED] Sent: Monday, June 09, 2003 2:06 PM To: [EMAIL PROTECTED] Subject: Re: faster way to remove characters? From: Johnson, Shaunn [EMAIL PROTECTED] I have this bit of code (below) and I'm

RE: problem opening file inside for-loop

2003-05-30 Thread Johnson, Shaunn
--Rob --Thanks for your script! Looks like it works like --a champ! --However, I don't have a clear understanding --as to *how* it works. Specifically, how is the --'build regex' being applied inside the SQL? --I mean, how is it getting IN there? --I'm looking at it and I don't fully grok

use DBI to connect to remote DBs

2003-05-30 Thread Johnson, Shaunn
Howdy: This is probably a silly question. Let's say that I want to pull data from a remote database (say, NT or Mainframe). For DB2, am I to understand that I need to install client software package, connect to that client and THEN run the perl DBI::DB2 mods to get data from the remote DB2

problem opening file inside for-loop

2003-05-29 Thread Johnson, Shaunn
Howdy: I have a script where I would like to connect to my database (PostgreSQL) and do a dump depending on what day it is. I'm having problems trying to figure out why I either can't open a file to write to it inside the loop, or, if I create a file outside of the for loop, nothing is written

RE: problem opening file inside for-loop

2003-05-29 Thread Johnson, Shaunn
not printing --anything and not returning an error. --any thoughts? -X -Original Message- From: WC -Sx- Jones [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 28, 2003 1:56 PM To: [EMAIL PROTECTED] Subject: Re: problem opening file inside for-loop On Wednesday, May 28, 2003, at 12:43 PM, Johnson

parse out HEX / ASCII characters

2003-04-02 Thread Johnson, Shaunn
Howdy: Is there a way to parse out characters that somehow wind up in an ASCII file. For examples, I have data that appears to have those wingding characters further down. I don't know all of what's in there, but I can not use the file unless I get rid of them. How do you identify them and

symbolic links on NT

2003-03-26 Thread Johnson, Shaunn
Does anyone know if it's possible to create symbolic links on an NT platform in Perl? Some history: I have an NTFS mounted on a Linux box and have created a few symbolic links to a few directories to work on a project. Works fine, lasts long time. Now, I have to point the link to another NT

perl to convert HTML to PDF

2003-02-19 Thread Johnson, Shaunn
Howdy: Running perl v5.6.0 on RedHat Linux 7.2. Is there a perl module that can help me convert a few thousand html files into PDF files? Currently, I have a program called 'htmldoc' and I can script it so that I convert the html files into PDF, however, the font size doesn't seem to carry

using if(0) statements

2003-01-17 Thread Johnson, Shaunn
Howdy: I am not familiar with using 'if' in a script and I have come across a list of new scripts that I now have to learn / maintain. In most of the scripts, there are things that begins with if (0). Say, for example: --[code] if (0) { $path=$dest/new_local; makepath ($path); first(1); }

editing control characters from file

2002-12-19 Thread Johnson, Shaunn
Howdy: I have a text file that I'm trying to use, but, it has control characters at the end. [snip] test.txt: ASCII text, with very long lines, with NEL line terminators [/snip] I've tried to use 'sed' and 'tr' to remove NEL and just have an ASCII text. I've even used dos2unix, but that

RE: editing control characters from file

2002-12-19 Thread Johnson, Shaunn
--thanks for the reply: --at this point, i'm still trying to figure out --how to find NEL. the ASCII chart says the following: [snip] DEC HEX OCT EDTTPU CHAR DESCRIPTION 10 00A 012 LF L/F CTRL-J LFline feed 13 00D 015 CR C/R CTRL-M CR

names with spaces

2002-12-17 Thread Johnson, Shaunn
Howdy: I thought that this worked, but, I have a script where I try to get a list of file names that have spaces and do something with those files (in this example, I'm making ISO images out of them). The problem is, the first step is to create a sub-directory in a path that have spaces in the

RE: names with spaces

2002-12-17 Thread Johnson, Shaunn
--i've tried that, but, this is the results from that: [snip] /i/Depression Management/Mailing/test/03 /i/Depression Management/Mailing/test/04 /i/Depression Management/Mailing/test/05 /i/Depression Management/Mailing/test/06 ls: /i/Depression: No such file or directory*** this is breaking

parse out parts of dir / files /

2002-12-10 Thread Johnson, Shaunn
Howdy: I'm having problems trying to parse out part of a directory into variables. I start with this: [snip script] /usr/local/bin/perl -w use diagnostics; my $dest=/i/'Depression Management'/Mailing/dec2002_iso_images; # Where is data coming from? my $source=/i/'Depression

check system integrity

2002-12-05 Thread Johnson, Shaunn
Howdy: Are there any perl-related scripts / apps to check a Linux system for attempted break-ins, password cracking, general hacking, ip spoofing, etc? Thanks! -X

Last Wednesday of Month

2002-11-22 Thread Johnson, Shaunn
Howdy: Can someone clue me in as to how I can get the last Wednesday (or whatever) of the month? I have an example of what *might* work, but I'm not sure how I can use it if, say, there are five Wednesdays in the Month. [snip from code] #!/usr/bin/perl -w use strict; use warnings; use

RE: Last Wednesday of Month

2002-11-22 Thread Johnson, Shaunn
--Looks great! --Thanks! -X -Original Message- From: Wagner, David --- Senior Programmer Analyst --- WGO [mailto:[EMAIL PROTECTED]] Sent: Friday, November 22, 2002 12:40 PM To: Johnson, Shaunn; [EMAIL PROTECTED] Subject: RE: Last Wednesday of Month I took at the doc

RE: set date variable and range - SOLVED

2002-11-12 Thread Johnson, Shaunn
--Howdy: -- // This is mostly for archives sake just in case I forget how // -- // I did this // --To recap, the purpose of this exercise was to create a few date variables to use --in an SQL script. I wanted the dates to have a 3 months span every time --I run the script (which would be once a

RE: set date variable and range

2002-11-08 Thread Johnson, Shaunn
year. is there a method --while using, say, Date::Manip, to change the results --from 08/08/02 to 08/08/2002? -X -Original Message- From: Beau E. Cox [mailto:beau;beaucox.com] Sent: Friday, November 08, 2002 4:25 PM To: Johnson, Shaunn; [EMAIL PROTECTED] Subject: RE: set date variable

RE: set date variable and range - correction

2002-11-08 Thread Johnson, Shaunn
again! -X -Original Message- From: Johnson, Shaunn Sent: Friday, November 08, 2002 5:55 PM To: 'Beau E. Cox'; [EMAIL PROTECTED] Subject: RE: set date variable and range --thanks for the reply: --let me rephrase my question this way. i have just installed --the Date::Manip module. i

explicit package name errors

2002-11-06 Thread Johnson, Shaunn
Howdy: Can someone tell me why I keep getting the errors: [snip error] D:\PERL\BIN\MY_SCPTSdb2_test1.pl syntax error at D:\PERL\BIN\MY_SCPTS\db2_test1.pl line 35, near my Global symbol $sth requires explicit package name at D:\PERL\BIN\MY_SCPTS\db2_ test1.pl line 35. Global symbol $sql requires

maybe a db2 question

2002-11-06 Thread Johnson, Shaunn
Howdy: This may be a DB2 question; if so, let me know and I'll send the question there - I have a script that connects to the mainframe and generates a flat file with data that I want. Works fine for what I'm doing. But now I want to create the outfile in an IXF format, somehow. I'm looking at

perl modules for NT

2002-11-05 Thread Johnson, Shaunn
--Howdy: --I've installed ActiveState 2.1.6 on Windows NT serv. pak 6. --I'd like to install a few modules with the ppm too, but --it doesn't seem to be working. As I understand it, all I --should have to do is : [snip] ppminstall DBI pmminstall DBD-Oracle [/snip] --my error is this:

problem installing DBIx module

2002-11-01 Thread Johnson, Shaunn
Howdy: I'm trying to install the DBIx-Connect-1.7 on RedHat Linux 7.2. My goal is to connect to DB2 on MVS / 390 (which is running DB2 6.1.x). When I try to run the 'make test', I get the following error: [snip error] PERL_DL_NONLAZY=1 /usr/local/bin/perl -Iblib/arch -Iblib/lib

connect perl to mainframe

2002-10-31 Thread Johnson, Shaunn
Howdy: How do I access a DB/2 database from a perl script? I have DB/2 version 6.1.1 on an MVS mainframe and I'm trying to connect from a RedHat Linux box. I imagine that I need the DBI modules, though. What else do I need to connect to the mainframe database? What syntax do I use? Thanks! -X

install modules via the internet

2002-09-26 Thread Johnson, Shaunn
Howdy: Correct me if I'm wrong, but isn't there supposed to be a way to have perl modules installed on your system via some network / internet script? If so, how can I get that info? Thanks! -X

creating MS Access tables via Perl

2002-07-31 Thread Johnson, Shaunn
Howdy: Just got an odd call today. A client (who works on a Microsoft platform) wants to have a MS Access table created for him on a monthly basis from my warehouse. The warehouse is a PostgreSQL database on a RedHat Linux platform. My question: Is there something in Perl that will allow me

problems inserting records

2002-07-26 Thread Johnson, Shaunn
Howdy: Trying to figure out exactly what my program thinks the problem is, but perhaps I need a fresh pair o' eyes. My goal: To do a basic query (count) against a database, get that number for each column I count and put those numbers into a new table, each under it's own column. Background:

SOLVED: RE: search and replace problem

2002-07-11 Thread Johnson, Shaunn
--thanks all (chris, jeff, nikola) --jeff: your suggestion worked like elfin magick. thanks! --(note: i had to do this twice ... in the search pattern --i forgot the $ in newpattern ... oops.) --anyways ... -X -Original Message- From: Jeff 'japhy' Pinyan [mailto:[EMAIL PROTECTED]]

multiple queries, one output

2002-07-10 Thread Johnson, Shaunn
Howdy: Perl / DB question - I am running a PostgreSQL database and would like to count and sum tables and put that data into a new table for trending. I have a perl script that connects to the database and can do (I *think* this part is working) three separate queries, but now that I have

getting date from localtime

2002-06-25 Thread Johnson, Shaunn
Howdy: I'm trying to do the following (which may have been created already) in perl: * create two variables var1 = this will be sunday of current week always var2 = this will be saturday of current week always I'm not sure how I can use 'localtime' as a tool for identifying var1 and var2. I

RE: how to parse filenames with spaces using regex

2002-05-31 Thread Johnson, Shaunn
, Johnson, Shaunn wrote: Question about capturing a file name with spaces using regular expressions. [..] The output looks like this (the result of just $group). [snip example] /samba/hmp/iso/06/UNASSIGNED-06 - DUMMY-06.iso [/snip example] My goal is to print UNASSIGNED-06 - DUMMY-06.iso

SOLVED:how to parse filenames with spaces using regex

2002-05-31 Thread Johnson, Shaunn
. If I need to go into more detail, please let me know. --Thanks! -X -Original Message- From: drieux [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 30, 2002 5:27 PM On Thursday, May 30, 2002, at 01:40 , Johnson, Shaunn wrote: Question about capturing a file name with spaces using

how to parse filenames with spaces using regex

2002-05-30 Thread Johnson, Shaunn
Question about capturing a file name with spaces using regular expressions. What I'm trying to do is get a list of files and then only print the file names from the path. I would use the readdir option, but that returns '.' and '..'. I've also heard about FILE: BASENAME(I think it's called

change list to numeric

2002-05-24 Thread Johnson, Shaunn
Howdy: I know this is WAY out in left field, but I am trying to figure out how I can bring back a numerical value and evaluate it so I can do something else. So, this is what I'm doing: I connect to the database, get a count of records and bring back that number. At least it looks good on

using Graph

2002-05-20 Thread Johnson, Shaunn
Howdy: I think I need a second pair of eyes. I think I'm close with creating a trending line graph, but I can't figure out what part goes where and why I can not see anything useful. My goal: I am trying to connect to the database and pull back 6 fields (5 regions and 1 timestamp) and chart

passing local value between sub functions

2002-05-02 Thread Johnson, Shaunn
Howdy: Have a question about trying to pass the result of a sub function to another sub function. Let's say I have some code like this: [snip] sub firstPart { while () { print Stuff here is: $_\n; } [/snip] I'd like to know how can I make $_ available for OTHER sub

searching arrays with foreign element

2002-04-30 Thread Johnson, Shaunn
Howdy: I'm looking for examples of how to use element 0 in one array as a search pattern and looking in other arrays for that pattern. Here's what I have so far ... [snip code] #!/usr/bin/perl -w use diagnostics; # test to read two files into two arrays # do a search for each *FIRST* element

graphs and charts question

2002-04-18 Thread Johnson, Shaunn
Howdy: I'm running Perl 5.6.1 on RedHat Linux 2.4.7. Also, running Postgres 7.1.3. I'd like to generate a graph / chart of data from my database. For example, in a perl script, I'm doing a distinct count of a column in a table and get a list of stuff back. I want to take that data and maybe

cgi / select / update question

2002-04-12 Thread Johnson, Shaunn
Howdy: Still looking for examples / pointers ... I am still butchering a page where I connect to the database and get a list of tables. That works - My goal is to figure out how to select a table and update the Description / input comments for the table (and maybe - being SUPER ambitious -

RE: perl / database question - thanks!

2002-04-05 Thread Johnson, Shaunn
Howdy: Just wanted to say thanks and post what I finally came up with in the code (for the first part of what I'm trying to do, anyways ...) Will have to edit; I'm not even using the start_form sub query ... figured this was as 'bare bones' as I could make it. (*special thanks to elaine a.,

module / driver install question

2002-04-04 Thread Johnson, Shaunn
Howdy: Silly question time: Running RedHat Linux 2.4.7 rel. 10 and Perl 5.6.1. I think I installed the DBI module correctly and I'd like to use it. But I keep getting errors like: [snip] DBD::Pg installation failed: Can't locate object method driver via package DBD::Pg [/snip] So my

perl / database question

2002-04-02 Thread Johnson, Shaunn
Howdy: Running Postgres 7.1.3 on RedHat Linux 2.4.7 and Perl 5.6.1. My goal is this: I am trying to put a perl / cgi script together to display a list of tables I pull back from Postgres. I would like to put the table in a scrolling menu form page. So far I have this: [snip code]

Perl for Windows 98

2002-03-18 Thread Johnson, Shaunn
Howdy: Where can I get Perl 5.6.x for Windows '98? I did try ActivePerl, but am still having problems with the installs (there is a package to install called 'InstMsia.exe' that is supposed to help, but doesn't). However, the ActivePerl 5.6.1 DOES work for my NT servers. TIA! -X

RE: Perl for Windows 98

2002-03-18 Thread Johnson, Shaunn
--have explorer 5 ... but i have no idea what DCOM is ... i'll have to look into whatever that is ... --aren't there any alternatives? -X -Original Message- From: yahoo [mailto:[EMAIL PROTECTED]] Hi, a quick look on the ActiveState site seems to indicate that DCOM for win98 and

RE: Perl for Windows 98

2002-03-18 Thread Johnson, Shaunn
--come on guys! *lol* --let me start from the beginning: sometime ago, i asked for, and got, perl training. it was cool. i got a better understanding of what was going on, methods, practical application, etc ... --the training was ON RedHat 7.2, perl version 5.6.1. so it's NOT that i WANT

RE: Perl for Windows 98

2002-03-18 Thread Johnson, Shaunn
at the Windows 98 bit and you see what you need to install first http://www.activestate.com/Products/Download/Get.plex?id=ASPNPerl joel -Original Message- From: Johnson, Shaunn [mailto:[EMAIL PROTECTED]] Sent: 18 March 2002 14:53 To: [EMAIL PROTECTED] Subject: Perl for Windows 98 Howdy: Where

file names with spaces in perl

2002-02-27 Thread Johnson, Shaunn
Howdy: I'm having a problem with trying to get a list of files with spaces in them. I'm writing a perl script that goes into a directory, get a list of files with spaces in them (this is a file.doc) and run a mkisofs command against it. I can get a list of the files: [example] $debug=2;

RE: file names with spaces in perl

2002-02-27 Thread Johnson, Shaunn
- From: Jenda Krynicky [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 27, 2002 11:32 AM To: [EMAIL PROTECTED] Subject: Re: file names with spaces in perl From: Johnson, Shaunn [EMAIL PROTECTED] I'm having a problem with trying to get a list of files with spaces in them

OT: Perl classes

2002-01-28 Thread Johnson, Shaunn
Howdy: My management is thinking about signing up the department for Perl classes (maybe introduction to Perl). Is there a list / company that has such a site? I went to Perl.org and did a search and didn't see much in the way of Perl classes and criteria. Any suggestions? Thanks! -X

RE: Size of directory

2002-01-25 Thread Johnson, Shaunn
--howdy: --maybe i'm not following this, but, are you saying 'du -sk /directory' doesn't do what you want? --grant it, this is a perl mail list, but does things really have to be that complicated? -X I don't reach understand how I could obtain the size of a given directory and all the

RE: question about CRON

2002-01-24 Thread Johnson, Shaunn
--you could run a script a few ways, but, for cron, you could do something like: [example] 0,5,10,15,20,25,30,35,40,45,50,55 * * * * sh /home/shaunn/scripts/reminder [/example] --but that seems just as strange as, say, putting a 'sleep' clause in one of your scripts. i'm sure there is a way

RE: question about CRON

2002-01-24 Thread Johnson, Shaunn
--howdy: [snip] --X: i did think about that, but then figured i'd be going way off topic, so i just answered the question and continued lurking ... if the script died for whatever reason, the sleep wouldn't help would it? --X: and very nicely, too. (at least, it works for my linux servers)

RE: writing to a file

2001-12-28 Thread Johnson, Shaunn
Howdy: You're not talking about something like THIS, are you? [snip example] open DATE, date +%H:%M; $date=DATE; chop $date; [/snip example] And as I look at it, I'm thinking that might not be right. I just modified this (like two seconds ago from this: [snip] open DATE, date |;

get list from database, email list

2001-12-14 Thread Johnson, Shaunn
Hi again: This is my first attempt at trying to pull info from a database ... but this is my goal: A few days ago, I was having problems emailing a list of users ('documentation about perl / email' ... thanks to Brett and Jenda for the pointers) and I got to thinking, Why not go directly to the

UPDATE: RE: get list from database, email list

2001-12-14 Thread Johnson, Shaunn
Update: I think I may be closer than I thought! In the original code, I *thought* I was bringing back the entire select output. I *believe* I was only bringing in one row. I am trying to recreate it by testing from another table. It brings the first row; but now, the 'fetchrow' part of it

documentation about perl / email

2001-12-12 Thread Johnson, Shaunn
Howdy: Where can i find documentation about using email addresses in perl scripts? I believe this has to do with regex, but I'd like to read it for myself. Not finding much but flames at the FAQ sites ... TIA -X

RE: documentation about perl / email

2001-12-12 Thread Johnson, Shaunn
sendmail from thinking the '.' is the end of message. -X -Original Message- From: Brett W. McCoy [mailto:[EMAIL PROTECTED]] On Wed, 12 Dec 2001, Johnson, Shaunn wrote: Where can i find documentation about using email addresses in perl scripts? What is you are trying to do? Are you

RE: documentation about perl / email

2001-12-12 Thread Johnson, Shaunn
, 12 Dec 2001, Johnson, Shaunn wrote: [excerpt] In string, @server now must be written as \@server at ./email_sys_users.pl line 17, near @server In string, @bcbsm now must be written as \@bcbsm at ./email_sys_users.pl line 17, near @server.fred.com email: admin@fred Execution

RE: documentation about perl / email

2001-12-12 Thread Johnson, Shaunn
for me at all. -X -Original Message- From: Brett W. McCoy [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 12, 2001 11:37 AM To: Johnson, Shaunn Cc: [EMAIL PROTECTED] Subject: RE: documentation about perl / email On Wed, 12 Dec 2001, Johnson, Shaunn wrote: --i know. i *know* i must

split and replace

2001-11-29 Thread Johnson, Shaunn
Howdy: I must be going about this the wrong way. I'm trying to modify a script and concatenates text files into one large file. That works. There is a part where inside the text file are six columns. The last column is what I need to edit. It's alpha_numerical. I want to edit the sixth

RE: split and replace

2001-11-29 Thread Johnson, Shaunn
--Howdy all: --I *DO* want to replace every occurance of each value in the last column with a zero before it ... not just a single diget. -X -Original Message- From: Bob Showalter [mailto:[EMAIL PROTECTED]] -Original Message- From: Adam Turoff [mailto:[EMAIL

RE: split and replace

2001-11-29 Thread Johnson, Shaunn
--Howdy: --This is what I wound up using: [example] open (FILE, +/temp/data.txt) || die Can't open the sourcefile\n; while (FILE) { s/(\d+)$/0$1/; print; } close FILE [/example] --The interesting thing is that if I have a decimal in there, it puts the zero in front of the

RE: Send e-mail attachment

2001-11-27 Thread Johnson, Shaunn
--yes. --at least that's what i do when i send a basic text file to remind me of something that i've done. [example:] addr='[EMAIL PROTECTED] [EMAIL PROTECTED] [EMAIL PROTECTED]' mailcmd=/usr/sbin/sendmail (some work going on here) $mailcmd $addr /tmp/reminder.txt [/example] --but the

  1   2   >