陶益数码工作室-Dreamweaver开发ASP视频教程
你的位置:首页 >>> 站内帮助 >>> VIP热点问题 >>> float 与 ntext 不兼容
VIP技术支持中心
欢迎你访问热点问题!我们回答了会员大量的问题,请搜索你想要的 
float 与 ntext 不兼容
问题类型 DW实际开发中的问题 提交时间 2014-11-20 23:57:00
[会员 186*** 提出的问题如下]

我在插入记录时提示:

Microsoft OLE DB Provider for SQL Server 错误 '80040e07'

操作数类型冲突: float 与 ntext 不兼容

/Admin/Admin_tjsj.asp,行 142

麻烦陶老师帮我看看

代码如下(142行已用红色加粗标注):

<%@LANGUAGE="VBSCRIPT" CODEPAGE="65001"%>
<!--#include file="../Connections/Conn.asp" -->
<%
Dim MM_editAction
MM_editAction = CStr(Request.ServerVariables("SCRIPT_NAME"))
If (Request.QueryString <> "") Then
  MM_editAction = MM_editAction & "?" & Server.HTMLEncode(Request.QueryString)
End If

' boolean to abort record edit
Dim MM_abortEdit
MM_abortEdit = false
%>
<%
' IIf implementation
Function MM_IIf(condition, ifTrue, ifFalse)
  If condition = "" Then
    MM_IIf = ifFalse
  Else
    MM_IIf = ifTrue
  End If
