|
Generic Database Display
Made Easy
When you want a quick easy generic database
display, go on over to:
http://www.genericdb.com Here
Eli Robillard has done a lot of work for you. You modify one ASP file that
specifies your database and query specs and his ASP scripts magically do the
rest. Here is an example where I make
a pubs.asp designed to plug into his ASP scripts.
filename=/learn/test/genericdb/pub.asp
<%
' Generic interface to the Northwinds Employee table.
Session("dbGenericPath") = "/learn/test/genericdb/"
Session("dbExitPage") = "http://www.activeserverpages.com"
Session("dbTitle") = "Pubs"
Session("dbType") = "SQL"
Session("dbConn") = "DSN=student;uid=student;pwd=magic"
Session("dbRs") = "Publishers"
Session("dbKey") = 1
Session("dbOrder") = 2
Session("dbRecsPerPage") = 10
Session("dbFooter") = 1
Session("dbDispList") = "011101000000100010"
Session("dbDispView") = "111111111111111111"
Session("dbDispEdit") = "011111111111111111"
Session("dbSearchFields") = "011100010010001000"
Session("dbDefault6") = Date()
Session("dbCombo11") = "LIST, ??, Unknown, CA, Canada, US, United States, DE, Denmark"
Session("dbDefault17") = 10
Session("dbWhere") = ""
Session("dbDebug") = 1
Session("dbCanEdit") = 1
Session("dbCanAdd") = 1
Session("dbCanDelete") = 1
Session("dbConfirmDelete") = 1
Session("dbViewPage") = Request.ServerVariables("PATH_INFO")
Response.Redirect Session("dbGenericPath") & "GenericList.asp"
%>
>
There is even a listserve
supporting this great FREE script collection @
http://www.asplists.com/asplists/aspgenericdb.asp
It is not a general database troubleshooting
list, instead only questions concerning these wonderful scripts are allowed.
|