inserting data into sql table using asp/vbscript

[webber123456]

 
Response.Redirect("mast.asp")
Conn.close

you should close the connections before redirecting...

[lucky20]

@ webber ..yes you are right..

I am copying my code and pasting here.. It was my mistake..

corrected code:

Conn.close
Response.Redirect("Mast.asp")

[verschha]

Although I adviced you to use ASP.NET, which you obviously can't use, I also gave you a link how to use parameterized queries in classic asp. That's good coding practice. So I'm willing to help you also. you just don't see it....

[awasson]

I appreciate glib suggestions about how technology B is better than technology A about as much as the next guy but to be fair verschha did make a relevant point about how you can improve the safety of an ASP script by passing SQL variables as parameters.

Once you've got creating and destroying your connection and record set objects down pat and you're SQL statement are squeaky clean, you'll want to look into making things as secure as possible. This link is good. You'll probably find others by searching "vbscript sql parameter" or something similar. It's good to know about even if you don't use it.

Good luck!