Any Exact
 Back to Index 
|
 Print 
|
 View CSV 
|
 View Excel 
|
 Reset 
|
 Refresh 
|
 db Info 
|
 Add New 
|
GenericDB Enhanced Help

Setting Description Reference Required Version
Response.Redirect Session("dbGenericPath") & "GenericList.asp" Last line of your config.asp file DO NOT CHANGE Yes Public Edit Copy Delete
Session("dbCompare") = 1 Displays an image in the EDIT template. Session("dbCompare") = 1 means YES, = 0 means NO (DEFAULT)  
 
Enables/Disables Session("dbCompareXX") variables. 		No Public Edit Copy Delete
Session("dbCopyIMG") = "<filename>" COPY Button Image The COPY Button image file can be located in any directory.  
Just enter the relative path to the IMG file, relative to the folder that contains the .asp template file. (default= "") 		No Enhanced Edit Copy Delete
Session("dbDeleteButton") = "any text" DELETE Button Text. Session("dbDeleteButton") = "any text" ... (default:"DELETE")  
 		No Enhanced Edit Copy Delete
Session("dbDeleteIMG") = "<filename>" DELETE Button Image The DELETE Button image file can be located in any directory.  
Just enter the relative path to the IMG file, relative to the folder that contains the .asp template file. (default= "") 		No Enhanced Edit Copy Delete
Session("dbEditIMG") = "<filename>" EDIT Button Image The EDIT Button image file can be located in any directory.  
Just enter the relative path to the IMG file, relative to the folder that contains the .asp template file. (default= "") 		No Enhanced Edit Copy Delete
Session("dbFilterFields") = "001111000" allows filtering of specific fields. Session("dbViewLink") = "001111000" ... means the fields 3-6 will have dropdowns in the Header that will filter the Database based on the selections of the dropdowns. No Enhanced Edit Copy Delete
Session("dbIMGinEdit") = 1 Displays an image in the EDIT template. Session("dbIMGinEdit") = 1 means YES, = 0 means NO (DEFAULT) No Public Edit Copy Delete
Session("dbListTemplate") = "<filename>" Custom List Template file The Custom List Template file, must be found in the same directory as the Config File. No Public Edit Copy Delete
Session("dbUserDefTemplate") = "<filename>" User Defined Template file The User Defined Template file, must be found in the same directory as the Config File...(default= "") No Enhanced Edit Copy Delete
Session("dbViewButton") = "any text" VIEW Button Text. Session("dbViewButton") = "any text" ... (default:"VIEW")  
 		No Enhanced Edit Copy Delete
Session("dbViewIMG") = "<filename>" VIEW Button Image The VIEW Button image file can be located in any directory.  
Just enter the relative path to the IMG file, relative to the folder that contains the .asp template file. (default= "") 		No Enhanced Edit Copy Delete
Session("NoHyperlink<xx>") = "<value>" Allow the User using URLforxx to change the Text to <value> for field <xx> or blank Session("NoHyperlink<xx>") = ""  
Field <xx> will be blank if there is no hyperlink associated with the URLfor<yy>  
 
Session("NoHyperlink<xx>") = "None"  
Field <xx> will be display "None" if there is no hyperlink associated with the URLfor<yy>  
 		No Public Edit Copy Delete
Session("NumberDecPlaces") = "000000034001z00"  
 
1-9 means show 1-9 decimalplaces as applicable  
0 means display all significant figures available  
z(lower case) means display as integer  
 
 		Allows control of number ofdecimal places in numbers for specific fields This string of 1's, 0's and z's decides how many decimal places will display for that field. Variable must be a number in the field for the record.  
 
1-9 means show 1-9 decimalplaces as applicable  
0 means display all significant figures available  
z(lower case) means display as integer  
 
 
 		Yes Public Edit Copy Delete
Session("RecordControlsLOC") = "<text-string>" Controls Location of Button Controls Session("RecordControlsLOC") = "LEFT"  
OR  
Session("RecordControlsLOC") = "RIGHT" (DEFAULT)  
OR  
Session("RecordControlsLOC") = "LEFT RIGHT"  
 
