01-06-2010
Output file not displayed in the proper format
Hi am using uuencode fro attaching one report which is nothing but sql query output.
But when i receive the report through attachement and when it is opened the report is not displayed in proper format. Means if the sql query has 100 rows the mail attachment report displays the report in 2 rows itself.Please help me to solve this problem.
Thanks in advance.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
We run an application called meta which reads user information from database and updates in LDAP.For that we have some scripts to check the uniqueness of mail ids between the existing LDAP and Database.It works fine when people enter mail ids in proper format (xxx.yyy@abc.com) but if it... (2 Replies)
Discussion started by: prolay
2 Replies
2. Shell Programming and Scripting
Hi Guys,
my $cmd = "ls -l"; #........ {or let it be as # my $cmd= "ls"; }
my $ssh = Net::SSH::Perl->new($host);
$ssh->login($user, $pass);
my($stdout, $stderr, $exit) = $ssh->cmd("$cmd");
print $stdout;
the script works fine, but i am unable to see the output getting displayed in a... (7 Replies)
Discussion started by: gsprasanna
7 Replies
3. Shell Programming and Scripting
Hi,
I have two files , one file with data file with attributes that need to be sent to another file to generate a predefined format.
Example:
File.txt
AP|{SSHA}VEEg42CNCghUnGhCVg==
APVG3|{SSHA}XK|"password"
AP3|{SSHA}XK|"This is test"
....
etc
---------
test.sh has... (1 Reply)
Discussion started by: hudson03051nh
1 Replies
4. Shell Programming and Scripting
There's a small SH script I'm trying to write where it will get the current month and find a log file that is based on the date.
Example: Today is February, so the log file is going to be 201102.log (2011 + 02)
An additional thing is that if today is the 1st of a month, it will also find the log... (3 Replies)
Discussion started by: kooshi
3 Replies
5. Shell Programming and Scripting
Hi,
I have a file which has xml data but all in single line
Ex -
<?xml version="1.0"?><User><Name>Robert</Name><Location>California</Location><Occupation>Programmer</Occupation></User>
I want to split the data in proper xml format Ex-
<?xml version="1.0"?>
<User>
<Name>Robert</Name>... (6 Replies)
Discussion started by: avishek007
6 Replies
6. Shell Programming and Scripting
Hi All
I have the following code
sub pall_nvrm {
my $cmd = `pall -w "/u/ab/scripts/dev/nvrmerros/nvrmpaller"`;
print $cmd;
}
if i run
pall -w "/u/ab/scripts/dev/nvrmerros/nvrmpaller"
in a shell i get this sort of out put
eagley:
boxted:
cadle:
eabost:
hales: (3 Replies)
Discussion started by: ab52
3 Replies
7. Shell Programming and Scripting
Hi,
I'm facing a problem in mailing attachments using uuencode in mailx.
I got to attach a couple of flatfiles. I'm able to attach and mail the files successfully.
But there is a problem in the format of the flatfiles when they are received as an attachemnt.
For Example :
Consider... (0 Replies)
Discussion started by: Sindhuap
0 Replies
8. Shell Programming and Scripting
Hi
I am executing below command to do summation on 46th coloumn.
cat File1| awk -F"|" '{p += $46} END { printf"Column Name | SUM | " p}'
I am getting output as
Column Name | SUM | 1.01139e+10
Here I want output in Proper decimal format. Can someone tell me what change is required for same? (1 Reply)
Discussion started by: sanranad
1 Replies
9. Shell Programming and Scripting
Hi Guys,
I need to grep below data in this format
backup_id
creation
expiration
policy
sched_label
backup_id = picoserver38_1212077050, version = 2
creation = 05/29/2008 18:04:10 (1212077050)
expiration = 06/29/2008 18:04:10 (1214755450)
retention_level = 3, fragment = 2, file_num = 1... (14 Replies)
Discussion started by: manalisharmabe
14 Replies
10. Shell Programming and Scripting
Hello Guys,
I have a file say FILE1.txt contains below data:-
A
B
C
D
E
F
G
H
I
J
K
L
I need the output in another file as FILE2 as:-
'A', 'B', 'C', 'D', 'E', (7 Replies)
Discussion started by: jassi10781
7 Replies
LEARN ABOUT PHP
sqlsrv_rows_affected
SQLSRV_ROWS_AFFECTED(3) SQLSRV_ROWS_AFFECTED(3)
sqlsrv_rows_affected - Returns the number of rows modified by the last INSERT, UPDATE, or DELETE query executed
SYNOPSIS
int sqlsrv_rows_affected (resource $stmt)
DESCRIPTION
Returns the number of rows modified by the last INSERT, UPDATE, or DELETE query executed. For information about the number of rows
returned by a SELECT query, see sqlsrv_num_rows(3).
PARAMETERS
o $stmt
- The executed statement resource for which the number of affected rows is returned.
RETURN VALUES
Returns the number of rows affected by the last INSERT, UPDATE, or DELETE query. If no rows were affected, 0 is returned. If the number of
affected rows cannot be determined, -1 is returned. If an error occurred, FALSE is returned.
EXAMPLES
Example #1
sqlsrv_rows_affected(3) example
<?php
$serverName = "serverNamesqlexpress";
$connectionInfo = array( "Database"=>"dbName", "UID"=>"username", "PWD"=>"password" );
$conn = sqlsrv_connect( $serverName, $connectionInfo);
if( $conn === false ) {
die( print_r( sqlsrv_errors(), true));
}
$sql = "UPDATE Table_1 SET data = ? WHERE id = ?";
$params = array("updated data", 1);
$stmt = sqlsrv_query( $conn, $sql, $params);
$rows_affected = sqlsrv_rows_affected( $stmt);
if( $rows_affected === false) {
die( print_r( sqlsrv_errors(), true));
} elseif( $rows_affected == -1) {
echo "No information available.<br />";
} else {
echo $rows_affected." rows were updated.<br />";
}
?>
SEE ALSO
sqlsrv_num_rows(3).
PHP Documentation Group SQLSRV_ROWS_AFFECTED(3)