I am trying to write an expect script for remote server login. At some point of time I need to telnet based on the output of grep command. Based on the output I need to select the ip address of the server. How can I write an expect script for the same. The output of the grep command is as follows:... (1 Reply)
Hi all, First post so go easy guys.......
I've seen this asked before on some other forums but never properly/fully answered.
My problem involves the automation of an SFTP script sending from F-Secure (ssh2) HP-UX, to Windows FTP server (ssh2) running VShell. We've set up SSH keys but while... (8 Replies)
When i execute rm -f $1 via a script file named rmf, it is not deleting all the files, say starting with "sec". i have execute rmf for many times to remove all the occurrences...
$rmf sec* - this should delete all files starting with sec, but not.
The rm -f sec* is working fine. kindly help... (3 Replies)
I would appreciate any help (sed / awk / perl) on the following question. I have the file in the following format. Note that the records are separated by the line that starts with the word "TRACE".I want the 5th and 6th values on the line starting with "TRACE" to be repeated down the file until the... (3 Replies)
Hi,
I am new to Unix shell scripting.I have a requirement where I have to search for a particular file in a Unix directory based on some criterian of the content of the file.Actually there would be two files with same name and then I have zip them together and stoe in the same directory.
As... (1 Reply)
Hi , I need little help regarding my script.
I have a file called abc which looks below.
Rohan 12
Rakesh 23
Ajay 25
Another file looks like this (xyz).
Mumbai
Delhi
Madras
How would i add column mentioned in second file so that the file looks as below.
Rohan 12 Mumbai... (2 Replies)
Hi experts,
I have two values in the file :
For example :
partcamt = 72.90
partdamt=27.9
I need to convert these values into 6 digits and ignore the "." sign so that the desired desired output is :
total value= 0072000027900
Currently I am using the following code :
... (3 Replies)
Iam new to shell scripting,i have a text file in my $home directory mentioned below.
201249_BAN_EXCL.TXT
I need to refer the above file in my automated script but the number 201249 used to change every week.How can i refer to this file everyt time without renaming it manually?
Thanks in... (7 Replies)
I have a shell script which calls a sql script.
But in the output file I'm getting an additional '^L' character.
Please advise how this is to be handled.
spool /opt/oracle/DART/out/Indx_rebuild.out
SET SERVEROUTPUT ON
SET VERIFY OFF
SET HEADING OFF
SET NEWPAGE NONE
SELECT 'ALTER INDEX '||... (2 Replies)
i have a o/p from find command that needs to be formatted
currently when i'm running
find . -name "v.info"
it is giving below o/p
/o/a/b/c/v.info
/o/a/b/c/d/v.info
/o/aa/bb/cc/v.info
/o/aa/bb/cc/dd/v.info
my requirement is if v.info is coming under sub-directories it shul be... (15 Replies)
Discussion started by: nikhil jain
15 Replies
LEARN ABOUT PHP
mssql_fetch_field
MSSQL_FETCH_FIELD(3)MSSQL_FETCH_FIELD(3)mssql_fetch_field - Get field informationSYNOPSIS
object mssql_fetch_field (resource $result, [int $field_offset = -1])
DESCRIPTION mssql_fetch_field(3) can be used in order to obtain information about fields in a certain query result.
PARAMETERS
o $result
- The result resource that is being evaluated. This result comes from a call to mssql_query(3).
o $field_offset
- The numerical field offset. If the field offset is not specified, the next field that was not yet retrieved by this function is
retrieved. The $field_offset starts at 0.
RETURN VALUES
Returns an object containing field information.
The properties of the object are:
o name - column name. if the column is a result of a function, this property is set to computed#N, where #N is a serial number.
o column_source - the table from which the column was taken
o max_length - maximum length of the column
o numeric - 1 if the column is numeric
o type - the column type.
EXAMPLES
Example #1
mssql_fetch_field(3) example
<?php
// Connect to MSSQL and select the database
mssql_connect('MANGOSQLEXPRESS', 'sa', 'phpfi');
mssql_select_db('php');
// Send a select query to MSSQL
$query = mssql_query('SELECT * FROM [php].[dbo].[persons]');
// Construct table
echo '<h3>Table structure for 'persons'</h3>';
echo '<table border="1">';
// Table header
echo '<thead>';
echo '<tr>';
echo '<td>Field name</td>';
echo '<td>Data type</td>';
echo '<td>Max length</td>';
echo '</tr>';
echo '</thead>';
// Dump all fields
echo '<tbody>';
for ($i = 0; $i < mssql_num_fields($query); ++$i) {
// Fetch the field information
$field = mssql_fetch_field($query, $i);
// Print the row
echo '<tr>';
echo '<td>' . $field->name . '</td>';
echo '<td>' . strtoupper($field->type) . '</td>';
echo '<td>' . $field->max_length . '</td>';
echo '</tr>';
}
echo '</tbody>';
echo '</table>';
// Free the query result
mssql_free_result($query);
?>
SEE ALSO mssql_field_seek(3).
PHP Documentation Group MSSQL_FETCH_FIELD(3)