get last record in db thanks

[melnet]

hi

i wanna get the last record.
i tried to code:
rs.MoveLast
pid=rs("productID")

get a error...:can't support to get the record from last(sth like that)

any method to solve?

and

2.33333333....=7/3
i dont want to get 2.333333...
i wanna get 3.

i just coded:
a=CInt(ttlCount/3)
b= ttlCount mod 3
c=a+b

~.~;

thanks

 

[Veep]

Does the last record have the highest number PID? If so, do it with your SQL.

strSql="SELECT MAX(PID) as theLastRecord FROM myTable"
set rs = conn.execute(strSql)
pid = rs("theLastRecord")

 

[ChrisHirst]

and the maths

response.write RoundUp(7,3)


function RoundUp(Dividend,Divisor)
if Dividend / Divisor - Dividend \ Divisor =< 0.5 then
RoundUp = round((Dividend / Divisor) + 0.5)
else
RoundUp = round(Dividend / Divisor)
end if
end function

Chris.

Indifference will be the downfall of mankind, but who cares?

http://www.candsdesign.co.uk

A website that proves the cobblers kids adage.

http://www.cram-system.com

Nightclub counting systems

So long, and thanks for all the fish.