End Function
%>
<%
If (CStr(Request("MM_insert")) = "myform") Then
  If (Not MM_abortEdit) Then
    ' execute the insert
    Dim MM_editCmd

    Set MM_editCmd = Server.CreateObject ("ADODB.Command")
    MM_editCmd.ActiveConnection = MM_Conn_STRING
    MM_editCmd.CommandText = "INSERT INTO dbo.Shouji_biao (Sj_pp, Sj_xh, Sj_ys, Sj_wg, Sj_czxt, Sj_ui, Sj_cpu, Sj_zp, Sj_srfs, Sj_jplx, Sj_wlzs, Sj_wlzs, Sj_wlzs, Sj_wlzs, Sj_wlzs, Sj_wlzs, Sj_wlzs, Sj_wlpl, Sj_sjyw, Sj_sjyw, Sj_sjyw, Sj_sjyw, Sj_sjyw, Sj_sjyw, Sj_dsklx, Sj_sim, Sj_ram, Sj_rom, Sj_sdlx, Sj_cckz, Sj_pmcc, Sj_pmsc, Sj_pmcz, Sj_pmfbl, Sj_cmplx, Sj_zlgy, Sj_gxgy, Sj_jlgy, Sj_tly, Sj_zwcgq, Sj_yybf, Sj_yybf, Sj_yybf, Sj_yybf, Sj_yybf, Sj_yybf, Sj_yybf, Sj_spbf, Sj_spbf, Sj_spbf, Sj_spbf, Sj_spbf, Sj_spbf, Sj_spbf, Sj_spbf, Sj_spbf, Sj_syj, Sj_syj, Sj_syj, Sj_zsxt, Sj_fsxt, Sj_sgd, Sj_spps, Sj_zpfbl, Sj_djfs, Sj_djfs, Sj_sxtqtxn, Sj_bgrj, Sj_dzyj, Sj_dzyj, Sj_jsq, Sj_nz, Sj_nz, Sj_nz, Sj_lygn, Sj_lygn, Sj_lygn, Sj_gps, Sj_gps, Sj_gps, Sj_gps, Sj_wifi, Sj_wifi, Sj_hwx, Sj_bluetooth, Sj_bluetooth, Sj_bluetooth, Sj_bluetooth, Sj_nfc, Sj_dclx, Sj_dcrl, Sj_lldjsj, Sj_llthsj, Sj_sjx, Sj_sjx, Sj_sjx, Sj_ejjk, Sj_jszl, Sj_jscc, Sj_pic1, Sj_pic2, Sj_pic3, Sj_pic4, Sj_pic5, Sj_price, Sj_djs, Sj_zuozhe, Sj_nrjj) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"
    MM_editCmd.Prepared = true
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param1", 5, 1, -1, MM_IIF(Request.Form("Sjpp_mc"), Request.Form("Sjpp_mc"), null)) ' adDouble
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param2", 202, 1, 50, Request.Form("Sj_xh")) ' adVarWChar
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param3", 202, 1, 50, Request.Form("Sj_ys")) ' adVarWChar
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param4", 202, 1, 50, Request.Form("Sj_wg")) ' adVarWChar
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param5", 202, 1, 50, Request.Form("Sj_czxt")) ' adVarWChar
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param6", 202, 1, 50, Request.Form("Sj_ui")) ' adVarWChar
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param7", 202, 1, 50, Request.Form("Sj_cpu")) ' adVarWChar
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param8", 202, 1, 50, Request.Form("Sj_zp")) ' adVarWChar
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param9", 202, 1, 50, Request.Form("Sj_srfs")) ' adVarWChar
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param10", 202, 1, 50, Request.Form("Sj_jplx")) ' adVarWChar
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param11", 203, 1, 1073741823, Request.Form("Sj_wlzs_0")) ' adLongVarWChar
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param12", 203, 1, 1073741823, Request.Form("Sj_wlzs_1")) ' adLongVarWChar
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param13", 203, 1, 1073741823, Request.Form("Sj_wlzs_2")) ' adLongVarWChar
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param14", 203, 1, 1073741823, Request.Form("Sj_wlzs_3")) ' adLongVarWChar
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param15", 203, 1, 1073741823, Request.Form("Sj_wlzs_4")) ' adLongVarWChar
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param16", 203, 1, 1073741823, Request.Form("Sj_wlzs_5")) ' adLongVarWChar
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param17", 203, 1, 1073741823, Request.Form("Sj_wlzs_6")) ' adLongVarWChar
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param18", 203, 1, 1073741823, Request.Form("Sj_wlpl")) ' adLongVarWChar
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param19", 202, 1, 50, Request.Form("Sj_sjyw_0")) ' adVarWChar
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param20", 202, 1, 50, Request.Form("Sj_sjyw_1")) ' adVarWChar
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param21", 202, 1, 50, Request.Form("Sj_sjyw_2")) ' adVarWChar
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param22", 202, 1, 50, Request.Form("Sj_sjyw_3")) ' adVarWChar
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param23", 202, 1, 50, Request.Form("Sj_sjyw_4")) ' adVarWChar
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param24", 202, 1, 50, Request.Form("Sj_sjyw_5")) ' adVarWChar
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param25", 203, 1, 1073741823, Request.Form("Sj_dsklx")) ' adLongVarWChar
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param26", 203, 1, 1073741823, Request.Form("Sj_sim")) ' adLongVarWChar
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param27", 202, 1, 50, Request.Form("Sj_ram")) ' adVarWChar
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param28", 202, 1, 50, Request.Form("Sj_rom")) ' adVarWChar
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param29", 202, 1, 50, Request.Form("Sj_sdlx")) ' adVarWChar
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param30", 202, 1, 50, Request.Form("Sj_cckz")) ' adVarWChar
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param31", 202, 1, 50, Request.Form("Sj_pmcc")) ' adVarWChar
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param32", 202, 1, 50, Request.Form("Sj_pmsc")) ' adVarWChar
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param33", 202, 1, 50, Request.Form("Sj_pmcz")) ' adVarWChar
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param34", 202, 1, 50, Request.Form("Sj_pmfbl")) ' adVarWChar
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param35", 202, 1, 50, Request.Form("Sj_cmplx")) ' adVarWChar
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param36", 202, 1, 50, Request.Form("Sj_zlgy")) ' adVarWChar
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param37", 202, 1, 50, Request.Form("Sj_gxgy")) ' adVarWChar
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param38", 202, 1, 50, Request.Form("Sj_jlgy")) ' adVarWChar
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param39", 202, 1, 50, Request.Form("Sj_tly")) ' adVarWChar
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param40", 203, 1, 1073741823, Request.Form("Sj_zwcgq")) ' adLongVarWChar
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param41", 203, 1, 1073741823, Request.Form("Sj_yybf_0")) ' adLongVarWChar
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param42", 203, 1, 1073741823, Request.Form("Sj_yybf_1")) ' adLongVarWChar
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param43", 203, 1, 1073741823, Request.Form("Sj_yybf_2")) ' adLongVarWChar
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param44", 203, 1, 1073741823, Request.Form("Sj_yybf_3")) ' adLongVarWChar
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param45", 203, 1, 1073741823, Request.Form("Sj_yybf_4")) ' adLongVarWChar
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param46", 203, 1, 1073741823, Request.Form("Sj_yybf_5")) ' adLongVarWChar
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param47", 203, 1, 1073741823, Request.Form("Sj_yybf_6")) ' adLongVarWChar
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param48", 203, 1, 1073741823, Request.Form("Sj_spbf_0")) ' adLongVarWChar
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param49", 203, 1, 1073741823, Request.Form("Sj_spbf_1")) ' adLongVarWChar
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param50", 203, 1, 1073741823, Request.Form("Sj_spbf_2")) ' adLongVarWChar
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param51", 203, 1, 1073741823, Request.Form("Sj_spbf_3")) ' adLongVarWChar
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param52", 203, 1, 1073741823, Request.Form("Sj_spbf_4")) ' adLongVarWChar
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param53", 203, 1, 1073741823, Request.Form("Sj_spbf_5")) ' adLongVarWChar
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param54", 203, 1, 1073741823, Request.Form("Sj_spbf_6")) ' adLongVarWChar
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param55", 203, 1, 1073741823, Request.Form("Sj_spbf_7")) ' adLongVarWChar
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param56", 203, 1, 1073741823, Request.Form("Sj_spbf_8")) ' adLongVarWChar
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param57", 202, 1, 50, Request.Form("Sj_syj_0")) ' adVarWChar
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param58", 202, 1, 50, Request.Form("Sj_syj_1")) ' adVarWChar
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param59", 202, 1, 50, Request.Form("Sj_syj_2")) ' adVarWChar
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param60", 203, 1, 1073741823, Request.Form("Sj_zsxt")) ' adLongVarWChar
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param61", 203, 1, 1073741823, Request.Form("Sj_fsxt")) ' adLongVarWChar
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param62", 202, 1, 50, Request.Form("Sj_sgd")) ' adVarWChar
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param63", 202, 1, 50, Request.Form("Sj_spps")) ' adVarWChar
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param64", 202, 1, 50, Request.Form("Sj_zpfbl")) ' adVarWChar
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param65", 202, 1, 50, Request.Form("Sj_djfs_0")) ' adVarWChar
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param66", 202, 1, 50, Request.Form("Sj_zddj_1")) ' adVarWChar
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param67", 203, 1, 1073741823, Request.Form("Sj_sxtqtxn")) ' adLongVarWChar
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param68", 202, 1, 50, Request.Form("Sj_bgrj")) ' adVarWChar
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param69", 202, 1, 50, Request.Form("Sj_dzyj_0")) ' adVarWChar
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param70", 202, 1, 50, Request.Form("Sj_dzyj_1")) ' adVarWChar
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param71", 202, 1, 50, Request.Form("Sj_jsq")) ' adVarWChar
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param72", 202, 1, 50, Request.Form("Sj_nz_0")) ' adVarWChar
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param73", 202, 1, 50, Request.Form("Sj_nz_1")) ' adVarWChar
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param74", 202, 1, 50, Request.Form("Sj_nz_2")) ' adVarWChar
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param75", 202, 1, 50, Request.Form("Sj_lygn_0")) ' adVarWChar
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param76", 202, 1, 50, Request.Form("Sj_lygn_1")) ' adVarWChar
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param77", 202, 1, 50, Request.Form("Sj_lygn_2")) ' adVarWChar
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param78", 202, 1, 50, Request.Form("Sj_gps_0")) ' adVarWChar
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param79", 202, 1, 50, Request.Form("Sj_gps_1")) ' adVarWChar
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param80", 202, 1, 50, Request.Form("Sj_gps_2")) ' adVarWChar
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param81", 202, 1, 50, Request.Form("Sj_gps_3")) ' adVarWChar
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param82", 202, 1, 50, Request.Form("Sj_wifi_0")) ' adVarWChar
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param83", 202, 1, 50, Request.Form("Sj_wifi_1")) ' adVarWChar
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param84", 202, 1, 50, Request.Form("Sj_hwx")) ' adVarWChar
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param85", 202, 1, 50, Request.Form("Sj_bluetooth_0")) ' adVarWChar
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param86", 202, 1, 50, Request.Form("Sj_bluetooth_1")) ' adVarWChar
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param87", 202, 1, 50, Request.Form("Sj_bluetooth_2")) ' adVarWChar
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param88", 202, 1, 50, Request.Form("Sj_bluetooth_3")) ' adVarWChar
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param89", 202, 1, 50, Request.Form("Sj_nfc")) ' adVarWChar
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param90", 202, 1, 50, Request.Form("Sj_dclx")) ' adVarWChar
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param91", 202, 1, 50, Request.Form("Sj_dcrl")) ' adVarWChar
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param92", 203, 1, 1073741823, Request.Form("Sj_lldjsj")) ' adLongVarWChar
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param93", 203, 1, 1073741823, Request.Form("Sj_llthsj")) ' adLongVarWChar
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param94", 202, 1, 50, Request.Form("Sj_sjx_0")) ' adVarWChar
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param95", 202, 1, 50, Request.Form("Sj_sjx_1")) ' adVarWChar
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param96", 202, 1, 50, Request.Form("Sj_sjx_2")) ' adVarWChar
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param97", 202, 1, 50, Request.Form("Sj_ejjk")) ' adVarWChar
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param98", 202, 1, 50, Request.Form("Sj_jszl")) ' adVarWChar
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param99", 202, 1, 50, Request.Form("Sj_jscc")) ' adVarWChar
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param100", 203, 1, 1073741823, Request.Form("d_image1")) ' adLongVarWChar
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param101", 202, 1, 50, Request.Form("d_image2")) ' adVarWChar
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param102", 202, 1, 50, Request.Form("d_image3")) ' adVarWChar
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param103", 202, 1, 50, Request.Form("d_image4")) ' adVarWChar
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param104", 202, 1, 50, Request.Form("d_image5")) ' adVarWChar
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param105", 202, 1, 50, Request.Form("Sj_price")) ' adVarWChar
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param106", 5, 1, -1, MM_IIF(Request.Form("Sj_djs"), Request.Form("Sj_djs"), null)) ' adDouble
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param107", 202, 1, 50, Request.Form("Sj_zuozhe")) ' adVarWChar
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param108", 203, 1, 1073741823, Request.Form("editor")) ' adLongVarWChar
    MM_editCmd.Execute
    MM_editCmd.ActiveConnection.Close

    ' append the query string to the redirect URL
    Dim MM_editRedirectUrl
    MM_editRedirectUrl = "Admin_sj.asp"
    If (Request.QueryString <> "") Then
      If (InStr(1, MM_editRedirectUrl, "?", vbTextCompare) = 0) Then
        MM_editRedirectUrl = MM_editRedirectUrl & "?" & Request.QueryString
      Else
        MM_editRedirectUrl = MM_editRedirectUrl & "&" & Request.QueryString
      End If
    End If
%>
<script>
alert("添加成功!")
window.location.href="Admin_sj.asp"
</script>
  <% End If %>
<% End If %>
<%
' *** Restrict Access To Page: Grant or deny access to this page
MM_authorizedUsers=""
MM_authFailedURL="Error5.asp"
MM_grantAccess=false
If Session("MM_Username") <> "" Then
  If (true Or CStr(Session("MM_UserAuthorization"))="") Or _
         (InStr(1,MM_authorizedUsers,Session("MM_UserAuthorization"))>=1) Then
    MM_grantAccess = true
  End If
End If
If Not MM_grantAccess Then
  MM_qsChar = "?"
  If (InStr(1,MM_authFailedURL,"?") >= 1) Then MM_qsChar = "&"
  MM_referrer = Request.ServerVariables("URL")
  if (Len(Request.QueryString()) > 0) Then MM_referrer = MM_referrer & "?" & Request.QueryString()
  MM_authFailedURL = MM_authFailedURL & MM_qsChar & "accessdenied=" & Server.URLEncode(MM_referrer)
  Response.Redirect(MM_authFailedURL)
