ODBC_RESULT(3) 1 ODBC_RESULT(3)odbc_result - Get result dataSYNOPSIS
mixed odbc_result (resource $result_id, mixed $field)
DESCRIPTION
Get result data
PARAMETERS
o $result_id
- The ODBC resource.
o $field
- The field name being retrieved. It can either be an integer containing the column number of the field you want; or it can be a
string containing the name of the field.
RETURN VALUES
Returns the string contents of the field, FALSE on error, NULL for NULL data, or TRUE for binary data.
EXAMPLES
The first call to odbc_result(3) returns the value of the third field in the current record of the query result. The second function call
to odbc_result(3) returns the value of the field whose field name is "val" in the current record of the query result. An error occurs if a
column number parameter for a field is less than one or exceeds the number of columns (or fields) in the current record. Similarly, an
error occurs if a field with a name that is not one of the fieldnames of the table(s) that is(are) being queried.
Example #1
odbc_result(3) examples
<?php
$item_3 = odbc_result($Query_ID, 3);
$item_val = odbc_result($Query_ID, "val");
?>
NOTES
Field indices start from 1. Regarding the way binary or long column data is returned refer to odbc_binmode(3) and odbc_longreadlen(3).
PHP Documentation Group ODBC_RESULT(3)
Check Out this Related Man Page
FBSQL_RESULT(3) 1 FBSQL_RESULT(3)fbsql_result - Get result dataSYNOPSIS
mixed fbsql_result (resource $result, [int $row], [mixed $field])
DESCRIPTION
Returns the contents of one cell from a FrontBase $result set.
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 fbsql_result(3).
Calls to fbsql_result(3) should not be mixed with calls to other functions that deal with the result set.
PARAMETERS
o $
result -A result identifier returned by fbsql_query(3) or fbsql_db_query(3).
o $row
-
o $field
- Can be the field's offset, or 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...'), use 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 SEE ALSO
Recommended high-performance alternatives: fbsql_fetch_row(3), fbsql_fetch_array(3), fbsql_fetch_assoc(3), fbsql_fetch_object(3).
PHP Documentation Group FBSQL_RESULT(3)
Hallo All, this is my code below. The problem happens under section A because field $9 sometimes does not contain a number it contains a (:) and a number is contained in field $10 as result under sectionC we get a syntax error @
echo "scale=1; $aa+$ee+$ff"|bc > /tmp/pax/c3.txt
So i need to... (5 Replies)
Hello,
I have a record which split with "," I would like to check..if the field is empty and it will field "NIL" into the field.
input
45111,40404,peter,,0303403,0,030304,john,,9,0,
output
45111,40404,peter,NIL,0303403,0,030304,john,NIL,9,0, (8 Replies)
Hi all, I need some help on switching field/column values. For example I have a file name data.txt which contains:
a b
a b
a b
and I want to switch a and b and save it to the same file.
the file data.txt then will have:
b a
b a
b a
The problem is, well, I know how to... (7 Replies)
pls explain me how this works....
DECODE (SUBSTR (field, 1, 1),'''', '''''' || field || '''','''' || field || '''')
here field is a column in an oracle table.... (7 Replies)
I have a file as:
A,B,C,D,E
G,H,I,J,K
I need to find if fourth field is blank or has a space and print that line to other file.
I tried using awk but am not getting the desired result.
Pls help. (6 Replies)
I have the test data with 10 column separated by comma and each column has more than 1000000 rows. Can anyone help me to find empty field in all columns and delete that empty field alone and lift that column up by one row.
Data with empty field:
A74203XYZ,A21718XYZ,A72011XYZ,A41095XYZ,... (7 Replies)
Hello,
I have a file with two fields. The first field repeats itself for quite a while but the second field changes. What I want to do is to go through the first column until its value changes (and while it doesn't, verify that the second field is in a sequence from 0-15).
Example input:
... (13 Replies)
I saw some recent posts where I thought the terms "field" and "column" were being misused. I work with data a lot, and have my opinions. I'm wondering if those opinions are correct.
***** Rows seem clear - I don't think there is any controversy about what a row is, either for database or text... (10 Replies)
Hi Guys,
I have a file as follows. Here is my story:
For each field, the string in the 5th column needs to be searched in other fields of the same column and counted if the 1st column of the field is different from that of the primary field. BTW, the unique strings of 1st column need to be... (6 Replies)
I'm not really sure how to explain this but I will try. In the attached file if $4=$4 and $5="-" then the last record is 1 and the one above that is 2, etc...
However, $4=$4 and $5="-" then the first record is 1 and the one below that is 2, etc...
"-" example:
chr10 90694830 90695123... (7 Replies)
Hi, all
I need your help and suggestions.
I want to print particular strings in a field of a csv file and show them in terminal. Here is an example of the csv file.
SourceFile,Airspeed,GPSLatitude,GPSLongitude,Temperature,Pressure,Altitude,Roll,Pitch,Yaw... (9 Replies)
Hi All,
I currently have flat file with 32 columns. The field delimiter is cntl-A ( \x01). The file has been extracted from an oracle table using a datastage job. However, in the 6th field, the data contains additional control -A characters which came as a part of the table data.
I need... (12 Replies)
Split column data if the table has n number of column's with some record then how to split n number of colmn's line by line with records
Table
---------
Col1 col2 col3 col4 ....................col20
1 2 3 4 .................... 20
a b c d .................... v
... (11 Replies)
Each record coming with column names. I have to replace them in each record as shown below
TIME=20181219110000261|CHAN=FMBKHJBAAAADPCFNAAAAAABA|EVNT=SWIclst|VALU=Session FMBKHJBAAAADPCFNAAAAAABA started|SRC=NSS|UCPU=0|SCPU=0
Output should look like: ... (9 Replies)