Forskellig record set
Hey!Har tre forskellige recordset. Kan ikke få det sidste til at virke!!
Set DataConn = Server.CreateObject("ADODB.Connection")
DSN = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & server.mappath("dbase.mdb")
DataConn.Open DSN
Set RS_read_text = Server.CreateObject("ADODB.RecordSet")
RS_read_text.open "Select * From [texts] WHERE id = " & Request("id") & "" , DataConn, 1, 3
Set RS_user = Server.CreateObject("ADODB.RecordSet")
SQL = "Select * from [users] Where username = '" & RS_read_text("author") & "'"
RS_user.Open SQL, DataConn, 1, 3
Set RS_disko = Server.CreateObject("ADODB.RecordSet")
SQL_disko = "Select * from [discos] Where id = '" & RS_user("discoId") & "'"
RS_disko.Open SQL_disko, DataConn, 1, 3
Please Help!!
/Bruhn