"" will be replaced by "RIGHT" 		No (NEW) Edit Copy Delete
Session("dbAddContinueCarry") = 0 Specifies whether a continue checkbox, or a carry-forward checkbox, or both checkboxes will be shown at the bottom of the ADD form. =0 .. no checkboxes (DEFAULT)  
=1 .. continue checkbox  
=2 .. carry-forward checkbox  
=3 .. both checkboxes 		No Public Edit Copy Delete
Session("dbAlternateColor") = "oldlace" Background color for alternate detail rows in GenericList Default is: #FFFFCC No Enhanced Edit Copy Delete
Session("dbAlternateColorA") = "white" Background color for alternate detail rows in GenericList Default is: #FFFFFF No Enhanced (NEW) Edit Copy Delete
Session("dbBodyTag") = "VLINK=#CC9999 ALINK=#CC9999 LINK=#CC9999" Build a custom body tag Define a custom body tag, including BACKGROUND, BGCOLOR, LINK color tags (as above), and more. Often, single quotes are allowed around tags:  
 
Session("dbBodyTag") = "BACKGROUND='MYGIF.GIF' BGCOLOR='white'" 		No Public Edit Copy Delete
Session("dbBoolean") = "CHECKBOX" Display a checkbox for YES/NO fields instead of radio buttons   No Public Edit Copy Delete
Session("dbBorderColor") = "Navy" Color to display the table borders Session("dbBorderColor") = "#99CCCC" (DEFAULT) No Public Edit Copy Delete
Session("dbCanAdd") = 1 Allows the User to Add records to the database Session("dbCanAdd") = 1 means YES, = 0 means NO (DEFAULT) No Public Edit Copy Delete
Session("dbCanCopy" ) = 1 Allows the User to Copy records of a database Session("dbCanCopy") = 1 means YES, = 0 means NO (DEFAULT) No Enhanced Edit Copy Delete
Session("dbCanDelete") = 1 Allows the User to Delete records in the database Session("dbCanDelete") = 1 means YES, = 0 means NO (DEFAULT) No Public Edit Copy Delete
Session("dbCanEdit") = 1 Allows the User to Edit records in the database Session("dbCanEdit") = 1 means YES, = 0 means NO (DEFAULT) No Public Edit Copy Delete
Session("dbCanView") = 1 Flag to turn on the VIEW button Session("dbCanView") = 0 means NO, = 1 means YES (DEFAULT)  
 		No Enhanced Edit Copy Delete
Session("dbChangeRecsPerPage") = "Yes" Allows the User to change the number of Records to display per page Allow user to change the number of records/page, "RecsPerPage", to display. If you want to use this variable, be sure to add this line to your table config files:  
 
Session("dbChangeRecsPerPage") = "Yes"  
 
If you don't use this variable or you set it to:  
 
Session("dbChangeRecsPerPage") = ""  
 
then the table to change the number of records/page will not be displayed  
 		No Enhanced Edit Copy Delete
Session("dbCombo<xx>") = "LIST,<value1>,<desc1> [,<value2>,<desc2>]"  
 
OR  
 
Session("dbCombo<xx>") = "TABLE, <tablename>, <RowForVal>, <RowForDesc>, <BlankVal>, <BlankDesc>, <WhereClause>, <OrderField>" 		Display a Combo Box for field <xx> Example 1: Session("dbCombo11") = "LIST, ??, Unknown, CA, Canada, US, United States, DE, Denmark"  
 
Example 1 makes field eleven a combo box (hence dbCombo11) taking values from a list.  
 
OR  
 
Example 2: Session("dbCombo3") = "TABLE, tlkpProvince, 1, 2, ??, Unknown, Country='Canada', 4"  
 
Example 2 works on field three (dbCombo3) taking values from a table. 		No Public Edit Copy Delete
Session("dbCompareXX") = "# strings\<string1>\color1\<string2>\color2\<string3>\color3\Color False"  
 		Does a Search Compare and replaces Background Cell Color # Strings = quantity of string/color pairs that follow  
XX = field Number  
 
Will Search a specific field for a non case sensitive string compare with <stringY>. If found, the <colorY> will replace the background color for that cell.  
 
if <color False> is present, and <stringY> is not found, then the background cell color will be replaced by <color False>. Including Blank Cells. if blank, normal background color will show.  
 
Session("dbCompare") must be equal to 1 for the above compare to work. If 0, then no color substitution will occur.  
 
