Hum I read my message sorry it is not clear it was real late when I wrote it. I have a
clone database to catch web entries it holds the same info as the main database. when
a user enters a record I don't want them to be able to slap it in the main without an
admin verifying the info. So what I have done is put a checkbox called submit to main
on the admin form. The admin loads the form from the database it loads all records
that have not been submitted to main(where chkSubmit = false). When the admin verifies
that the record is indeed ok he puts a check in the chkSubmit box then submits the
record there for it should disappear out of the ado collection. I agree that ado is
intense on the server so I would like to hook up to the database and retrieve records
each time the next, back, submit or delete buttons are clicked. There are never going
to be more than 2 admins doing this at a time and probably only 20 to 30 records
entered a day for now. It is possible that this number grows in the future at which
point this Pentium 3 550 server isn't going to cut it but for now it works. I know how
to make the buttons work but I am not sure how to get the record number for the move
next move back and such. When the admin hits the submit button it calls the submit
page and inserts into the web database and also into main database. the Admin form is
renewed and the submitted record is not there so the next one to be submitted is. My
dilemma is that two groups make entries on forms one registers a user the user does
tests and the test center completes the form once tests are passed. So when the admin
is checking entries some will not be submitted and some will so the back and next
button come into play. I have two forms that will do this and they are both nasty with
about 69 entries on each one. Just to make things worse one of the forms has editable
listboxes(about 9 of them) and I have to make sure entries aren't entered for nothing
from those boxes so I have to check if the record was manually typed or if it is in
the database each time. Hope this is a better explanation.
----- Original Message -----
From: Mark E
To: [EMAIL PROTECTED]
Sent: Wednesday, May 12, 2004 5:19 AM
Subject: Re: [AspClassicAnyQuestionIsOk] move next one record at a time
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
ADVERTISEMENT
------------------------------------------------------------------------------
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 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/
