Each inner
array represents a record as an array. If key is specified (primary key field number), the
returned array will be associative, using the record primary key as array key.
Parameters [key] Primary key
Returns Two-dimensional array of records
nameQuote( s : string ) : string
Encapsulates a string in quotes. This is for strings that are named SQL elements (tables,
fields, databases), not values.
Parameters s String to encapsulate
Returns Quote encapsulated string
PageExecute( sql : string, nrows : int, page : int, inputarr :
boolean=false, sec2cache : int=0 ) : JRecordSet
Emulates ADOdb functionality.
Executes query and returns the results in a JRecordSet object. nrows and page are used to
determine the offset and limit.
Parameters sql Query to execute
nrows Number of records per page
page Results page (pagination)
[inputarr] Ignored; emulation purposes only
[secs2cache] Ignored; emulation purposes only
Returns JRecordSet object
Appendix
[ 450 ]
query( ) : mixed
Executes the current query.
Pages:
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621