Examples:  
Session("dbCompare") = 1  
Session("dbCompare4") = "2\4/29/2010\lime\"&Date&"\lime\" 'Date is todays Date  
Session("dbCompare6") = "1\4:00 PM\amber\yellow"  
Session("dbCompare9") = "1\Home\blue\"  
Session("DBcompare13") = "2\HOME\cyan\Away\pink\#336699"  
Session("DBcompare19") = "3\League\red\Practice\pink\Playoff\blue\yellow"  
 		No (NEW) Edit Copy Delete
Session("dbConfirmDelete") = 1 Require the User to Confirm the deletion of database records Session("dbConfirmDelete") = 0 Don't confirm (DEFAULT)  
 
Session("dbConfirmDelete") = 1 Confirm deletions  
 
A screen will be presented to the user to confirm that the record should be deleted. 		No Public Edit Copy Delete
Session("dbConn") = "myDSN" Data Source Name or DSN connection The name of the ODBC System data source name (DSN) as it's set up on your server. If your data source requires a username and password, this string should have the following format:  
 
"DSN=dbEli;UID=sa;PWD=mypass" 		Yes Public Edit Copy Delete
Session("dbCopyButton") = "any text" COPY Button Text. Session("dbCopyButton") = "any text" ... (default:"COPY")  
 		No Enhanced Edit Copy Delete
Session("dbCSV") = 1 Adds a link from the Lister, GenericList.asp, to display the table as a CSV, comma-delimited file Session("dbCSV") = 1 YES  
 
Session("dbCSV") = 0 NO (DEFAULT) 		No Registered Edit Copy Delete
Session("dbCSVQuote") = 0 Allows the User to pad all string fields with quotation marks Session("dbCSVQuote") = 0 NO  
 
Session("dbCSVQuote") = 1 YES (DEFAULT) 		No Registered Edit Copy Delete
Session("dbdbDispDelete") Designate fields that should show up on the delete page UNKNOWN implementation as of March 01, 2009 No Enhanced Edit Copy Delete
Session("dbDebug") = 1 Allows the User to display the link to the dbInfo page on the NavBar Session("dbDebug") = 1 YES  
 
Session("dbDebug") = 0 NO (DEFAULT) 		No Public Edit Copy Delete
Session("dbDefault<xx>") = <value> Allow the User to set a default <value> for field <xx> Session("dbDefault6") = Date()  
 
Session("dbDefault11") = "Canada" 		No Public Edit Copy Delete
Session("dbDispEdit") = "0211" Controls which fields appear on the Edit page Field display settings for the edit screen  
2 = Read-only  
1 = Read/write  
0 = Do not display  
 
In the example, field 1 is not displayed, 2 is read-only, and 3 and 4 are editable.  
 
Same format as dbDispList and dbDispView. 		No Public Edit Copy Delete
Session("dbDispExcel") = "0111010" Controls which fields appear in the EXCEL spreadsheet This string of 1's and 0's decides which fields will be shown by the Lister, GenericExcel.asp.  
1 means show  
0 means don't show  
In this case we're displaying fields 2, 3, 4, 6, as shown by the positions of the 1's. 		Yes Enhanced (NEW) Edit Copy Delete
Session("dbDispList") = "01110100" Controls which fields appear on the List page This string of 1's and 0's decides which fields will be shown by the Lister, GenericList.asp.  
 
1 means show  
0 means don't show  
 
In this case we're displaying fields 2, 3, 4, 6, as shown by the positions of the 1's. 		Yes Public Edit Copy Delete
Session("dbDispNew") = "10010" Controls which fields appear on the Edit page Sets which fields appear on the Edit screen when a new record is being created. If this is not set, the fields displayed will default to those set in "dbDispEdit". No Public Edit Copy Delete
Session("dbDispPrint") = "01110100" Controls which fields appear on the Print page This string of 1's and 0's decides which fields will be shown by the Lister, GenericList.asp.  
 
1 means show  
0 means don't show  
 
In this case we're displaying fields 2, 3, 4, 6, as shown by the positions of the 1's. 		Yes Public Edit Copy Delete
Session("dbDispView") = "011101" Controls which fields appear on the View page It is formed the same way as Session("dbDispList"), above. Leaving it blank, Session("dbDispView") = "", will prevent the View links from being displayed. No Public Edit Copy Delete
Session("dbEditButton") = "any text" EDIT Button Text. Session("dbEditButton") = "any text" ... (default:"EDIT")  
 		No Enhanced Edit Copy Delete
