Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 221
  • Last Modified:

SQL database question...

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
PCWoes
Asked:
PCWoes
3 Solutions
 
gplanaCommented:
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
 
PCWoesAuthor Commented:
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
 
plusone3055Commented:
VB.NET w/ SQL server  would be the path of least resistance
0
 
PCWoesAuthor Commented:
Currently I'm not setup as a commerce site...
0
 
Paul MacDonaldDirector, Information SystemsCommented:
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

NEW Veeam Backup for Microsoft Office 365 1.5

With Office 365, it’s your data and your responsibility to protect it. NEW Veeam Backup for Microsoft Office 365 eliminates the risk of losing access to your Office 365 data.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now