Hi everyone, first post here so please be gentle :-)
I normally likle to script in Bourne Shell simply for guarenteed compatibility across any system I might run across but this latest problem has me stumped.
Arrays is a rather significant construct missing from sh and after finding a way to... (2 Replies)
Hi,
can we use arrays in shell script?
I have this so far:
#!/bin/sh
isql -Usa -P -S DBSERVER -o output << EOF
sp_transactions "state", "prepared", "xactname"
go
/
EOF
the file 'output'' will be have many entries and I want to caputre the transaction names only: grep 000 output works... (3 Replies)
I have a bash shell script that sources a data file, the data file has array values such as:
#--data file ---#
sg_name="db1"
sg_size="12892"
sg_allow="50000"
sg_name="db2"
sg_size="12892"
sg_allow="50000"
export sg_name sg_size sg_allow
#--end data file --#
In my shell script... (8 Replies)
Hi guys
could you please post links that explain how to use and manipulate arrays in c shell (.csh files) ? examples are useful too :rolleyes: (5 Replies)
hi guys,
i have the following code in C shell..
set i=0
while ($i < 11)
master_array=${ARRAY}
i++
done
it gives me error at line 3: Variable syntax.
what is wrong here? any help is appreciated. (4 Replies)
I have three arrays. One is Master array and that has list of other array in config file.
for e.g (for simplicity I have only defined array with 2 elements each)
set +A MASTERARRAY SQLUPDATE_ONETIME SQLUPDATE_DAILY END_OF_ARRAY
set +A SQLUPDATE_ONETIME update12 update22 END_OF_ARRAY... (4 Replies)
I have 2 arrays abc and xyz
abc = ( a b c d e f g h i j k l m n o p q r s t u v w x y z )
and
xyz = ( b c d e f )
lets assume a .... z are the file name.
I have to perform a pattern replacement on each file present in abc array accept the files i have in xyz array. and i am doing... (4 Replies)
I have defined an array like this:
set -A MYARRAY
MYARRAY=file1
MYARRAY=file2
MYARRAY=file3
MYARRAY=file4
i=0
while } ]]
do
echo "File Name $i :" ${MYARRAY}
i=`expr $i + 1 `
echo "value of i=" $i
done
This works perfectly and shows... (4 Replies)
Discussion started by: Hangman2
4 Replies
LEARN ABOUT PHP
mssql_num_fields
MSSQL_NUM_FIELDS(3)MSSQL_NUM_FIELDS(3)mssql_num_fields - Gets the number of fields in resultSYNOPSIS
int mssql_num_fields (resource $result)
DESCRIPTION mssql_num_fields(3) returns the number of fields in a result set.
PARAMETERS
o $result
- The result resource that is being evaluated. This result comes from a call to mssql_query(3).
RETURN VALUES
Returns the number of fields, as an integer.
EXAMPLES
Example #1
mssql_num_fields(3) example
<?php
// Connect to MSSQL and select the database
$link = mssql_connect('KALLESPCSQLEXPRESS', 'sa', 'phpfi');
mssql_select_db('php', $link);
// Select some data from our database
$data = mssql_query('SELECT [name], [age] FROM [php].[dbo].[persons]');
// Construct a table
echo '<table border="1">';
$header = false;
// Iterate through returned results
while ($row = mssql_fetch_array($data)) {
// Build the table header
if (!$header) {
echo '<thead>';
echo '<tr>';
for ($i = 1; ($i + 1) <= mssql_num_fields($data); ++$i) {
echo '<td>' . ucfirst($row[$i]) . '</td>';
}
echo '</tr>';
echo '</thead>';
echo '<tbody>';
$header = true;
}
// Build the row
echo '<tr>';
foreach($row as $value) {
echo '<td>' . $value . '</td>';
}
echo '</tr>';
}
// Close table
echo '</tbody>';
echo '</table>';
// Clean up
mssql_free_result($data);
mssql_close($link);
?>
SEE ALSO mssql_query(3), mssql_fetch_field(3), mssql_num_rows(3).
PHP Documentation Group MSSQL_NUM_FIELDS(3)