OdbcGetOne

Syntax

OdbcGetOne(str_dbidentifier, str_sql_statement,                  var_1[, var_2, var_n]);

str_dbidentifier	The identifier specified in OdbcConnect.
str_sql_statement	The SQL statement to execute.
var_n	The variables that will store the data.

Description

Executes an SQL statement and copies the values from the first row in the result set to script variables. The query is closed when the first row has been retrieved, and all resources allocated by the query will be released. Using this function is equivalent to calling OdbcGetFirst and then calling OdbcCloseQuery.

Returns

	The statement was executed successfully.
	No data found. The statement did not return any result set. The variables are cleared.
-1	Error. An error occurred while trying to execute the statement.

Example

$st="SELECT CUSTNAME FROM CUSTOMER WHERE CUSTID="+$cnr + ";";

OdbcGetOne("my_identifier", $st, $custname);