Hello!
I have a crosstab report that calculates for failure rates for my products ; it has two measures (PASSCOUNT, FAILCOUNT) and a calculation FAILRATE (FAILCOUNT/PASSCOUNT+FAILCOUNT)
The report layout looks thusly:
OEM
MODEL
TESTYEAR TESTMONTH PASSCOUNT...
I am working with a supplier who's just tightened their security. They moved from an anonymous FTP setup to a more secure alternative. The parameters they gave me
Host: blahblah.net
Port: 4421
Path: /mailbox
User: (...)
Password: (...)
Auth SSL: yes
Passive mode: yes
Using ftp -pn blahblah.net...
I have a script that puts a list of files in two separate arrays:
First, I get a file list from a ZIP file and fill `FIRST_Array()` with it. Second, I get a file list from a control file within a ZIP file and fill `SECOND_Array()` with it
while read length date time filename...
Hello,
I have a script that "validates" a ZIP file that look like this
AAA_20120801.zip =>
x~back end~20120801.TXT
y~time in~20120801.TXT
z~heat_chamber~20120801.TXT
AAA_20120801.ctlMy task is to compare its contents (i.e the list of files contained inside) with the control file that is...
I built a very simple app using a PHP form with a bit of Javascript.
In my form, I have a text input which I used to run a database search. In case I have multiple values, I have a bit of code that puts a comma in between each.
The weird part is this:
In Firefox, I can go do MS Excel, copy 5...
Hello,
I am trying to implement a simple script that ZIPs up a text file.
The problem is that I don't think the ZIPArchive is available on my server. Here is an example of my code:
<?php
$zip = new ZipArchive();
$filename = "./PJR.v2.zip";
if ($zip->open($filename...
I am parsing text files looking for specific entries like so
grep -e 'Model' -e 'Manufacturer' -e 'Man Date' -e 'SW Version' -e' SW Name' -e 'HW Version' -e 'Receiver ID' JGMDTV356.HDD
This gives me an output like so
Model = HR24
Manufacturer = 100
Man Date =...
I have a bunch of SQL scripts (with shell script wrappers) to unload data like so
EXPORT TO /tmp/out.csv OF DEL MODIFIED BY NOCHARDEL COLDEL, DATESISO
MESSAGES /tmp/out.msg SELECT WIDGETID
...
I want to add an error handler to the script the way Oracle does it...
**Disclaimer: It's been a while since I last wrote any code. The quality of my code is likely to be sub-par. You've been warned.**
Greetings.
I am coding a basic form that uses a SELECT list I populate from my database.
However, my user needs the form to be dynamic and wants to be able to...
**Disclaimer: It's been a while since I last wrote any code. The quality of my code is likely to be sub-par. You've been warned.**
I have a basic form that's meant to search flat files on our server. The "search engine" I created as two select lists: one for the file names and one for the...
Greetings!
I am trying to build a very basic fulltext search app in php. I have found an example here [http://tips4php.net/2010/03/create-your-own-fulltext-searchengine-with-php-and-mysql] so I used it to build my own.
This is my table/data (field types are text)
name...
For a project that I have been assigned to, I need to send emails to a business partner (business_partner.com) from one production server. However, my emails neither reach their destination nor bounce back to me.
Working with our business partner's IT support, the following error was discovered...
I know nothing about javascript.
Assuming the string "3005600008000", I need to find a way to multiply all the digits in the odd numbered positions by 2 and the digits in the even numbered positions by 1.
This pseudo code I wrote outputs (I think) TRUE for the odd numbers (i.e. "0"),
var...
Why does this work
for myfile in `find . -name "R*VER" -mtime +1`
do
SHELLVAR=`grep ^err $myfile || echo "No error"`
ECHO $SHELLVAR
done
and outputs
No error
err ->BIST Login Fail 3922 err
No error
err ->IR Remote Key 1 3310 err
But this does not...
I have ASCII files to parse that 48 hours old or more ; I can identify them like so
find . -name "FILE*TXT" -mtime +1 -exec ls -ltas '{}' ';'
Some files have a list of hardware errors (we test electronic components), some have none. If the file name has no errors, I still want to...
[Running DB2 UDB version 9] Why does this SQL statement work
SELECT
CASE
WHEN A.DAILYDOWNLOADSIZE is null THEN 0
else bigint(A.DAILYDOWNLOADSIZE)
END "DAILYDOWNLOADSIZE",
CASE
WHEN A.DAILYDOWNLOADTIME is null THEN 0
else bigint(A.DAILYDOWNLOADTIME)...
Greetings. I am using SED to cleanup files that are laid out like so:
ReceiverID=028936004663
SerialNumber=WD-WCAV95708405
Currenttemp=44C
PowerOnHours=3663h
ReceiverID=028923894902
SerialNumber=WD-WCAV9A766701
Currenttemp=49C
PowerOnHours=2215h
My boss wants files like this one to be tab...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.