 |
| |
Error แบบนี้แก้ไงคับ Error Type: Microsoft OLE DB Provider for ODBC Drivers (0x80040E21) Multiple-step OLE DB operation generated errors. Check each OLE DB status value, |
| |
 |
|
|
 |
 |
|
ดูที่ line 136 8รับ ผมอยากรู้ว่า Collection ตัวไหนที่ทำให้ Error เผื่อจะช่วยได้บ้างครับ 
|
 |
 |
 |
 |
| Date :
7 มี.ค. 2548 15:01:58 |
By :
@W_IN |
|
 |
 |
 |
 |
|
|
 |
 |
|
 |
 |
| |
|
|
|
| |
|
พี่คับในส่วนนี้เป็นส่วนของ Add มันบอกว่า
RS1("magname")นะ มัน Error อย่างที่บอกคับ
ผมลองปิดตัวนี้ทิ้งมันก็เพิ่มได้แต่พอผมเปิดมันก็ Error เหมือนเดิมคับ
ช่วยหน่อยคับ ขอบคุณคับ
if Request.QueryString("Action")="Add" Then
cid=request.form("cid")
name=request.form("name")
surname=request.form("surname")
address=request.form("address")
qid=request.form("qid")
cusid=request.form("cid")
cid=request.form("cid")
size=request.form("A") & "x" & request.form("B")
product=request.form("mBrand")
num=request.form("num")
datetime=request.form("Date")
square=request.form("square")
discount=request.form("discount")
total=request.form("total")
present=request.form("present")
condi=request.form("condi")
timework=request.form("timework")
byname=request.form("byname")
bysurname=request.form("bysurname")
magname=request.form("magname")
magsurname=request.form("magsurname")
comment=request.form("comment")
war=request.form("war")
vat=request.form("vat")
sql = "select * from customer"
set rsad = conn.execute(sql)
sql = "INSERT IGNORE into customer ( cusid, name, surname, address ) SELECT "
sql = sql & " '" & request.form("cid") & "' as cid, "
sql = sql & " '" & request.form("name") & "' as name, "
sql = sql & " '" & request.form("surname") & "' as surname, "
sql = sql & " '" & request.form("address") & "' as address; "
set rsad = conn.Execute(sql)
sql ="Select * From quotation"
Set RS1 = Server.CreateObject("ADODB.Recordset")
Rs1.open Sql,Conn,1,3
Rs1.AddNew
Rs1("qid") = request.form("qid")
Rs1("cusid") = cusid
Rs1("size") = size
Rs1("product") = product
Rs1("num") = num
Rs1("datetime") = datetime
Rs1("square") = square
Rs1("discount") = discount
Rs1("total") = total
Rs1("present") = present
Rs1("condition") = condi
Rs1("timework") = timework
Rs1("byname") = byname
Rs1("bysurname") = bysurname
Rs1("magname") = magname
Rs1("magsurname") = magsurname
Rs1("comment") = comment
Rs1("war") = war
Rs1("vat") = vat
Rs1.Update
end if
|
| |
|
|
| |
| Date :
7 มี.ค. 2548 16:25:32 |
By :
bank |
|
|
| |
|
|
|
|
|
| |
|
|
|
|
|
