• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 227
  • 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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

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