?
Solved

NonProfit Donation Site

Posted on 2003-03-09
5
Medium Priority
?
355 Views
Last Modified: 2012-06-27
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)
0
Comment
Question by:esams
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
5 Comments
 
LVL 1

Expert Comment

by:Computer101
ID: 8098287
Solicitaion and e-mail address edited.  The solicitaion is against e-e policy

Computer101
E-E Admin
0
 
LVL 1

Accepted Solution

by:
yitz99 earned 1000 total points
ID: 8101915
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
 

Author Comment

by:esams
ID: 8103255
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
 

Author Comment

by:esams
ID: 8103264
yitz99's answer was not what I was looking for... but hey, he responded!
0
 
LVL 1

Expert Comment

by:yitz99
ID: 8111609
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

Featured Post

Setting up LaraDock for Laravel

Learn how to set up LaraDock in a Laravel project - LaraDock gives us an easy way to run a Laravel application using Docker in a single command.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Australian government abolished Visa 457 earlier this April and this article describes how this decision might affect Australian IT scene and IT experts.
When it comes to security, close monitoring is a must. According to WhiteHat Security annual report, a substantial number of all web applications are vulnerable always. Monitis offers a new product - fully-featured Website security monitoring and pr…
Viewers will get an overview of the benefits and risks of using Bitcoin to accept payments. What Bitcoin is: Legality: Risks: Benefits: Which businesses are best suited?: Other things you should know: How to get started:
This tutorial demonstrates how to identify and create boundary or building outlines in Google Maps. In this example, I outline the boundaries of an enclosed skatepark within a community park.  Login to your Google Account, then  Google for "Google M…
Suggested Courses

752 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question