Click here to Skip to main content
15,885,546 members
Articles / Web Development / IIS

Universal Table Editor

Rate me:
Please Sign up or sign in to vote.
4.86/5 (117 votes)
11 May 2003 1.6M   12.3K   275  
Viewer and Editor for any table in any Database you can reach from your IIS/PWS.
<%
'---------------------------------------------------------------------------
'
'   Project:    UTE - (U)niversal ASP (T)able (E)ditor
'
'   Module:     UTE Language Specific Definitions - English
'
'   Version:    3.00
'
'   Comments:
'
'---------------------------------------------------------------------------
'
'   (c) in 2000-2003 by Tom Wellige                    
'   http://www.wellige.com  mailto:tom@wellige.com     
'                                               
'   This project is released under the "GNU General Public License (GPL)" 
'   http://www.gnu.org/licenses/gpl.html
'
'   and is maintained on SourceForge at
'   http://sourceforge.net/projects/ute-asp/
'
'   and can also be found on CodeProject at
'   http://www.codeproject.com/asp/ute.asp
'
'---------------------------------------------------------------------------

Session.LCID = &h0409 ' English (United States) 
'Session.LCID = &h0809 ' English (United Kingdom) 
'Session.LCID = &h0c09 ' English (Australian) 
'Session.LCID = &h1009 ' English (Canadian) 
'Session.LCID = &h1409 ' English (New Zealand) 
'Session.LCID = &h1809 ' English (Ireland) 
'Session.LCID = &h1c09 ' English (South Africa) 
'Session.LCID = &h2009 ' English (Jamaica) 
'Session.LCID = &h2409 ' English (Caribbean) 
'Session.LCID = &h2809 ' English (Belize) 
'Session.LCID = &h2c09 ' English (Trinidad) 
'Session.LCID = &h3009 ' English (Zimbabwe) 
'Session.LCID = &h3409 ' English (Philippines) 

' ---- Application ----
Const STR_SORT_ASC					= "sort ascending"
Const STR_SORT_DESC					= "sort descending"

Const STR_DATABASE					= "Database"
Const STR_DB_TITLE					= "%1"

Const STR_INSERT					= "Insert record"
Const STR_EDIT						= "Edit record"
Const STR_DELETE					= "Delete record"

Const STR_DEF_FILTER				= "Define Filter"
Const STR_NUM_FILTER				= "Number of Filters:"

Const STR_NON_VIEW					= "none-viewable data"

Const STR_OK						= "Ok"
Const STR_CANCEL					= "Cancel"
Const STR_CLEAR						= "Clear"

Const STR_PAGES						= "Page:"
Const STR_NEXT_PAGE					= "switch to next page"
Const STR_PREV_PAGE					= "switch previous page"
Const STR_REC_COUNT					= "Records per Page:"
Const STR_ALL						= "All"

Const STR_RECORDS					= "Display Record %1 - %2 of %3 Records"

Const STR_POWERED_BY				= "powered by %1 %2"
Const STR_FILTER					= "Define Filter"
Const STR_LIST_TABLES				= "List Tables in Database"
Const STR_EXPORT					= "Save as CSV (Excel) file"
Const STR_DEF_SHOW					= "Show Field Definitions"
Const STR_DEF_HIDE					= "Hide Field Definitions"
Const STR_SQL_SHOW					= "Show current SQL Statment"
Const STR_SQL_HIDE					= "Hide current SQL Statment"

Const STR_DEF_NAME					= "Name"
Const STR_DEF_TYPE					= "Type"
Const STR_DEF_DEFINEDSIZE			= "Definied Size"
Const STR_DEF_PRECISION				= "Precision"
Const STR_DEF_ATTRIBUTES			= "Attributes"

' ---- ADO -----
Const STR_ADO_MAYDEFER				= "may defer" 
Const STR_ADO_UPDATEABLE			= "updatable"
Const STR_ADO_UNKNOWNUPDATEABLE		= "unknown updatable"
Const STR_ADO_FIXED					= "fixed"
Const STR_ADO_ISNULLABLE			= "can be set to NULL"
Const STR_ADO_MAYBENULL				= "may be NULL"
Const STR_ADO_LONG					= "long"
Const STR_ADO_ROWID					= "Row ID"
Const STR_ADO_ROWVERSION			= "Row Version"
Const STR_ADO_CACHEDEFERRED			= "Cache deferred"

