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!

IBM – Taking Web 2.0 to Work You'll get answers to many questions and more from David Barnes, Lead Evangelist for IBM Emerging Internet Technologies. David will discuss aspects of Web 2.0 that bring value to corporations, academia, and government. He'll also discuss IBM's vision around Web 2.0, including the importance of remixability and consumability. The discussion will culminate with examples of various IBM Software Group solutions you can use to get ahead of the Web 2.0 adoption curve. FREE! Go There Now!

NEW! Calling all CC Power Users – and those that would like to be! Join this Rational Talks to You teleconference, featuring Paul Boustany and Mark Krasovich, to speak to the experts about becoming a Rational ClearCase power user. Get a chance to ask your questions and learn tips and tricks for using Rational ClearCase in Agile development FREE! Go There Now!

NEW! IBM – Taking Web 2.0 to Work David Barnes, Lead Evangelist for IBM Emerging Internet Technologies will discuss aspects of Web 2.0 that bring value to corporations, academia, and government. He'll also discuss IBM's vision around Web 2.0, including the importance of remixability and consumability. The discussion will culminate with examples of various IBM Software Group solutions you can use to get ahead of the Web 2.0 adoption curve. FREE! Go There Now!

NEW! Achieving True Agility -- How process can change the behavior of your tools Achieving true agility is a never-ending effort. We will showcase how you can become agile incrementally, a few practices at the time.Which practices should any agile team strive to adopt? What additional practices should you consider based on your needs to scale? Adopting practices are however made much easier with the right tool support. What about if your tools adapt to your practices? We will take a look at how the Jazz technology can be leveraged to make your process change the behavior of your tools. FREE! Go There Now!

NEW! Evaluate IBM Lotus Sametime Standard V8.0 Visit IBM developerWorks to download a free trial of the latest release of IBM Lotus Sametime Standard V8.0. Lotus Sametime Standard V8.0 is a platform for unified communications and collaboration that combines security features with an extensible, open solution including integrated Voice over IP, geographic location awareness, mobile clients, and a robust Business Partner community offering telephony and video integration. FREE! Go There Now!

NEW! Rational Talks to You:Per Kroll on Rational Method Composer Plug-in customization Join this Rational Talks to You teleconference on December 11 at 1:00 pm ET to get tips on building your own plugins with Rational Method Composer. Get your questions answered! FREE! Go There Now!

NEW! Run your first CICS application on a PC using TXSeries for Windows Learn the basics of the IBM Customer Information Control System (CICS). With a hands-on exercise, learn how to get your first CICS application up and running on your desktop using TXSeries V6.1 for Windows. The tutorial shows you how to download and install a free trial version of TXSeries V6.1. FREE! Go There Now!

NEW! Trial download: IBM Rational Method Composer V7.2 Get a free trial download of the latest version of IBM Rational Method Composer V7.2 which helps you deliver customized yet consistent process guidance to your project teams and IT organization, and includes the latest version of IBM Rational Unified Process (RUP), which has provided process guidance to teams since 1996. 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! Webcast: IBM Rational Build Forge - Beyond the Build The discipline of assembling and delivering software is maturing beyond standard developer-centric compile/test software builds. The end-to-end software development lifecycle is emerging as the new focus moves “Beyond the Build.” Join this on demand webcast to learn about methods for streamlining software delivery and key capabilities of the IBM Rational Build Forge framework for automating build and release management in environments of any size. FREE! Go There Now!

All FREE IBM® developerWorks Tools!