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!

  • Congratulations dencom 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: ssmith001
  • Content: Threads
  • Order by date
  1. ssmith001

    Useless use of a constant in void context error

    I have the following code that I keep getting this error on: Useless use of a constant in void context at ... I've highlighted the lines it has a problem with. What exactly does this mean and how do I get rid of the error/warning? [code] my @promocodes = qw/code1 code2 code3 code4 code5/; my...
  2. ssmith001

    Dynamic Where Clause using DBI

    I've got an interesting problem that I'm trying to resolve in Perl and I need some advice. Perhaps someone has run into this before. I'll do my best to keep this simple. I have a form my user fills out. This form is basically nothing more than "where clause" criteria from which I need to build a...
  3. ssmith001

    Subroutine help

    I have the following subroutine that 99.99% of the time will return a single value. My concern the how do I build in error trapping for the .01% in case there happens to be more than two distinct values. I want to bail. sub what_category_do_we_process { my $planner = shift; my ( $cur...
  4. ssmith001

    help accessing array of array references

    I have an array of arrays and here are some of the elements I dumped using Dumper: $VAR6 = [ 'B400', 'A1199P1394', 'A' ]; $VAR7 = [ 'B400', 'A1205G2425', 'A' ]; $VAR8 = [ 'B400', 'A1205Z1534'...
  5. ssmith001

    Help with subroutine

    I am working on my first Perl script and I have a sub that calls a sub. The 1st sub returns a list of location/item/abccodes. If the abccode = 'A' then I want to call the 2nd sub to get and return the quantity. When I comment out the call to the 2nd sub, the 1st sub spins through and prints out...
  6. ssmith001

    Need help understanding something

    I have a table that looks like this: PLNRCODE PARAM VALUE PROCESSFLAG M01 DlrGrp AMOS N M01 DlrGrp BALTIMORKW N M01 DlrGrp BAY AREA N M01 DlrGrp CAROLINAKW N M01 DlrGrp C-B KW N M01 Abc A N M01 Abc B...
  7. ssmith001

    Create on-the-fly query

    I have a need to create a query that will look like this: SELECT DISTINCT a.item FROM stsc.sku a , stsc.item b , stsc.loc c WHERE a.p_abc = 'A' AND b.p_stkclass IN ('010', '010A') AND a.item = b.item AND a.loc = c.loc AND c.p_dlrgrp = 'MHC' but the problem is that I could have many...
  8. ssmith001

    Perl DBI question

    I'm rather new at Perl and I have a question for which I need some advice. I don't know if this is more of a Perl question or an Oracle question, but here goes... My program accesses an Oracle database and I am trying to minimize the number of times my perl code calls Oracle. I run a query...
  9. ssmith001

    Check date string for day of week

    I'm sure this is easy, but I've looked everywhere and cannot find a way to do this. I have a flat file that I read, line by line. I need to look at a date that is on each of these lines, and is in the YYYYMMDD format, and see if this date falls on a Monday. If it does, I need to move the file to...

Part and Inventory Search

Back
Top