AxpDB documentation

© Axezz Data, Oslo Norway 1999-2006

Kickstart

Installation

• Alternative 1. Run the Setup program on the Server and check the other requirements below.
  
  AxpDB requires VB runtime version 6.0 (included in AxpDB Setup), Microsoft VBScript Regular Expressions, and MDAC (ADO) v 2.7 or higher
  Download locations:
  MDAC/ADO : http://www.microsoft.com/data
  Microsoft scripting : Microsoft Windows Script 5.6
  
  
  
• Alternative 2. Manual installation
  
  Register AxpDb on your server using the command REGSVR32 AxpDB.dll
  
  Install VB6 Runtime, MDAC and Microsoft scripting if it is not present on your server already.
  
  
• Unpacking Stylesheets, Graphics and Samples
  
  Unzip the file AxpDbSample.zip and create a virtual directory for the AxpDbSample catalogue (or just copy the whole catalogue to your /InetPub/wwwroot catalogue)
  
  Make sure to copy the supplied gif files to a sub directory of your web project named gfx. (Use the directory name gfx as this is the default AxpDb is looking for)
  
  You should also copy the supplied CSS files to a sub directory of your web project.
  
  

Reference

AxpDB.DBView

Important Methods

• WriteHtmlTable()
  Writes the output table or form to the client browser

• QHtmlTable(ConnectionString,strTable)
  A simplified method where the table name is given in strTable

Required properties

• ConnectionString : String
  Contains the information used to establish a connection to a data source.
  Standard ADO Connectionstring (see Microsoft documentation)

  Usage:
  objAxpDB.ConnectionString = "Provider=MSDAORA; Data Source=datasourcename; User ID=userid; Password=password" ' Oracle
objAxpDB.ConnectionString = "DSN=MYDSN;UID=Adm;pwd="' System Data Source Name
objAxpDB.ConnectionString = "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=c:\db\mybase.mdb" ' Access
etc.

• sql : String
  An SQL SELECT statement

  Usage:
  objAxpDB.sql = "SELECT NAME,EMAIL FROM USERS"

  Notes:
  Avoid using ORDER BY clause in the SQL as AxpDB has user interface enabling the user to sort column of choice.
  
  See also the properties FormSQL, EditSQL and Stored procedures below.
  
  

• Stored procedures
  To use a stored procedure returning a recordset instead of an SQL SELECT statement, just specify the stored procedure name in the SQL property.
  
  If the stored procedure use parameters, set parameters via AxpDB's StoredProcCommand property.
  
  StoredProcCommand : ADODB.Command
  This is a standard ADODB Command object.
  See example below for usage.
  
  Code example:
  <%
Const adChar = 129
Const adParamInput = &H0001
Dim objAxpDb
Set objAxpDb = Server.CreateObject("AxpDB.DBView")
objAxpDB.ConnectionString = "Your connection string"
' Ex.1 Parameterless Stored Procedure on MS SQL Server 2000, Northwind database
' objAxpDb.SQL = "[Ten Most Expensive Products]"
' Ex.2 Stored Procedure with parameters on MS SQL Server 2000, Northwind database
objAxpDb.SQL = "CustOrderHist"
Dim Param
Set Param = objAxpDb.StoredProcCommand.CreateParameter("CustomerID", adChar, adParamInput, 5, "ALFKI")
objAxpDb.StoredProcCommand.Parameters.Append Param
objAxpDb.WriteHtmlTable
Set objAxpDb = Nothing
%>


General Data display

• CurrentMode : String READONLY
  Represents the current display mode and has one of the following values: "grid", "formview", "formedit", "formadd"
  
  
• FormSQL : String (default : same as sql)
  The SQL statement that should be used for the form display.
  
  
• OrderByFields : String
  List of field names (or numbers) used to order the table
  Use this property if the table always should be sorted on certain fields.
  It would be better in this case however to include an ORDER BY clause in the SQL statement.
  
  
• OrderByDesc : Boolean (default : False)
  Set to True if the OrderByFields property should be sorted in descending order.
  
  
