MSSQL_FIELD_LENGTH(3)MSSQL_FIELD_LENGTH(3)mssql_field_length - Get the length of a fieldSYNOPSIS
int mssql_field_length (resource $result, [int $offset = -1])
DESCRIPTION
Returns the length of field no. $offset in $result.
PARAMETERS
o $result
- The result resource that is being evaluated. This result comes from a call to mssql_query(3).
o $offset
- The field offset, starts at 0. If omitted, the current field is used.
RETURN VALUES
The length of the specified field index on success or FALSE on failure.
EXAMPLES
Example #1
mssql_field_length(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 [name], [age] FROM [php].[dbo].[persons]');
// Print the field length
echo 'The field 'age' has a data length of ' . mssql_field_length($query, 1);
// Free the query result
mssql_free_result($query);
?>
The above example will output something similar to:
The field 'age' has a data length of 4
NOTES
Note
Note to Windows Users
Due to a limitation in the underlying API used by PHP (MS DBLib C API), the length of VARCHAR fields is limited to 255. If you need
to store more data, use a TEXT field instead.
SEE ALSO mssql_field_name(3), mssql_field_type(3).
PHP Documentation Group MSSQL_FIELD_LENGTH(3)
Check Out this Related Man Page
MSSQL_FIELD_NAME(3)MSSQL_FIELD_NAME(3)mssql_field_name - Get the name of a fieldSYNOPSIS
string mssql_field_name (resource $result, [int $offset = -1])
DESCRIPTION
Returns the name of field no. $offset in $result.
PARAMETERS
o $result
- The result resource that is being evaluated. This result comes from a call to mssql_query(3).
o $offset
- The field offset, starts at 0. If omitted, the current field is used.
RETURN VALUES
The name of the specified field index on success or FALSE on failure.
EXAMPLES
Example #1
mssql_field_name(3) example
<?php
// Send a select query to MSSQL
$query = mssql_query('SELECT [username], [name], [email] FROM [php].[dbo].[userlist]');
echo 'Result set contains the following field(s):', PHP_EOL;
// Dump all field names in result
for ($i = 0; $i < mssql_num_fields($query); ++$i) {
echo ' - ' . mssql_field_name($query, $i), PHP_EOL;
}
// Free the query result
mssql_free_result($query);
?>
The above example will output something similar to:
Result set contains the following field(s):
- username
- name
- email
SEE ALSO mssql_field_length(3), mssql_field_type(3).
PHP Documentation Group MSSQL_FIELD_NAME(3)
I have a file with three fields, where the first two fields are of fixed length, left justified, and right padded with spaces. The third field is truncated to the length of the data (max length 5), and possibly contains a single letter. Each field is separated by an additional space. How can I... (1 Reply)
Hi there,
Someone there who knows how to fix this problem.
using PHP, in my .ini file I have the following line:
query = "SELECT * FROM interfaces WHERE intf_id=$key1 ORDER BY intf_code"
(where $key1 had to be variable.)
While scripting I do this:
$key1=5;
$query =... (3 Replies)
hi everybody
i would to select the last field of a file
here as you can see i select the field number 8
y=`cat sortie2 | grep "^"| grep "starting"| awk '{ print $8}'`
but line can containt more or less field in never know, i just know is the last one
so i wondering to know if is... (3 Replies)
hi
i have to modify a number accross a file
for example in the following file
name - abc
age 20
name - def
age 25
name - pqr
age 54
name - xyz
age 32
i want the number against all age to be say 50. like this
name - abc
age 50
name - def (2 Replies)
Ok here's my pickle. I have a file in which every line must be the same length. Each field within the line is a certain length. None of these can be changed. What I need to do is look at a specific field within this file, let's say it starts with character 30 and ends with 50. If this field is... (3 Replies)
Hi,
I have a shell script that returns 10 records for the column Name and age from a select query. Where when i store those data in retrieve_list.txt file i need to store the data in a particular format like:-
$Jason$30
$Bill$23
$Roshan$25
Here is my script:
1)... (15 Replies)
Hi Friends,
Can u please help mw with the following query .
I need to run a database sql statement to select particular fields from a table.I need to store the retrieved filed values into variables so that i can print it in a specific format. But the particular select query retrieves more... (12 Replies)
Hi Folks!!
I would like to convert each and every output of my query to the excel column wise. Let me give you an example
The first attachment (cr.jpg) is the one which i am getting out of a query and the fields are delimited with a '|' (pipe) symbol. I would like to convert each field into a... (4 Replies)
Hi to all,
this is my first time in the forum...and I know some basic's about UNIX...
I want to write an expression to validate a field.
field is varchar2, length is 5, can be from '00001' to '99999'.
no loops or if condition, just check the value if between these two numbers it is OK if it is... (2 Replies)
I have a field MPN-BANK-NUMBERO:006,00:N in a file FILE1
How can i display the length of the Bank Number.Any idea ?
The output shud take the following format
FILE 1 6
Where 1 is the starting position and 6 is the Ending position. (9 Replies)
Hello,
Is there anyway that I can align a pipe delimited text file by the maxium field length where the field is separated out by pipes for large text files with more than
100,000 rows?
So, far I have searched other forums and google about aligning text files in unix and I have noticed that... (7 Replies)
Hello Group,
What I have is a database with about a dozen fields and one being "City".
What I would like to do is to have a custom query on a single field for multiple items (cities) but I don't know how to do this. I know this is probably kids play for most of you but I am lost. What I have... (4 Replies)
Hi all,
I have a requirement to replace a field with a character as per the length of the field.
Suppose i have a file where second field is of 20 character length. I want to replace second field with 20 stars (*). like ********************
As the field is not a fixed one, i want to do the... (2 Replies)
Dear community,
I have to make a query from a database and apply the following filter:
select filed1,field2,field3
from database
where (field1 contains only alphanumeric chars and NOT only numbers)
Let me explain better what I Need:
21test ==> OK
test ==> OK
test21 ==> OK
te21st ==>... (6 Replies)
function one {
echo "Who is here?"
read name
echo "Who old are you $name?"
read age
if ; then
Sam="$age"
else
Sam="26"
fi
if ; then
Jack="$age"
else
Jack="49"... (4 Replies)