<% ‘define variables DIM objConn, objRS ‘connection DIM i_last, count, bgcolor ‘even row bg color Dim job, recID ‘fetching query strings job = Request.QueryString(“do”) recID = Request.QueryString(“rid”) Dim sqlstatement ‘ sql query command string If job = “del” Then SET objConn = Server.CreateObject(“ADODB.Connection”) objConn.ConnectionTimeOut = 30 objConn.Open “DSN=MySystemDSN” sqlstatement = “DELETE FROM Customers WHERE ID=” […]
Home » Posts tagged "Classic ASP" (Page 2)
Archive for the 'Classic ASP' Tag
Classic ASP – Date and time formating
Code <script type=”text/vbscript”> document.write(DateAdd(“yyyy”,1,”31-Jan-10″) & “”) document.write(DateAdd(“q”,1,”31-Jan-10″) & “”) document.write(DateAdd(“m”,1,”31-Jan-10″) & “”) document.write(DateAdd(“y”,1,”31-Jan-10″) & “”) document.write(DateAdd(“d”,1,”31-Jan-10″) & “”) document.write(DateAdd(“w”,1,”31-Jan-10″) & “”) document.write(DateAdd(“ww”,1,”31-Jan-10″) & “”) document.write(DateAdd(“h”,1,”31-Jan-10 08:50:00″) & “”) document.write(DateAdd(“n”,1,”31-Jan-10 08:50:00″) & “”) document.write(DateAdd(“s”,1,”31-Jan-10 08:50:00″) & “”) </script> Output 1/31/2011 4/30/2010 2/28/2010 2/1/2010 2/1/2010 2/1/2010 2/7/2010 1/31/2010 9:50:00 AM 1/31/2010 8:51:00 AM 1/31/2010 8:50:01 AM
Text-box autocomplete
The code is initial designed by Mircho Mirev [ momche.net ]. I’ve enhanced this script so instead of array of static data the text-box auto-complete uses database back end. Default.asp <%@LANGUAGE=”VBSCRIPT” CODEPAGE=”65001″%> <!DOCTYPE HTML PUBLIC “-//W3C//DTD HTML 4.01 Transitional//EN” “http://www.w3.org/TR/html4/loose.dtd”> <html> <head> <meta http-equiv=”Content-Type” content=”text/html; charset=utf-8″> <title>Intellisense Example</title> <SCRIPT language=”JavaScript” src=”moautocomplete.js”></SCRIPT> </head> <body style=”font-family: Verdana, […]