End If
%>
<%
Dim Recordset1
Dim Recordset1_cmd
Dim Recordset1_numRows

Set Recordset1_cmd = Server.CreateObject ("ADODB.Command")
Recordset1_cmd.ActiveConnection = MM_Conn_STRING
Recordset1_cmd.CommandText = "SELECT * FROM dbo.Sjpp_biao ORDER BY Sjpp_ID ASC"
Recordset1_cmd.Prepared = true

Set Recordset1 = Recordset1_cmd.Execute
Recordset1_numRows = 0
%>
<%
Dim Recordset2__MMColParam
Recordset2__MMColParam = "1"
If (Session("MM_UserName") <> "") Then
  Recordset2__MMColParam = Session("MM_UserName")
End If
%>
<%
Dim Recordset2
Dim Recordset2_cmd
Dim Recordset2_numRows

Set Recordset2_cmd = Server.CreateObject ("ADODB.Command")
Recordset2_cmd.ActiveConnection = MM_Conn_STRING
Recordset2_cmd.CommandText = "SELECT ID, UserName, PassWord, Name FROM dbo.Staff WHERE UserName = ?"
Recordset2_cmd.Prepared = true
Recordset2_cmd.Parameters.Append Recordset2_cmd.CreateParameter("param1", 200, 1, 50, Recordset2__MMColParam) ' adVarChar

Set Recordset2 = Recordset2_cmd.Execute
Recordset2_numRows = 0
%>
<!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>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>无标题文档</title>
<script type="text/javascript" charset="gbk" src="../ueditor/ueditor.config.js"></script>
<script type="text/javascript" charset="gbk" src="../ueditor/ueditor.all.min.js"> </script>
<script type="text/javascript" charset="gbk" src="../ueditor/lang/zh-cn/zh-cn.js"></script>
<style type="text/css">
body a:link,a:active,a:visited {
 color: #000;
 text-decoration:none;
 cursor: pointer;
}
body a:hover {
 color: #ff0000;
}
body,html{
      SCROLLBAR-FACE-COLOR:#E36C0A;
      SCROLLBAR-HIGHLIGHT-COLOR:#FFFFFF;
      SCROLLBAR-SHADOW-COLOR:#FFFFFF;
      SCROLLBAR-3DLIGHT-COLOR:#C0C0C0;
      SCROLLBAR-ARROW-COLOR:#FFFFFF;
      SCROLLBAR-TRACK-COLOR:#D4D0C8;
      SCROLLBAR-DARKSHADOW-COLOR:#E36C0A;
      CURSOR: default;
}
#tzlb_bt {
 background-image: url(../Images/newnotice_tittlebg.png);background-repeat: repeat-x;margin: 0px;padding: 0px;height: 32px;width: 100%;
}
#tzlb_bt .tzlb_pic {
 margin: 10px auto 10px 10px;padding: 0px;float: left;height: 12px;width: 12px;
}
#tzlb_bt .tzlb_tittle {
 font-family: "微软雅黑";font-size: 14px;line-height: 32px;font-weight: bold;color: #F00;text-decoration: none;margin-left: 5px;padding: 0px;
}
#tjtzlb_bd {
 background-color: #CCC;margin: 10px auto;padding: 0px;
 font-family: "微软雅黑";font-size: 12px;font-weight: bold;color: #000;text-decoration: none;
}
.srk {
 font-family: "微软雅黑";font-size: 12px;color: #e36c0a;text-decoration: none;
 margin-left: 10px;padding-left: 5px;height: 20px;border: 1px solid #000;border-radius: 3px;
}
.anniu {
 font-family: "微软雅黑";font-size: 12px;font-weight: bold;color: #FFF;text-decoration: none;
 background-image: url(../Images/button_bg.png);background-repeat: no-repeat;text-align: center;
 margin: 0px;padding: 0px;height: 25px;width: 60px;border: none; cursor: pointer;
}
.lbcd {
 font-family: "微软雅黑";font-size: 12px;color: #e36c0a;text-decoration: none;
 margin-left: 10px;padding: 0px;
 height: 20px;border: 1px solid #000;border-radius: 3px;
}
.wby {
 margin-left: 10px;padding: 0px;
}
</style>
<script language="javascript">
// 参数说明
// s_Type : 文件类型,可用值为"image","flash","media","file"
// s_Link : 文件上传后,用于接收上传文件路径文件名的表单名
// s_Thumbnail : 文件上传后,用于接收上传图片时所产生的缩略图文件的路径文件名的表单名,当未生成缩略图时,返回空值,原图用s_Link参数接收,此参数专用于缩略图
function showUploadDialog(s_Type, s_Link, s_Thumbnail){
 //以下style=coolblue,值可以依据实际需要修改为您的样式名,通过此样式的后台设置来达到控制允许上传文件类型及文件大小
 var arr = showModalDialog("../ewebeditor/dialog/i_upload.htm?style=coolblue&type="+s_Type+"&link="+s_Link+"&thumbnail="+s_Thumbnail, window, "dialogWidth:0px;dialogHeight:0px;help:no;scroll:no;status:no");
}
</script>
</head>

<body>
<div id="tzlb_bt">
    <span class="tzlb_pic"><img src="../Images/icon.gif" width="12" height="12" /></span>
<span class="tzlb_tittle">添加手机</span></div>
<form ACTION="<%=MM_editAction%>" METHOD="POST" name="myform" id="myform">
<table width="100%" border="0" cellpadding="0" cellspacing="1" id="tjtzlb_bd">
      <tr>
        <td width="30%" height="32" align="center" valign="middle" bgcolor="#FFCC33">主体信息</td>
        <td width="70%" height="32" align="left" valign="middle" bgcolor="#FFCC33">&nbsp;</td>
      </tr>
      <tr>
            <td width="30%" height="32" align="right" valign="middle" bgcolor="#FFFFFF"><span class="tzlb_tittle">手机品牌</span>:</td>
        <td width="70%" height="32" align="left" valign="middle" bgcolor="#FFFFFF"><select name="Sjpp_mc" class="lbcd" id="Sjpp_mc">
          <%
While (NOT Recordset1.EOF)
%>
          <option value="<%=(Recordset1.Fields.Item("Sjpp_ID").Value)%>"><%=(Recordset1.Fields.Item("Sjpp_mc").Value)%></option>
          <%
  Recordset1.MoveNext()
Wend
If (Recordset1.CursorType > 0) Then
  Recordset1.MoveFirst
Else
  Recordset1.Requery