Session("dbEditFieldNames") Specifies the prompts to use on the EDIT page. Defaults to actual Field Names, can customize here No Enhanced Edit Copy Delete
Session("dbEditTemplate") = "<template file>" The Custom Edit Template file The Custom Edit Template file, to be found in the same directory as the Config File. No Public Edit Copy Delete
Session("dbEMailFor<xx>") = <field #> Display field <xx> as a link to the E-mail address stored in <field #> This setting displays a field as a link using the E-mail address stored in another field No Public Edit Copy Delete
Session("dbExcel") = 1 Flag to allow the "View Excel" link to appear in the NavBar Session("dbExcel") = 0 ... do NOT show link in the NavBar (DEFAULT)  
 
OR  
 
Session("dbExcel") = 1 ... show the link in the NavBar 		NO Enhanced (NEW) Edit Copy Delete
Session("dbExitPage") = "<URL of exit page>" URL of the Exit page Session("dbExitPage") = "http://www.ofifc.org/Eli/" Yes Public Edit Copy Delete
Session("dbExitPageText") = "<any text>" Text for the Exit link on the NavBar Each page has an "Exit" link and this is where you decide what page that link goes to.  
 
Session("dbExitPageText") = "BACK" (DEFAULT) 		No Public Edit Copy Delete
Session("dbExtraAdd") = 1 Put an extra, more obvious, "ADD" button on the List page Session("dbExtraAdd") = 0 (DEFAULT)  
 
OBSOLETE...Replace with Session("dbAddContinueCarry"). 		No Public Edit Copy Delete
Session("dbFieldNames") = "field1, field2, ..." List of Field names for each database field Set field names to use when displaying the data instead of the raw field names from the database.  
 
Session("dbFieldNames") = "EmployeeID, Last Name, First Name, Title"  
 
Defaults to actual Field names from the database 		No Public Edit Copy Delete
Session("dbFields") = "field1, field2, field3" SELECT clause or Field List Sets the list of fields to display. That's right, you're no longer limited to selecting all the fields. See the dbGroupBy setting below for a tip on how to use this to build complex queries  
 
DEFAULT is a List of all Field names, which is the same as setting the Fields to "asterisk":  
 
Session("dbFields") = "*" (DEFAULT) 		No Public Edit Copy Delete
Session("dbFont") = "<font1>, <font2>, ..." Choose main fonts to use for GenericDB tables List of Font names to use for GenericDB tables. If <font1> doesn't exist on your computer, <field2> will be used. If <field2> doesn't exist then <field3> will be used.  
 
Session("dbFont") = "Courier New, Arial, Helvetica" (DEFAULT) 		No Public Edit Copy Delete
Session("dbFontSize") = 3 Sets the Font size to use for GenericDB tables Font sizes range from "0 to 4"  
 
0 = smallest  
1 = smaller  
2 = default size  
3 = larger  
4 = largest  
 
Session("dbFontSize") = 2 (DEFAULT) 		No Public Edit Copy Delete
Session("dbFooter") = 1 Flag to display a footer on all GenericDB tables Session("dbFooter") = 1 Use Footer  
 
Session("dbFooter") = 0 No Footer, (DEFAULT) 		No Public Edit Copy Delete
Session("dbFooterString") = "<footer string>"  
 
or  
 
Session("dbFooterString") = "include file=<filename>" 		Set the footer string to use Session("dbFooterString") = "This is where we put the FOOTER"  
or  
Session("dbFooterString") = "<p><table><tr><td>Footer string</td></tr></table></p>"  
or  
Session("dbFooterString") = "include file= <any file>" 		No Enhanced Edit Copy Delete
Session("dbFormatDateTime") = "00021032" Display settings for Date/Time fields 0=General  
1=LongDate  
2=ShortDate  
3=LongTime  
4=hh:mm(24 hr military time)  
5=hh:mm AM/PM 		No Registered (NEW) Edit Copy Delete
Session("dbGenericPath") = "/Eli/ASP/" Relative path to the GenericDB files The relative path of your Generic Database files (GenericList.asp, GenericEdit.asp, etc.) This path is used to build the links on the pages. Yes Public Edit Copy Delete
Session("dbGRLink") = <field #> Display <field #> as a link UNKNOWN implementation as of March 1, 2009 No Enhanced Edit Copy Delete
Session("dbGroupBy") = "field list" A "GROUP BY" clause for SQL queries Session("dbGroupBy") = ""  (DEFAULT) No Public Edit Copy Delete
Session("dbHaving") = "Count(myField) > 1" A "HAVING" clause for SQL queries   No Public Edit Copy Delete
Session("dbHeader") = 1 Flag to display a header on all GenericDB tables Set this variable and modify the GenericHeader.asp file to include a standard footer on each page.  
 
