Hi,
I justs started learning Unix on my own.
I have a question:
What command can I use when I need to read in part of the file into another file?
I remember I saw it somewhere but I don't know what it is.
Thanks (3 Replies)
Hi there,
I am lil confused with the following issue.
I have a File, which has the following header: IMSHRATE_043008_101016
a sample detailed record is :9820101 A982005000CAVG030108000000000000010169000MAR 2008
9820102 MAR 2008 D030108
... (1 Reply)
Ok, I am brand new to UNIX and I am trying to learn a cross between basic script and database use. I had got some ideas off the net on simple ideas for learning UNIX. I am working on creating a simple phone book program that allows myself to enter our employees from work into a phone book text... (0 Replies)
For a field format such as AAL1001_MD82, how do I select(and use in if statement) only the last four elements( in this case MD82) or the first three elements (in this case AAL)?
For instance, how do I do the following - if first three elements of $x == yyy, then ... (5 Replies)
Hi Guys
I need to have a shell script which reads a log file and insert a part of each line into the database. Some sample lines in the file are as below.
20091112091359 MED_RQACK : user_data=60173054304,100232120,20091112091359,;ask_status=0;ask_reason=OK;msg_id=20091112091319... (5 Replies)
Hi,
I have 80 large files, from which I want to get a specific value to run a Bash script. Firstly, I want to get the part of a file which contains this:
Name =A
xxxxxx
yyyyyy
zzzzzz
aaaaaa
bbbbbb
Value = 57
This is necessary because in a file there are written more lines which... (6 Replies)
I have files named with different prefixes. From each I want to extract the first line containing a specific string, and then print that line along with the prefix.
I've tried to do this with a while loop, but instead of printing the prefix I print the first line of the file twice.
Files:... (3 Replies)
Hello
let me explain senario.
there is a file which name is config and it store main software variable:
file main.conf contents:
update="1"
log_login="0"
allow_ports=""
deny_ports="21,22,23"
and there is a file which name is ports.txt
file ports.txt contents:
25,26,27
i... (3 Replies)
I'm working on Aix 6.1 and using ksh shell.
The below works fine on Linux bash or ksh shell .
while IFS= read -r dirpath ; do
echo "Hi"
done <<<"$var"
However, any such while loop that reads the input from file or variable using <<< fails on Aix system with the below error:
Below... (2 Replies)
Discussion started by: mohtashims
2 Replies
LEARN ABOUT PHP
mssql_result
MSSQL_RESULT(3)MSSQL_RESULT(3)mssql_result - Get result dataSYNOPSIS
string mssql_result (resource $result, int $row, mixed $field)
DESCRIPTION mssql_result(3) returns the contents of one cell from a MS SQL result set.
PARAMETERS
o $result
- The result resource that is being evaluated. This result comes from a call to mssql_query(3).
o $row
- The row number.
o $field
- Can be the field's offset, the field's name or the field's table dot field's name (tablename.fieldname). If the column name has
been aliased ('select foo as bar from...'), it uses the alias instead of the column name.
Note
Specifying a numeric offset for the $field argument is much quicker than specifying a fieldname or tablename.fieldname argu-
ment.
RETURN VALUES
Returns the contents of the specified cell.
EXAMPLES
Example #1
mssql_result(3) example
<?php
// Send a select query to MSSQL
$query = mssql_query('SELECT [username] FROM [php].[dbo].[userlist]');
// Check if there were any records
if (!mssql_num_rows($query)) {
echo 'No records found';
} else {
for ($i = 0; $i < mssql_num_rows($query); ++$i) {
echo mssql_result($query, $i, 'username'), PHP_EOL;
}
}
// Free the query result
mssql_free_result($query);
?>
The above example will output something similar to:
Kalle
Felipe
Emil
Ross
Example #2
Faster alternative to above example
<?php
// Send a select query to MSSQL
$query = mssql_query('SELECT [username] FROM [php].[dbo].[userlist]');
// Check if there were any records
if (!mssql_num_rows($query)) {
echo 'No records found';
} else {
while ($row = mssql_fetch_array($query)) {
echo $row['username'], PHP_EOL;
}
}
// Free the query result
mssql_free_result($query);
?>
NOTES
Note
When working on large result sets, you should consider using one of the functions that fetch an entire row (specified below). As
these functions return the contents of multiple cells in one function call, they're MUCH quicker than mssql_result(3).
SEE ALSO
Recommended high-performance alternatives: mssql_fetch_row(3), mssql_fetch_array(3), mssql_fetch_assoc(3), mssql_fetch_object(3).
PHP Documentation Group MSSQL_RESULT(3)