<% Dim MyConn, RS, i accessdb="data/database.mdb" myDSN="DRIVER={Microsoft Access Driver (*.mdb)};" myDSN=myDSN & "DBQ=" & server.mappath(accessdb) dim conntemp, rstemp set conntemp=server.createobject("ADODB.connection") conntemp.open myDSN mySQL1 = "Select * From News order By theDate DESC" set rstemp=conntemp.execute(mySQL1) if rstemp.eof then call show_error() else howmanyfields=rstemp.fields.count -1%> ePodiatry
ePodiatry

ePodiatry Home
Podiatry Newsletter
Educational Resources
Directory
News
Conferences
Podiatry Books  
Foot Problems  

 

 

 

 

 

Web site designers
WebGenius

<% ' Now lets grab all the records do while not rstemp.eof %> <% for i = 1 to howmanyfields-5 thisvalue=rstemp(i) If isnull(thisvalue) then thisvalue=" " end if%> <% next %> <%rstemp.movenext loop%>
Podiatry News
 
Coming
 
  
 
<% rstemp.close set rstemp=nothing end if%>

Site Map

<%sub show_error()%>
No message available.

Please click here
<%end sub%>