% dim db dim rs dim PicID dim PicTitle dim HullNo dim TypeOfVessel dim PageNo dim DWT set db = Server.CreateObject("ADODB.connection") set rs = Server.CreateObject("ADODB.recordset") picID = request.QueryString("picID") PageNo = request.QueryString("PageNo") pat = Server.MapPath(".") & ".\PhotoGallery.mdb" db.open "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & pat rs.open "select * from tblPicsShips where fldPicID = '"& picID &"'",db if not rs.eof then PicTitle = rs.fields("fldPicTitle") HullNo = rs.fields("fldHullNo") TypeOfVessel = rs.fields("fldType") MSize = rs.fields("fldSize") DateOfLaunching = rs.fields("flddateofLaunching") Owner = rs.fields("fldowner") DWT = rs.fields("fldDWT") GRT = rs.fields("fldGRT") end if rs.close set rs = nothing db.close set db = nothing %>
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||