1.1 Kernel

The Kernel is required for database operations.

Function	Syntax	Returns	Dependencies
GetField	Variable = GetField(SQL) Executes an SQL statement. SQL is a fully qualified SQL statement. Eg: select title from product where id = 100	Single Value	None

1.2 Render Kernel

Function	Syntax	Returns	Dependencies
SetDataGrid	SetDataGrid(table, rows, fields, GridWhere, related, related_id, orderby, PerPage) Default fields in the array, which appear prior to any specified: aurora_data.id aurora_data.master_id aurora_data.current_id, aurora_data.title Required Table: the database table name Rows: the maximum number of rows Fields: comma separated list of fields GridWhere: a where clause Related: join a related table Related_ID: join a related ID OrderBy: sort order PerPage: how many rows per page Options prefix table with # to return only DISTINCT records prefix rows with % to return LIVE records (don't care about publish state; ie: all current records) set orderby to #search to return all matching rows from all tables (unless a table is specified) in full-text index s_keyword contains search term/s (which will be split into multiple words)	One Page of Results in the array DataGrid().	Admin / Stage / Live Published if called from the live site. Current but not expired if called from the stage. If called from admin...

RenderFormField(field_name,table_name,strValue,doLabel,ID)

Field_name Valid field name

Table_name Valid table name

strValue Existing or default value

doLabel Controls rendering of <label> tags

0 = NO LABELS | 1 = DO LABELS

ID DOM ID (also used for Name)

The following application settings are controlled by Application variables set in the GLOBAL.ASA file.

In a future version these settings will be managed through an admin interface.

Setting	Values	Effect	Future R&D
AuroraVersion	Developer	Enables all features	The version setting will be checked against an encrypted activation key file.
	Professional	Enables all released features
	eCommerce	Disables Reporting, Group Security
	Small Business	Disables eCommerce, Group Security, Reporting and Broadcasting
AuroraBroadcasting	Activated	Enables Broadcasting
AuroraReporting	Activated	Enables Advanced Reporting

GetGrid(flags, gridname, table, rows, fields, GridWhere, related, related_id, orderby)

Returns array {gridname}; RowCnt = total records

# to return DISTINCT records
% to return CURRENT records in Aurora_Data

* to return ALL records in table and *NOT* join Aurora_Data

! in front of related table name denotes reverse relationship

@ keep RS open for paging

& Expects ExportType to have been set

S Leave Sort Order unprefixed

X Don't use COUNT

GetRecord(flags, table, fields, GridWhere, related, related_id, orderby)

Returns dictionary object Record

# to return DISTINCT records

% to return CURRENT records in Aurora_Data

* to return ALL records in table and *NOT* join Aurora_Data

! in front of related table name denotes reverse relationship