• GridDisplayFieldNames : String
  List of column names to appear in the grid or form header. If not specified, the query field names will be used.

  Usage:
  objAxpDB.GridDisplayFieldNames = "User,EMail"
  
  

• FormDisplayFieldNames : String
  List of column names to appear in the form header. Needed when FormSQL differs from normal SQL and GridDisplayFieldNames is set. FormDisplayFieldNames defaults to GridDisplayFieldNames, so always set FormDisplayFieldNames after setting GridDisplayFieldNames.
  If you want to use the database table column names set FormDisplayFieldNames="" after setting GridDisplayFieldNames.

  Usage:
  objAxpDB.FormDisplayFieldNames = "User,EMail"
  
  

• GridColsNoSort : String
  List of column numbers where the user should NOT be able to sort the table.

  Usage:
  objAxpDB.GridColsNoSort = "2,3"
  or objAxpDB.GridColsNoSort = "*"
  
  

• GridDisplayIndex : Boolean (default : True)
  Display a sequential number in column 1 for each record.
  As default this column will be used as a hyperlink to the form page.
  
  
• GridLinkIndex : Integer (default : 0)
  0 : use auto number index as hyperlink to form
  1..cols : use specified grid column as hyperlink to form
  
  
• GridFieldsShow : String
  List of field numbers to be displayed in the grid.
  Note. You cannot specify both GridFieldsShow and GridFieldsHide at the same time.

  Usage:
  objAxpDB.GridFieldsShow= "1,2,3,5"
  
  

• FormFieldsShow : String (default : blank i.e. all columns)
  List of field numbers to be displayed in the form.
  Note. You cannot specify both FormFieldsShow and FormFieldsHide at the same time.

  Usage:
  objAxpDB.FormFieldsShow = "2,3"
  
  

• GridFieldsHide : String
  List of field numbers to be hidden in the grid.
  Note. You cannot specify both GridFieldsShow and GridFieldsHide at the same time.

  Usage:
  objAxpDB.GridFieldsHide= "4"
  
  

• FormFieldsHide : String
  List of field numbers not to be displayed in the form.

  Usage:
  objAxpDB.FormFieldsHide = "2,3"
  
  

• GridFieldsSupressDup : String
  List of field numbers where duplicate values will be supressed.
  Can be useful for certain reports.

  Usage:
  objAxpDB.GridFieldsSupressDup= "2"
  
  

Page navigation and display options

• DisplayType : String (default : "form,grid")
  Possible values : "default|form|grid"
  Set to "form" if the table shall be displayed as a form only.
  Set to "grid" if the table shall be displayed as a grid only.
  
  
• DisplayHeader : Boolean (default : True)
  Set to False to hide the column (field) names header
  
  
• DisplayNavBar : String (default : "bottom")
  One of : "none"|"bottom"|"top"|"both"
  
  
• DisplayNavBarFirstLastBtn : Boolean
  Set new property DisplayNavBarFirstLastBtn=False to hide the Grid First and Last page buttons.
  Note. The last page button can be disabled by setting the property DisableNavBarLastPageBtn = True.
  
  
• DisplayNavBarTextOptions : String
  Navigation bar display options.
  Set the property DisplayNavBarTextOptions to control if the "Record i..j of n" and the new "Page i of n" should be displayed in the navigation bar.
  Set to "both" or "records" or "pages" or "none". Default is "both".
  
  
• RecordsPerPage : Integer (default : 20)
  Number of rows to display on each page
  
  
• DisplayRecordsPerPageSelect : Boolean (default : False)
  Drop-down for selecting records per page. Set the property DisplayRecordsPerPageSelect=True to display it.
  
  
• RecordsPerPageOptions : String
  Override default options by setting the property RecordsPerPageOptions = "<comma separated list of options>", e.g. "20,50,100,500"
  
  
• RecordsPerPageSelectPlacement : String
  Override default placement by setting RecordsPerPageSelectPlacement = one of "top" or "bottom"
  
  
• FooterText : String (default : blank on licensed versions)
  Html code and text to appear in grid navigation bar
  
  

