Dump the complete contents of a SQL table to the screen.

Optionally, sort by any column and/or filter by a single column value.

Save the code to DumpTable.asp on your server and run using the URL as shown in the instructions.

Here's the code:

' Instructions -' Enter URL like this:' DumpTable.asp?tbl=yourtablename&selc=selectcolumnname&selv=selectvalue&ord=orderbycolumnname' selc, selv, and ord are optional' selc and selv must be used in tandem' Don't forget to set the ODBC connection settings on line 39' ---------------------------------------------------------------------------------------' Original idea from Greg Sawin's TableMe.asp (MorePhotos.com)' Filtering, Ordering, and Cosmetic additions by Ben McLendon (www.surfsouth.com/~benmcl)' ---------------------------------------------------------------------------------------Dim ObjConn, ObjCmd, ObjRec, strTable, strCmd, strSelc, strSelv, strSelect, strOrd, strOrder, sTablestrTable = Request("tbl")if not isempty (Request("selc")) then strSelc = Request("selc") strSelv = Request("selv") strSelect = "WHERE " & strSelc & "= " & strSelvelse strSelect = ""end ifif not isempty (Request("ord")) then strOrd = Request("ord") strOrder = "ORDER BY " & strOrdelse strOrder = ""end ifstrCmd = "SELECT * FROM " & strTable & " " & strSelect & " " & strOrderset ObjConn = server.createobject ("adodb.connection")set ObjCmd = server.createobject ("adodb.command")set ObjRec = server.createobject ("adodb.recordset")' ODBC Connection SettingsObjConn.Open "ODBCConnectionName", "SQLUserName", "SQLPassword"ObjRec.Open strCmd, ObjConn, , 1, 1sTable="<TABLE BORDER='0' cellspacing='1' cellpadding='2' style='font-family: Arial; font-size: 8pt' bgcolor='#dddddd'><THREAD><TR>"'Collect Field NamesFor each ObjFld in ObjRec.Fields sTable = sTable & "<TD bgcolor='#FFFFFF'>" & ObjFld.Name & "</TD>"next'Build the table bodysTable = sTable & "</TR></THREAD>" _ & "<TBODY><TR><TD bgcolor='#FFFFFF'>" _ & objRec.getString(, ,"</TD><TD bgcolor='#FFFFFF'>", "</TD></TR><TR><TD bgcolor='#FFFFFF'>") _ & "</TD></TR></TBODY></TABLE>"Response.Write "<p><b><font face='Arial' size='2'>Table Contents - " & strTable & "</font></b></p>"Response.Write sTableObjRec.CloseSet ObjRec = NothingObjConn.CloseSet ObjConn = Nothing 

More Database Code Articles
More By aspfree

developerWorks - FREE Tools!

NEW! Best Practices: The Integrated Project and Portfolio Management Platform. Hear how IBM Rational Project and Portfolio Management integrated solutions help teams put the right tools and processes in place to maximize the effectiveness and efficiency of project teams and ensure that the business vision is being executed correctly. Learn how to automate and integrate requirements prioritization, top-down project planning, communications and controls, and methodology deployment to keep your scope, costs, and schedules under control. Tackle with an end-to-end approach the management of scope and scope changes, usage of methodology to control and empower project teams, and optimization of resources to align activity costs with the overall project plan. FREE! Go There Now!

NEW! Addressing software-as-a-service challenges using Tivoli security and WebSphere solutions Building a software-as-a-service solution requires addressing a few key technical challenges. In this webcast, we'll focus on the role of IBM Tivoli Directory Server and WebSphere Portlet Factory in creating a Software as a Service solution. We will demonstrate how to use Tivoli Directory Server to prevent the user population of one tenant from accessing the virtual portal and portlet components of another tenant. We will also use the dynamic profile capability of WebSphere Portlet Factory to create multiple highly customized applications from one code base. FREE! Go There Now!

NEW! Hello World: WebSphere Service Registry and Repository Manage, govern, and share services across your organization by using WebSphere Service Registry and Repository. Follow the hands-on exercises to learn how to navigate the Web interface to publish, find, reuse, and update services. FREE! Go There Now!

NEW! Integrating XML into Your Enterprise Using Data Federation XML has become a common way of storing business data as flat files and many data server vendors including IBM have provided ways to store this data within relational database systems. Increasingly collections of XML files are accessed like databases using an xQuery and other XML standard mechanisms. Businesses find the need to combine the traditional tabular structured data with XML formatted data. In this webcast, you’ll learn about IBM’s WebSphere Federation Server technology, which provides users with the ability to integrate these two data formats. FREE! Go There Now!

NEW! Try IBM Rational Asset Manager V7.0 online! You can now evaluate IBM Rational Asset Manager V7.0 online without installing or configuring it on your own system! Rational Asset Manager helps create, modify, govern, find, and reuse any type of development assets, including SOA and systems development assets. Rational Asset Manager helps you reduce software development costs and improve quality by facilitating the reuse of all types of software development-related assets. Visit developerWorks to learn more about this product and register to explore its capabilities online. FREE! Go There Now!

NEW! Try the IBM SOA Sandbox for Connectivity Visit IBM developerWorks to try the IBM SOA Sandbox for connectivity. The SOA Sandbox for connectivity provides a trial environment with the tooling and components to help you explore how to effectively connect your infrastructure and integrate all of the people, processes and information in your company. Use the hosted sandbox to explore SOA techniques that streamline connecting existing IT assets together, as well as learn how to connect them to new business logic. FREE! Go There Now!

NEW! Try the IBM SOA Sandbox for People Visit IBM developerWorks to try the IBM SOA Sandbox for people. The SOA Sandbox for people provides a trial environment with the necessary tooling and components required to enable consistent human and process interaction and collaboration, showing how you can improve user experience and business productivity. FREE! Go There Now!

NEW! Understanding Web application security challenges As businesses grow increasingly dependent upon Web applications, these complex entities grow more difficult to secure. Most companies equip their Web sites with firewalls, Secure Sockets Layer (SSL), and network and host security, but the majority of attacks are on applications themselves – and these technologies cannot prevent them. This paper explains what you can do to help protect your organization, and it discusses an approach for improving your organization’s Web application security. FREE! Go There Now!

NEW! Using IBM Rational Developer for System z and IBM Rational ClearCase together to manage application development Whether you are creating new applications or modifying existing ones, managing integration of new components with traditional z/OS elements is a critical part of building and deploying modern applications. Listen to this webcast to see how IBM can help you optimize your development process using an IDE like Rational Developer for System z that integrates with management tools, such as ClearCase to manage your application development on mainframes. FREE! Go There Now!

NEW! Whitepaper: Delivering SOA solutions: service lifecycle management The unprecedented scope of a service-oriented architecture (SOA) initiative brings to the forefront a number of management and governance issues that were sidestepped in the past. The key to a successful SOA implementation is managing and governing activities throughout the entire SOA delivery lifecycle by ensuring that services conform to the needs of all of the business’s stakeholders. Learn how service lifecycle management allows the business to ensure that the process by which services are defined, created, tested, deployed, optimized and retired is manageable, repeatable and auditable. FREE! Go There Now!

All FREE IBM® developerWorks Tools!