FBSQL_FIELD_TYPE(3) 1 FBSQL_FIELD_TYPE(3)fbsql_field_type - Get the type of the specified field in a resultSYNOPSIS
string fbsql_field_type (resource $result, [int $field_offset])
DESCRIPTION fbsql_field_type(3) is similar to the fbsql_field_name(3) function, but the field type is returned instead.
PARAMETERS
o $
result -A result identifier returned by fbsql_query(3) or fbsql_db_query(3).
o $field_offset
- The numerical offset of the field. The field index starts at 0.
RETURN VALUES
Returns the field type, as a string.
This can be one of int, real, string, blob, and others as detailed in the FrontBase documentation.
EXAMPLES
Example #1
fbsql_field_type(3) example
<?php
fbsql_connect("localhost", "_SYSTEM", "");
fbsql_select_db("wisconsin");
$result = fbsql_query("SELECT * FROM onek;");
$fields = fbsql_num_fields($result);
$rows = fbsql_num_rows($result);
$i = 0;
$table = fbsql_field_table($result, $i);
echo "Your '" . $table . "' table has " . $fields . " fields and " . $rows . " records <br />";
echo "The table has the following fields <br />";
while ($i < $fields) {
$type = fbsql_field_type($result, $i);
$name = fbsql_field_name($result, $i);
$len = fbsql_field_len($result, $i);
$flags = fbsql_field_flags($result, $i);
echo $type . " " . $name . " " . $len . " " . $flags . "<br />";
$i++;
}
fbsql_close();
?>
SEE ALSO fbsql_field_name(3).
PHP Documentation Group FBSQL_FIELD_TYPE(3)
Check Out this Related Man Page
FBSQL_NUM_ROWS(3) 1 FBSQL_NUM_ROWS(3)fbsql_num_rows - Get number of rows in resultSYNOPSIS
int fbsql_num_rows (resource $result)
DESCRIPTION
Gets the number of rows in the given $result set.
This function is only valid for SELECT statements. To retrieve the number of rows returned from a INSERT, UPDATE or DELETE query, use
fbsql_affected_rows(3).
PARAMETERS
o $
result -A result identifier returned by fbsql_query(3) or fbsql_db_query(3).
RETURN VALUES
Returns the number of rows returned by the last SELECT statement.
EXAMPLES
Example #1
fbsql_num_rows(3) example
<?php
$link = fbsql_connect("localhost", "username", "password");
fbsql_select_db("database", $link);
$result = fbsql_query("SELECT * FROM table1;", $link);
$num_rows = fbsql_num_rows($result);
echo "$num_rows Rows
";
?>
SEE ALSO fbsql_affected_rows(3), fbsql_connect(3), fbsql_select_db(3), fbsql_query(3).
PHP Documentation Group FBSQL_NUM_ROWS(3)
hello
how can i print to screen the result of this command ?
echo "pwd | sed 's/.*foo//'"
when i type it im geting it printed as string "pwd | sed 's/.*DevEnv//'"
and not the result of the operetion.
tnx (2 Replies)
I have a input file with formating:
6000000901 ;36200103 ;h3a01f496 ;
2000123605 ;36218982 ;heefa1328 ;
2000273132 ;36246985 ;h08c5cb71 ;
2000041207 ;36246985 ;heef75497 ;
Each fields is seperated by semi-comma. Sometime, the second files is... (6 Replies)
Hi All,
I have a file which has the conetent like this:-
SELECT F1, F2, F3, F1, F5, F2 FROM T1
I Want to replace multiple occurences of F1 and F2 with single field.
Required Output Should be:
SELECT F1, F2, F3,F5 FROM T1
Please guide me how can i do this?
Thanks in Advance.
Dilip (1 Reply)
Hi,
I have a file that has 300 records with a load of fields. two of them are:
field_1 has between 8-9 bytes i.e. 012345678, 0123456789
field_2 has 10 bytes i.e. 01234567890
I want to be able to echo out the total of each of these fields i.e.
200 (have 8 - 9 bytes)
100 (have 10 bytes)... (3 Replies)
Hi everyone,
I want to write a function which calculates the space needed between fields, to generate a table with aligned fields, like when you type "ls -l", the operating system generates a table with beautifully aligned fields.
I've got this code so far:
for line in $(cat tmpSearch)... (2 Replies)
Hi all,
I'm trying to count the fields in a file and I'm not getting back the desired result. I was wondering if anyone can help.
This is the code:
#!/bin/bash
a=$(awk '{print NF}' foobar)
if
then
echo "this works"
else
echo "no it's $a instead"
fi
The foobar file contains... (1 Reply)
Hi,
I have a huge text file. It looks like
abcde bangalo country 12345 lastfield
i want to get first 3 characters from field1 and first 3 characters from field 2 and insert the result as a new field. example the result should be:
abcde bangalo abcban country 12345 lastfield
Please... (4 Replies)
I'm trying extract a number of filename fields from a log file and copy them out as separate rows in a text file so i can load them into a table. I'm able to get the filenames but the all appear on one line. I tried using the cut command with the -d (delimiter) option but cant seem to make it... (1 Reply)
I am trying to echo all fields except for the last field.
I want to include the field seperator, but it is removed.
echo "a;s;v;g" | awk -F ";" '{$(NF--)=""; print}'
a s v
I want an output like this:
a;s;v; (3 Replies)
I have made a table PRD_WORK_LM.test and it contains one field, ctrl_test. This field contains a 0 or a 1. I want to write a unix script that goes like this:
IF ctrl_test = 1 THEN ... ELSE exit FI
How can I write this in a script? Do I have to do this within bteq? or outside bteq? can... (5 Replies)
Hi All,
We are trying to pull out data from below table, the table contains four fields and out of which last two fields are having sub-fields with delimiter $, we want to identify number "1" position in the 3rd field and from 4th field need to extract the information from the same position.
... (4 Replies)