Grid and Form Visual Display Options

• DisplayExcelIcon : Boolean (default : True)
  It is now possible to export the current dataset to Excel.
  To hide the Excel icon, set the property DisplayExcelIcon=False
  The Excel icon is placed on the navigation bar.
  Note. Response.Buffer must be True for this to work. This is default in IIS.
  
  
• ApplyCellFormattingToExcel : Boolean (default False)
  Apply data formatting if GridFormatCellFunction is set for selected columns.
  Note that Excel might have problems parsing the data properly if formatting is applied.
  
  
• ApplyCellFormattingToForm : Boolean (default True, unless FormSQL is set)
  Let GridFreeCell and GridFormatCellFunction formatting apply to Form view as well as Grid view
  
  
• ApplyColFormattingToForm : Boolean (default True, unless FormSQL is set)
  Let the Column formatting apply to Form view as well as Grid view
  
  
• MemoFieldLimit : Long (default : -1 no limit) Set to limit display of memo data fields to MemoFieldLimit characters. If your datafield contains html code, it is not recommended to restrict the length. Either display the whole or nothing. You risk truncating html code in the middle and breaking the page design completely otherwise.
  
  
• GridCellsNoBr : String
  List of column numbers (e.g. "1,2,5" or "*" = all columns) where the cell content will be contained in a <nobr> tag.
  
  
• Width : String
  Set the Grid Width. Applies to the Grid only, not form view. For Form view, use FormCellWidths (see below).

  Usage examples:
  objAxpDB.Width= "400px"
  objAxpDB.Width= "400"
  objAxpDB.Width= "50%"
  
  If the Html attribute "width" is set in the property TableTag or GridTableTag, the value is extracted and automatically transferred to the Width property.
  
  

• GridCellWidths : String
  A list containing the width in pixels of each column

  Usage:
  objAxpDB.GridCellWidths= "140,500"
  
  

• FormCellWidths : String
  A list containing the width in pixels of each column.
  Only 2 widths can be specified here.

  Usage:
  objAxpDB.FormCellWidths= "140,500"
  
  

• UseCSS : Boolean (default : True)
  Set to False if css tags should not be generated
  AxpDB will otherwise generate CSS code for TABLE,TD, TH tags etc.

  See the enclosed AxpStyle.css file for a list of all AxpDB styles in use.
  
  

• ImageDir : String (default : "../gfx/")
  The relative or full URL to the directory where the navigation bar gifs are stored.
  
  

HTML Attributes

• TableTag : String (default : "border=0 cellspacing=0")
  HTML attributes that applies both to the form and grid TABLE tag

  Usage:
  objAxpDB.TableTag= "cellspacing=2"
  
  

• THTag : String
  HTML attributes for the TH tag (column header). Applies to form and grid
  
  
• TDTag : String
  HTML attributes for the TD tag. Applies to form and grid
  
  
• TDEvenTag : String
  HTML attributes for TD cells of even numbered rows. Applies to form and grid
  
  
• TDOddTag : String
  HTML attributes for TD cells of odd numbered rows. Applies to form and grid
  
  
• GridColHeadAttributes(ColumnNumber) : String
  Set normal html attributes including style and scripting for Column Headers.
  
  
• GridColAttributes(ColumnNumber) : String
  Set normal html attributes including style and scripting.
  E.g. Let index column have a 3D windows grid look
  
  objAxpDB.GridColAttributes(0) = "style=""text-align:right;padding-right:4px;background-color:#d4d0c8;border-top:#ffffff 1px solid;border-left: #ffffff 1px solid;"""
  
  
• GridTableTag : String
  HTML attributes for the Grid TABLE tag.
  
  
• GridTRTag : String
  HTML attributes for the Grid data rows (TR tag)
  Data fields enclosed in double set of #'s (e.g. ##CUSTOMERID##) and special fields (enclosed in double set of #'s) allowed. The double set of #'s are required because # is a very commonly used html character. See also Free Format Cell for more details.
  
  