Session("dbHeader") = 1 Use Header  
 
Session("dbHeader") = 0 No Header (DEFAULT) 		No Public Edit Copy Delete
Session("dbHeaderbgColor") = "black"  
 		Change header background color for the sorted column When you click on a column header to sort the table by the field. This is the background color for the header cell.  
 
Session("dbHeaderbgColor") = "black"  
 
Default = "yellow" 		    Edit Copy Delete
Session("dbHeaderString") = "<header string>"  
 
or  
 
Session("dbHeaderString") = "include file=<filename>" 		Set the header string to use Session("dbHeaderString") = "This is where we put the HEADER"  
or  
Session("dbHeaderString") = "<p><table><tr><td>Header string</td></tr></table></p>"  
or  
Session("dbHeaderString") = "include file= <any file>" 		No Enhanced Edit Copy Delete
Session("dbHideColumns") = 1 Hide columns in the LIST table = 1 (YES), Hide the column.  
 
= 0 (NO), DEFAULT. 		No Enhanced Edit Copy Delete
Session("dbHidePageNumbers") = <value> Flag to suppress Page numbers and Record count Session("dbHidePageNumbers") controls how and where Page numbers are printed. It also can print a Record count for each page.  
 
= 0 ... Page numbers printed ONLY between the "<<Previous" and "Next>>" buttons below the table (DEFAULT)  
 
= 1 ... Page numbers ONLY will be printed in a seperate bar (RIGHT side) below the "<<Previous" and "Next>>" buttons  
 
= 2 ... Record count ONLY will be printed in a seperate bar (LEFT side) below the "<<Previous" and "Next>>" buttons  
 
= 3 ... Both Page numbers and Record count will be printed in a seperate bar below the "<<Previous" and "Next>>" buttons  
 		No Public Edit Copy Delete
Session("dbKey") = <field #> Field number to use as the Key field, usually an Autonumber field   Yes Public Edit Copy Delete
Session("dbLowerLabels") = 1 Displays Column Labels at bottom of Table. Session("dbLowerLabels") = 1 means YES, = 0 means NO (DEFAULT)  
 
Enables/Disables the header labels to be printed below the table. Useful if working with a table with a large number of records. This does not have the sort and filter enhancements on the labels like at the top. 		No Public Edit Copy Delete
Session("dbMaxImageSize") = <imgsize> Make GenericList IMG fields be displayed at <imgsize> pixels in width This gives you a thumbnail image in LIST, and the thumbnail is a link to the full size image.  
 
First 3 characters of the fieldname must be IMG 		No Public Edit Copy Delete
Session("dbMaxVImageSize") = <imgsize> Make GenericView IMG fields be displayed at <imgsize> pixels in width This gives you a thumbnail image in VIEW, and the thumbnail is a link to the full size image.  
 
First 3 characters of the fieldname must be IMG 		No Public Edit Copy Delete
Session("dbMenuColor") = "Navy" Color to display menus Change the color of the menu tables  
 
Session("dbMenuColor") = "#99CCCC" (DEFAULT) 		No Public Edit Copy Delete
Session("dbMenuTextColor") = "Navy" Change the color of menu text and links Session("dbMenuTextColor") = "#000000" (DEFAULT)  
 
Change the color of text in the menu tables including the page title, field names, etc. 		No Public Edit Copy Delete
Session("dbMouseOverColor") = "lime" MouseOver Background color for row in GenericList Default is: Blank, Code will use dbalternateColor or dbAlternatecolorA as applicable. mouseover will have no affect if not used unless session carries over from another script. In that case set session variable to blank to diasble MouseOver. No Enhanced (NEW) Edit Copy Delete
Session("dbNavBar") =  
"  
<background color>,  
<text color>,  
<stylesheet class for normallink>,  
<stylesheet class for hilighted link>  
" 		Display top menu as a navigation bar Session("dbNavBar") = "navy,white,normal,hilite" (DEFAULT)  
 
