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