• GridTROddTag : String
  HTML attributes for the odd numbered Grid data rows (TR tag)
  Data fields enclosed in double set of #'s (e.g. ##CUSTOMERID##) and special fields (enclosed in double set of #'s) allowed. The double set of #'s are required because # is a very commonly used html character. See also Free Format Cell for more details.
  
  
• GridTREvenTag : String
  HTML attributes for the even numbered Grid data rows (TR tag)
  Data fields enclosed in double set of #'s (e.g. ##CUSTOMERID##) and special fields (enclosed in double set of #'s) allowed. The double set of #'s are required because # is a very commonly used html character. See also Free Format Cell for more details.
  
  
• GridTDTag : String
  HTML attributes for TD cells of Grid rows
  Data fields enclosed in double set of #'s (e.g. ##CUSTOMERID##) and special fields (enclosed in double set of #'s) allowed. The double set of #'s are required because # is a very commonly used html character. See also Free Format Cell for more details.
  
  
• GridTDOddTag : String
  HTML attributes for TD cells of odd numbered Grid rows
  Data fields enclosed in double set of #'s (e.g. ##CUSTOMERID##) and special fields (enclosed in double set of #'s) allowed. The double set of #'s are required because # is a very commonly used html character. See also Free Format Cell for more details.
  
  
• GridTDEvenTag : String
  HTML attributes for TD cells of even numbered Grid rows
  Data fields enclosed in double set of #'s (e.g. ##CUSTOMERID##) and special fields (enclosed in double set of #'s) allowed. The double set of #'s are required because # is a very commonly used html character. See also Free Format Cell for more details.
  
  

How to create a mouse roll-over effect on rows, and going to form view when clicking on a row
Example from Sample number 7 in the sample collection
...
<style>
.HighlightRow {background-color: yellow; cursor: pointer;}
</style>
...
objAxpDb.GridFreeFormatCellByCol(2) = "<a class=""AXDBTable"" href=""#AXPDBFORMURL#"">#CompanyName#</a>"

objAxpDb.GridTREvenTag = "onClick=""window.location='##AXPDBFORMURL##'"" onMouseOver=""this.className='HighlightRow'"" onMouseOut=""this.className ='AXDBTableTReven'"""

objAxpDb.GridTROddTag = "onClick=""window.location='##AXPDBFORMURL##'"" onMouseOver=""this.className='HighlightRow'"" onMouseOut=""this.className ='AXDBTableTRodd'"""



• FormTableTag : String
  HTML attributes for the Form TABLE tag
  
  
• FormTDTag : String
  HTML attributes for the Form TD tag
  
  

Data editing

• EditOptions : String
  Set to : "all" to enable updates, add and delete.
  Set to one or more of "update delete add" to enable individual edit types.
  Add the option "noview" if clicking on a grid link should take the user directly to edit form. A data form view will then not be displayed.
  
  
• EditPrimaryKeys : String
  A comma separated list of primary key names for the table beeing edited. Required if editing.
  
  
• EditNewPKStatement : String
  Comma separated list of specifications, one entry for each primary key (if table has combined key).
  Control if primary keys are autoincrement or require a separate sql statement (eg for Oracle Sequences)
  If a primary key is autoincrement, it will suffice to set the property EditFieldsReadOnly="nameof primary key column" (see below)
  If you dont want it to be read only, set EditNewPKStatement="autoincrement".
  
  For Oracle using sequences, specify an SQL
  E.g.
  objAxpDb.EditNewPKStatement = "SELECT SEQ_TEST.NextVal FROM DUAL"
  
  
• EditFieldsReadOnly : String
  List of field names (or column numbers) that is read only.
  
  
• EditConfirmDeleteString : String
  If set, the user will get a confirmation question containing this string when clicking Delete button.
  
  
• EditPerformUpdates : Boolean (default : True)
  Set to False if you want AxpDb to create the necessary Forms and user interface, but NOT do any database updating.
  You can then handle the form requests yourself for custom database updates.
  
  