Both "normal" and "hilite" are style classes contained in "GenericStyle.css". You can define your own style classes for the "normal" NavBar and "highlighted" NavBar. 		No Enhanced Edit Copy Delete
Session("dbNewWin") = 0 Flag to choose which tables will be opened in a new browser window 0 = NEITHER (DEFAULT)  
1 = open VIEW in new window  
2 = open EDIT in new window  
3 = open BOTH in new window 		No Enhanced Edit Copy Delete
Session("dbNullSubstitute") = NULL Mainly used to substitue an empty string with a NULL character Session("dbNullSubstitute") = "" (DEFAULT) No Enhanced Edit Copy Delete
Session("dbOnlyAdd") = 1 Skip the Lister, GenericList.asp, and drop the user straight in to edit a record Returns to the dbExitPage after submitting the record  
 
Default: 0 		No Public Edit Copy Delete
Session("dbOnlyEdit") = 1 Returns to the "dbExitPage" after editing the record To skip the Lister and drop the user straight in to edit a record, use this switch. Returns to the dbExitPage after editing the record  
 
Session("dbOnlyEdit") = 0 (DEFAULT) 		No Public Edit Copy Delete
Session("dbOrder") = <field #> Field number to sort by, make it negative to do the reverse sort Session("dbOrder") = 2  
 
The field to sort the records by. In this case we've chosen the second field (Field 2) or [Last Name]. 		No Public Edit Copy Delete
Session("dbOrderBy") = "<field1> DESC, <field2> ASC, etc." Set the "ORDER BY" clause Session("dbOrderBy") = "LastName DESC, FirstName"  
 
Sets an "ORDER BY" clause. "dbOrderBy" uses a full string to set sort order as opposed to "dbOrder" which only takes a single field number to sort on. 		No Public Edit Copy Delete
Session("dbRecsPerPage") = <value> Number of records to display per page Session("dbRecsPerPage") = 10  
 
Sets the number of records to show per page and displays "Previous" and "Next" buttons for navigation.  
 
DEFAULT: display ALL records 		No Public Edit Copy Delete
Session("dbRequiredFields") = "011101" flags that indicate whether a field is required to have a value 1's or 0's representing whether a red * is displayed beside each field. Does not validate data, just displays the star.  
 
1 = YES  
 
0 = NO (DEFAULT) 		No Public Edit Copy Delete
Session("dbRs") = "<datasource>" A Table/Query name or "FROM" clause The name of the table/query in the ODBC datasource. This variable REQUIRES a value for <datasource> Yes Public Edit Copy Delete
Session("dbRsBU") = "YES,<tablename>" Duplicate New records to another DB table Session("dbRsBU") = "NO" (Default)  
 
Session("dbRsBU") = "YES,<tablename>"  
 
The tablename must have the same structure as the table defined by Session("dbRs"). Be careful of queries!! If Session("dbRs") is a query you must make a backup table of the Table and the Query. 		    Edit Copy Delete
Session("dbSearchAdvanced") = 1 Activates an "Advanced Search" link This setting adds an "Advanced Search" link where the user can specify a field-by-field search of the recordset, including whether to AND or OR the search terms. Currently this feature does not support numeric or date fields.  
 
Session("dbSearchAdvanced") = 1  
 
Session("dbSearchAdvanced") = 0 (DEFAULT)  
 		No Public Edit Copy Delete
Session("dbSearchEnhanced") = 1 Adds option below the regular search box for a user to search This setting enhances the regular search box (see dbSearchFields) on the Lister screen.  
 
Session("dbSearchEnhanced") = 1  
 
Session("dbSearchEnhanced") = 0 (DEFAULT) 		No Public Edit Copy Delete
Session("dbSearchFields") = "011101" Flags that WILL/WON'T allow Fields to be searched When this variable exists, a Search box appears on the List page. The 0's and 1's determine which fields are searched, and are limited to string and memo fields for now (no dates, no numbers, no greater than or less than, just text).  
 
Note: Only string and memo fields are searchable  
 
1 = YES searchable  
 
0 = NO not searchable  
 
Session("dbSearchFields") = "" NO SEARCH BOX displayed 		No Public Edit Copy Delete
Session("dbSearchPos") = "<text-string>" Position of the Search box, The position of the Search box can have several values:  
 
