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

    Creating an array from a method

    I am attempting to construct an array from a method, but I am receiving an error that the array must have an array size or array initializer. I thought the code below would do this, but it seems that C# is wanting more information up front, and I am not entirely sure what to give it. If I try...
  2. pmcmicha

    Connection issues with reservation software

    The location in question has a cable connection for their internet that serves a business and other users. The cable modem is connected to a RVS4000 Cisco Small Business Router. The router has been configured to separate the users from the business using VLANs. Everything on the user side...
  3. pmcmicha

    Wireless AP while segregating the LAN

    Here is the current setup of the system I work with: Internet comes in at one building where it is connected to a firewall and this goes to a point to point wireless device. That signal hits a second omnidirectional device where the signal is then transmitted to the final point to point device...
  4. pmcmicha

    Report Query

    I have a report in which it queries the database for information and runs IIf statement. This works without a problem, but when I go to create a new report and then try this same query, I get an #Error for the result. I tried a copy and paste of the statement, no luck. Looked up the #Error...
  5. pmcmicha

    Output Issue

    I am just starting with php, but I have been unable to find a solution. I have a simple html page with php. <html> <head> <style type="text/css"> @import url(file); </style> <title>Page</title> </head> <body> Text here. <hr> <?php echo "Hello World!"; ?> <hr> </body> </html> While...
  6. pmcmicha

    DB2 Tablespaces not matching

    I have two databases that exact mirrors of each other. All the tablespaces match, with the exception of the number of pages being used and the number of pages free. Database 1 reports having fewer free pages than Database 2. The tablespace state is fine, but I am unable to determine why this...
  7. pmcmicha

    Long tar extractions

    Issue: When unarchiving tar files on some of our servers, I am running into long extraction times for a paticular directory. There are about 1,000,000+ files in this directory all with 444 permission. This slice is about 200 GB. The servers are running Solaris 5.8 with 2 processers (@ 1200...
  8. pmcmicha

    db2 load w/ method option

    Recently the company I work for moved to supporting double byte characters in the UDB8.2 database. As the DB was already setup as (utf-8, codepage=1208) this was not much of an issue, but when we loaded our first test case, it failed. db2 "load from <DAT_FILE> of del modified by chardel~...
  9. pmcmicha

    Command line pattern matching

    I have some files that I want to pattern match on, but I cannot get it to work right. Test Files (0 byte touched files) Test_GroupUIDxxx_FILETYPE_SERVER_DATE_NO.tar Test_GroupUIDyyy_FILETYPE_SERVER_DATE_NO.tar Test_GroupUID_FILETYPE_SERVER_DATE_NO.tar...
  10. pmcmicha

    Problem with INDIRECT and Dynamic Lists

    I am attempting to reduce the amount of maintenance on a worksheet by making certain columns dynamic in regards to their named range. Then I wish to reference this from a couple of lists. Dynamic Named Range: TEST =INDIRECT("DATA!$A$2:$A"&ROW(OFFSET(DATA!$A$2,COUNTA(DATA!$A$2:$A$50)-1,0)))...
  11. pmcmicha

    Spaces and special characters

    I am attempting to remove spaces and other special characters from a variable reference. This reference is passed from an array. This array is based into a function to build a table. That part works without a problem, but I would like to be able to create an <a href="" without the real...
  12. pmcmicha

    Perl grep

    I have a job which runs with the following code: if($rdir eq "test1") { if(scalar(@ex_test1) != 0) { foreach $file (@file_list0) { chomp($file); if(grep(/$file/, @ex_test1) == 0) { MTIME(); ## print current time print LOG...
  13. pmcmicha

    perl grep

    I am trying to do the following with no success and I cannot seem to find any good documentation on this problem. open(LIST,"<test.txt"); @list = <LIST>; close(LIST); foreach $value (@unq) {\ chomp($value); @ent = grep /^$value\|/, @list; } When I try this, the variable $value...
  14. pmcmicha

    Removing duplicate entries

    I have an excel file that has some duplicate entries in COL A with various values in COL B and COL C. What I would like to do is to remove all duplicate values in COL A so that they are unique, but at the same time, keep the values in COL B and COL C so that they all appear in the same row. I...
  15. pmcmicha

    NESTED VLOOKUP

    I have an issue with a nested VLOOKUP formula. =IF(ISBLANK(E50),"+0",VLOOKUP(COUNTIF(($E$50:E50),E50),BAB,VLOOKUP((E50),VLOOKUP((C50),CLASS_SELECT,2),2))+O48) CLASS_SELECT is a named range which is set as follows: VALUE ==> NAMED_RANGE The problem is with the section of the formula in red...
  16. pmcmicha

    COUNT cells with two conditions

    I know that I cannot use COUNTIF with more than one condition and I have tried to use the 'CONDITIONAL SUM' wizard as well (This failed since my cells are merged.). But I have two conditions which need to be met. COUNTIF(A1:A100,"*text") This is what I am trying to do, but I need to limit my...
  17. pmcmicha

    Help with DSUM

    I only want to sum the contents of a paticular column based on certain criteria which changes throughout the history of the worksheet. Below is what I have setup for DSUM, but I cannot seem to get this to work properly. Either I am using the function incorrectly or this is the wrong function...
  18. pmcmicha

    Crypt Module?

    All, I need to encrypt a file while it is not in use and I am wondering which of the crypt modules out there for PERL is the best. I would prefer not to use the unix implementation of crypt, but I do need it to have the same functionality. Thanks in advance.
  19. pmcmicha

    DB2 messages file, incorrect permissions

    When I am loading the db2 database, I output all messages into a file called <filename>.db2err. My default unix permissions are set to create any file as 664, but when the db2err file is created, it is created with 640 permissions. I have looked through some db2 documentation, but I am unable...
  20. pmcmicha

    Unix Process Status Table

    Is there some way in which I can prevent a command from showing up in the unix process status table? I have several automated scripts which run that contain a database UID and database PSWD. The PSWD is encrypted, but this doesn't help much when I run the command to connect to the database as...

Part and Inventory Search

Back
Top