executeQuery() joins the prepared SQL statment from prepareQuery() with the data that was set using one of the setParam() methods and executes the SQL query.
query handle from prepareQuery()
if supplied, the types of the columns in the result set will be set for fetching
Таблица 34-1. Возможные значения PEAR_Error
| Error code | Error message | Reason | Solution |
|---|---|---|---|
| MDB_ERROR_INVALID | NULL | SQL statment handle is not valid. | Check correct processing of the SQL statment with prepareQuery() . Note that executeQuery() requires a handle to the statement returned by prepareQuery() , not the statment itself. |
| MDB_ERROR_NEED_MORE_DATA | NULL | To less data for filling the prepared SQL statment. | Check the number of wild cards given in the SQL statment for prepareQuery() . Check the count of entries in the array for $data. The count of entries have to be equal to the number of wild cards. |
| MDB_ERROR_NO_DB_SELECTED | NULL | No database was choosen. | Check the DSN in connect() . |
| every other error code | Database specific error | Check the database related section of PHP-Manual to detect the reason for this error. In the most cases a misformed SQL statment. Ie. using LIMIT in a SQL-Statment for an Oracle database. |
Эта функция не должна вызываться статически.
See Introduction - Execute for general using and an example.
| Пред. | Начало | След. |
| MDB_Common::execute() | Уровень выше | MDB_Common::executeMultiple() |
HIVE: All information for read only. Please respect copyright! |
