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 Chriss Miller 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: V00D00
  • Content: Threads
  • Order by date
  1. V00D00

    Data to Drive the Layout of Report

    I am going to have a very hard time articulating this problem so forgive me if this is very confusing. I have the following code #!/usr/local/bin/perl use warnings; use strict; use DBI; use Mail::Sender; $ENV{DBPATH} = "/usr/task"; $ENV{DBF} = "/usr/task/task.dbs"; $ENV{DB} = "task"...
    • V00D00
    • Thread
    • Replies: 2
    • Forum: Perl
  2. V00D00

    Can't Count using Hash

    I am doing a query from a database and returning two pieces of data. A name, and a status code. I am attempting to use the name (First and Last) as a key and count the number of instances it appears in my data set. For some reason it will count the first instance, but will not give me a count...
    • V00D00
    • Thread
    • Replies: 4
    • Forum: Perl
  3. V00D00

    Query Help

    Any help with this will be greatly appreciated. The table I have has a field called 'TYPE' and 'DOL' (DOL = Date of Load). I need to produce a query that will count the number of 'TYPE' and group them by 'DOL' for a given week. For example: TYPE 1 WEEK OLD 2 WEEKS OLD 3 WEEKS OLD...
  4. V00D00

    Help Creating a Query

    Any help with this will be greatly appreciated. The table I have has a field called 'TYPE' and 'DOL' (DOL = Date of Load). I need to produce a query that will count the number of 'TYPE' and group them by 'DOL' for a given week. For example: TYPE 1 WEEK OLD 2 WEEKS OLD 3 WEEKS OLD...
  5. V00D00

    CallPilot 201i - Message Indicator

    Got a Nortel Option 11 with Call Pilot 201i. For no apparent reason, all the voice mail message indicator lights on my 3904's stopped working. Anyone run in to this before?
  6. V00D00

    Perl Database Report

    I need some guidance on the best way to start a new project. I have to run several queries against a database to retrieve counts. I would like to have a perl script make all these separate queries, store the values, and then print them to a text file so it is nice and clean. Attached is the...
    • V00D00
    • Thread
    • Replies: 9
    • Forum: Perl
  7. V00D00

    Remove Special Characters

    Hello, I am looking for a way to remove special characters from a sheet. These special characters being the '*' and '?'. Using the normal code for find/replace does not have the effect I am looking for, it removes and replaces all characters. Any help would be appreciated.
  8. V00D00

    Matching Cell Contents

    I need some help setting this up and I am at a loss at where to start. Below is my basic requirement. If cell(A1) from sheet1 matches cell(A1) from sheet2 then add to sheet2 cell(23) and cell(24) with the value from sheet1 cell(12) and cell(13). Repeat for each cell in column A until no more...
  9. V00D00

    IsNumeric in a Range

    Can someone give me some sample VBA code to determine if any cell in a selected range has a numeric value? VD
  10. V00D00

    Invoke & Invoke.Required

    Can someone give me an example of invoke and invoke.required used to show and hide a form? VD
  11. V00D00

    Forms Malformed

    Please forgive me for my ignorance, I am extremely new with programming and am at my wits end. Anyone run in to problems with the forms that appear normal in the designer becoming malformed and hanging when run? I have a small authentication form, it launches using form.show() from a method...
  12. V00D00

    Calculate the Max Field Length

    I am looking for a way to calculate the longest field length in use for a given column in excel. A formula or VBA solution would be most greatly appreciated. VD
  13. V00D00

    Enable Speaker Phone and Headset

    Nortel Option 11 with the 3904 handsets. How do you enable the speaker phone and Headset button?
  14. V00D00

    Combine Text Lists

    I have two text files that contain customer information. One is from a specialty lead source, the second is from a generic lead source. I looking to take these two lists in to a file so that they are ordered in an alternating pattern based on the total number of records for each file. For...
    • V00D00
    • Thread
    • Replies: 3
    • Forum: Perl
  15. V00D00

    Remove Prompt For Save on Close

    I have a small Excel report that uses database connectivity. When the report is ran it connects to the database and does some caluclations that are populated in the excel sheet. Apon closing the workbook I am always prompted to save changes. How would I go about removing that prompt so that...
  16. V00D00

    IDE

    I am very new to the world of programming and before I devote a serious amount of time in development I wanted to find out from you nice people what IDE you prefer and why or if you prefer no IDE at all. I will be developing applications that will run on either KDE or Gnome. In the end I think...
    • V00D00
    • Thread
    • Replies: 3
    • Forum: C++
  17. V00D00

    Extremely New

    I am extremely new to Visual Basic and .NET. I come from using Perl as a sysadmin, so most of my scripts are for list iteration. My first attempt at a VB application will be to take a comma delimited file and reformat it, both in field order and for content. Can someone point me in the right...
  18. V00D00

    Net::SMTP and Attachments

    I have seen many posts that talk around this subject but nothing that comes out and says this is the way. Using Net::SMTP can you send an attachment? My particular need is to send a text file. As always... forgive me for ingorance.
    • V00D00
    • Thread
    • Replies: 7
    • Forum: Perl
  19. V00D00

    Date Modifications

    I am creating a script that will be making calls to an Informix database. Part of the Query is based on date ranges. Using gmtime and time I have gotten the dates formated to M/D/YYYY. The problem is getting leading zeros in front of the Month and Day when they are only one digit. The final...
    • V00D00
    • Thread
    • Replies: 2
    • Forum: Perl
  20. V00D00

    Location of Recordings

    Nortel Option 11 with CallPilot. What is the path to the actual voicemail greeting recordings on the CallPilot server? I am looking to make copies of these recordings for easy manipulation offline but can't find them.

Part and Inventory Search

Back
Top