WhizBase Help

FormFields variables

WB_AllowMultipart - accept uploaded files

WB_AppendMode - append report to existing file

WB_Command - the action to be performed by WhizBase

WB_Config

WB_Defaults - set the default values for request variables

WB_Destination - set the file name for saving the output

WB_Forced - force values for request variables

WB_FULID - generate unique form upload ID

WB_HideLogin - scramble login data in navigation URL

WB_Required - list of required request variables

WB_ShowLogo - display powered by WhizBase logo

WB_SysVarByForm - allow system variables (wb_) set as request variables (by form)

WB_TempName - report template file name

WB_TimeOut - set script time-out interval

WB_UseEscapes - use escape sequences for special WB characters

WB_UserData - user defined content

WB_ValDelimiter - delimiter for wb_defaults and wb_forced

Access control

HTAccess File - configuration file for authentication

WB_AuthType - authentication method

WB_LoginPage - file name of login page for cookie authentication

WB_Realm - realm for basic and digest authentication

WB_Scramble - scramble (hide) password(s) stored in htaccess file

WB_HTAccess - location of configuration file for authentication

WB_HTPass - authentication password

WB_HTUsr - authentication user name

WB_IPListFile - location of file containing list of (dis)allowed IP address ranges

Database

WB_AddJoker - position of automatically added wildcards

WB_AndOr - condition concatenation type

WB_BaseName - name of the database used

WB_CDate - set conversion of date/time and boolean fields

WB_ChangeHFOn - report header/footer grouping field(s)

WB_Connect - ISAM driver or ODBC DSN

WB_DBFlds - field(s) included in recordset

WB_DBLock - record locking type

WB_DBObject - object used to access the database

WB_ExactCount - count all records in recordset

WB_Exclusive - open the database in exclusive mode

WB_Execute - execute SQL statement(s)

WB_Group - SQL clause "GROUP BY"

WB_Having - SQL clause "HAVING"

WB_InsBr - replace new line characters with <br>

WB_LCID - locale identifier ID

WB_MatchCase - case sensitive search

WB_MaxPages - maximum number of page links in report navigation

WB_MaxRec - maximum number of records per page

WB_MQ - make query (yes/no)

WB_Null - update string for clearing field value

WB_Order - SQL clause "ORDER BY"

WB_Pass - database password

WB_Predicate - SQL predicate

WB_Query - SQL clause "WHERE"

WB_RcdSet - SQL clause "FROM"

WB_ReadOnly - open the database in read-only mode

WB_SetADOCompatible - ANSI wildcard compatibility

WB_ShowEmpty - display empty database fields as space

WB_StartRec - internal page counter

WB_System - system database (MDA/MDW) file name

WB_UID - unique record identifier field(s)

WB_Unicode - send field value as unicode

WB_UniFTS - field(s) to be included in Universal Query Search

WB_UniQS - string to be searched for in Universal Query Search

WB_WC - database wildcard character for LIKE comparison

WB_WholeWord - whole word search

WB_Usr - database user name

WBF_field - sending field values as request variables

DB administering (DAO only)

WB_DBAddData - permission for adding records to the database

WB_DBAdmin - permission for administering the database

WB_DBDelData - permission for deletinging records from the database

WB_DBEditData - permission for updating records in the database

WB_DBGroup - name of the database users' group

WB_DBModDes - permission for modifying the database structure

WB_DBNewPass - new database password

WB_DBNPassCh - control value of the new password

WB_DBOldPass - old database password

WB_DBReadData - permission for reading records from the database

WB_DBReadDes - permission for reading records the database design (structure)

WB_DBUser - database user name for administering

WB_PID - personal identification

Error reporting

WB_ErrFile - template for error reports

WB_ErrMail - email address at the end of error message

File related (WF and DF commands)

WB_FileName - file name for DF and WF commands

WB_KeyName - variable name(s) for WF command

WB_KeyValue - variable value(s) for WF command

WB_Section - file section for WF command

WB_Separator - character used to separate different keys and different values for WF command

HTTP

WB_AddCookie - name and value of the cookie to be added/modified

WB_ContentType - value for HTTP Content-Type: clause

WB_HTTPHeader - additional clauses for HTTP header

WB_Redirect - the URL for 301 redirect (HTTP header Location: clause)

Logging

WB_Debug - file name for storing the debug information

WB_Log - file name for storing the log data

WB_LogData - data to be stored in log

WB_LogTemp - template for log record

Mail related

WB_Attach - mail attachment

WB_AttachField - name of field containing attachment file name(s)

WB_BCC - email BCC address(es)

WB_BCCField - database field name containing email BCC address(es)

WB_CC - email CC address(es)

WB_Embed - the name(s) of the file(s) to be embedded in the email

WB_From - email from address

WB_MailAuth - mail server authentication type

WB_MailPass - mail server authentication password

WB_MailPort - mail server SMTP port

WB_MailServer - mail server name or IP address

WB_MailSSL - mail server authentication type

WB_MailUser - mail server authentication user name

WB_PlainText - plain text email messsage part

WB_Subject - email subject

WB_To - email TO address(es)

WB_ToField - database field name containing email TO address(es)

Sessions

WB_ClearSessions - clear incative (expired) sessions

WB_LogOffSession - clear current session

WB_UseSessions - use server sessions

SMS

WB_SMSBR - SMS baud rate

WB_SMSC - SMS center number

WB_SMSCharacter - SMS character type

WB_SMSDB - SMS data bits

WB_SMSField - database field name containing phone number of text message recipient

WB_SMSIgnoreErrors - ignore SMS error messages

WB_SMSNumber - SMS recipient phone number

WB_SMSParity - SMS parity type

WB_SMSPIN - SMS Personal Identity Number (PIN)

WB_SMSPort - SMS modem COM port

WB_SMSSB - SMS stop bits size

WB_SMSSD - SMS send delay

WB_SMSSR - SMS send retry

WB_SMSTO - SMS timeout

MsgAndLbl variables

WB_AddToURL - additional request variables for navigation URLs formated as QUERY_STRING

WB_DigitDir - directory containing image files for graphic navigation links

WB_Style - navigation links CSS style

WBL_FirstPage - link text for First page link

WBL_LastPage - link text for Last page link

WBL_NextPage - link text for Next page link

WB_PassVars - comma delimited list of additional request variables for navigation URLs

WBL_PrevPage - link text for Previous page link

WBM_Deleted - message template for reporting deleted records

WBM_NoMatch - text for reporting that search returned no records

Upload section variables

WB_BaseUrl - URL prefix to be added to uploaded file name

WB_Disallow - list of file types (extensions) that can not be uploaded

WB_MaxFSize - maximum size for a single uploaded file

WB_Overwrite - overwrite existing file with uploaded one

WB_UploadDir - destination directory for uploaded files

WB_UploadLog - file name for logging upload activities