How do I select the last article in a database? I could get all the records and then move to the last one but that does not seem very efficient. How do I select only the last?
Do you have a datetime field in there? If so, just sort on that field DESC<BR><BR>SELECT<BR>FROM<BR>WHERE<BR>ORDER BY yourdatefield DESC<BR><BR>If there isn't one, try and put one in?
Select TOP * From Table Order By ID
Well you probably want to avoid using the GetRows method.<BR><BR>Can you use MoveLast method?<BR><BR>I.e; dsoData.recordset.MoveLast()
Getting all of the records. Using SQL is a more efficent way to go about it.
Yeah, I thought so to.. Anyway - your code worked..:)