473,401 Members | 2,127 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,401 software developers and data experts.

ASP Code to display last row in DB

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
9 3203
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
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
<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
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
"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
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

"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
Dude, how old are you? 7?
?
y
a
s

u
o
y

d
i
d

t
a
h
W

Sep 6 '05 #9
"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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: pembed2003 | last post by:
"news.hku.hk" <billychu@hkusua.hku.hk> wrote in message news:<408e8476$2@newsgate.hku.hk>... > thanks for all of your's help > but i still can't grasp the idea of the algorithm > maybe could...
10
by: Vineet | last post by:
If anybody has any insight into this problem I'm running into I would really appreciate if you could write to me... I'm running a simple C++ program on Solaris 8 that forks and execs a bunch of...
6
by: Sally | last post by:
I need to be able to click in a subform and run code but at the same time I need to be able to scroll the records without running the code. I tried coding the Enter event of the subform control but...
5
by: Steven Smith | last post by:
I was flicking through the windows accesories programs for some inspiration for todays vb challenge when I came accross the calculator program & thought that looks easy I could do that. However...
7
by: Andrea | last post by:
Hi there - I'm hoping someone can help me; I've been struggling with this for a few days! :-) I have a webpage that is comprised of many forms containing questions. As the user answers one...
5
by: loc2006 | last post by:
I got this tablesort code from http://www.brainjar.com/dhtml/tablesort/default7.asp This is very slow for my table of 10 columns and 400 rows. Is there a way to optimize this code make it...
10
by: Mythmon | last post by:
I am trying to make a program that will basically simulate a chess clock in python. To do this I have two threads running, one that updates the currently running clock, and one that watches for a...
1
by: rn5a | last post by:
I want an ASP app to retrieve records from a MS-Access database table but display them in a HTML table but I want the HTML table table to display only 7 records in a row (<tr>...</tr>) in 7...
3
by: Hazza | last post by:
Hi, I am using PHP and mysql to create a website. I am fairly new to PHP, and thus am grateful to anyone who helps! Firstly I am running a homepage, that displays additional content if a user...
2
by: prakatak7410 | last post by:
#include<iostream> #include<string> #include<cctype> using namespace std; struct SEAT { bool occupied; // initially, false string first,last; // passenger name int numBags; ...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.