pfrenchy,
I don't actually work with an ADO recordset. It's server-side and too resource
intensive to maintain. Think of it more as working with a single record with the
ability to get the first, previous, next and last record on the fly.
Anyhow, I don't I fully understand what you are trying to do.
I understand the part about moving through the records. But what do you mean by after
you submit the entry you do not want it to appear in your ado any more?
Sorry, it's early and I haven't finished my first cup of coffee. So forgive me if
this is obvious!
Mark
pfrenchy <[EMAIL PROTECTED]> wrote:
Hey Mark E is there anyway you could post some sample code to create an ado
connection. I as well am trying to go threw records. My dilemma is that in my admin
portion I want to go threw my web database and verify entries before I submit them to
my main database. When I am going threw records and I am satisfied with the entry I
will check a box then hit a submit button once I do this I don't want this record to
appear in my ado any more. I would like a( back , next ,delete button on this ado )
and my submit button to insert into my main database. Is this even possible. Any
enlightenment on this would be a great help.
----- Original Message -----
From: Mark E
To: [EMAIL PROTECTED]
Sent: Tuesday, May 11, 2004 10:30 AM
Subject: Re: [AspClassicAnyQuestionIsOk] move next one record at a time
Well, I would start by changing your SQL statement to order the records by the
number you are presenting (100, 101, 102, etc). Something like this:
sql="select * from leavepending order by ID"
Replace the word "ID" with the field name of the the number.
Once that is done, your code should work because the records will come back in order
by ID. So it won't matter if you delete any records. It will always move to the next
record in the recordset.
Mark
peijanelaw <[EMAIL PROTECTED]> wrote:
hi everyone,
i need to move next record, in some case not in order...
eg.100,101,103,106, with assumption that record 104,105 have been
deleted... i have tried the following but fail, please help thanks...
Set rs=server.createobject("ADODB.Recordset")
sql="select * from leavepending"
rs.ActiveConnection = strconnect
rs.Source = Sql
rs.CursorType = 0
rs.CursorLocation = 2
rs.LockType = 3
rs.Open()
if request.form="" then
rs.movefirst
end if
If request.form("combutton")="NEXT" Then
rs2.movenext
End If
If request.form("combutton")="BACK" Then
rs2.moveprevious
End If
<input type="text" name="leaveid" size="30" value="<% =rs2
("numid").value %>">
but base on my code,it can only move ONCE only,eg.100 move to 101,
keep on 'Next' won't move to 103, just remain 101.... please help, i
am really stuck, i can't find any referece on this.....thanks..
Yahoo! Groups SponsorADVERTISEMENT
---------------------------------
Yahoo! Groups Links
To visit your group on the web, go to:
http://groups.yahoo.com/group/AspClassicAnyQuestionIsOk/
To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
---------------------------------
Do you Yahoo!?
Win a $20,000 Career Makeover at Yahoo! HotJobs
[Non-text portions of this message have been removed]
------------------------------------------------------------------------------
Yahoo! Groups Links
a.. To visit your group on the web, go to:
http://groups.yahoo.com/group/AspClassicAnyQuestionIsOk/
b.. To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[Non-text portions of this message have been removed]
---------------------------------
Yahoo! Groups Links
To visit your group on the web, go to:
http://groups.yahoo.com/group/AspClassicAnyQuestionIsOk/
To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
---------------------------------
Do you Yahoo!?
Yahoo! Movies - Buy advance tickets for 'Shrek 2'
[Non-text portions of this message have been removed]
------------------------ Yahoo! Groups Sponsor ---------------------~-->
Yahoo! Domains - Claim yours for only $14.70
http://us.click.yahoo.com/Z1wmxD/DREIAA/yQLSAA/saFolB/TM
---------------------------------------------------------------------~->
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/AspClassicAnyQuestionIsOk/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
