|
 |
| |
สอบถามเกี่ยวกับการเชื่อม Access คับ.. The specified field 'IP' could refer to more than one table listed in the FROM |
| |
 |
|
|
 |
 |
|
ขอ Code ที่เขียนไว้มาดูหน่อยครับ 
|
 |
 |
 |
 |
| Date :
2013-05-02 08:55:36 |
By :
mr.win |
|
 |
 |
 |
 |
|
|
 |
 |
|
 |
 |
| |
|
|
|
| |
|
Code (ASP)
Dim Conn,strSQL,objRec
Set Conn = Server.Createobject("ADODB.Connection")
Conn.Open "DRIVER=Microsoft Access Driver (*.mdb);DBQ=" & Server.MapPath("mydatabase.mdb"),"" , ""
'*** Search By Name or Email ***'
strSQL = "SELECT * FROM MyTable as a INNER JOIN Table1 as b on a.IP = b.IP "
strSQL = strSQL & "WHERE (IP LIKE '%"& Request.QueryString("txtKeyword") &"%' "
strSQL = strSQL & "or Cill LIKE '%"& Request.QueryString("txtKeyword") &"%' ) "
Set objRec = Server.CreateObject("ADODB.Recordset")
objRec.Open strSQL, Conn, 1,3
|
| |
|
|
| |
| Date :
2013-05-02 08:57:35 |
By :
solskjaer16 |
|
|
| |
|
|
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
พอดีเพิ่งหัดเขียนครั้งแรกอ่าคับ
|
| |
|
|
| |
| Date :
2013-05-02 08:58:14 |
By :
solskjaer16 |
|
|
| |
|
|
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
คุณไม่ได้ดูที่ผมทำสีแดงให้เหรอครับ
|
| |
|
|
| |
| Date :
2013-05-02 09:03:41 |
By :
mr.win |
|
|
| |
|
|
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
จัดไปครับ
|
| |
|
|
| |
| Date :
2013-05-02 09:12:40 |
By :
mr.win |
|
|
| |
|
|
|
|
|
| |
|
|
|
|
|
| |
|
 Load balance : Server 03
|
Quote:
