Please help a newbie!

[christinak]

I was hoping that someone out there could give me direction! I can code VB, etc. so I am not programming stupid and I know what I need to do, but I'm not sure how to do this in a web environment.

I work in a office which uses a complex project numbering system.
I have a web form to apply for a project number that I need to have do a few things:
1. programmatically find the project number based on info entered in the form and already in the database
i.e. the project number is determined by the year, the office location (we have 4 offices) and the next number in order. So if the year is 2003, the office is Lima and the next number is 199 the project number would have to be 03L199
2.submit this info to a sql server db
3. be able to bring this info back into the form in order to update it.

What I'd like to know is, what language(s) should I be using to do this? I know html and some javascript, but for the database portion, I'm not sure that this is enough...

Thanks!!!!

[AdamGundry]

Almost any server-side language should be suitable for what you want to do (e.g. PHP, Perl, etc.). HTML and JavaScript are client-side languages and as such have no file access/database support.

It depends on what languages your server supports. I'd personally recommend PHP (http://www.php.net/), which is free and open source, similar to JavaScript. Alternatively, ASP (http://www.asp.net/) might be more suitable as you are familiar with VB.

Adam

[BlueMonk]

If you can code in VB, you can use VB to write CGI programs to perfom your task. Here is a CGI module written in VB, you could use it to do your job (just rename the file to .bas extension).