FBSQL_INSERT_ID(3) 1 FBSQL_INSERT_ID(3)fbsql_insert_id - Get the id generated from the previous INSERT operationSYNOPSIS
int fbsql_insert_id ([resource $link_identifier])
DESCRIPTION
Gets the id generated from the previous INSERT operation which created a DEFAULT UNIQUE value.
Note
The value of the FrontBase SQL function fbsql_insert_id(3) always contains the most recently generated DEFAULT UNIQUE value, and is
not reset between queries.
PARAMETERS
o $
link_identifier -A FrontBase link identifier returned by fbsql_connect(3) or fbsql_pconnect(3).If optional and not specified, the
function will try to find an open link to the FrontBase server and if no such link is found it will try to create one as if
fbsql_connect(3) was called with no arguments.
RETURN VALUES
Returns the ID generated from the previous INSERT query, or 0 if the previous query does not generate an DEFAULT UNIQUE value.
If you need to save the value for later, be sure to call this function immediately after the query that generates the value.
SEE ALSO fbsql_affected_rows(3).
PHP Documentation Group FBSQL_INSERT_ID(3)
Check Out this Related Man Page
FBSQL_ERRNO(3) 1 FBSQL_ERRNO(3)fbsql_errno - Returns the error number from previous operationSYNOPSIS
int fbsql_errno ([resource $link_identifier])
DESCRIPTION
Returns the numerical value of the error message from previous FrontBase operation.
Errors coming back from the fbsql database backend don't issue warnings. Instead, use fbsql_errno(3) to retrieve the error code. Note that
this function only returns the error code from the most recently executed fbsql function (not including fbsql_error(3) and fbsql_errno(3)),
so if you want to use it, make sure you check the value before calling another fbsql function.
PARAMETERS
o $
link_identifier -A FrontBase link identifier returned by fbsql_connect(3) or fbsql_pconnect(3).If optional and not specified, the
function will try to find an open link to the FrontBase server and if no such link is found it will try to create one as if
fbsql_connect(3) was called with no arguments.
RETURN VALUES
Returns the error number from the last fbsql function, or 0 (zero) if no error occurred.
EXAMPLES
Example #1
fbsql_errno(3) Example
<?php
fbsql_connect("marliesle");
echo fbsql_errno() . ": " . fbsql_error() . "<br />";
fbsql_select_db("nonexistentdb");
echo fbsql_errno() . ": " . fbsql_error() . "<br />";
$conn = fbsql_query("SELECT * FROM nonexistenttable;");
echo fbsql_errno() . ": " . fbsql_error() . "<br />";
?>
SEE ALSO fbsql_error(3), fbsql_warnings(3).
PHP Documentation Group FBSQL_ERRNO(3)
Hi,
I sometimes bulk upload data in oracle. The problem is that I sometimes get an INSERT statemnt like this:
INSERT INTO ALL_USER_HOTSPOT_DETAILS (USR_LOGIN,USR_LASTNAME,USR_FIRSTNAME,USR_EMAIL,
PROPERTYNR)
VALUES ('SABRDAG','D'AGOS','SABRINA','sabrina_d'agos@sheraton.com',70)
I... (4 Replies)
insert_FileConfig="INSERT INTO FILECONFIG ( FILE_TYPE, FILE_DESC, FILE_SCHDL_TYPE, FILE_SCHDL, FILE_SCHDL_TIME, RESULTS ) \
VALUES action_list "
i have to replace "action_list" with the contents of a variable but when i am using
echo $insert_FileConfig | sed... (6 Replies)
Hai,
I have strings as follows.
0 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'SYS_C0030166' (INDEX (UNIQUE))
1 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'SYS_C0029845' (INDEX (UNIQUE)
9 INDEX MODE: ANALYZED (RANGE SCAN) OF ... (2 Replies)
Discussion started by: sagarbsa
2 Replies
4. Forum Support Area for Unregistered Users & Account Problems
Hello,
I have 1000 of sql queries and i need to push column value in query. e.g.
SET INSERT_ID=1
INSERT INTO test (id,name) VALUES ('a');
SET INSERT_ID=2
INSERT INTO test (id,name) VALUES ('b');
SET INSERT_ID=3
INSERT INTO test (id,name) VALUES ('c');
SET INSERT_ID=4
INSERT INTO test... (12 Replies)
Hi All ,
I have tried many times am getting syntax error on 'UNION'
can anybody tell me ...
INSERT INTO table1
(
Type
, num_items
, num_letters
, total_value
)
(select
type='1',
num_items,
num_letters=count(*),
total_value=sum(letter_value)
from
table2
where
num_items = 1 (1 Reply)
Hi all,
recently I found that $_SERVER does not deliver the complete url with query anymore on my server.
http://www.example.org/search.php?stichwort=wiki
echo $_SERVER;
/search.phpHowever $GLOBALS works in this case.
http://www.example.org/search.php?stichwort=wiki
echo $GLOBALS;... (1 Reply)
Hi guys,
I need a help with a query. Basically i want to know the difference between (0+01)* and ((0+01)*)* . It seems whatever string can be generated by the first RE can also be generated by second and they should essentially be same. Am i missing something? (1 Reply)