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
  • 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 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...
  3. V00D00

    Can't Count using Hash

    Looks like my UNION in the query is only returning distict values. More to follow.
  4. 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
  5. V00D00

    CallPilot 201i - Message Indicator

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

    Query Help

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

    Query Help

    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
  8. 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...
  9. 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...
  10. 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?
  11. V00D00

    Perl Database Report

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

    Perl Database 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...
  13. V00D00

    Perl Database Report

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

    Perl Database Report

    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. :)
  15. V00D00

    Perl Database Report

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

    Perl Database Report

    ..."\n"; print "Week One Start Date = $week1_startdate\n"; print "Week One End Date = $week1_enddate\n"; my $sql_first_week_wkv_spg = "select count(*), leadcode.description ". "from leadcode, outbound ". "where leadcode.lead_src = outbound.lead_src ". "and (listid between \"1000\"...
    • V00D00
    • Thread
    • Replies: 9
    • Forum: Perl
  17. V00D00

    Remove Special Characters

    ...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 code looks like: Selection.Replace What:="~*", Replacement:="", LookAt:=xlPart, _...
  18. V00D00

    Remove Special Characters

    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?
  19. 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.
  20. 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...

Part and Inventory Search

Back
Top