Em Andamento

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

Ver mais: vbscript for, str, hp server, creating sql, asp connect sql server, vbscript php, recordset, call function, php connect sql server, function order, php vbscript, par2, queries creation, asp sql injection, function asp, prevent sql injection, php function written, vbscript par2, sql injection asp, call vbscript, array easy php, call php function, variable php sql, set function, asp filtering products

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

ID do Projeto: #3024345

Premiar a:


See private message.

$85 USD em 3 dias
(72 Avaliações)

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


See private message.

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