|
|
 |
|
|
Published: Monday, January 17, 2000 By Geno Timlin When creating a data-driven web site, you obviously need to use a number of SQL queries to grab datasets from your database. Before you use a particular SQL query in one of your production ASP pages, though, you want to ensure that it returns the correct information. Therefore, a SQL query test web page, one that allows you to try various SQL statements and view their results, will often come in handy.
For every web database project I work on, I pop this code somewhere onto the server. This page allows me to test out SQL queries before I put them into my ASP. Recently I was doing a project on a co-located SQL Server in Atlanta. I used this page to set up all the tables from my home office in Florida. The idea is simple. You put SQL code into the form, select the DSN from the drop down list and click submit. If the recordset contains columns, a table is built to display all rows and all columns. If the SQL is an data manipulation statement, a message appears stating that the command completed successfully. One of the cool features is the clipboard. You can cut and paste SQL into the clipboard and it will be there each time you submit the form. The drop down list of DSN's is fairly simple, you set up an array of DSN strings and loop through them to fill the drop down list. Sometimes I use another textarea for the DSN instead of the drop down list. This allows me to try out different connection strings. I've become familiar enough with the Microsoft error messages so I haven't built in any fancy error checking. Well, here's the code, I hope you find it useful! If you have any questions, comments, or ideas for improvement, please email me.
Notice that I have the list of System DSN's hard coded into the above code. The disadvantage with that is when new DSNs are added, or old ones are removed, this ASP page must be updated. To overcome this problem, I highly recommend that you use Mike Shaffer's free DSN listing component. The complete source code and an detailed article can be found here. Here is a screen shot of the system in action! 
Happy Programming!
Attachments:
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
 |
 |
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
| ||||||||||||
Jupitermedia Corporation has two divisions: Jupiterimages and JupiterOnlineMedia
Legal Notices, Licensing, Reprints, Permissions, Privacy Policy.
Whitepapers and eBooks
Webcasts
Downloads and eKits
Tutorials and Demos
|
