Search results for query: *

We are trying to set up an export process to automatically establish a VPN connection before running it's normal tasks. The connection is usually established manually via the Cisco VPN client. I'm not finding much on CPAN. There was only one module...and I wasn't successful in getting it...

I am trying to do some cleanup of database connections when a GUI window is closed or destoyed. If the database handle is currently "connected" I want to rollback all transactions associated with database handle and disconnect. If I try to rollback and disconnect a database handle that is not...

#!/usr/bin/perl -w use strict; use Tk; my $mw = MainWindow->new(); $mw->Label(-text => "TESTING", -background => 'white', -width => 50, -justify => 'left')->pack(); MainLoop; This code should create a label with the text on the left side. Doesn't work. Puts it in the center. This must be a...

I'm trying to truncate a string at a non-alphanumeric character to include the most characters to still be within a 30 character maximum. It's being greedy even though I'm using the "?" non-greedy version of the quantifier. Here's the string.... BIT|DRL|6MM|12.8CM|CTR|CNRSTN-SR...

I have a TK gui used for updating a database. I'm having a problem with the users closing the window via the button in the top right hand corner and leaving the database connection open. I would like to tie the same "cleanup" process associated with the "CLOSE" button I created to the standard...

I have several Perl apps that run external Perl processes. I'm running the external processes for purposes of memory management and organization. It works very well, but the external processes only print their results to the "main" app when they finish and close. I want to be able to print to...

I've been connecting to an oracle database via Perl for years. I updated my DBD-Oracle driver to the most current one and now I keep getting error "ORA-12705: invalid or unknown NLS parameter value" and it wont make the connection. The only NLS value that I'm seeing on the machine I'm...

I have a script that analyzes contents of a file and compares it's contents to another file. This script has been working fine...but when we throw a large amount of data at it....it stops prematurely. The file has 6.6 million rows but there seems to be available memory on the machine when it...

I built a hash of arrays of hashes. I can access everything, but I need to do something with each hash within the array of hashes and am having trouble defining how many hashes exist in the array so I can use a 'for' loop to get each one. The structure looks like...

Getting an error.... can't use "string" as an array reference when "strict ref" is in use Makes sense...as I'm using a new variable, but it still seems silly. Using array references has proven to be very powerful for me. Anyone know how to get around this? I love "use strict" but want to...

I have some very memory intensive processing that I'm trying to consolidate via multiple scripts...so when each process if finished..it will return the memory to the OS. I know how to call external scripts with backticks..and pass arguments as literals. Is it possible to pass variables..or...

I need to be able to truncate at least a specific number of characters to make a string meet a character length requirement. But..I have to truncate on a delimiter (a pipe in this instance) so the string still makes sense. Example: I need to remove at least 30 characters from the end of this...

I'm still trying to determine the quickest route to a GUI for a bunch of Perl-based data processing tools I've written. I noticed that the ActiveState Komodo IDE comes with a graphical GUI builder. Looks very interesting? Anyone used it with success? Cheers, Sloppyhack

My company is into data management services. Enhancing data, cleaning data, reporting, etc. We handle LOTS of text, use tons of RexExs with lots of database interaction and Perl has served me/us very well. I have a new boss now who is not technically savy and wants me to put a GUI on all of...

We have a db stored procedure calling a Perl process and passing a parameter...the script is to take the parameter...process it..and return a parameter to the database. I'm not sure how to accept and pass back. It should be just as you would run a script and pass a parameter via the command...

I'm trying to send mail from a machine running W2K Server. I set up the SMTP services on that maching and had the network admin confirm that it's working properly. I get the following error message.... RCPT TO: error (550 5.7.1 Unable to relay for bculler@comcast.net) when I try to run the...

Does anyone know of a way (module?) to write to an existing Excel file? I am very familiar with the Write-Excel module, but with that module you have to generate a new Excel file every time. The Excel file I need to write to is too complicated for the Write-Excel module (drop down lists, data...

I have an script that inserts data into a SQL Server table and I'm having some trouble with zero-length vs. null values. Everything appends just fine, however SQL Server is interpreting all undefined variables as zero-length instead of null. I want the field left as null. Does anyone have...

I am running some bulky data processing and need to notify a group of people when processing finishes. Does any know of a good module to use for sending emails? The module needs to work with Windows based machines. Any help would be greatly appreciated!!!! Cheers, Sloppyhack

I am trying to capture a hash from an array of hashes and assign it to one hash. It's not working, but I know it's possible. Here's an example. my @dups; #my array containing hashes I want to pash one hash from this array into a hash variable. $lgth1 = length $dups[$row]->{'ITDESC'}; #assign...