Search results for query: *

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

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

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

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

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?

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

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.

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

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

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

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

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

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

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

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

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

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

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.

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

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.