Move to last record 1

[discusmania]

Hi guys.....

Who knows how to move to last record in oracle db?

for example i want to get the value on entry_id field for the last record in mydata table. how to get that? can i use movelast?

TQ
Nor

 

[iqof188]

You can do that in your SQL statement (which is fastest!) like this:

strSQL = "SELECT MAX(entry_id) As LastAdded FROM mytable"

Open a recordset with this statement, and output the last record like this:

<%= RS(&quot;LastAdded&quot %>

Good luck man, hope this helps...


<webguru>iqof188</webguru>