Read last entry from data base


#1

Hi…

I want to read ID of last entered data set from table, are there any
possible ways to it?
help Im stucked…
thankx


#2

try
Model.find(:last)


#3

or:

User.find(:all, :order => ‘id DESC’, :limit=>1)

On Oct 30, 12:44 pm, “bala kishore pulicherla” removed_email_address@domain.invalid


#4

thankx guys
but
still there is a problem

User.find(:all, :order => ‘id DESC’, :limit=>1)

and

Model.find(:last)

both return “#” mark only. whats the reson? i want last index id


#5

ok then say

lst_id = Model.find(:last).id
puts lst_id.inspect

hope 'll get this

as Model.find_last retunrns the entire last record

On Thu, Oct 30, 2008 at 5:53 PM, mithila karunarathna
<removed_email_address@domain.invalid


#6

If you want only the id of the last entered data then try this,
User.maximum(‘id’)
This will return the maximum id which will be anyways the last one.

xxmithila wrote:

Hi…

I want to read ID of last entered data set from table, are there any
possible ways to it?
help Im stucked…
thankx


#7

Thankx guys I got the answer…
WoW…
answer was

Model.maximum(“id”)

thank u again for ur help