End If
%>
        </select></td>
        </tr>
        <tr>
          <td width="30%" height="32" align="right" valign="middle" bgcolor="#FFFFFF"><span class="tzlb_tittle">手机</span>型号:</td>
          <td width="70%" height="32" align="left" valign="middle" bgcolor="#FFFFFF"><input name="Sj_xh" type="text" class="srk" id="Sj_xh" size="30" /></td>
        </tr>
        <tr>
          <td width="30%" height="32" align="right" valign="middle" bgcolor="#FFFFFF">颜色:</td>
          <td width="70%" height="32" align="left" valign="middle" bgcolor="#FFFFFF"><select name="Sj_ys" class="lbcd" id="Sj_ys">
            <option value="银色" selected="selected">银色</option>
            <option value="金色">金色</option>
            <option value="深空灰">深空灰</option>
            <option value="白色">白色</option>
            <option value="黑色">黑色</option>
            <option value="棕色">棕色</option>
            <option value="深邃黑">深邃黑</option>
            <option value="曜石黑色">曜石黑色</option>
            <option value="月光银色">月光银色</option>
            <option value="雅墨黑色">雅墨黑色</option>
            <option value="幻影白色">幻影白色</option>
            <option value="暮光金色">暮光金色</option>
            <option value="花漾粉色">花漾粉色</option>
            <option value="蓝色">蓝色</option>
            <option value="粉色">粉色</option>
          </select></td>
        </tr>
        <tr>
          <td width="30%" height="32" align="right" valign="middle" bgcolor="#FFFFFF"><span class="tzlb_tittle">外观</span>:</td>
          <td width="70%" height="32" align="left" valign="middle" bgcolor="#FFFFFF"><select name="Sj_wg" class="lbcd" id="Sj_wg">
            <option value="直板手机" selected="selected">直板手机</option>
            <option value="翻盖手机">翻盖手机</option>
          </select></td>
        </tr>
        <tr>
          <td width="30%" height="32" align="right" valign="middle" bgcolor="#FFFFFF">操作系统:</td>
          <td width="70%" height="32" align="left" valign="middle" bgcolor="#FFFFFF"><select name="Sj_czxt" class="lbcd" id="Sj_czxt">
            <option value="IOS 8.1" selected="selected">IOS 8.1</option>
            <option value="IOS 8.0">IOS 8.0</option>
            <option value="Android 4.4">Android 4.4</option>
            <option value="Android 4.3">Android 4.3</option>
            <option value="Android 4.2">Android 4.2</option>
            <option value="Android 4.1">Android 4.1</option>
            <option value="Android 4.0">Android 4.0</option>
            <option value="Android 2.3">Android 2.3</option>
            <option value="Windows Phone 8.1">Windows Phone 8.1</option>
            <option value="Windows Phone 8.0">Windows Phone 8.0</option>
            <option value="Windows Phone 7.5">Windows Phone 7.5</option>
          </select></td>
        </tr>
    <tr>
          <td width="30%" height="32" align="right" valign="middle" bgcolor="#FFFFFF">用户界面:</td>
          <td width="70%" height="32" align="left" valign="middle" bgcolor="#FFFFFF"><select name="Sj_ui" class="lbcd" id="Sj_ui">
            <option value="IOS 8界面">IOS 8界面</option>
            <option value="IOS 7界面">IOS 7界面</option>
            <option value="华为Emotion UI 3.0">华为Emotion UI 3.0</option>
            <option value="华为Emotion UI 2.3">华为Emotion UI 2.3</option>
            <option value="华为Emotion UI 2.0">华为Emotion UI 2.0</option>
            <option value="华为Emotion UI 1.8">华为Emotion UI 1.8</option>
            <option value="华为Emotion UI 1.5">华为Emotion UI 1.5</option>
            <option value="小米MIUI 6.0">小米MIUI 6.0</option>
            <option value="小米MIUI 5.0">小米MIUI 5.0</option>
            <option value="小米MIUI 4.5">小米MIUI 4.5</option>
            <option value="小米MIUI 4.0">小米MIUI 4.0</option>
            <option value="HTC Sense 6.0">HTC Sense 6.0</option>
            <option value="HTC Sense 5.5">HTC Sense 5.5</option>
            <option value="HTC Sense 5.0">HTC Sense 5.0</option>
            <option value="HTC Sense 4.5">HTC Sense 4.5</option>
            <option value="HTC Sense 4.1">HTC Sense 4.1</option>
            <option value="HTC Sense 4.0">HTC Sense 4.0</option>
            <option value="三星TouchWiz 5.0">三星TouchWiz 5.0</option>
            <option value="三星TouchWiz 4.0">三星TouchWiz 4.0</option>
            <option value="三星TouchWiz 3.0">三星TouchWiz 3.0</option>
            <option value="酷派CoolLife UI 5.7">酷派CoolLife UI 5.7</option>
            <option value="酷派CoolLife UI 5.5">酷派CoolLife UI 5.5</option>
            <option value="酷派CoolLife UI 4.1">酷派CoolLife UI 4.1</option>
          </select></td>
    </tr>
    <tr>
          <td width="30%" height="32" align="right" valign="middle" bgcolor="#FFFFFF">CPU型号:</td>
          <td width="70%" height="32" align="left" valign="middle" bgcolor="#FFFFFF"><input name="Sj_cpu" type="text" class="srk" id="Sj_cpu" size="40" /></td>
        </tr>
        <tr>
          <td width="30%" height="32" align="right" valign="middle" bgcolor="#FFFFFF">CPU频率:</td>
          <td width="70%" height="32" align="left" valign="middle" bgcolor="#FFFFFF"><input name="Sj_zp" type="text" class="srk" id="Sj_zp" size="30" /></td>
        </tr>
        <tr>
          <td width="30%" height="32" align="right" valign="middle" bgcolor="#FFFFFF">输入方式:</td>
          <td width="70%" height="32" align="left" valign="middle" bgcolor="#FFFFFF"><select name="Sj_srfs" class="lbcd" id="Sj_srfs">
            <option value="触控输入" selected="selected">触控输入</option>
            <option value="按键输入">按键输入</option>
          </select></td>
        </tr>
        <tr>
          <td width="30%" height="32" align="right" valign="middle" bgcolor="#FFFFFF">键盘类型:</td>
          <td width="70%" height="32" align="left" valign="middle" bgcolor="#FFFFFF"><select name="Sj_jplx" class="lbcd" id="Sj_jplx">
            <option value="虚拟键盘" selected="selected">虚拟键盘</option>
            <option value="实体键盘">实体键盘</option>
          </select></td>
        </tr>
        <tr>
          <td width="30%" height="32" align="center" valign="middle" bgcolor="#FFCC33">网络信息</td>
          <td width="70%" height="32" align="left" valign="middle" bgcolor="#FFCC33">&nbsp;</td>
        </tr>
        <tr>
          <td width="30%" height="32" align="right" valign="middle" bgcolor="#FFFFFF">网络制式:</td>
          <td width="70%" height="32" align="left" valign="middle" bgcolor="#FFFFFF"><p>
            <label>
                &nbsp;&nbsp;<input type="checkbox" name="Sj_wlzs" value="TDD-LTE" id="Sj_wlzs_0" />
              TDD-LTE</label>
            <label>
              <input type="checkbox" name="Sj_wlzs" value="FDD-LTE" id="Sj_wlzs_1" />
              FDD-LTE</label>
            <label>
              <input type="checkbox" name="Sj_wlzs" value="WCDMA" id="Sj_wlzs_2" />
              WCDMA</label>
            <label>
              <input type="checkbox" name="Sj_wlzs" value="GSM" id="Sj_wlzs_3" />
              GSM</label>
            <label>
              <input type="checkbox" name="Sj_wlzs" value="CDMA2000" id="Sj_wlzs_4" />
              CDMA2000</label>
            <label>
              <input type="checkbox" name="Sj_wlzs" value="CDMA" id="Sj_wlzs_5" />
              CDMA</label>
            <label>
              <input type="checkbox" name="Sj_wlzs" value="TD-SCDMA" id="Sj_wlzs_6" />
              TD-SCDMA</label>
          </td>
        </tr>
        <tr>
          <td width="30%" height="32" align="right" valign="middle" bgcolor="#FFFFFF">网络频率:</td>
          <td width="70%" height="32" align="left" valign="middle" bgcolor="#FFFFFF"><input name="Sj_wlpl" type="text" class="srk" id="Sj_wlpl" size="80" /></td>
        </tr>
        <tr>
          <td width="30%" height="32" align="right" valign="middle" bgcolor="#FFFFFF">数据业务:</td>
          <td width="70%" height="32" align="left" valign="middle" bgcolor="#FFFFFF"><p>
            <label>
              &nbsp;&nbsp;<input type="checkbox" name="Sj_sjyw" value="TD-LTE" id="Sj_sjyw_0" />
              TD-LTE</label>
            <label>
              <input type="checkbox" name="Sj_sjyw" value="FDD-LTE" id="Sj_sjyw_1" />
            FDD-LTE</label>
            <label>
              <input type="checkbox" name="Sj_sjyw" value="HSDPA" id="Sj_sjyw_2" />
              HSDPA</label>
            <label>
              <input type="checkbox" name="Sj_sjyw" value="HSPA+" id="Sj_sjyw_3" />
              HSPA+</label>
            <label>
              <input type="checkbox" name="Sj_sjyw" value="GPRS" id="Sj_sjyw_4" />
              GPRS</label>
            <label>
              <input type="checkbox" name="Sj_sjyw" value="EDGE" id="Sj_sjyw_5" />
              EDGE</label>
          </td>
        </tr>
        <tr>
          <td height="32" align="right" valign="middle" bgcolor="#FFFFFF">单双卡类型:</td>
          <td height="32" align="left" valign="middle" bgcolor="#FFFFFF"><input name="Sj_dsklx" type="text" class="srk" id="Sj_dsklx" size="30" /></td>
        </tr>
        <tr>
          <td height="32" align="right" valign="middle" bgcolor="#FFFFFF">SIM卡类型:</td>
          <td height="32" align="left" valign="middle" bgcolor="#FFFFFF"><input name="Sj_sim" type="text" class="srk" id="Sj_sim" size="30" /></td>
        </tr>
        <tr>
          <td width="30%" height="32" align="center" valign="middle" bgcolor="#FFCC33">存储信息</td>
          <td width="70%" height="32" align="left" valign="middle" bgcolor="#FFCC33">&nbsp;</td>
        </tr>
        <tr>
          <td width="30%" height="32" align="right" valign="middle" bgcolor="#FFFFFF">运行内存:</td>
          <td width="70%" height="32" align="left" valign="middle" bgcolor="#FFFFFF"><p>
            <select name="Sj_ram" class="lbcd" id="Sj_ram">
              <option value="3GB">3GB</option>
              <option value="2GB" selected="selected">2GB</option>
              <option value="1.5GB">1.5GB</option>
              <option value="1GB">1GB</option>
              <option value="768MB">768MB</option>
              <option value="512MB">512MB</option>
            </select>
            <br />
          </p></td>
        </tr>
        <tr>
          <td width="30%" height="32" align="right" valign="middle" bgcolor="#FFFFFF">机身内存:</td>
          <td width="70%" height="32" align="left" valign="middle" bgcolor="#FFFFFF"><select name="Sj_rom" class="lbcd" id="Sj_rom">
            <option value="512MB">512MB</option>
            <option value="768MB">768MB</option>
            <option value="1GB">1GB</option>
            <option value="2GB">2GB</option>
            <option value="3GB">3GB</option>
            <option value="4GB">4GB</option>
            <option value="8GB" selected="selected">8GB</option>
            <option value="16GB">16GB</option>
            <option value="32GB">32GB</option>
            <option value="64GB">64GB</option>
