?
Solved

SQL database question...

Posted on 2012-04-03
5
Medium Priority
?
218 Views
Last Modified: 2012-04-03
I want to create a website that is able to post automatically a payment confirmation code to cells in a simple spreadsheet format. This would be retrieved from an email that both the payer and payee receive as acknowledgement. At this point I do this manually. If volume were to begin to escalate that might become quite difficult to keep current. Is using an SQL database the best avenue to accomplish this?
0
Comment
Question by:PCWoes
[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
5 Comments
 
LVL 15

Assisted Solution

by:gplana
gplana earned 498 total points
ID: 37802496
You should use some programming language, such as Visual Basic .Net or PHP, to calculate the confirmation code and send it by e-mail
0
 

Author Comment

by:PCWoes
ID: 37802504
I should also say at this point the payments currently are processed through PayPal and that code is generated and sent off by them to both parties...
0
 
LVL 22

Assisted Solution

by:plusone3055
plusone3055 earned 501 total points
ID: 37802510
VB.NET w/ SQL server  would be the path of least resistance
0
 

Author Comment

by:PCWoes
ID: 37802520
Currently I'm not setup as a commerce site...
0
 
LVL 34

Accepted Solution

by:
Paul MacDonald earned 501 total points
ID: 37802524
You could do this with SQL Server, but - depending on how you need to implement it - you'll have to do some scripting.  It might be easier to use an web page with some code behind it to do what you want.
0

Featured Post

Optimize your web performance

What's in the eBook?
- Full list of reasons for poor performance
- Ultimate measures to speed things up
- Primary web monitoring types
- KPIs you should be monitoring in order to increase your ROI

Question has a verified solution.

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

For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Suggested Courses

765 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