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?
PCWoesAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
Paul MacDonaldConnect With a Mentor Director, 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
 
gplanaConnect With a Mentor Commented:
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
 
plusone3055Connect With a Mentor Commented:
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
All Courses

From novice to tech pro — start learning today.