Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
Returns the value fetched for the specified column.
sqlany_get_column ( $stmt, $col_index )
A statement object that was executed by sqlany_execute or sqlany_execute_direct.
The number of the column to be retrieved. A column number is between 0 and sqlany_num_cols() - 1.
Returns a 2-element array that contains 1 on success or 0 on failure as the first element and the column value as the second
stmt = api.sqlany_execute_direct( conn, "SELECT * FROM Employees" )
# Fetch the second row
rc = api.sqlany_fetch_next( stmt )
rc, employeeID = api.sqlany_get_column( stmt, 0 )
rc, managerID = api.sqlany_get_column( stmt, 1 )
rc, surname = api.sqlany_get_column( stmt, 2 )
rc, givenName = api.sqlany_get_column( stmt, 3 )
rc, departmentID = api.sqlany_get_column( stmt, 4 )
print employeeID, ",", managerID, ",",
surname, ",", givenName, ",", departmentID, "\n"