12-12-2008
this seems to be something that could be done easily with
CPAN's List::Compare module
where yesterday's data and today's data would be two set of lists and methods provided to retrieve required data can be used
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Hi everyone!
I'm trying to create a database monitoring script that reads an alert file and sends an error message if it can 'grep' a particular string.
Is there a way to send this message to a mail client using SMTP?
Even better, is there any place on this site that has these kinds of... (5 Replies)
Discussion started by: solaris73
5 Replies
2. Shell Programming and Scripting
I am comparing two table structure in different databases,Put into 2 txt files , when comparing if column sequnce and data type is not matching ,it has to display that info else Table structure is ok.
wrote shell script ,its not working .I am getting "Table structure is not ok" even if both... (1 Reply)
Discussion started by: akil
1 Replies
3. Shell Programming and Scripting
Hi,
I have two databases with same tables on different servers.I need to check the data content in each table and if something is missing, should print that.
I have a tool which takes the snapshot the table structure,index so on and compares with the other server tables snapshot.
Now i need... (1 Reply)
Discussion started by: nessj
1 Replies
4. Shell Programming and Scripting
Hi guys...
I am busy writing a script to notify me via an mail if my application is down. I have done that.
Now I want this script to stop sending mails after five mails were sent but the script should keep on checking the application.
When the application is up again that count should be... (5 Replies)
Discussion started by: Phuti
5 Replies
5. Shell Programming and Scripting
Hello all;
I have been really frustrated with finding the correct perl code (and MySql statements) to accomplish what I thought was straight forward...I have tested I don't know how many different codes\suggestions I found on the net without any success...but anyhow let me explain my plight and... (0 Replies)
Discussion started by: gvolpini
0 Replies
6. Shell Programming and Scripting
I have 2 files that need to be compared. Email the differences if something is different and don't email if nothing is different. One or both of the files could be empty. One or both could have data in them.
example files
backup.doc.$(date +%y%m%d) file size is 0
backup.doc.$(TZ=CST+24... (4 Replies)
Discussion started by: jabbott3
4 Replies
7. Red Hat
Whats the difference between mail and mailx?
I'm trying to troubleshoot a problem where I can send mail from server A with this `echo $MESSAGE | mail -s "$SUBJECT" -r $FROM $RECIPIENTS` command but executing the same command from server B throws me this error (Both servers are RHEL)
... (1 Reply)
Discussion started by: RedSpyder
1 Replies
8. UNIX for Dummies Questions & Answers
Hi,
I have txt file below
02.05.2014,10.05.2014,dfs,srtytr,tyhty
05.10.2014,15.10.2014,456ef,t6y5fgtd,xg45t
21.11.2014,28.11.2014,sefser,dfw344,zsdfrw
22.12.2014,30.12.2014,fwe,aerw4,zwq4q
my script will ask two input,
enter start date
05.10.2014
enter end date... (3 Replies)
Discussion started by: stew
3 Replies
9. Shell Programming and Scripting
my queryis :
select distinct m.name, item_count, item from master m join client p on m.name=p.name where item_count = 1 and item > 1;
But how should I update them?
i used update statetment :
Update from client Set item =1 where m.name=p.name and item_count=1 AND item>1
Is this wrong? (1 Reply)
Discussion started by: siya@
1 Replies
10. Shell Programming and Scripting
I have defined a set of global variables at the beginning of my script as below:
#ideal values
export ITEM1=SUCCESS
export ITEM2=FAILURE
export ITEM3=UNAVAILABLE
export ITEM5=FAILURE
export ITEM6=SUCCESS
now I have a shell script function which returns a value in below format.
ITEM1... (1 Reply)
Discussion started by: ctrld
1 Replies
LEARN ABOUT PHP
dbx_fetch_row
DBX_FETCH_ROW(3) 1 DBX_FETCH_ROW(3)
dbx_fetch_row - Fetches rows from a query-result that had the DBX_RESULT_UNBUFFEREDflag set
SYNOPSIS
mixed dbx_fetch_row (object $result_identifier)
DESCRIPTION
dbx_fetch_row(3) fetches rows from a result identifier that had the DBX_RESULT_UNBUFFERED flag set.
When the DBX_RESULT_UNBUFFERED is not set in the query, dbx_fetch_row(3) will fail as all rows have already been fetched into the results
data property.
As a side effect, the rows property of the query-result object is incremented for each successful call to dbx_fetch_row(3).
PARAMETERS
o $result_identifier
- A result set returned by dbx_query(3).
RETURN VALUES
Returns an object on success that contains the same information as any row would have in the dbx_query(3) result data property, including
columns accessible by index or fieldname when the flags for dbx_query(3) were set that way.
Upon failure, returns 0 (e.g. when no more rows are available).
EXAMPLES
Example #1
How to handle the returned value
<?php
$result = dbx_query($link, 'SELECT id, parentid, description FROM table', DBX_RESULT_UNBUFFERED);
echo "<table>
";
while ($row = dbx_fetch_row($result)) {
echo "<tr>
";
foreach ($row as $field) {
echo "<td>$field</td>";
}
echo "</tr>
";
}
echo "</table>
";
?>
SEE ALSO
dbx_query(3).
PHP Documentation Group DBX_FETCH_ROW(3)