The SqlParam specifies a request parameter that will be used to obtain a value to insert into an SqlStmt that is sent to a database. A type attribute is used to tell the backend code how to process the value before inserting it into the stmt and how to test it for validity.
@see com.plands.dbutil.DbSyntax.

Here are the accepted attributes: CHAR is for text values, NUMBER is for numeric values, DATE is for dates submitted in the form mm/dd/yr and DIRECT is for values that you want inserted without processing.

Here is an exmple of the format:
<dxp:SqlParam name="first" type="CHAR" require="true"/>
<dxp:SqlParam name="last" type="CHAR" require="true"/>
<dxp:SqlParam name="age" type="NUMBER"/>
<dxp:SqlParam name="born" type="DATE"/>
<dxp:SqlParam name="salary" type="CURRENCY"/>
<dxp:SqlParam name="spam" type="CHAR" default="true"/>

Return to Index

Note: We have tried to test all of the code examples but they may contain errors. Any questions, comments, suggestions, or problems should be sent to info@plands.com.