记录集的代码有关问题
日期：2014-05-17 浏览次数：20992 次
记录集的代码问题
页面的源代码如下
<%@LANGUAGE= "VBSCRIPT " CODEPAGE= "936 "%>
<!--#include file= "../Connections/test.asp " -->
<%
Dim Recordset1__MMColParam
Recordset1__MMColParam = "1 "
If (Session( "MM_user ") <> " ") Then
Recordset1__MMColParam = Session( "MM_user ")
End If
%>
<%
Dim Recordset1
Dim Recordset1_numRows
Set Recordset1 = Server.CreateObject( "ADODB.Recordset ")
Recordset1.ActiveConnection = MM_test_STRING
Recordset1.Source = "SELECT nameid, phone, address, email, info FROM dbo.studentinfo WHERE nameid = ' " + Replace(Recordset1__MMColParam, " ' ", " ' ' ") + " ' "
Recordset1.CursorType = 0
Recordset1.CursorLocation = 2
Recordset1.LockType = 1
Recordset1.Open()
Recordset1_numRows = 0
%>
<!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=gb2312 ">
<title> 信息控制面板 </title>
<style type= "text/css ">
<!--
.style1 {
font-size: 24px;
font-weight: bold;
font-family: "隶书 ";
}
-->
</style>
</head>
<body>
<form name= "form1 " method= "post " action= " ">
<table width= "100% " height= "239 " border= "1 ">
<tr>
<td width= "38% " rowspan= "6 "> </td>
<td width= "20% "> <div align= "center "> 您的用户名是 </div> </td>
<td width= "42% "> <div align= "center ">
<input name= "txtnamefield " type= "text " id= "txtnamefield " value= " <%=(Recordset1.Fields.Item( "nameid ").Value)%> ">
</div> </td>
</tr>
<tr>
<td> <div align= "center "> 联系电话 </div> </td>
<td> <div align= "center ">
<input name= "phfield " type= "text " id= "phfield " value= " <%=(Recordset1.Fields.Item( "phone ").Value)%> ">
</div> </td&
页面的源代码如下
<%@LANGUAGE= "VBSCRIPT " CODEPAGE= "936 "%>
<!--#include file= "../Connections/test.asp " -->
<%
Dim Recordset1__MMColParam
Recordset1__MMColParam = "1 "
If (Session( "MM_user ") <> " ") Then
Recordset1__MMColParam = Session( "MM_user ")
End If
%>
<%
Dim Recordset1
Dim Recordset1_numRows
Set Recordset1 = Server.CreateObject( "ADODB.Recordset ")
Recordset1.ActiveConnection = MM_test_STRING
Recordset1.Source = "SELECT nameid, phone, address, email, info FROM dbo.studentinfo WHERE nameid = ' " + Replace(Recordset1__MMColParam, " ' ", " ' ' ") + " ' "
Recordset1.CursorType = 0
Recordset1.CursorLocation = 2
Recordset1.LockType = 1
Recordset1.Open()
Recordset1_numRows = 0
%>
<!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=gb2312 ">
<title> 信息控制面板 </title>
<style type= "text/css ">
<!--
.style1 {
font-size: 24px;
font-weight: bold;
font-family: "隶书 ";
}
-->
</style>
</head>
<body>
<form name= "form1 " method= "post " action= " ">
<table width= "100% " height= "239 " border= "1 ">
<tr>
<td width= "38% " rowspan= "6 "> </td>
<td width= "20% "> <div align= "center "> 您的用户名是 </div> </td>
<td width= "42% "> <div align= "center ">
<input name= "txtnamefield " type= "text " id= "txtnamefield " value= " <%=(Recordset1.Fields.Item( "nameid ").Value)%> ">
</div> </td>
</tr>
<tr>
<td> <div align= "center "> 联系电话 </div> </td>
<td> <div align= "center ">
<input name= "phfield " type= "text " id= "phfield " value= " <%=(Recordset1.Fields.Item( "phone ").Value)%> ">
</div> </td&
免责声明： 本文仅代表作者个人观点，与爱易网无关。其原创性以及文中陈述文字和内容未经本站证实，对本文以及其中全部或者部分内容、文字的真实性、完整性、及时性本站不作任何保证或承诺，请读者仅作参考，并请自行核实相关内容。
