出現(xiàn)“ADODB.Field 錯(cuò)誤 '800a0bcd' ? BOF 或 EOF 中有一個(gè)是“真”，或者當(dāng)前的記錄已被刪除，所需的操作要求一個(gè)當(dāng)前的記錄。 ? /order_ch.asp，行 54”的錯(cuò)?ADODB.Recordset(0x800A0BCD)-->rs對(duì)像出錯(cuò)(記錄集中沒有記錄卻對(duì)記錄集進(jìn)行操作)?<%@LANGUAGE="VBSCRIPT" CODEPAGE="65001"%><!--#include file="Connections/web_ljdata.asp" --><%Dim pro__MMColParampro__MMColParam = "1"If (Request.Form("pro_id") <> "") Then?? pro__MMColParam = Request.Form("pro_id")End If%><%Dim proDim pro_cmdDim pro_numRowsSet pro_cmd = Server.CreateObject ("ADODB.Command")pro_cmd.ActiveConnection = MM_web_ljdata_STRINGpro_cmd.CommandText = "SELECT * FROM shop WHERE pro_id = ?"?pro_cmd.Prepared = truepro_cmd.Parameters.Append pro_cmd.CreateParameter("param1", 5, 1, -1, pro__MMColParam) ' adDoubleSet pro = pro_cmd.Executepro_numRows = 0%><%Dim user__MMColParamuser__MMColParam = "1"If (Session("mm_username") <> "") Then?? user__MMColParam = Session("mm_username")End If%><%Dim userDim user_cmdDim user_numRowsSet user_cmd = Server.CreateObject ("ADODB.Command")user_cmd.ActiveConnection = MM_web_ljdata_STRINGuser_cmd.CommandText = "SELECT * FROM user WHERE username = ?"?user_cmd.Prepared = trueuser_cmd.Parameters.Append user_cmd.CreateParameter("param1", 200, 1, 20, user__MMColParam) ' adVarCharSet user = user_cmd.Executeuser_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>無(wú)標(biāo)題文檔</title></head><body><p>確認(rèn)訂單</p> ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? 53行<p>您選的商品：<%=(pro.Fields.Item("pro_name").Value)%>，購(gòu)買的數(shù)量為<%= Request.Form("num") %>件，單價(jià)為：<%=formatcurrency((pro.Fields.Item("pro_price").Value))%>（元/件）</p><p>支付的總金額：<%=formatcurrency((pro.Fields.Item("pro_price").Value)*Request.Form("num"))%>元</p><p> </p><p>您的收貨信息：<%=(user.Fields.Item("name").Value)%>，<%=(user.Fields.Item("tel").Value)%>，<%=(user.Fields.Item("add").Value)%></p><form id="form1" name="form1" method="post" action="">? <input type="submit" name="button" id="button" value="確認(rèn)訂單" />? <input name="name" type="hidden" id="name" value="<%=(user.Fields.Item("name").Value)%>" />? <input name="add" type="hidden" id="add" value="<%=(user.Fields.Item("add").Value)%>" />? <input name="tel" type="hidden" id="tel" value="<%=(user.Fields.Item("tel").Value)%>" />? <input name="about" type="hidden" id="about" value="<%=(pro.Fields.Item("pro_name").Value)%><%=formatcurrency((pro.Fields.Item("pro_price").Value))%>（元/件）*<%= Request.Form("num") %>" />? <input name="price" type="hidden" id="price" value="<%=formatcurrency((pro.Fields.Item("pro_price").Value)*Request.Form("num"))%>" />? <input type="hidden" name="username" id="username" /></form><p> </p></body></html><%pro.Close()Set pro = Nothing%><%user.Close()Set user = Nothing%>
在Dreamweaver里使用access數(shù)據(jù)庫(kù)做的關(guān)于后臺(tái)確認(rèn)訂單
周星星2
2016-12-19 17:28:10