&am, p;nb, , , , , sp;           <option value="128GB">128GB</option>
          </select></td>
        </tr>
        <tr>
          <td width="30%" height="32" align="right" valign="middle" bgcolor="#FFFFFF">存储卡类型:</td>
          <td width="70%" height="32" align="left" valign="middle" bgcolor="#FFFFFF"><input name="Sj_sdlx" type="text" class="srk" id="Sj_sdlx" value="Micro SD卡" size="20" /></td>
        </tr>
        <tr>
          <td width="30%" height="32" align="right" valign="middle" bgcolor="#FFFFFF">最大扩展存储:</td>
          <td width="70%" height="32" align="left" valign="middle" bgcolor="#FFFFFF"><select name="Sj_cckz" class="srk" id="Sj_cckz">
            <option value="4GB">4GB</option>
            <option value="8GB">8GB</option>
            <option value="16GB">16GB</option>
            <option value="32GB" selected="selected">32GB</option>
            <option value="64GB">64GB</option>
            <option value="128GB">128GB</option>
          </select></td>
        </tr>
        <tr>
          <td width="30%" height="32" align="center" valign="middle" bgcolor="#FFCC33">显示信息</td>
          <td width="70%" height="32" align="left" valign="middle" bgcolor="#FFCC33">&nbsp;</td>
        </tr>
        <tr>
          <td width="30%" height="32" align="right" valign="middle" bgcolor="#FFFFFF">屏幕尺寸:</td>
          <td width="70%" height="32" align="left" valign="middle" bgcolor="#FFFFFF"><select name="Sj_pmcc" class="srk" id="Sj_pmcc">
            <option value="2.0英寸">2.0英寸</option>
            <option value="2.5英寸">2.5英寸</option>
            <option value="3.2英寸">3.2英寸</option>
            <option value="3.5英寸">3.5英寸</option>
            <option value="4.0英寸">4.0英寸</option>
            <option value="4.5英寸">4.5英寸</option>
            <option value="4.7英寸" selected="selected">4.7英寸</option>
            <option value="4.8英寸">4.8英寸</option>
            <option value="5.0英寸">5.0英寸</option>
            <option value="5.1英寸">5.1英寸</option>
            <option value="5.3英寸">5.3英寸</option>
            <option value="5.5英寸">5.5英寸</option>
            <option value="5.7英寸">5.7英寸</option>
            <option value="5.8英寸">5.8英寸</option>
            <option value="5.9英寸">5.9英寸</option>
            <option value="6.0英寸">6.0英寸</option>
            <option value="6.3英寸">6.3英寸</option>
            <option value="7.0英寸">7.0英寸</option>
          </select></td>
        </tr>
        <tr>
          <td width="30%" height="32" align="right" valign="middle" bgcolor="#FFFFFF">屏幕色彩:</td>
          <td width="70%" height="32" align="left" valign="middle" bgcolor="#FFFFFF"><input name="Sj_pmsc" type="text" class="srk" id="Sj_pmsc" size="20" /></td>
        </tr>
        <tr>
          <td width="30%" height="32" align="right" valign="middle" bgcolor="#FFFFFF">屏幕材质:</td>
          <td width="70%" height="32" align="left" valign="middle" bgcolor="#FFFFFF"><input name="Sj_pmcz" type="text" class="srk" id="Sj_pmcz" size="30" /></td>
        </tr>
        <tr>
          <td width="30%" height="32" align="right" valign="middle" bgcolor="#FFFFFF">屏幕分辨率:</td>
          <td width="70%" height="32" align="left" valign="middle" bgcolor="#FFFFFF"><select name="Sj_pmfbl" class="srk" id="Sj_pmfbl">
            <option value="320×240">320×240</option>
            <option value="640×480">640×480</option>
            <option value="854×480">854×480</option>
            <option value="960×640">960×640</option>
            <option value="1280×720" selected="selected">1280×720</option>
            <option value="1136×640">1136×640</option>
            <option value="1334×750">1334×750</option>
            <option value="1920×1080">1920×1080</option>
            <option value="2560×1440">2560×1440</option>
          </select></td>
        </tr>
        <tr>
          <td width="30%" height="32" align="right" valign="middle" bgcolor="#FFFFFF">触摸屏类型:</td>
          <td width="70%" height="32" align="left" valign="middle" bgcolor="#FFFFFF"><input name="Sj_cmplx" type="text" class="srk" id="Sj_cmplx" size="30" /></td>
        </tr>
        <tr>
          <td width="30%" height="32" align="center" valign="middle" bgcolor="#FFCC33">传感器类型</td>
          <td width="70%" height="32" align="left" valign="middle" bgcolor="#FFCC33">&nbsp;</td>
        </tr>
        <tr>
          <td width="30%" height="32" align="right" valign="middle" bgcolor="#FFFFFF">重力感应:</td>
          <td width="70%" height="32" align="left" valign="middle" bgcolor="#FFFFFF"><p>
            <label>
              &nbsp;&nbsp;
              <input type="radio" name="Sj_zlgy" value="支持" id="Sj_zlgy_0" />
              支持</label>
            <label>
              <input type="radio" name="Sj_zlgy" value="不支持" id="Sj_zlgy_1" />
              不支持</label>
          </td>
        </tr>
        <tr>
          <td width="30%" height="32" align="right" valign="middle" bgcolor="#FFFFFF">光线感应器:</td>
          <td width="70%" height="32" align="left" valign="middle" bgcolor="#FFFFFF"><label>
            &nbsp;&nbsp;
            <input type="radio" name="Sj_gxgy" value="支持" id="Sj_zlgy_2" />
            支持</label>
            <label>
              <input type="radio" name="Sj_gxgy" value="不支持" id="Sj_zlgy_3" />
          不支持</label></td>
        </tr>
        <tr>
          <td width="30%" height="32" align="right" valign="middle" bgcolor="#FFFFFF">距离感应器:</td>
          <td width="70%" height="32" align="left" valign="middle" bgcolor="#FFFFFF"><label>
            &nbsp;&nbsp;
            <input type="radio" name="Sj_jlgy" value="支持" id="Sj_zlgy_4" />
            支持</label>
            <label>
              <input type="radio" name="Sj_jlgy" value="不支持" id="Sj_zlgy_5" />
          不支持</label></td>
        </tr>
        <tr>
          <td width="30%" height="32" align="right" valign="middle" bgcolor="#FFFFFF">三轴陀螺仪:</td>
          <td width="70%" height="32" align="left" valign="middle" bgcolor="#FFFFFF"><label>
            &nbsp;&nbsp;
            <input type="radio" name="Sj_tly" value="支持" id="Sj_zlgy_6" />
            支持</label>
            <label>
              <input type="radio" name="Sj_tly" value="不支持" id="Sj_zlgy_7" />
          不支持</label></td>
        </tr>
        <tr>
          <td height="32" align="right" valign="middle" bgcolor="#FFFFFF">指纹传感器:</td>
          <td height="32" align="left" valign="middle" bgcolor="#FFFFFF"><input name="Sj_zwcgq" type="text" class="srk" id="Sj_zwcgq" size="40" /></td>
        </tr>
        <tr>
          <td width="30%" height="32" align="center" valign="middle" bgcolor="#FFCC33">娱乐功能</td>
          <td width="70%" height="32" align="left" valign="middle" bgcolor="#FFCC33">&nbsp;</td>
        </tr>
        <tr>
          <td width="30%" height="32" align="right" valign="middle" bgcolor="#FFFFFF">音乐播放:</td>
          <td width="70%" height="32" align="left" valign="middle" bgcolor="#FFFFFF"><p>
            <label>
              &nbsp;&nbsp;
              <input type="checkbox" name="Sj_yybf" value="mp3" id="Sj_yybf_0" />
              mp3</label>
            <label>
              <input type="checkbox" name="Sj_yybf" value="aac" id="Sj_yybf_1" />
              aac</label>
            <label>
              <input type="checkbox" name="Sj_yybf" value="aac+" id="Sj_yybf_2" />
              aac+</label>
            <label>
              <input type="checkbox" name="Sj_yybf" value="amr" id="Sj_yybf_3" />
              amr</label>
            <label>
              <input type="checkbox" name="Sj_yybf" value="wb-amr" id="Sj_yybf_4" />
              wb-amr</label>
            <label>
              <input type="checkbox" name="Sj_yybf" value="midi" id="Sj_yybf_5" />
              midi</label>
            <label>
              <input type="checkbox" name="Sj_yybf" value="ogg" id="Sj_yybf_6" />
              ogg</label>
          </td>
        </tr>
        <tr>
          <td width="30%" height="32" align="right" valign="middle" bgcolor="#FFFFFF">视频播放:</td>
          <td width="70%" height="32" align="left" valign="middle" bgcolor="#FFFFFF"><p>
            <label>
              &nbsp;&nbsp;
              <input type="checkbox" name="Sj_spbf" value="mpeg4" id="Sj_spbf_0" />
              mpeg4</label>
            <label>
              <input type="checkbox" name="Sj_spbf" value="h263" id="Sj_spbf_1" />
              h263</label>
            <label>
              <input type="checkbox" name="Sj_spbf" value="h264" id="Sj_spbf_2" />
              h264</label>
            <label>
              <input type="checkbox" name="Sj_spbf" value="avi" id="Sj_spbf_3" />
              avi</label>
            <label>
              <input type="checkbox" name="Sj_spbf" value="rmvb" id="Sj_spbf_4" />
              rmvb</label>
            <label>
              <input type="checkbox" name="Sj_spbf" value="rm" id="Sj_spbf_5" />
              rm</label>
            <label>
              <input type="checkbox" name="Sj_spbf" value="wmv" id="Sj_spbf_6" />
              wmv</label>
            <label>
              <input type="checkbox" name="Sj_spbf" value="swf" id="Sj_spbf_7" />
              swf</label>
            <label>
              <input type="checkbox" name="Sj_spbf" value="flv" id="Sj_spbf_8" />
              flv</label>
          </td>
        </tr>
        <tr>
          <td width="30%" height="32" align="right" valign="middle" bgcolor="#FFFFFF">收音机:</td>
          <td width="70%" height="32" align="left" valign="middle" bgcolor="#FFFFFF"><p>
            <label>
              &nbsp;&nbsp;
              <input type="checkbox" name="Sj_syj" value="支持" id="Sj_syj_0" />
              支持</label>
            <label>
              <input type="checkbox" name="Sj_syj" value="不支持" id="Sj_syj_1" />
              不支持</label>
            <label>
              <input type="checkbox" name="Sj_syj" value="网络收音机" id="Sj_syj_2" />
              网络收音机</label>
          </p></td>
        </tr>
        <tr>
          <td width="30%" height="32" align="center" valign="middle" bgcolor="#FFCC33">摄像功能</td>
          <td width="70%" height="32" align="left" valign="middle" bgcolor="#FFCC33">&nbsp;</td>
        </tr>
        <tr>
          <td width="30%" height="32" align="right" valign="middle" bgcolor="#FFFFFF">主摄像头:</td>
          <td width="70%" height="32" align="left" valign="middle" bgcolor="#FFFFFF"><input name="Sj_zsxt" type="text" class="srk" id="Sj_zsxt" size="50" /></td>
        </tr>
        <tr>
          <td width="30%" height="32" align="right" valign="middle" bgcolor="#FFFFFF">副摄像头:</td>
          <td width="70%" height="32" align="left" valign="middle" bgcolor="#FFFFFF"><input name="Sj_fsxt" type="text" class="srk" id="Sj_fsxt" size="50" /></td>
        </tr>
        <tr>
          <td width="30%" height="32" align="right" valign="middle" bgcolor="#FFFFFF">闪光灯:</td>
          <td width="70%" height="32" align="left" valign="middle" bgcolor="#FFFFFF"><input name="Sj_sgd" type="text" class="srk" id="Sj_sgd" size="30" /></td>
        </tr>
        <tr>
          <td width="30%" height="32" align="right" valign="middle" bgcolor="#FFFFFF">视频拍摄:</td>
          <td width="70%" height="32" align="left" valign="middle" bgcolor="#FFFFFF"><input name="Sj_spps" type="text" class="srk" id="Sj_spps" size="40" /></td>
        </tr>
        <tr>
          <td width="30%" height="32" align="right" valign="middle" bgcolor="#FFFFFF">照片分辨率:</td>
          <td width="70%" height="32" align="left" valign="middle" bgcolor="#FFFFFF"><input name="Sj_zpfbl" type="text" class="srk" id="Sj_zpfbl" size="40" /></td>
        </tr>
        <tr>
          <td width="30%" height="32" align="right" valign="middle" bgcolor="#FFFFFF">对焦方式:</td>
          <td width="70%" height="32" align="left" valign="middle" bgcolor="#FFFFFF"><p>
            <label>
              &nbsp;&nbsp;
              <input type="checkbox" name="Sj_djfs" value="自动对焦" id="Sj_djfs_0" />
              自动对焦</label>
            <label>
              <input type="checkbox" name="Sj_djfs" value="手动对焦" id="Sj_zddj_1" />
              手动对焦</label>
          </td>
        </tr>
        <tr>
          <td width="30%" height="32" align="right" valign="middle" bgcolor="#FFFFFF">摄像头其他功能:</td>
          <td width="70%" height="32" align="left" valign="middle" bgcolor="#FFFFFF"><input name="Sj_sxtqtxn" type="text" class="srk" id="Sj_sxtqtxn" size="50" /></td>
        </tr>
        <tr>
          <td width="30%" height="32" align="center" valign="middle" bgcolor="#FFCC33">个人助理</td>
          <td width="70%" height="32" align="left" valign="middle" bgcolor="#FFCC33">&nbsp;</td>
        </tr>
        <tr>
          <td width="30%" height="32" align="right" valign="middle" bgcolor="#FFFFFF">办公软件:</td>
          <td width="70%" height="32" align="left" valign="middle" bgcolor="#FFFFFF"><input name="Sj_bgrj" type="text" class="srk" id="Sj_bgrj" size="50" /></td>
        </tr>
        <tr>
          <td width="30%" height="32" align="right" valign="middle" bgcolor="#FFFFFF">电子邮件:</td>
          <td width="70%" height="32" align="left" valign="middle" bgcolor="#FFFFFF"><p>
            <label>
              &nbsp;&nbsp;
              <input type="checkbox" name="Sj_dzyj" value="系统自带电子邮件" id="Sj_dzyj_0" />
              系统自带电子邮件</label>
            <label>
              <input type="checkbox" name="Sj_dzyj" value="第三方电子邮件软件" id="Sj_dzyj_1" />
              第三方电子邮件软件</label>
          </td>
        </tr>
        <tr>
          <td width="30%" height="32" align="right" valign="middle" bgcolor="#FFFFFF">计算器:</td>
          <td width="70%" height="32" align="left" valign="middle" bgcolor="#FFFFFF"><p>
            <label>
              &nbsp;&nbsp;
              <input type="radio" name="Sj_jsq" value="支持" id="Sj_jsq_0" />
              支持</label>
            <label>
              <input type="radio" name="Sj_jsq" value="不支持" id="Sj_jsq_1" />
              不支持</label>
          </td>
        </tr>
        <tr>
          <td width="30%" height="32" align="right" valign="middle" bgcolor="#FFFFFF">闹钟:</td>
          <td width="70%" height="32" align="left" valign="middle" bgcolor="#FFFFFF"><p>
            <label>
              &nbsp;&nbsp;
              <input type="checkbox" name="Sj_nz" value="普通闹钟" id="Sj_nz_0" />
              普通闹钟</label>
            <label>
              <input type="checkbox" name="Sj_nz" value="第三方闹钟软件" id="Sj_nz_1" />
              第三方闹钟软件</label>
            <label>
              <input type="checkbox" name="Sj_nz" value="关机闹钟" id="Sj_nz_2" />
              关机闹钟</label>
          </td>
        </tr>
        <tr>
          <td width="30%" height="32" align="right" valign="middle" bgcolor="#FFFFFF">录音功能:</td>
          <td width="70%" height="32" align="left" valign="middle" bgcolor="#FFFFFF"><p>
            <label>
              &nbsp;&nbsp;
              <input type="checkbox" name="Sj_lygn" value="普通录音" id="Sj_lygn_0" />
              普通录音</label>
            <label>
              <input type="checkbox" name="Sj_lygn" value="语音备忘录" id="Sj_lygn_1" />
              语音备忘录</label>
            <label>
              <input type="checkbox" name="Sj_lygn" value="通话录音" id="Sj_lygn_2" />
              通话录音</label>
          </td>
        </tr>
        <tr>
          <td width="30%" height="32" align="center" valign="middle" bgcolor="#FFCC33">传输功能</td>
          <td width="70%" height="32" align="left" valign="middle" bgcolor="#FFCC33">&nbsp;</td>
        </tr>
        <tr>
          <td width="30%" height="32" align="right" valign="middle" bgcolor="#FFFFFF">GPS:</td>
          <td width="70%" height="32" align="left" valign="middle" bgcolor="#FFFFFF"><p>
            <label>
              &nbsp;&nbsp;
              <input type="checkbox" name="Sj_gps" value="GPS" id="Sj_gps_0" />
              GPS</label>
            <label>
              <input type="checkbox" name="Sj_gps" value="AGPS" id="Sj_gps_1" />
              AGPS</label>
            <label>
              <input type="checkbox" name="Sj_gps" value="GLONASS" id="Sj_gps_2" />
              GLONASS</label>
            <label>
              <input type="checkbox" name="Sj_gps" value="北斗定位" id="Sj_gps_3" />
              北斗定位</label>
          </td>
        </tr>
        <tr>
          <td width="30%" height="32" align="right" valign="middle" bgcolor="#FFFFFF">Wi-Fi:</td>
          <td width="70%" height="32" align="left" valign="middle" bgcolor="#FFFFFF"><p>
            <label>
              &nbsp;&nbsp;
              <input type="checkbox" name="Sj_wifi" value="802.11 a/b/g/n" id="Sj_wifi_0" />
              802.11 a/b/g/n</label>
            <label>
              <input type="checkbox" name="Sj_wifi" value="802.11 a/b/g/n/ac 2.4GHz+5.0GHz双频WIFI" id="Sj_wifi_1" />
              802.11 a/b/g/n/ac 2.4GHz+5.0GHz双频WIFI</label>
          </td>
        </tr>
        <tr>
          <td width="30%" height="32" align="right" valign="middle" bgcolor="#FFFFFF">红外传输:</td>
          <td width="70%" height="32" align="left" valign="middle" bgcolor="#FFFFFF"><p>
            <label>
              &nbsp;&nbsp;
              <input type="radio" name="Sj_hwx" value="支持" id="Sj_hwx_0" />
              支持</label>
            <label>
              <input type="radio" name="Sj_hwx" value="不支持" id="Sj_hwx_1" />
              不支持</label>
          </td>
        </tr>
        <tr>
          <td width="30%" height="32" align="right" valign="middle" bgcolor="#FFFFFF">蓝牙:</td>
          <td width="70%" height="32" align="left" valign="middle" bgcolor="#FFFFFF"><p>
            <label>
              &nbsp;&nbsp;
              <input type="checkbox" name="Sj_bluetooth" value="BT2.0" id="Sj_bluetooth_0" />
              BT2.0</label>
            <label>
              <input type="checkbox" name="Sj_bluetooth" value="BT3.0" id="Sj_bluetooth_1" />
              BT3.0</label>
            <label>
              <input type="checkbox" name="Sj_bluetooth" value="BT4.0" id="Sj_bluetooth_2" />
              BT4.0</label>
            <label>
              <input type="checkbox" name="Sj_bluetooth" value="BT4.0 BLE" id="Sj_bluetooth_3" />
              BT4.0 BLE</label>
          </td>
        </tr>
        <tr>
          <td width="30%" height="32" align="right" valign="middle" bgcolor="#FFFFFF">NFC近场通讯技术:</td>
          <td width="70%" height="32" align="left" valign="middle" bgcolor="#FFFFFF"><p>
            <label>
              &nbsp;&nbsp;
              <input type="radio" name="Sj_nfc" value="支持" id="Sj_nfc_0" />
              支持</label>
            <label>
              <input type="radio" name="Sj_nfc" value="不支持" id="Sj_nfc_1" />
              不支持</label>
          </td>
        </tr>
        <tr>
          <td width="30%" height="32" align="center" valign="middle" bgcolor="#FFCC33">其他性能</td>
          <td width="70%" height="32" align="left" valign="middle" bgcolor="#FFCC33">&nbsp;</td>
        </tr>
        <tr>
          <td width="30%" height="32" align="right" valign="middle" bgcolor="#FFFFFF">电池型号:</td>
          <td width="70%" height="32" align="left" valign="middle" bgcolor="#FFFFFF"><input name="Sj_dclx" type="text" class="srk" id="Sj_dclx" size="40" /></td>
        </tr>
        <tr>
          <td width="30%" height="32" align="right" valign="middle" bgcolor="#FFFFFF">电池容量:</td>
          <td width="70%" height="32" align="left" valign="middle" bgcolor="#FFFFFF"><input name="Sj_dcrl" type="text" class="srk" id="Sj_dcrl" size="40" /></td>
        </tr>
        <tr>
          <td width="30%" height="32" align="right" valign="middle" bgcolor="#FFFFFF">理论待机时间:</td>
          <td width="70%" height="32" align="left" valign="middle" bgcolor="#FFFFFF"><input name="Sj_lldjsj" type="text" class="srk" id="Sj_lldjsj" size="50" /></td>
        </tr>
        <tr>
          <td width="30%" height="32" align="right" valign="middle" bgcolor="#FFFFFF">理论通话时间:</td>
          <td width="70%" height="32" align="left" valign="middle" bgcolor="#FFFFFF"><input name="Sj_llthsj" type="text" class="srk" id="Sj_llthsj" size="50" /></td>
        </tr>
        <tr>
          <td width="30%" height="32" align="right" valign="middle" bgcolor="#FFFFFF">数据线接口类型:</td>
          <td width="70%" height="32" align="left" valign="middle" bgcolor="#FFFFFF"><p>
            <label>
              &nbsp;&nbsp;
              <input type="checkbox" name="Sj_sjx" value="Micro USB" id="Sj_sjx_0" />
              Micro USB</label>
            <label>
              <input type="checkbox" name="Sj_sjx" value="30pin 接口" id="Sj_sjx_1" />
              30pin 接口</label>
            <label>
              <input type="checkbox" name="Sj_sjx" value="Lightning" id="Sj_sjx_2" />
              Lightning</label>
          </td>
        </tr>
        <tr>
          <td width="30%" height="32" align="right" valign="middle" bgcolor="#FFFFFF">耳机接口类型:</td>
          <td width="70%" height="32" align="left" valign="middle" bgcolor="#FFFFFF"><input name="Sj_ejjk" type="text" class="srk" id="Sj_ejjk" value="3.5mm通用耳机接口" size="30" /></td>
        </tr>
        <tr>
          <td width="30%" height="32" align="right" valign="middle" bgcolor="#FFFFFF">机身重量:</td>
          <td width="70%" height="32" align="left" valign="middle" bgcolor="#FFFFFF"><input name="Sj_jszl" type="text" class="srk" id="Sj_jszl" size="20" /></td>
        </tr>
        <tr>
          <td width="30%" height="32" align="right" valign="middle" bgcolor="#FFFFFF">机身尺寸:</td>
          <td width="70%" height="32" align="left" valign="middle" bgcolor="#FFFFFF"><input name="Sj_jscc" type="text" class="srk" id="Sj_jscc" size="30" /></td>
        </tr>
        <tr>
          <td width="30%" height="32" align="center" valign="middle" bgcolor="#FFCC33">图片上传</td>
          <td width="70%" height="32" align="left" valign="middle" bgcolor="#FFCC33">&nbsp;</td>
        </tr>
        <tr>
          <td width="30%" height="32" align="right" valign="middle" bgcolor="#FFFFFF">手机图片1:</td>
          <td width="70%" height="32" align="left" valign="middle" bgcolor="#FFFFFF"><input name=d_image1 type=text class="srk" id="d_image1" size=50>
          <input type=button class="anniu" onClick="showUploadDialog('image', 'myform.d_image1', '')" value="上传图片">&nbsp;</td>
        </tr>
        <tr>
          <td width="30%" height="32" align="right" valign="middle" bgcolor="#FFFFFF">手机图片2:</td>
          <td width="70%" height="32" align="left" valign="middle" bgcolor="#FFFFFF"><input name=d_image2 type=text class="srk" id="d_image2" size=50>
          <input type=button class="anniu" onClick="showUploadDialog('image', 'myform.d_image2', '')" value="上传图片"></td>
        </tr>
        <tr>
          <td width="30%" height="32" align="right" valign="middle" bgcolor="#FFFFFF">手机图片3:</td>
          <td width="70%" height="32" align="left" valign="middle" bgcolor="#FFFFFF"><input name=d_image3 type=tex, t class="srk" , id="d_image3" size=50>
          <input type=button class="anniu" onClick="showUploadDialog('image', 'myform.d_image3', '')" value="上传图片"></td>
        </tr>
        <tr>
          <td width="30%" height="32" align="right" valign="middle" bgcolor="#FFFFFF">手机图片4:</td>
          <td width="70%" height="32" align="left" valign="middle" bgcolor="#FFFFFF"><input name=d_image4 type=text class="srk" id="d_image4" size=50>
          <input type=button class="anniu" onClick="showUploadDialog('image', 'myform.d_image4', '')" value="上传图片"></td>
        </tr>
        <tr>
          <td width="30%" height="32" align="right" valign="middle" bgcolor="#FFFFFF">手机图片5:</td>
          <td width="70%" height="32" align="left" valign="middle" bgcolor="#FFFFFF"><input name=d_image5 type=text class="srk" id="d_image5" size=50>
          <input type=button class="anniu" onClick="showUploadDialog('image', 'myform.d_image5', '')" value="上传图片"></td>
        </tr>
        <tr>
          <td width="30%" height="32" align="center" valign="middle" bgcolor="#FFCC33">其他信息</td>
          <td width="70%" height="32" align="left" valign="middle" bgcolor="#FFCC33">&nbsp;</td>
        </tr>
        <tr>
          <td width="30%" height="32" align="right" valign="middle" bgcolor="#FFFFFF">手机价格:</td>
          <td width="70%" height="32" align="left" valign="middle" bgcolor="#FFFFFF"><input name="Sj_price" type="text" class="srk" id="Sj_price" size="30" /></td>
        </tr>
        <tr>
          <td width="30%" height="32" align="right" valign="middle" bgcolor="#FFFFFF">点击数:</td>
          <td width="70%" height="32" align="left" valign="middle" bgcolor="#FFFFFF"><input name="Sj_djs" type="text" class="srk" id="Sj_djs" value="0" size="10" /></td>
        </tr>
        <tr>
          <td width="30%" height="32" align="right" valign="middle" bgcolor="#FFFFFF">作者:</td>
          <td width="70%" height="32" align="left" valign="middle" bgcolor="#FFFFFF"><input name="Sj_zuozhe" type="text" class="srk" id="Sj_zuozhe" value="<%=(Recordset2.Fields.Item("Name").Value)%>" size="20" /></td>
        </tr>
        <tr>
          <td width="30%" height="50" align="right" valign="middle" bgcolor="#FFFFFF"><span class="tzlb_tittle">手机介绍</span>:</td>
          <td width="70%" height="50" align="left" valign="middle" bgcolor="#FFFFFF"><textarea name="editor" id="editor" cols="" rows="" style="width:800px;height:300px;"></textarea></td>
        </tr>
        <tr>
          <td width="30%" height="32" align="right" valign="middle" bgcolor="#FFFFFF">&nbsp;</td>
          <td width="70%" height="32" align="left" valign="middle" bgcolor="#FFFFFF"> 
            <input name="button3" type="submit" class="anniu" id="button5" value="提 交" />
                      
            <input name="button3" type="reset" class="anniu" id="button6" value="重 置" /></td>
        </tr>
    </table>
