 |
| |
จะต้องแก้ไขที่ใดครับ... Error Type: Microsoft JET Database Engine (0x80040E07) Data type mismatch in criteria expression. |
| |
 |
|
|
 |
 |
|
Error Type:
Microsoft JET Database Engine (0x80040E07)
Data type mismatch in criteria expression.
/sis/admin/transationresult.asp, line 127
121 = If trans <> "" Then
123 = sql="Insert Into trans (trans, debit, credit, balance, cid, mname, mlname, muser,tdate) Values ('" & trans & "','" & debit & "','" & credit & "','" & balance & "','" & tcid & "','"& tname &"', '"& tlname &"', '" & tuser & "','"& Now & "')"
125 = Response.Write("<div align='center' class='text'><br><BR>Send Transation Details Success<br>")
126 = Response.End()
127 = Set rs=conn.execute (sql)
129 = End if
Tag : - - - -
|
|
|
 |
 |
 |
 |
| Date :
10 ม.ค. 2550 10:37:16 |
By :
_sunshine_ |
View :
2431 |
Reply :
3 |
|
 |
 |
 |
 |
|
|
|
|
 |
 |
|
 |
 |
| |
|
|
|
| |
|
DB >> Trans
Tid = AutoNumber
trans = Memo
debit = Number
credit = Number
balance = Number
cid = Number (FK)
mname = Text
mlname = Text
muser = Text
tdate = Date / Time
|
| |
|
|
| |
| Date :
10 ม.ค. 2550 11:09:37 |
By :
_sunshine_ |
|
|
| |
|
|
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
Error Type:
Microsoft JET Database Engine (0x80040E07)
Data type mismatch in criteria expression.
/sis/admin/transationresult.asp, line 127
121 = If trans <> "" Then
123 = sql="Insert Into trans (trans, debit, credit, balance, cid, mname, mlname, muser,tdate) Values ('" & trans & "',"& debit & ","& credit &","& balance &","& cid &",'"& tname &"', '"& tlname &"', '" & tuser & "','"& Now & "')"
125 = Response.Write("<div align='center' class='text'><br><BR>Send Transation Details Success<br>")
126 = Response.End()
127 = Set rs=conn.execute (sql)
129 = End if
"& debit & ","& credit &","& balance &","& cid &"
number = "& debit &"
text = '"& mname &"'
|
| |
|
|
| |
| Date :
10 ม.ค. 2550 11:56:43 |
By :
kittipong |
|
|
| |
|
|
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
ขอบคุณครับ ที่ช่วยเหลือ
พอดีว่าผมวางไว้แยก Form ก็เลยไม่สามารถ Insert ลง DB ได้ แต่ตอนนี้เรียบร้อยแล้วครับ
ขอบคุณมากครับ
|
| |
|
|
| |
| Date :
10 ม.ค. 2550 15:03:58 |
By :
_sunshine_ |
|
|
| |
|
|
|
|
|
| |
|
|
|
|
|
