This is quite possibly not the place for this but it is more to do with SQL than the other things included so I apologise if I am wrong.
I am looking for some help on a task I have been set.
When I say help, what I actually mean is I need someone to draw the dots that I am supposed to be joining, as this is not my area and I am bumbling through with not much of a clue so do please bear with me on this one...
I have an MS SQL database full of all my customers details including issues they have had in the passed etc. which is linked to a 4th Dimension front end which I use for input.
I want to put a simple form on my website so my customers can go there, fill thier details in (usual stuff: name, address, issue etc.), hit 'Submit' then the information is slammed straight into my database the same as it would usually be done from our 4D application. I would then like it to send an email to me with our reference number (issued by the server) and the details of the call so we can bring it up in our system for editing and contacting the customer obviously.
If someone could point me in the direction of some material to read or even give me some idea of where I should be starting that would be massively appreciated.
I have been told Perl could be the way to go but, as with the other subjects covered above, I lack the know how when it comes to using them.
I have installed ActivePerl on my test server but if anyone knows another, or better way of going about what I am looking to do I would be very interested. I don't mind learning a new language etc. but I don't want to spend hours educating myself only to find there is a much easier way of doing it.
Thank you very much for taking the time to read this and I look forward to seeing back from you.