• EditSQL : String
  Default is the same as FormSql (or just the normal sql) but can be set here if the other sql's does not contain updateable queries or of they select include functions not suitable for use when editing. Note that AxpDb removes the WHERE clause spefied in the SQL's when editing and replaces it with a query containg the primary keys for the table. All updates are based on primary keys.
  
  
• DeleteSQL : String
  Required if Delete records should be supported. Typically just set it to "DELETE FROM tablename". AxpDb fills in the where clause automatically.
  
  
• Method AddEditLookup(ByVal FieldName As String, ByVal LookupTable As String, ByVal LinkField As String, ByVal DisplayField As String, ByVal OrderBy As String, ByVal AllowNulls As Boolean)
  
  Add one or more lookup fields. These fields will be displayed with a drop down list.
  E.g.
  
  objAxpDb.SQL = "SELECT * FROM PRODUCTS"
objAxpDb.AddEditLookup "SupplierId", "Suppliers", "SupplierId", "CompanyName", "2", False
objAxpDb.AddEditLookup "CategoryId", "Categories", "CategoryId", "CategoryName", "2", False
objAxpDb.EditFieldsReadOnly = "ProductId"
objAxpDb.EditPrimaryKeys = "ProductId"
objAxpDb.DeleteSql = "DELETE FROM PRODUCTS"
objAxpDb.EditOptions = "all"

  
• RequiredFieldIndicator : String (default is an asterisk enclosed in blanks : "&nbsp;*&nbsp;")
  Text appearing after a required field. Html code is allowed
  E.g.
  
  objAxpDb.RequiredFieldIndicator = "" ' i.e. No indicator
objAxpDb.RequiredFieldIndicator = "&nbsp;<font color=red>*</font>&nbsp;" ' i.e. A red asterisk

  Note. The label (column name) of required fields has its own css style: AxpDBRequiredFieldLabel.
  
  
• Notes for Microsoft Access users
  You may encounter the following common error when you use ActiveX Data Objects (ADO) with Active Server Pages (ASP):
  
  Microsoft OLE DB Provider for ODBC Drivers error '80004005'
  [Microsoft][ODBC Microsoft Access 97 Driver] Operation must use an updateable query.
  

  The most common reason is that the Internet Guest account (IUSR_MACHINE), which is by default part of the "Everyone" group, does not have Write permissions on the database file (.mdb). To fix this problem, use the Security tab in Explorer to adjust the properties for this file so that the Internet Guest account has the correct permissions.

  NOTE: When using Microsoft Access databases with ADO, it is also necessary to give the Internet Guest account Write permissions on the directory containing the .mdb file. This is because Jet creates an .ldb file to handle database locking. You may also need to give read/write permission on the "Temp" folder because Jet may create temporary files in this directory.

  See also MS KB article 175168

Formatting, Functions, Regular expressions

