About string query and parameter

[yael]

Hi,

How can I connect parameter as string sql to the queryString ??

Code:

strSql = " AND tasks.watch_date IS NULL ";

 

Code:

[code] <parameter name="strSql" isForPrompting="true" class="java.lang.String"/> <parameter name="owner_id" isForPrompting="true" class="java.lang.Integer"/> <queryString><![CDATA[sELECT * FROM tasks WHERE owner_id = $P{owner_id} $P{strDateSql}

[lucianc]

Read this.

 

HTH,

Lucian