pfrenchy,
OK, I will take a stab at this:
1) Admin clicks on a "GetUnapprovedDetails.asp".
2) GetUnapprovedDetails.asp has a sql statment like "select max(ID), Name, Date from
leavepending".
3) Check recordset for a record. If found, display the details. If not, display "no
pending records to display". Or something like that.
4) If there was a record from step 3, display the data on the form for approval.
Then, take this ID, build and execute the following SQL: select max(ID), Name, Date
from leavepending where ID <> " & intID
5) Check for a record. If one is found, dynamically display a next link calling this
same page. If no record is found, do nothing as there are no more records.
6) Admin submits the form to itself, updating the record and it gets removed from the
clone database and goes to the main database. Then the page again starts at step 1.
Now, I just typed this as I was going along, so I might have missed some things. But
it's a start.
An alternative would be to create a page that lists each record pending approval and
make the admin always go to this page & drill down to see & approve the record. It's
much easier to create, but you would loose the "next record" feature.
Mark
pfrenchy <[EMAIL PROTECTED]> wrote:
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 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!?
Yahoo! Movies - Buy advance tickets for 'Shrek 2'
[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:
http://docs.yahoo.com/info/terms/
