<!--#include file="ACN.asp"-->
<%
' State SQL Select Statement and Drop box.
country = int(request("country"))
Set sqlStates = CreateObject("ADODB.Command")
sqlStates.ActiveConnection=objConn
sqlStates.Prepared = true
sqlStates.commandtext = "SELECT id,statename FROM state WHERE countryid=?"
sqlStates.Parameters.Append sqlStates.CreateParameter("@countryid", 3, 1, , country)
set rsStates = sqlStates.execute
%>
<select name="state" onchange="getCity(<%=country%>,this.value)">
<option>Select State</option>
<%while not rsStates.eof%>
<option value="<%=rsStates("id")%>"><%=rsStates("statename")%></option>
<%rsStates.movenext
wend
rsStates.close
set rsStates = nothing
objConn.close%>
</select>
@charset "utf-8";
/*This is for the paging.*/
#Paging {
margin:5px 0 0 0;
padding-top:5px;
}
#Paging .One {
border:1px double #000;
background-color:#036;
color:#FFF;
padding:4.5px; /*Make the selected number container larger than those around it.*/
font-size:10pt;
}
#Paging .NotOne {
border:1px double #000;
padding:2.5px;
font-size:10pt;
}
#Paging .Numbered {
border:1px double #000;
padding:2.5px;
font-size:10pt;
}
#Paging .Dots {
font-size:12px;
background-color: #f1f1f1;
color: black;
border:1px double #000;
padding:5px;
}
.StraightLined {
display: inline;
}
<html >
<head>
<meta charset="utf-8" />
<meta http-equiv="X-UA-Compatible" content="IE=edge" />
<meta name="viewport" content="width=device-width, initial-scale=1, maximum-scale=1, user-scalable=no"/>
<title>Classic ASP Login Script with MD5 HASH Protection.</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
</head>
<body style="text-align:center;">
<div id="Main" align="center"><table style="border:1px double #999;" cellspacing="0">
<caption>
<span style="font-size:15pt; color:#CCC;">Users</span>
</caption>
<thead>
<tr>
<th class="pwTD">username</th>
<th class="pwTD">password</th>
</tr>
</thead>
<tbody>
<tr valign="top">
<td class="pwTD">logincookie</td>
<td class="pwTD">12345678</td>
</tr>
</tbody>
<tfoot>
</tfoot>
</table>
<form action="Tutorials/carrzkiss/7/login validate.asp" method="post" id="Login" style="background-color:#333333;">
<table id="LoginTD" cellspacing="0">
<tr><td style="width:90px;">User Name:</td><td style="width:120px;"> <input class="InputClass" type="UserName" name="UserName" /></td></tr>
<tr> <td style="width:90px;"> Password:</td><td style="width:120px;"><input class="InputClass" type="password" name="PassWord" value="" /></td></tr>
<tr><td colspan="2">
<div align="center">
<input class="InputClass" type="submit" name="Submit" value="Login" />
</div>
</td>
</tr>
</table>
</form>
<br />
Thank You<br />
</div>
</div>
</body>
</html>
// JavaScript Document
$(function() {
//More Button
$('.more').live("click",function()
{
var ID = $(this).attr("id");
if(ID)
{
$("#more"+ID).html('<img src="moreajax.gif" />');
$.ajax({
type: "POST",
//https://www.cffcs.com/Lessons/2051/
url: "Ajax more.asp",
data: "lastmsg="+ ID,
cache: false,
success: function(html){
$("ol#updates").append(html);
$("#more"+ID).remove();
}
});
}
else
{
$(".morebox").html('The End');
}
return false;
});
});
-- Create a new database called [Test] in SQL Server.
-- Right-click and choose [New Query]
-- Copy and paste the code below and hit [Execute]
USE [Test]
GO
/****** Object: Table [dbo].[Tags] Script Date: 4/4/2022 1:12:42 PM ******/
CREATE TABLE [dbo].[Tags](
[TagID][int] IDENTITY(1,1) NOT NULL,
[TagName][nvarchar](50) NOT NULL,
CONSTRAINT [PK Tags] PRIMARY KEY CLUSTERED
(
[TagID] ASC
)WITH (PAD INDEX = OFF, STATISTICS NORECOMPUTE = OFF, IGNORE DUP KEY = OFF, ALLOW ROW LOCKS = ON, ALLOW PAGE LOCKS = ON, OPTIMIZE FOR SEQUENTIAL KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
SET IDENTITY INSERT [dbo].[Tags] ON
GO
INSERT [dbo].[Tags] ([TagID], [TagName]) VALUES (1, N'Dallas')
GO
INSERT [dbo].[Tags] ([TagID], [TagName]) VALUES (2, N'Charlotte')
GO
INSERT [dbo].[Tags] ([TagID], [TagName]) VALUES (3, N'Raleigh')
GO
INSERT [dbo].[Tags] ([TagID], [TagName]) VALUES (4, N'Houston')
GO
INSERT [dbo].[Tags] ([TagID], [TagName]) VALUES (5, N'Washington')
GO
INSERT [dbo].[Tags] ([TagID], [TagName]) VALUES (6, N'New York')
GO
INSERT [dbo].[Tags] ([TagID], [TagName]) VALUES (7, N'Los Angeles')
GO
INSERT [dbo].[Tags] ([TagID], [TagName]) VALUES (8, N'Sydney')
GO
INSERT [dbo].[Tags] ([TagID], [TagName]) VALUES (9, N'Melbourne')
GO
SET IDENTITY INSERT [dbo].[Tags] OFF
GO
, USE [Test]
GO
/****** Object: Table [dbo].[Tags] Script Date: 4/4/2022 1:12:42 PM ******/
CREATE TABLE [dbo].[Tags](
[TagID][int] IDENTITY(1,1) NOT NULL,
[TagName][nvarchar](50) NOT NULL,
CONSTRAINT [PK Tags] PRIMARY KEY CLUSTERED
(
[TagID] ASC
)WITH (PAD INDEX = OFF, STATISTICS NORECOMPUTE = OFF, IGNORE DUP KEY = OFF, ALLOW ROW LOCKS = ON, ALLOW PAGE LOCKS = ON, OPTIMIZE FOR SEQUENTIAL KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
SET IDENTITY INSERT [dbo].[Tags] ON
GO
INSERT [dbo].[Tags] ([TagID], [TagName]) VALUES (1, N'Dallas')
GO
INSERT [dbo].[Tags] ([TagID], [TagName]) VALUES (2, N'Charlotte')
GO
INSERT [dbo].[Tags] ([TagID], [TagName]) VALUES (3, N'Raleigh')
GO
INSERT [dbo].[Tags] ([TagID], [TagName]) VALUES (4, N'Houston')
GO
INSERT [dbo].[Tags] ([TagID], [TagName]) VALUES (5, N'Washington')
GO
INSERT [dbo].[Tags] ([TagID], [TagName]) VALUES (6, N'New York')
GO
INSERT [dbo].[Tags] ([TagID], [TagName]) VALUES (7, N'Los Angeles')
GO
INSERT [dbo].[Tags] ([TagID], [TagName]) VALUES (8, N'Sydney')
GO
INSERT [dbo].[Tags] ([TagID], [TagName]) VALUES (9, N'Melbourne')
GO
SET IDENTITY INSERT [dbo].[Tags] OFF
GO