• GridFormatCellFunction(ColumnNumber) : String
  
  Data value formatting and functions
  Most of these functions represents their VBScript or Visual Basic equivalents.
  
  Syntax :
  
  GridFormatCellFunction(ColumnNumber) = "FunctionName [, args, ...]".
  
  Formatting functions :
  • FormatCurrency [,NumDigitsAfterDecimal [,IncludeLeadingDigit [,UseParensForNegativeNumbers [,GroupDigits]]]]
  • FormatNumber [,NumDigitsAfterDecimal [,IncludeLeadingDigit [,UseParensForNegativeNumbers [,GroupDigits]]]]
  • FormatPercent [,NumDigitsAfterDecimal [,IncludeLeadingDigit [,UseParensForNegativeNumbers [,GroupDigits]]]]
  
  • NumDigitsAfterDecimal Optional.
  Numeric value indicating how many places to the right of the decimal are displayed. Default value is –1, which indicates that the computer's regional settings are used.
  
  • IncludeLeadingDigit Optional.
  Tristate constant that indicates whether or not a leading zero is displayed for fractional values.
  
  • UseParensForNegativeNumbers Optional. Tristate constant that indicates whether or not to place negative values within parentheses.
  
  • GroupDigits Optional. Tristate constant that indicates whether or not numbers are grouped using the group delimiter specified in the computer's regional settings.
  
  Settings
  The IncludeLeadingDigit, UseParensForNegativeNumbers, and GroupDigits arguments have the following settings:
  
  –1 : True
  0 : False
  –2 : Use the setting from the computer's regional settings.
  
  
  • FormatDateTime [,NamedFormat]
  
  The NamedFormat argument has the following settings:
  
  0 : Display a date and/or time. If there is a date part, display it as a short date. If there is a time part, display it as a long time. If present, both parts are displayed.
  1 : Display a date using the long date format specified in your computer's regional settings.
  2 : Display a date using the short date format specified in your computer's regional settings.
  3 : Display a time using the time format specified in your computer's regional settings.
  4 : Display a time using the 24-hour format (hh:mm).
  
  
  • Format [, format[, firstdayofweek[, firstweekofyear]]]
  
  The Format function syntax has these parts:
  
  format : Optional. A valid named or user-defined format expression.
  firstdayofweek : Optional. Aconstant that specifies the first day of the week.
  firstweekofyear : Optional. A constant that specifies the first week of the year.
  
  Settings
  
  The firstdayofweekargument has these settings:
  
  0 : Use NLS API setting.
  1 : Sunday (default)
  2 : Monday
  3 : Tuesday
  4 : Wednesday
  5 : Thursday
  6 : Friday
  7 : Saturday
  
  
  The firstweekofyear argument has these settings:
  
  0 : Use NLS API setting.
  1 : Start with week in which January 1 occurs (default).
  2 : Start with the first week that has at least four days in the year.
  3 : Start with the first full week of the year.
  
  Remarks
  
  To Format Numbers : Use predefined named numeric formats or create user-defined numeric formats.
  To Format Dates and times : Use predefined named date/time formats or create user-defined date/time formats.
  To Format Date and time serial numbers : Use date and time formats or numeric formats.
  To Format Strings : Create your own user-defined string formats.
  
  If you try to format a number without specifying format, Format provides functionality similar to the Str function, although it is internationally aware. However, positive numbers formatted as strings using Format don’t include a leading space reserved for the sign of the value; those converted using Str retain the leading space.
  
  
  Other :
  • DateAdd, interval, number
  
  • interval Required. String expression that is the interval of time you want to add.
  • number Required. Numeric expression that is the number of intervals you want to add. It can be positive (to get dates in the future) or negative (to get dates in the past).
  
  
  Settings
  
  The intervalargument has these settings:
  
  Setting Description
  yyyy Year
  q Quarter
  m Month
  y Day of year
  d Day
  w Weekday
  ww Week
  h Hour
  n Minute
  s Second
  
  
  • DatePart, interval [,firstdayofweek[,firstweekofyear]]
  
  • interval Required.String expression that is the interval of time you want to return.
  • firstdayofweek Optional. Aconstant that specifies the first day of the week. If not specified, Sunday is assumed.
  • firstweekofyear Optional. A constant that specifies the first week of the year. If not specified, the first week is assumed to be the week in which January 1 occurs.
  
  Settings
  
  See above!
  
  
  • Replace, find, replacewith [,start[,count]]
  • Left, length
  • Right, length
  • Mid, start[,length]
  • UCase
  • LCase
  • InitCaps
  • InitCapsAll
  • Len
  • Round [,numdecimalplaces]
  • Abs
  
  
  E.g.
  
  objAxpDB.GridFormatCellFunction(1) = "Mid,10,20"
