Contents
Component xdobry::mysql
comment:XOTcl API for mysqltcl based on mysqltcl (www.xdobry.de/mysqltcl)
Classes
Classes Hierarchy
Class MySql
parameter:
user
password
hostname
socket
{interface mysql}
superclasses:
Sqlinterface
comment:Interfaceclass for mysqltcl base interface
Instprocs:
- execute {sqlstatement}
- Sendet eine SQL Anweisung an Server (keine SELECT)
gibt die Zahl von verÃÂÃÂÃÂÃÂÃÂÃÂÃÂÃÂÃÂÃÂÃÂÃÂÃÂÃÂÃÂänderten Tupel oder {} beim Fehler
- query {sqlstatment}
- Sendet eine SQL Anweisung an Server und gibt ein SqlQuerry Objekt
oder {} beim Fehler
ZurÃÂÃÂÃÂÃÂÃÂÃÂÃÂÃÂÃÂÃÂÃÂÃÂÃÂÃÂÃÂück, das fÃÂÃÂÃÂÃÂÃÂÃÂÃÂÃÂÃÂÃÂÃÂÃÂÃÂÃÂÃÂür die Tranfersiereung der Antwort (Tablle=Menge)
benutzt werden kann
Class MySql::SqlQuerry
parameter:
{qhandle 0}
{frows 0}
Instprocs:
- columnNames {}
- Return the name of columns in the query.
Warning! This method are not supported by all interfaces
- fetch {}
- fetch next row and return it as list.
Warning!
The result is always a list.
If the reusult has only one column that it is list with only
one element at should be accessed with lindex $row 0
- rows {}
- Return the total number of rown in the result
Warning! fetch does not decrease this number
- seek {point}
- Can set the cursor in result object.
Warning! not all interfaces supports this method