SP wrapper generator

[Jenda]

Sorry if this looks like a SPAM ...

If you need to call stored procedures from your ASP pages you may either do it "directly" via ADO (create ADODB.Command, fill in parameters, execute or open recordset ...) which is kind of messy
or hide this stuff into a COM object and use something like

db.FetchSomething( param1, param2, Rst)




If you do the later you will notice that you are writing almost the same code over and over. Which is tedious, takes time and is prone to errors.

So why not to generate the code? Then if you change a stored procedure you only have to change the ASPs (if anything). The COM wrapper is just regenerated. And since it's possible to get data directly from Session and you may pass some data behind the scenes you might not need to change anything.

You may find such a code generator at http://jenda.krynicky.cz/#SP_COM_Generator

It's free, all I want is to get some comments on it. What
improvements would be handy, what options to use when opening recordsets, whether to implement something differently ...

Thanks ,Jenda