objAxpDB.GridFormatCellFunction(2) = "Replace, USA, Unites States of America"
objAxpDB.GridFormatCellFunction(3) = "FormatNumber, 2, -1, -2, -1"
objAxpDB.GridFormatCellFunction(4) = "FormatCurrency, 2"
objAxpDB.GridFormatCellFunction(5) = "Round"
objAxpDB.GridFormatCellFunction(6) = "Abs"
objAxpDB.GridFormatCellFunction(7) = "FormatPercent, 0"
objAxpDB.GridFormatCellFunction(8) = "Exp"
objAxpDB.GridFormatCellFunction(9) = "Format,dddd mmm dd yyyy"
objAxpDB.GridFormatCellFunction(10) = "FormatDateTime,1"
objAxpDB.GridFormatCellFunction(11) = "DatePart,q,2,3"
objAxpDB.GridFormatCellFunction(12) = "InitCapsAll"

  Note. GridFormatCellFunction can only be applied once per column.
  
  
  Regular Expressions
  AxpDb now supports Regular expression Replace function through the Regular expression engine supplied with VBScript
  Microsoft Windows Script 5.6 must be installed on server
  
  Syntax :
  
  GridFormatCellFunction(ColumnNumber) = "RegExpReplace, /regular expression/[m[g[i]]], replace value"
  
  Example 1 - Swap first and second word:
  objAxpDB.GridFormatCellFunction(1) = "RegExpReplace, /(\S+)(\s+)(\S+)/, $2$1"
  
  
  Example 2 - Lets every second word be in bold:
  objAxpDB.GridFormatCellFunction(1) = "RegExpReplace, /(\S+)(\s+)(\S+)/g, $3$2<b>$1</b>"
  
  Example 3 - Highlight words with yellow background:
  
  objAxpDB.GridFormatCellFunction(1) = "RegExpReplace, /(\bMicrosoft|\bIBM)/mgi,<span style=""background-color:yellow"">$1</span>"
  

Free Format Cell

The GridFreeFormatCell and GridFreeFormatCellByCol allows combining the values of data columns with your own text or html code.
The data column names must be enclosed in a pair of # characters (or the delimiter specified in GridFreeFormatCellDataFieldDelimiter).
In addition to the data column names, a couple of useful special fields can be used.
These are #AXPDBPOSTBACKURL# and #AXPDBFORMURL# (see details below)


• GridFreeFormatCell : String
  Syntax : (column number),(cell content),(column number),(cell content),....
  (cell content) : legal HTML code or text. Data fields is tagged with #

  Usage:
  objAxpDB.GridFreeFormatCell ="3,<a href=""userdetail.asp?ID=#ID#"">#FIRSTNAME# #SURNAME#<a>"

  

• GridFreeFormatCellByCol(ColumnNumber) : String
  It is possible to set free format cell by column number.
  
  E.g.
  onjAxpDB.GridFreeFormatCellByCol(1) = "#FIRSTNAME# #SURNAME#"
onjAxpDB.GridFreeFormatCellByCol(2) = "Phone : #PHONE#, Fax : #FAX#"
onjAxpDB.GridFreeFormatCellByCol(3) = "<a href='mailto:#EMAIL#'>Send mail</a>"

' The following statement is an example of a custom link that can be used to go from Grid to Form Mode.
' It will display as a hyperlink with the data field PRODUCTNAME.
' The #AXPDBFORMURL# generates the URL to the form

objAxpDb.GridFreeFormatCellByCol(2) = "<a href=""#AXPDBFORMURL#"">#PRODUCTNAME#</a>"

  
• Special field #AXPDBFORMURL#.
  This field will generate the URL to go from grid to form. It is useful when you want to handle this yourself.
  See "Sample7 - Search, Edit, Master-detail, Mouse Roll over effect on rows" for an example of usage.
  
  
• Special field #AXPDBPOSTBACKURL#.
  The field will contain the grid's "page URL and state information" and can be used to create a hyperlink referring back to the same ASP page ensuring that the currents grid state is persisted. If there are more grids on the same page, the other grid's "state information" is not persisted when using this special field.
  See "Sample3 - Master Detail" for an example of usage.
  
  
• GridFreeFormatCellDataFieldDelimiter : String
  The string used to denote data column names in GridFreeFormatCell can now be set manually.
  The Default Delimiter is '#'
  
  
• GridFreeFormatCellColumnDelimiter : String
  The string used to denote data column names in the existing property GridFreeFormatCell can now be set manually.
  This is useful if a cell contains javascript functions calls with several parameters. The Default Delimiter is ',' (a comma).
  Alternatively use the new property GridFreeFormatCellByCol (see above)
  
  
