Specific record

[sanjay]

Hi,

I have a set recordset (20 records) I would like to get a specific record from this set, eventually I would like to get each one but need to place the record in different places within a page is this possible?

So say I a recordset called rsBuildings and would like to retreive record 5 from this set.

I am using ASP VBScript and MS Access.

Thanks,

SAnjay

[makeupalley]

[devguru.com...]

[sanjay]

Thanks for the reply, after reading the reply I was a bit confused (I'm not a programmer)

so I tried numerous variations:

My recordset is called rsNoOfTickets, there are always 10 records, an I am tring to get say record 5

<script language="VBScript" type="text/VBScript">
varBkMrk = rsNoOfTickets.Bookmark
rsNoOfTickets.Move 3
If rsNoOfTickets.EOF = True
rsNoOfTickets.Bookmark = varBkMrk
End If
response.write(varBkMrk)
response.write(rsNoOfTickets.Move (5, 5 ))
</script>

Any ideas?

Thanks,

Sanjay

[davegerard]

Each record should have a unique ID (Primary Key). Try this.

'--start--

set rs = server.createobject("adodb.recordset")
sql = "select field from table where IdField = 5"
rs.open sql, "Dsn = MyDsn"
if not rs.eof then

BookMark = rs("field")

end if
rs.close
set rs = nothing

'--end--

***Dsn being your ODBC connection to the Access database. Let me know via email if you need some further help.

Dave
[e-mail]