NonProfit Donation Site

I am developing a website that will facilitate the donation of stock and mutual funds to any nonprofit organization.
I have 1 database with 5 tables which gather the following:
1- Nonprofit Information
2- Donor Personal Info
3- Donor Brokerage Info
4- Stock gift info
5- Mutual fund gift info
The sequence of gathering the information is as follows:
1) Donor chooses Nonprofit to donate to
2) Donor specifies stock or mutual fund gift
3) Donor specifies exact gift of stock or mutual fund
4) Donor enters personal information
5) Donor enters brokerage information
My question: What is the best way to transfer gather, transfer, and post the information to the appropriate tables?
SessionID, parameters, hidden fields, cookies or some other way?
Another Question: How can I submit forms to the Donor database and retrieve the unique id assigned by ms access in a single step so I can move to the next page?

(Edited by Computer101)
esamsAsked:
Who is Participating?
 
yitz99Connect With a Mentor Commented:
Your question is kind of vague.  Are you asking advice for what type of technology to use - Windows, unix, linux, ASP, cgi, jsp etc. etc.?

Since you mentioned access, I would assume that you are using windows, IIS, and ASP.

If so, what would you like to know?  Go to learnasp.com to learn ASP's.  

As you mention there are different ways to maintain session state. They have different advantages and disadvantages.  

You will need a secure connection with a certificate if you expect people to submit sensitive information.

Access and autonumbers - I have found in the past that access has trouble returning a newly created autonumber value in real time.  As a were around, I send a click here to continue screen to the user to continue processing.
0
 
Computer101Commented:
Solicitaion and e-mail address edited.  The solicitaion is against e-e policy

Computer101
E-E Admin
0
 
esamsAuthor Commented:
I figured out how to submit and retrieve the unique id assigned by access. This came from MSFT.

As follows:


<%@ Language=VBScript %>
<HTML>
<BODY>

<!--#include file=adovbs.inc -->


<%
NPEIN=request.form("NPEIN")
FirstName=request.form("FirstName")
LastName=request.form("LastName")
Address=request.form("Address")
City=request.form("City")
State=request.form("State")
Zip=request.form("Zip")
DayPhone=request.form("DayPhone")
EveningPhone=request.form("EveningPhone")
Email=request.form("Email")
%>

<%
Set objConn = CreateObject("ADODB.Connection")
Set objRS = CreateObject("ADODB.Recordset")

objConn.Open "SNLAL"

'Access does not support a cursor engine so a client cursor must be used
objRS.CursorLocation = adUseClient

objRS.Open "SELECT * FROM dnr", objConn, adOpenStatic, adLockOptimistic

     ' when you invoke the method AddNew it adds a new record to the end of          
     ' your current recordset and places your cursor on that record.
     
objRS.AddNew
        objRS("FirstName") = request.form("FirstName")
        objRS("LastName") = request.form("LastName")
        objRS("Address") = request.form("Address")
        objRS("City") = request.form("City")
        objRS("State") = request.form("State")
        objRS("Zip") = request.form("Zip")
        objRS("DayPhone") = request.form("DayPhone")
        objRS("EveningPhone") = request.form("EveningPhone")
        objRS("Email") = request.form("Email")
objRS.Update

     ' when you invoke the method Update, it updates the database with the
     ' values of the new record that we just created.  To retrieve the
     ' value of the Autonumber field we need to update the ADO recordset that
     ' currently have.

     ' When you do a Requery on your recordset, you lose your cursor.  So
     ' we need to store the location before we do the Requery, then reset
     ' it after the Requery.

'before the requery, the Autonumber field shows as 0
'Response.Write "<br>ID before Requery = " & objRS("DNRID")  

bookmark = objRS.absolutePosition  ' First, store the location of you cursor
objRS.Requery                      ' Next, update your recordset with the data from the database

'after the requery, the absolutePosition is the first record of the recordset
'Response.Write "<br>ID before setting absolutePosition = " & objRS("DNRID")

objRS.absolutePosition = bookmark  ' Finally, change your cursor back

'now we have the Autonumber value
'Response.Write "<P>Added ID = " & objRS("DNRID")

'I Added this info!
DNRID= objRS("DNRID")

objRS.Close
objConn.Close
set objConn = nothing
set objRS = nothing
%>
<br>
<form action="brokerage.asp" method="POST">
<input type="hidden" name="NPEIN" value="<%=NPEIN%>">
<input type="hidden" name="DNRID" value="<%=DNRID%>">
<p>
<input type="submit" value="Donate Mutual Fund"></p>
</p>

<%=NPEIN%><br>
<%=FirstName%><br>
<%=LastName%><br>
<%=Address%><br>
<%=City%><br>
<%=State%><br>
<%=Zip%><br>
<%=DayPhone%><br>
<%=EveningPhone%><br>
<%=Email%><br>
<%=DNRID%>
0
 
esamsAuthor Commented:
yitz99's answer was not what I was looking for... but hey, he responded!
0
 
yitz99Commented:
esams - Why not elaborate a bit on what you are looking for?  As a general comment, I can tell you that the scope of your project sounds ambitous.  It will take a lot of work to get it looking clean and running smoothly and securely.

Good luck and stay healthy!
0
All Courses

From novice to tech pro — start learning today.