Parameters sql Query
prefix Database table prefix to replace
Returns ???uery with correct table prefixes
RollbackTrans( ) : string
Emulates ADOdb functionality.
This method must be overridden in subclasses. If you intend to use this, please ensure the
database driver supports it.
stderr( showSQL : boolean=false ) : string
Gets an error report of the last error. If showSQL is true, the SQL is included in the report.
Parameters [showSQL] Display query
Returns Error report
Appendix
[ 451 ]
SelectLimit( query : string, count : int, offset : int=0 ) : JRecordSet
Emulates ADOdb functionality.
Executes query and returns the results in a JRecordSet object. offset and limit are used
for pagination; in MySQL databases, this relates directly to the LIMIT clause.
Parameters query Query to execute
count Maximum number of records
[offset] Start record
Returns JRecordSet object
setUTF( ) : void
Prepares the database connection for UTF-8 strings.
setQuery( sql : string, offset : int=0, limit : int=0, prefix : string='#__' )
: void
Sets the next query to execute.
Pages:
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623