Home >	Contents >	Index >

Template Tags TOC   |    Alpha TOC   |    Tag Family TOC   |    Purpose TOC   |    Annotated TOC   |    Index

ics:sqlexp

Passes a column name and an expression that contains the column name to be used as the left side in the where clause.

Syntax

<ics:sqlexp
      column="column name"
      output="variable name"
      string="string"
      table="table name"
      [type="logical operator"]
      verb="comparison operator"
      [expression="expression"]/>

Parameters

column (required)

Name of the column in the table.

output (required)

Name of the output variable.

string (required)

Value or values to compare against.

table (required)

Name of the table.

type (optional)

Logical operator to use between. Default is and.

verb (required)

Comparison operator.

expression (optional)

Column expression to be used instead of column name.

errno

The possible values of errno include:

Value	Description
-100	Exception error
-103	Invalid table name
-106	Bad parameter value
-406	Bad parameter value
-10004	Missing required attribute

 

Description

This tag was introduced in CS release 5.0. This tag allows building of the components of a SQL where clause without direct knowledge of the data type of a column and the database-specific rules for specifying a literal for that column.

		Home >	Contents >	Index >
	FatWire JSP Tag Reference Copyright 2005 by FatWire Software All rights reserved.