-----Original Message-----
From: Ai Rosita <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
Date: 17 Oktober 2000 09:25
Subject: [webauthor] Gimana nampilkan Query..????
<!--DEL-->
>Mas/Mba tolong bantu saya dong..!! saya lagi bikin aplikasi
>Web pake ASP
>pingin nampilkan hasil query yang telah saya buat di ACCESS
>97 gimana
>yah..???
>kalo kita nampilin tabel begini :
>
><%
>Set OBJdbConnection =
>Server.CreateObject("ADODB.Connection")
>OBJdbConnection.Open "Nama_Connectsi_nya"
>SQLQuery = "SELECT * FROM Table_nya "
>Set RSTable_nyaList = OBJdbConnection.Execute(SQLQuery)
>%>
>
>Nah di ACCESS 97 saya sudah buat tabel Query dengan nama
"Gabungan"
>gimana manggilnya..????
Gimana kalo dirubah dikit:
Set ADORcs = Server.CreateObject("ADODB.Recordset")
ConnStr = "Provider=Microsoft.Jet.OLEDB.3.51;Data
Source=c:\nama_file_mdb_anda.mdb"
ADORcs.Open "SELECT * FROM Gabungan", ConnStr
ADORcs.MoveFirst
i = 0
Do While Not ADORcs.EOF
'menampilkan data pada field pertama
Response.Write ADORcs(1)
Response.Write "<br>"
ADORcs.MoveNext
Loop
ADORcs.Close
<!--DEL-->
Syarif Lumintarjo
### FREE DOMAIN [.COM|.NET|.ORG *] >> http://www.indoglobal.com << ###
Berhenti langganan kirim email ke [EMAIL PROTECTED]
Arsip di http://www.mail-archive.com/[email protected]/
