Forums

This topic is locked

get specific record from recorset

Posted 08 Aug 2003 03:24:57
1
has voted
08 Aug 2003 03:24:57 paolo titolo posted:
I will like to get from a recordset record number 4(for example)
I know that for the first record the code is <%=(Recordset1_first)%>
And for number 4 ??????
is it possible?

Replies

Replied 08 Aug 2003 15:16:17
08 Aug 2003 15:16:17 Marcellino Bommezijn replied:
In your recordset dialog, click the Advanced button and at the Variables set your default value to the value you want to retrieve from your db.

Example:

SELECT Id, Content
FROM ContentTable
WHERE Id = MMColParam

--

Set the Default Value for MMColParam to 4.

This will return Id 4 if no run-time value is provided.
I hope this is what you want to achieve (?)

Reply to this topic