<%set conn = server.createobject("adodb.connection")
conn.open "provider=microsoft.jet.oledb.4.0; data source=" & server.mappath("db/db_school01.mdb")
Sql="SELECT curriculum.cur_code,curriculum.cur_name,section_all.cur_code,section_all.sec_code,section_all.sec_name,section_all.sec_year FROM section_all INNER JOIN curriculum ON section_all.cur_code = curriculum.cur_code ORDER BY curriculum.cur_code DESC "
Set RS=Server.CreateObject("ADODB.Recordset")
RS.Open Sql, Conn, 0, 3
Do While Not RS.Eof
Response.Write rs("section_all.cur_code")&response.write("<br>")
Response.Write rs("curriculum.cur_name")&response.write("<br>")
Response.Write rs("section_all.sec_code")&response.write("<br>")
Response.Write rs("section_all.sec_name")&response.write("<br>")
Response.Write rs("section_all.sec_year")&response.write("<br>")
RS.MoveNext
Loop
set rs = nothing
conn.close %>
Error Type:
ADODB.Recordset (0x800A0CC1)
Item cannot be found in the collection corresponding to the requested name or ordinal.
/test_2table.asp, line 11 (ตรงนี้คือเรียกข้อมูลออกมาแสดงค่ะ ไม่ได้ตังแต่ Field แรกจนถึง Field สุดท้ายเลย) มือใหม่น่ะค่ะ
Load balance : Server 02