Session("dbSearchPos") = "TOP" ... search table is above data table  
 
Session("dbSearchPos") = "BOTTOM" ... search table is below data table  
 
Session("dbSearchPos") = "NAV" ... search field is in NavBar 		No Public Edit Copy Delete
Session("dbShopCart") = "addprod.asp" Script to add item to shopping cart The record's key field is passed in the form variable called No Enhanced Edit Copy Delete
Session("dbShopCartImage") = "/genericdb/images/add.gif" Path to shopping cart "ADD" image for "GenericList.asp" A default SUBMIT type of button is used if this is not specified, with the name and value of No Enhanced Edit Copy Delete
Session("dbShopCartImageView") = "/genericdb/images/addtocart.gif" Defaults to "dbShopCartImage", but is used only for "GenericView.asp" A default SUBMIT type of button is used if this is not specified AND if "dbShopCartImage" is not specified, with the name and value of No Enhanced Edit Copy Delete
Session("dbShowPassword") = 1 Display password fields on "GenericList.asp"   No Enhanced Edit Copy Delete
Session("dbShowTimeout") = "YES" New Session variable to display template timeout. Session("dbShowTimeout") = "YES"  
 
or  
 
Session("dbShowTimeout") = "NO" (DEFAULT) 		No Enhanced Edit Copy Delete
Session("dbSortCols") = "00010110" Flags to designate which fields should be sortable 0 = NO not sortable  
 
1 = YES sortable 		No Enhanced Edit Copy Delete
Session("dbStartRec") = <record #> A record number to start the display at Session("dbStartRec") = 1 (DEFAULT)  
 
Indicates which record to begin displaying at. Useful to force GenericDB to start at 1, or if for some reason you want to start from the middle. GenericDB is "smart" enough to begin at 1 each time you use a different recordset, but if you have two Config Files for different views of the same recordset, you may need to force it to begin at 1. 		No Public Edit Copy Delete
Session("dbStyleSheet") = "<stylesheet>" Used to include an external stylesheet Session("dbStyleSheet") = "GenericStyle.css" (DEFAULT) No Enhanced Edit Copy Delete
Session("dbSubTable") = xx Quantity of subtables in config file Must be followed by a corresponding Quantity of  
 
Session("dbSubTablexx") = .....  
 
 
 		No Public Edit Copy Delete
Session("dbSubTable1") = "Link Title, SubTable Configfile, LinkingField, Key Field number from Parent, return path to main config file, return path text"  
 
 
Session("dbSubTable1") = "Edit Categories, ../Examples/TodoCat.asp, Category, 9, ../Examples/Todo.asp, Back to ToDo"  
 
 
 		Defines link to Subtable ENHANCED Version Added two more parameters to dbSubTable:  
 
The two new parameters get stored into "dbParent" and "dbParentText", respctively.  
 
