|
You can use the following common parameters in your event
code:
dbConnection - database
connection handle.
dal - DAL object. For
more information about using Data Access Layer (DAL), see Data Access Layer.
strTableName - name of
the currently selected table.
strWhereClause - WHERE
clause to be applied to the SQL query. It is not defined in the
BeforeProcess event. It is defined
in the BeforeQuery and subsequent
events.
Example:
|
' retrieve a record to be deleted or edited
set rs=Server.CreateObject("ADODB.Recordset")
rs.Open "select * from Table where " & strWhereClause, dbConnection
|
pageObject - use this
object to save, move and delete uploaded files. $pageObject includes the following
arrays:
|
pageObject.filesToSave
pageObject.filesToMove
pageObject.filesToDelete
|
Each of these arrays contains the object described in the file
source\classes\files.asp.
You can access the filename of uploaded file, the path to the
uploaded file, new file name (for example if 'add timestamp to the
filename' option is turned on) with these objects.
Here are some examples:
|
' Filename of uploaded file
pageObject.filesToMove(..).sourceFilename
' Path to the file
pageObject.filesToSave(..).destPath
' Filename of saved file
pageObject.filesToSave(..).destFilename
|
pageObject.filesToSave
is used only if the Create
thumbnail option is turned on.
Other useful
functions and values
|
·
|
GetRequestForm("FieldName")
- use it access any field value on Edit or Add pages; |
|
·
|
Session(strTableName &
"MasterKey") - master table foreign key value; |
|
·
|
Request.QueryString("editid") - on
Edit/View pages stores value of first key column. To reach other
key columns values use Request.QueryString("editid2") and
Request.QueryString("editid3"). |
|
