Please help a novice

[sabavno]

Hi,
Never written a singe CGI script, but I guess I would need to, so I am asking for your help.

I have a HTML form.
I need to take a value from the form, then open ODBC connection to the SQL Server table and look if the value taken from the form is in the table. If it is, then I open 1.asp page, if not, then I need open 2.asp page.

So, as I understand, I would have to write cgi script to such processing. Am I wrong?

If not, would anybody share an example of cgi script that would do the ODBC connection and execute SQL statement.

Please, I am desperate for your help.

Thanks.

 

[goBoating]

If you are using ASP on two pages already, why don't you want to use ASP to do the chores you describe? ASP will do it just fine. I'd go check out the ASP forum.

If you have to do this with CGI, I'd be glad to help you find your way into CGI. (I play with Perl, so all my support would look, smell, and feel like Perl.)

What ever works. 'hope this helps

If you are new to Tek-Tips, please use descriptive titles, check the FAQs, and beware the evil typo.