actuall I did forget the single quote, but it isn't referring to a negative number. It's part of a sample script. I should have included the whole thing.
what I wanted to know was how the * and $ mean what my book says it means, because I don't see it (particularly the dollar sign at the end of the grep expression; I know what it means in reference to the positional parameter).
There are files on a remote server with the file name ending in "mm-dd-yy.txt". The script I am running is:
mls "Daily_Service_Text_File_*" /my/local/dir/Filelisting.txt
nawk -F_ -f file.awk /my/local/dir/Filelisting.txt | sort -k1n | cut -f2- | tail -1
It worked up too "12-31-07.txt" but... (3 Replies)
I found this very useful perl script that will check a remote ftp server, search for files of a specific time and get them. When I run the script it works, but it gave me the following error:
Couldn't get filename_12-13-07.txt Bad file number
What in this script would cause this? I know... (2 Replies)
Hi people I am trying to learn this code and see how it relates to the old DOS days. I have a line of code that I am not sure what the first part does. Any help will be greatly appreciated.
It is from a Save command that is used to backup files to a directory.
It goes like this
if ;then... (10 Replies)
Hi,
I have a script at the moment of which reads in simply what the latest version is within a folder i.e. v001, v002, v003 etc and then stores this latest version in a variable i.e. $LATEST would echo v003. I have then cut this string so that I only consider the 003 part. I would then like to... (3 Replies)
I'm reading about command substitutions and came across this little function in my book:
function lsd
{
date=$1
ls -l |grep -i "^.\{42\}$date"|cut -c55-
}
it's a little example which is supposed to select files by modification date, given as an argument to the function.
I... (3 Replies)
I am trying to simplify the coding in a script I was given, but it was written 7-10 years ago and is pretty complicated. below is a tidbit, if someone can break it down for me I would appreciate it.
sub ParseText
{
my ($line, $key, $value, $sub, $script);
foreach $line (@_)... (0 Replies)
I have a string, eg 7f30.3 and I want to store things in the following way
npos = 7
decform = true
width = 30
ndp = 3
I need to read each character one by one. I am coding in fortran but I can try to code it should answer be given in C in the above way. (2 Replies)
Hi folks,
I have a scenario to convert the update statements into insert statements using shell script (awk, sed...) or in database using regex.
I have a bunch of update statements with all columns in a file which I need to convert into insert statements.
UPDATE TABLE_A SET COL1=1 WHERE... (0 Replies)
Dear experts,
I am a relative novice in the Unix and came across a very useful code that I regularly use for my research blindly. I am wondering if any of the professional members could kindly briefly explain to me what the code actually does?
Many thanks in advance
The script is
awk... (4 Replies)
Discussion started by: arsalane
4 Replies
LEARN ABOUT PHP
sqlsrv_num_fields
SQLSRV_NUM_FIELDS(3)SQLSRV_NUM_FIELDS(3)sqlsrv_num_fields - Retrieves the number of fields (columns) on a statementSYNOPSIS
mixed sqlsrv_num_fields (resource $stmt)
DESCRIPTION
Retrieves the number of fields (columns) on a statement.
PARAMETERS
o $stmt
- The statment for which the number of fields is returned. sqlsrv_num_fields(3) can be called on a statement before or after
statement execution.
RETURN VALUES
Returns the number of fields on success. Returns FALSE otherwise.
EXAMPLES
Example #1
sqlsrv_num_fields(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 = "SELECT * FROM Table_1";
$stmt = sqlsrv_query($conn, $sql);
if( $stmt === false) {
die( print_r( sqlsrv_errors(), true));
}
$numFields = sqlsrv_num_fields( $stmt );
while( sqlsrv_fetch( $stmt )) {
// Iterate through the fields of each row.
for($i = 0; $i < $numFields; $i++) {
{
echo sqlsrv_get_field($stmt, $i)." ";
}
echo "<br />";
}
?>
SEE ALSO sqlsrv_field_metadata(3), sqlsrv_fetch(3), sqlsrv_get_field(3).
PHP Documentation Group SQLSRV_NUM_FIELDS(3)