<input type="hidden" name="MM_insert" value="myform" />
</form>
<script type="text/javascript">
//实例化编辑器
  
    UE.getEditor('editor');
 
 function hasContents() {
     var arr = [];
  if(UE.getEditor('editor').hasContents()==false)
  {
   alert("请填写内容!")
   setFocus();
   return false;
  }
  return true
  ;
 }
 function setFocus() {
  UE.getEditor('editor').focus();
 }
</script>
</body>
</html>
<%
Recordset1.Close()
Set Recordset1 = Nothing
%>
<%
Recordset2.Close()
Set Recordset2 = Nothing
%>

[本站回复]

解决办法:

用插入记录表单向导来做,做好之后再修改为相应的内容,比如改为下拉菜单等

[相关内容]
 变量(阶段变量、请求变量和应用程序变量)的作用及用法?
 按月汇总求和数据库中的某列数据
 怎样注销 阶段变量
 request() 与 request.form() 的区别
 数据库自动生成随机数
 怎么做动态跳转页
 如何实现不同用户登陆时信息的不一样!
 关于文章删除问题
 关于按时间段统计的问题
 如何在这些数据前显示新的序列号
 您好!老师,请问这个是什么意思哇 我都做了几遍 还是不懂
 创建记录集后点击记录集的加号出现'-' 附近有语法错误。
 您好!老师,我在做插入记录的时候,记录没添加进去,这样是什么原因呀
 是否可以用表单验证阶段变量的存在?
 MD5加密解密问题
 下拉列表菜单传递的值
 变量不等于空转到请求的页面的问题
 有asp编写代码的教程吗?
 多个判断条件怎么写?
 想要在一张表中的不同字段中进行模糊搜索的问题(续)
 幻灯片修改的问题
 陶老师好!根据账号,设置每天提交的数据
 一个条件判断的问题...
 变量更新+1和-1的意思一样吗
 开发网站中遇到的问题
 显示区域没有则显示具体信息提示的问题
 请教关于删除的问题...
 限制对页的访问可否制作独立页面
 页面制作为什么会显示这段乱码?
 请教这连接设置.....

会员中心 意见建议 获取VIP 联系我们 付款方式
陶益数码工作室 Ty502.com Copyright © 2017 黔ICP备11000612号