• ApplyCellFormattingToForm : Boolean (default True)
  The formatting set by the properties GridFreeFormatCell, GridFreeFormatCellByCol and GridFormatCellFunction now automatically applies to the form view.
  If the property FormSQL is set, ApplyCellFormattingToForm will be set to False. This behaviour can be overriden if needed, by setting ApplyCellFormattingToForm=True after setting FormSQL.
  
  

Additional properties

• Tag : String
  Required if there is more than 1 AxpDB grid object on a single web page.
  Set to "1","2" etc for each object.

• LanguageString : String
  Comma separated lists for strings used in AxpDb
  The default string list is :
  "Next, Next (plural), Previous, Previous (plural), Record, Records, List, of, First, Last, Records per Page, Page"
  If, say you have a page containg books and book lists, you could set the list to the following:
  objAxpDB.LanguageString = "Next,Next,Previous,Previous,Book,Books,View booklist,of,First,Last,Books per Page,Page"
  
  
• Ditto for :
  LanguageBtnString : "Edit, Save, Close, Add, Delete"
  LangUpdString : [New record saved ok], [Record saved ok], [Record deleted], Record WAS NOT SAVED. Fill out all required fields."
  

• Language : String (one of "ENG"|"NOR"|"GER" default : "ENG")
  Displays user interface strings in local language. English, Norwegian and German is supported.

• DisplayDebug
  Set to True to display the current SQL statement.

• ErrorMessage : String READONLY
  If an error occurs, the error message(s) is placed in this property

  Usage:
  ...
  objAxpDB.WriteHtmlTable
  If objAxpDB.ErrorMessage<>"" Then Response.Write objAxpDB.ErrorMessage
  

• CurrentRecord(ColumnNumber) : Variant
  
  Available after rendering (The call to WriteHtmlTable).
  
  Returns the data value of the current record.
  Column numbers starts at 1. Current record is defined as the first record on the current page if it there is more than one record on the page.
  
  

• AxConnection : AxpDB.DBConnection
  Can be used instead of ConnectionString.
  The DBConnection object must be created first as in:
  Set objAxpDbConn = Server.CreateObject("AxpDB.DBConnection")
  Alternatively use the DBConnection of another AxpDB.DBView object.

• ADORecordset : ADODB.RecordSet
  Alternative to SQL

  Notes:
  The User Interface for setting column order will be disabled

• CountRecords : Boolean (default : True)
  Count and display the total number of records in the query

• RecordCount : Long
  Number of records in the recordset
  If the number of records is known in advance (i.e. a read-only table), this property can be set manually and will be displayed. The net result is that tables will be displayed quicker as no counting has to be performed.
  
  Available after rendering (The call to WriteHtmlTable).
  Possible use:
  Hide the Grid if there are no records in the table.
  E.g. Enclose AxpDb in a SPAN tag. Use Javascript to set the span style.display="none"
  

• FromRow, ToRow : Long READONLY
  The start and end row on current page.
  Available after rendering (The call to WriteHtmlTable).
  
  

• PersistentSQL : Boolean (default : False)
  If set to True the query statement will be persisted on the page as grid hyperlinks and in the hidden form field values.
  This property is very obscure and rarely used. Only kept for backward compatibility.
  

• RecordsMaxLimit : Long (default : 1 000 000, max 30 on unlicensed copies)
  Set an absolute limit on how many rows the grid should handle (e.g. to restrict output to 10 pages of 10 records, set RecordsMaxLimit=100 and RecordsPerPage=10

AxpDB.DBConnection

Properties

• Connection : ADODB.Connection

• DatabaseEngine : String (default : "ORACLE")
  One of "ORACLE" | "SYBASE" | "MSSQL" | "ACCESS" | "SQLA"
  Might be needed when enabling editing.

General notes

• AxpDB does not use the ASP Session object. It is therefore safe to turn off the ASP Session handling
• AxpDB does not depend on cookies
• AxpDB is MTS-enabled
• AxpDB uses Microsoft ADO to access all data sources (databases)

• Avoid enclosing AxpDB.DBView in <FORM> tags as the object itself contain a <FORM>