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 updated the query as follow: my $sql = "select tsrmaster.sname, call_history.status ". "from tsrmaster, call_history ". "WHERE tsrmaster.tsr = call_history.tsr ". "and ((call_history.status = \"LM\" and time_connect < 20) ". "or (call_history.status = \"R\" and time_connect > 120) ". "or...

Looks like my UNION in the query is only returning distict values. More to follow.

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

I have only 3904's. They all are experiencing the problem.

I should add this will be a report run each sunday night and the "WEEKS OLD" will reflect how old from the day the report is run.

Sample Input Data. TABLE NAME: LEADS TYPE DOL 01 09/01/2006 03 09/04/2006 04 09/14/2006 05 09/08/2006 02 09/11/2006 03 09/01/2006 05 09/04/2006 01 09/14/2006 00 09/08/2006 02 09/11/2006 04 08/25/2006 05 09/03/2006

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?

Okay. I have come up with the SQL that will return all the results for counts even if the count is 0. My question returns to Perl. I will be running 4 different queries, one for each week to produce its counts. My question now is how do I use the fetchall_arrayref() to populate my report...

In your example: SQL> SELECT 'AAA' FROM DUAL 2 UNION 3 SELECT 'CCC' FROM DUAL 4 UNION 5 SELECT 'BBB' FROM DUAL 6 UNION 7 SELECT 'CCC' FROM DUAL 8 order by 1 desc; What is the return set if there is no BBB in DUAL. For my example I am counting the instances of AAA BBB...

Thanks Tharg, Actually the code I posted is a much abbreviated version for simplicity sakes. I most likely screwed things up a bit in my simplification. But thank you very much for suggesting an optimized version of the SQL. On the Perl side of things, I have remaining issue. Using the...

If there was a way to give you 5 stars I would. Thank you. This is going to be be one monsterously long sql statement. :)

After reading my own post I thought I would simplify things. I am attempting to run multiple queries against a database. The results from these queries will always be one row. I would like to put the results of each of these queries in a text file/report. The output should be similiar to the...

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

Thank you for your help. Although the ASAP utilities perform this function, it requires human intelligence to operate. I am looking for a code only option. I did a little more research and was able to do a regular find and replace of the '*' character by just preceding it with a '~'. So the...

I was hoping for something in VBA. Is it possible to use the unicode representation of a character for replace code? If so, do you have a example so I can learn the formating?

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