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 (?)
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 (?)