Function for creating a recordset with para

I need a function for VBscript / classic ASP that returns a recordset based parametrisized sql for SQL Server 2000.

The goal is to use this function to simplify the creation of parametrisized queries for SQL Server 2000 in order to prevent SQL-injection.

The function input should look something like this:

function getRsPar(strSql,arrSqlArg,arrSqlArgTypes,cursorType,lockType)

An example of the call:

set rs = getRsPar("SELECT id FROM products WHERE prodname=@par1 AND prodbrand=@par2",array("Laptop","HP"),array("str","str"),adOpenForwardOnly ,adLockReadOnly)

I dont know if the above is correct but it illustrates the idea. If you have a better idea then you are welcome to present it.

The connect variable is simply named "connect"

The import thing is that this is not "solved" by filtering.

## Deliverables

The function must be well written and easy to follow because it will be used with other functions. All internal variables must be declared etc.

Habilidades: ASP, PHP

Veja mais: php function for, vbscript for, classic asp array, str, hp server, creating sql, asp connect sql server, asp classic connect, connect sql server asp classic, vbscript php, classic asp connect sql, recordset, call function, asp classic recordset, php connect sql server, function order, classic asp import sql, php vbscript, classic asp connect sql server, par2, queries creation, classic asp function, sql asp classic, need vbscript classic asp, asp classic vbscript connect sql

Acerca do Empregador:
( 16 comentários ) Lulea, Thailand

ID do Projeto: #3024345

Concedido a:


See private message.

$85 USD em 3 dias
(72 Comentários)

2 freelancers estão ofertando em média $106 para esse trabalho


See private message.

$127.5 USD in 3 dias
(0 Comentários)