ADO ObjectsLesson 74Free preview

ADO Parameter

This lesson is part of ASP · All levels

Summary

The object parameter is used to send values from scripts into queries securely without combining SQL strings. The parameter has the name, data type, direction (input/output), length, and initial value created through the CreateParameter. With parameters, user value is treated as data so that injection is avoided.

Key points

Parameters are made with CreateParameter(nama, tipe, arah, panjang, value).
Direction determines whether the input, output, or both parameters.
The type uses ADO constants like adVarChar and adInteger.
Length is filled for text type so the data is not cut.

Full lesson

Code examples and quizzes

Full lessons, code examples, and quizzes are available to subscribers. 5 questions.