Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: sloppyhack
  • Content: Threads
  • Order by date
  1. sloppyhack

    VPN connection automation?

    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...
  2. sloppyhack

    How to test the status of a database connection?

    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...
  3. sloppyhack

    GUI problem: "-justify" doesn't work in the LABEL widget?

    #!/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...
  4. sloppyhack

    Problem with minimal (nongreedy) matching

    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...
  5. sloppyhack

    Tk - Tying events to closing a window

    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...
  6. sloppyhack

    Reading from an external Perl process

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

    DBD-ORACLE (ORA-12705: NLS parameter value problem)

    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...
  8. sloppyhack

    What would cause a script to exit prematurely?

    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...
  9. sloppyhack

    finding total hashes within the array in a hash of arrays of hashes

    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...
  10. sloppyhack

    error with array reference while using 'use strict'

    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...
  11. sloppyhack

    Passing variables to an external script

    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...
  12. sloppyhack

    Regex Question - non-greedy truncation

    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...
  13. sloppyhack

    Komodo IDE GUI Builder - Good/Bad?

    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
  14. sloppyhack

    "THEY" want a GUI - any suggestions?

    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...
  15. sloppyhack

    running a script and passing a parameter

    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...
  16. sloppyhack

    Newbie Mail::Sendmail problems on Windows

    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...
  17. sloppyhack

    Writing to an existing Excel file

    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...
  18. sloppyhack

    DBI: How do I set a variable to NULL in SQL Server?

    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...
  19. sloppyhack

    Need to send an email when a process finishes. Module?

    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
  20. sloppyhack

    capturing a hash from an array of hashes

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

Part and Inventory Search

Back
Top