<%@LANGUAGE="VBSCRIPT" CODEPAGE="65001"%>
<%
Set connectString = Server.CreateObject("ADODB.Connection")
connectString.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & _
Server.MapPath ("..\asia2\login\css_users.mdb") & ";"
connectString.Open
ID = request.QueryString("ID")
Set sqlContent = CreateObject("ADODB.Command")
sqlContent.ActiveConnection=connectString
sqlContent.Prepared = true
sqlContent.commandtext = "SELECT Users.ID, Users.FName, Users.LName, Users.Email, Users.Password, Users.Country, Users.Telephone, Users.Mobile, Users.Company, Users.Address, Users.Status FROM Users INNER JOIN WHERE Users.ID=?"
'"SELECT Users.ID, Users.FName, Users.LName, Users.Email, Users.Password, Users.Country, Users.Telephone, Users.Mobile, Users.Company, Users.Address, Users.Status FROM Users INNER JOIN series ON products.seriesid = series.seriesid WHERE products.seriesid=?"
sqlContent.Parameters.Append sqlContent.CreateParameter("@seriesid", 3, 1, , SeriesID)
Set rsProducts = sqlContent.Execute
if not rsProducts.eof then
series_name = rsProducts("series_name")
end if
%>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
-------------------
<table width="100%" border="1" bordercolor="#cccccc" cellpadding="0" bgcolor="#999999">
<!--<form name="form" id="form" method="post" action="signup_result2.asp" onSubmit="return checkform(this)">-->
<tr>
<td class="td" width="23%" align="right">First Name:</td>
<td width="77%"><b><font class="b"><%=rsUsers("FName")%></font></b>
</td>
</tr>
<tr>
<td class="td" width="23%" align="right">Last Name:</td>
<td width="77%"><font class="b"><%=rsUsers("LName")%></font>
</b>
</td>
</tr>
<tr>
<td class="td" width="23%" align="right">Email:</td>
<td width="77%"><font class="b"><%=rsUsers("Email")%></font></b>
</td>
</tr>
<tr>
<td class="td" width="23%" align="right">Password:</td>
<td width="77%"><font class="b"><%=rsUsers("Password")%></font></b>
</td>
</tr>
<tr>
<td class="td" width="23%" align="right">Country:</td>
<td width="77%"><font class="b"><%=rsUsers("Country")%></font></b>
</td>
</tr>
<tr>
<td class="td" width="23%" align="right">Telephone:</td>
<td width="77%"><font class="b"><%=rsUsers("Telephone")%></font></b>
</td>
</tr>
<tr>
<td class="td" width="23%" align="right">Mobile:</td>
<td width="77%"><font class="b"><%=rsUsers("Mobile")%></font></b>
</td>
</tr>
<tr>
<td class="td" width="23%" align="right">Company:</td>
<td width="77%"><font class="b"><%=rsUsers("Company")%></font></b>
</td>
</tr>
<tr valign="top">
<td class="td" width="23%" align="right">Address:</td>
<td width="77%"><font class="b"><%=rsUsers("Address")%></font>
</b>
</td>
</tr>
<tr valign="top">
<td class="td" width="23%" align="right">Status:</td>
<td width="77%"><font class="b"><%=rsUsers("Status")%></font>
</b>
</td>
</tr>
<tr>
<td class="td" width="23%" align="right">Activate:</td>
<td width="77%">
<input name="activate" type="radio" value="Activate" checked />
<input name="notactivate" type="radio" value="Not Activate" />
</td>
</tr>
</table>
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
From novice to tech pro — start learning today.
sumamry.asp:
Open in new window
Details.asp:
Open in new window
If this is not what you want., then explain yourself better.