If you are
creating an application that relies on sequences, ensure that the JDatabase subclass object
supports GenID() fully. Subclasses must implement this method to enable GenID()
support. JDatabaseMySQL and JDatabaseMySQLi do not support GenID(); using
GenID() with these databases will always return 0.
Parameters foo1 Sequence name
foo2 Start ID
Returns Sequence ID; normally an integer, but sometimes a string
getAffectedRows( ) : int
Gets the total number of records that were affected by the last query.
Returns Number of records that were affected by the last query
Appendix
[ 445 ]
GetCol( query : string ) : array
Emulates ADOdb functionality.
Executes query and returns an array of the first column from the resultant records.
Parameters query Query to execute
Returns Array of first column from records
getCollation( ) : string
Gets the database collation. This method is not infallible for MySQL databases; MySQL
allows the collation to be set at four different levels, server, database, table, and column.
Pages:
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614