Const STR_ADO_TYPE_EMPTY			= "Empty"
Const STR_ADO_TYPE_TINYINT			= "TinyInt"
Const STR_ADO_TYPE_SMALLINT			= "SmallInt"
Const STR_ADO_TYPE_INTEGER			= "Integer"
Const STR_ADO_TYPE_BIGINT			= "BigInt"
Const STR_ADO_TYPE_UNSIGNEDTINYINT	= "UnsignedTinyInt"
Const STR_ADO_TYPE_UNSIGNEDSMALLINT	= "UnsignedSmallInt"
Const STR_ADO_TYPE_UNSIGNEDINT		= "UnsignedInt"
Const STR_ADO_TYPE_UNSIGNEDBIGINT	= "UnsignedBigInt"
Const STR_ADO_TYPE_SINGLE			= "Single"
Const STR_ADO_TYPE_DOUBLE			= "Double"
Const STR_ADO_TYPE_CURRENCY			= "Currency"
Const STR_ADO_TYPE_DECIMAL			= "Decimal"
Const STR_ADO_TYPE_NUMERIC			= "Numeric"
Const STR_ADO_TYPE_BOOLEAN			= "Boolean"
Const STR_ADO_TYPE_ERROR			= "Error"
Const STR_ADO_TYPE_USERDEFINED		= "UserDefined"
Const STR_ADO_TYPE_VARIANT			= "Variant"
Const STR_ADO_TYPE_IDISPATCH		= "IDispatch"
Const STR_ADO_TYPE_IUNKNOWN			= "IUnknown"
Const STR_ADO_TYPE_GUID				= "GUID"
Const STR_ADO_TYPE_DBDATE			= "DBDate"
Const STR_ADO_TYPE_DBTIME			= "DBTime"
Const STR_ADO_TYPE_DBTIMESTAMP		= "DBTimeStamp"
Const STR_ADO_TYPE_BSTR				= "BSTR"
Const STR_ADO_TYPE_CHAR				= "Char"
Const STR_ADO_TYPE_VARCHAR			= "VarChar"
Const STR_ADO_TYPE_LONGVARCHAR		= "LongVarChar"
Const STR_ADO_TYPE_WCHAR			= "WChar"
Const STR_ADO_TYPE_VARWCHAR			= "VarWChar"
Const STR_ADO_TYPE_LONGVARWCHAR		= "LongVarWChar"
Const STR_ADO_TYPE_BINARY			= "Binary"
Const STR_ADO_TYPE_VARBINARY		= "VarBinary"
Const STR_ADO_TYPE_LONGVARBINARY	= "LongVarBinary"
Const STR_ADO_TYPE_CHAPTER			= "Chapter"
Const STR_ADO_TYPE_PROPVARIANT		= "PropVariant"
Const STR_ADO_TYPE_UNKONWN			= "Unknown"

' ---- Error Messages ----
Const STR_ERR_1001					= "Invalid ODBC Connection String"
Const STR_ERR_1002					= "Missing ""%1"" URL parameter."
Const STR_ERR_1003					= "Invalid ""%1"" URL parameter. Must be numeric."
Const STR_ERR_1004					= "Invalid ""%1"" URL parameter. Must be ""1"", ""2"" or ""3""."
Const STR_ERR_1005					= "Invalid ""%1"" URL parameter. Must be either ""%2"" or ""%3""."

%>

By viewing downloads associated with this article you agree to the Terms of Service and the article's licence.

If a file you wish to view isn't highlighted, and is a text file (not binary), please let us know and we'll add colourisation support for it.

License

This article has no explicit license attached to it but may contain usage terms in the article text or the download files themselves. If in doubt please contact the author via the discussion board below.

A list of licenses authors might use can be found here


Written By
CEO Student
Germany Germany
Tom is in software development for about 15 years. He started with a SHARP MZ80k in Basic and Assembly Language. After collecting some experiance on an ATARI 1040ST he bought his very first IBM XT 286 (incl. 287!) and started to program in Turbo Pascal. He became very familiar with Borland's Turbo Vision and over the last years did a lot of development in C++ (MFC), Visual Basic, VB Script, ASP and SQL. He currently works as senior consultant for Swyx Solutions GmbH, based in Dortmund, Germany.
His absolute favourite is Guinness Wink | ;-) Sláinte!

Comments and Discussions