Allows sub-tables. This example presumes a table exists which contains access logs. The title "Access Log" will be the displayed on a link beside each user listed in the Lister, "todoCat.asp" will be the asp file (use the same format as any other Config File but "NO dbWhere setting" and your "dbExitPage" points back to the main table's config file), and "Category" is the key field used to set the relationship.  
 
This works well with:  
Session("dbCombo<xx>") = "TABLE, <tablename>, <RowForVal>, <RowForDesc>, <BlankVal>, <BlankDesc>, <WhereClause>, <OrderField>"  
 
Works similar to a DB association.  
 
 		No Enhanced Edit Copy Delete
Session("dbSubTableLocation") = "<text-string>"  
 
 		Controls Location of SubTables Session("dbSubTableLocation") = "BOTTOM"  
OR  
Session("dbSubTableLocation") = "TOP"  
OR  
Session("dbSubTableLocation") = "NONE"  
OR  
Session("dbSubTableLocation") = "ROW" (DEFAULT)  
 
Choices are TOP, BOTTOM, ROW, NONE  
 
More Than 1 can be used in the string.  
 
"" will be replaced by "ROW"  
 		No (NEW) Edit Copy Delete
Session("dbTimeOutMsg") = <xx> Time to display a Session Timeout warning message (in minutes). <xx> = amount of time left before an impending session timeout in minutes.  
 
<xx> = 0 (DEFAULT) 		No Enhanced Edit Copy Delete
Session("dbTitle") = "<title string>" Page Title This is where you set your page's title. Yes Public Edit Copy Delete
Session("dbTotalFields") = "00101" Totals the specified fields at the bottom of each page Session("dbTotalFields") = "00101"  
 
0 = NO ... do NOT total the field  
 
1 = YES ... total the field  
 
In the above example, fields 3 and 5, will be totalled 		No Public Edit Copy Delete
Session("dbType") = "<database type>" Type of database to use Session("dbType") = "ACCESS" (DEFAULT)  
 
Possible values: SQL, ACCESS, or UDF 		No Public Edit Copy Delete
Session("dbUpdateField<xx>") = <value> After updating a record, field <xx> will be set to this value   No Public Edit Copy Delete
Session("dbURLfor<xx>") = <value> Display field <xx> as a link to the URL stored in field <value> Session("dbURLfor3") = 4  
 
This setting displays a field as a link using the URL stored in another field. In this example, the 3rd field will be displayed as a link to the URL stored in field 4. 		No Public Edit Copy Delete
Session("dbURLNewWin") = <value> Flag to open a URL in a new window Session("dbURLNewWin") = 0 ... NO  
 
OR  
 
Session("dbURLNewWin") = 1 ... YES 		No Enhanced Edit Copy Delete
Session("dbUseNavBar") = "<value>" Specifies whether to use the NAVBAR Session("dbUseNavBar") = "NO"  
 
OR  
 
Session("dbUseNavBar") = "YES" (DEFAULT)  
 
Note: if set to "NO", then NavBar will not be shown 		No Enhanced (NEW) Edit Copy Delete
Session("dbUsePopUpMsg") = "loading.htm" file containing a popup message DO NOT know what this is really used for !!! No Enhanced Edit Copy Delete
Session("dbUserDefButton") = "any text" User Defined Button Text. Session("dbUserDefButton") = "any text" ... (default:"USER DEFINED")  
 		No Enhanced Edit Copy Delete
Session("dbUserDefIMG") = "<filename>" USER DEFINED Button Image The User Defined Button image file can be located in any directory.  
Just enter the relative path to the IMG file, relative to the folder that contains the .asp template file. (default= "") 		No Enhanced Edit Copy Delete
Session("dbUseTextArea") = <value> set the length for a string that will automatically display as a textarea Session("dbUseTextArea") = 70  
 
In this case, if a field is a string, and is 70 characters or more, then it will be displayed as a textarea. The default is 255, so if you don't define this variable, it shouldn't cause any problems. 		No Enhanced Edit Copy Delete
Session("dbViewFieldNames") = "<field1>, <field2>, etc" Specifies the prompts to use on the VIEW page defaults to actual Field Names No Enhanced Edit Copy Delete
Session("dbViewLink") = "0010000" flags to add VIEW link to any field. Session("dbViewLink") = "0010000" ... means the VIEW link will be associated with field #3. No Enhanced Edit Copy Delete
Session("dbViewPage") = Request.ServerVariables("PATH_INFO") DO NOT CHANGE You won't normally need to change this one Yes Public Edit Copy Delete
Session("dbViewTemplate") = "<filename>" Custom View Template file The Custom View Template file, must be found in the same directory as the Config File. No Public Edit Copy Delete
Session("dbWhere") = "fruit='apples'" A "WHERE" clause for the database Session("dbWhere") = ""  
 
A SQL "WHERE" clause. Leave it empty to display all records. 		No Public Edit Copy Delete
Session("EmailNew") = "Title String for email,path/filename to unique code,email address1,email address2,field # for Best Decription of Record"  
 
email address #2 is optional  
 		Send email when record is added /updated or Deleted. syntax-  
Session("EmailNew")= "Title String for email,path/filename to unique code,email address1,email address2,field # for Best Decription of Record"  
 
Session("EmailNew")= "Meier ToDo DB Updated,../meier/Test4Change.asp,gailmeier@comcast.net,webmaster@tahomabaseball.com,3"  
 
 
The record ID# is in Email along with the ACTION code and the Description field selected and the DB .update section.  
 
UPDATE - UPD or ADD  
ADD NEW - COPY or ADD  
Delete - Delete  
 
Unique code can be modified to support your web application 		    Edit Copy Delete
Session("memocols")  
 
And  
 
Session("memorows") 		Enables resizing of memo field textarea   No Enhanced Edit Copy Delete
Records 1 to 119 of 119