ha! lol never saw that post 5 from the top
however, im stuck. basicly im editing a script i downloaded. its the page that shows all the entries of the database. However, im not sure where or what to edit to make the RND function work.
- Code: Select all
<%
dim Connect, SHOWALL, Query
Set Connect = Server.CreateObject("ADODB.Connection")
Connect.Open("DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & server.MapPath("db.mdb"))
Set SHOWALL = Server.CreateObject("ADODB.Recordset")
Query = "SELECT * FROM records"
SHOWALL.Open Query, Connect, adOpenDynamic, adLockOptimistic
SHOWALL.movefirst
do while not SHOWALL.eof
%>
how do i edit this? and whats the basic connection to the db, cos i know some of that is extra, just dont know what.
(is it this?)
- Code: Select all
<%
dim Connect, SHOWALL, Query
Set Connect = Server.CreateObject("ADODB.Connection")
Connect.Open("DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & server.MapPath("db.mdb"))
Query = "SELECT * FROM whatever"
%>
with regards