Re: FN-FORUM ultradev and move to last entry problem...help!

date posted 9th January 2001 11:04

rob, you can either use rs.movelast

code:

set rs=server.createobject(adodb.recordset)

rs.open sql, conn, adopenstatic

rs.movelast

variable=rs(fieldname)

or you can cheat if youre having hassles with recordsets

sql="SELECT TOP 1 * FROM tablename ORDERBY primarykeyname DESC"

set rs=conn.execute(sql)

the cheats way is less versatile but will quickly do as you want

dave ecky

David Eckersall
Kinetic North Limited
A member of the Wize Group of companies
Reg Co No 4100142
Reg Office and Business Address
St James House, Wellington Road North
Stockport SK4 2QN
Office Tel - 00 44 161 975 5900
Office Fax - 00 44 161 975 5924
Web - http://www.kineticnorth.com

This communication contains information which is confidential and may also
be privileged. It is for the exclusive use of the intended recipient(s). If
you are not the intended recipient(s) please note that any form of
distribution, copying or use of this communication or the information in it
is strictly prohibited and may be unlawful. If you have received this
communication in error please return it to the sender. Internet e-mails are
not necessarily secure. Kinetic North Limited does not accept responsibility
for changes made to this message after it was sent. Our messages are checked
for viruses but please note that we do not accept liability for any viruses
which may be transmitted in or with this message.

----- Original Message -----
From: [EMAIL REMOVED]
To: [EMAIL REMOVED]
Sent: Tuesday, January 09, 2001 10:44 AM
Subject: FN-FORUM ultradev and move to last entry problem...help!


> does anyone know how to pull out the last entry of an access 2000 database
using ultradev. At the moment I can only get it to pull out the first entry
without using a search (which I don't want to do). I've been advised to use
rs.movelast but can't get it to work. If this is correct, where would I
put it in the code? any help would be much appreciated!!! I'd also like to
thank you all for all your help so far in my quest to crack asp...I'm
getting there!
>
> ============================================================
>
> * Free listing for freelancers
> * Free to advertise jobs
> * Free jobs distribution service
> * Free database of 1000 freelancers
>
> Freelancers and Freelance Jobs
> http://www.freelancers.net
>
> To post to the Forum:
> [EMAIL REMOVED]
>
> To unsubscribe please email:
> [EMAIL REMOVED]
>
> If you have difficulties unsubscribing please email:
> [EMAIL REMOVED]
>
> To subscribe to the digest for this list or for further information please
visit:
> http://www.freelancers.net/forum.html