By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,694 Members | 1,847 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,694 IT Pros & Developers. It's quick & easy.

ASP Code to display last row in DB

P: n/a
I'm a new to asp and I'm trying to display the entired last row on the DB. I
try the objRecordset.MoveLast but I get the erros saying "Rowset does not
support fetching backward." How I can do that? Thanks in advance for any help
--
Pao Pao
Sep 3 '05 #1
Share this Question
Share on Google+
9 Replies


P: n/a
What does "last" mean? Why don't you return a resultset that only has one
row, instead of getting the entire table, if you only care about the "last"
row?


"Paola" <Pa***@discussions.microsoft.com> wrote in message
news:9B**********************************@microsof t.com...
I'm a new to asp and I'm trying to display the entired last row on the DB.
I
try the objRecordset.MoveLast but I get the erros saying "Rowset does not
support fetching backward." How I can do that? Thanks in advance for any
help
--
Pao Pao

Sep 3 '05 #2

P: n/a
that's what i try to do and I do not know how. I have made this table where a
customer add a record, and I want to show the record he/she enters.. but it
always show the first record of the table, not the last. I try getrows and
movelast and I get similar erros.
--
Pao Pao
"Aaron Bertrand [SQL Server MVP]" wrote:
What does "last" mean? Why don't you return a resultset that only has one
row, instead of getting the entire table, if you only care about the "last"
row?


"Paola" <Pa***@discussions.microsoft.com> wrote in message
news:9B**********************************@microsof t.com...
I'm a new to asp and I'm trying to display the entired last row on the DB.
I
try the objRecordset.MoveLast but I get the erros saying "Rowset does not
support fetching backward." How I can do that? Thanks in advance for any
help
--
Pao Pao


Sep 3 '05 #3

P: n/a
<sigh>
And, I suppose you're getting paid to do this.
</sigh>

Bob Lehmann

"Paola" <Pa***@discussions.microsoft.com> wrote in message
news:67**********************************@microsof t.com...
that's what i try to do and I do not know how. I have made this table where a customer add a record, and I want to show the record he/she enters.. but it always show the first record of the table, not the last. I try getrows and
movelast and I get similar erros.
--
Pao Pao
"Aaron Bertrand [SQL Server MVP]" wrote:
What does "last" mean? Why don't you return a resultset that only has one row, instead of getting the entire table, if you only care about the "last" row?


"Paola" <Pa***@discussions.microsoft.com> wrote in message
news:9B**********************************@microsof t.com...
I'm a new to asp and I'm trying to display the entired last row on the DB. I
try the objRecordset.MoveLast but I get the erros saying "Rowset does not support fetching backward." How I can do that? Thanks in advance for any help
--
Pao Pao


Sep 4 '05 #4

P: n/a
Unfortunately no. I'm learning as, sql, access, ado, VBScript to try to get
paid for that and I whised to have a client to make somthing like that
because I know I will get well paid.. sorry to dissapionted you
--
Pao Pao
"Bob Lehmann" wrote:
<sigh>
And, I suppose you're getting paid to do this.
</sigh>

Bob Lehmann

"Paola" <Pa***@discussions.microsoft.com> wrote in message
news:67**********************************@microsof t.com...
that's what i try to do and I do not know how. I have made this table

where a
customer add a record, and I want to show the record he/she enters.. but

it
always show the first record of the table, not the last. I try getrows and
movelast and I get similar erros.
--
Pao Pao
"Aaron Bertrand [SQL Server MVP]" wrote:
What does "last" mean? Why don't you return a resultset that only has one row, instead of getting the entire table, if you only care about the "last" row?


"Paola" <Pa***@discussions.microsoft.com> wrote in message
news:9B**********************************@microsof t.com...
> I'm a new to asp and I'm trying to display the entired last row on the DB. > I
> try the objRecordset.MoveLast but I get the erros saying "Rowset does not > support fetching backward." How I can do that? Thanks in advance for any > help
> --
> Pao Pao


Sep 4 '05 #5

P: n/a
"Paola" wrote in message
news:27**********************************@microsof t.com...
: Unfortunately no. I'm learning as, sql, access, ado, VBScript to try to
get
: paid for that and I whised to have a client to make somthing like that
: because I know I will get well paid.. sorry to dissapionted you

A: Because it messes up the order in which people normally
read text.
Q: Why is top-posting such a bad thing?
A: Top-posting.
Q: What is the most annoying thing on usenet and in e-mail?

What database are you using?

--
Roland Hall
/* This information is distributed in the hope that it will be useful, but
without any warranty; without even the implied warranty of merchantability
or fitness for a particular purpose. */
Technet Script Center - http://www.microsoft.com/technet/scriptcenter/
WSH 5.6 Documentation - http://msdn.microsoft.com/downloads/list/webdev.asp
MSDN Library - http://msdn.microsoft.com/library/default.asp
Sep 5 '05 #6

P: n/a
Oh, FFS, I am unsubscribing from this group. The most annoying thing on
usenet and in e-mail, indeed.
A: Because it messes up the order in which people normally
read text.
Q: Why is top-posting such a bad thing?
A: Top-posting.
Q: What is the most annoying thing on usenet and in e-mail?

Sep 5 '05 #7

P: n/a

"Aaron Bertrand [SQL Server MVP]" <te*****@dnartreb.noraa> wrote in message
news:O0**************@TK2MSFTNGP10.phx.gbl...
: Oh, FFS, I am unsubscribing from this group. The most annoying thing on
: usenet and in e-mail, indeed.
:
:
:
: > A: Because it messes up the order in which people normally
: > read text.
: > Q: Why is top-posting such a bad thing?
: > A: Top-posting.
: > Q: What is the most annoying thing on usenet and in e-mail?
:
:

--
Roland Hall
/* This information is distributed in the hope that it will be useful, but
without any warranty; without even the implied warranty of merchantability
or fitness for a particular purpose. */
Technet Script Center - http://www.microsoft.com/technet/scriptcenter/
WSH 5.6 Documentation - http://msdn.microsoft.com/downloads/list/webdev.asp
MSDN Library - http://msdn.microsoft.com/library/default.asp
?
y
a
s

u
o
y

d
i
d

t
a
h
W
Sep 6 '05 #8

P: n/a
Dude, how old are you? 7?
?
y
a
s

u
o
y

d
i
d

t
a
h
W

Sep 6 '05 #9

P: n/a
"Pencil Pusher" <pe***********@hotmail.org> wrote in message
news:er*************@tk2msftngp13.phx.gbl...
: Dude, how old are you? 7?

Big enough to push you down and take your lunch money.
Sep 6 '05 #10

This discussion thread is closed

Replies have been disabled for this discussion.