GenericDB Help
Setting | Description | Reference | Required | Version | |
|---|---|---|---|---|---|
| Session("memocols") and Session("memorows") | enable resizing memo field textarea | No | Enhanced | View | |
| Session("dbWhere") = "fruit='apples'" | a WHERE clause | Session("dbWhere") = ""
A SQL Where clause. Leave it empty to display all records. | No | Public | View |
| Session("dbViewTemplate") = "tblEmployeesView.htm" | The Custom View Template file, to be found in the same directory as the Config File. | No | Public | View | |
| Session("dbViewPage") = Request.ServerVariables("PATH_INFO") | DO NOT CHANGE | You won't normally need to change this one | Yes | Public | View |
| Session("dbViewFieldNames") | Specifies the prompts to use on the VIEW page. | defaults to actual Field Names, can customize here | No | Enhanced | View |
| session("dbUseTextArea")=70 | set the length that will force a textarea to be used: | 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 | View |
| Session("dbUsePopUpMsg") = "loading.htm" | Includes javascript routine for a popup | If the page is going to take a while to load, this simply informs the user to wait. | No | Enhanced | View |
| Session("dbURLNewWin") | 1=open in new window | No | Enhanced | View | |
| Session("dbURLfor3") = 4 | display field 3 as a link to the URL stored in field 4 | This setting displays a field as a link using the URL stored in another field. In this example, the 2nd field will be displayed as a link to the URL stored in field 20, which might be the employee's Home Page. | No | Public | View |
| Session("dbUpdateField<x>") = <value> | After updating a record, field x will be set to this value. | No | Public | View |