----- Original Message -----
Sent: Tuesday, December 14, 2004 3:52
PM
Subject: [plum] cf_DisplayFilteredSelect
& Where clause
* This tag call:
<cf_DisplayFilteredSelect
parentTable="tblFunnelCategoryLU"
primaryKey="n_funnelCategoryID"
primaryKeyType="integer"
foreignKey="n_funnelCategoryID"
displayColumn="c_funnelCategory"
displaycolumntype="varchar(50)"
required="No"
label="Diet Choice ID"
whereClauseExtension="n_programTypeID = 1 and b_activeChoice =
1">
* works fine for me and generates the following
SQL:
SELECT tblFunnelCategoryLU.n_funnelCategoryID,
tblFunnelCategoryLU.c_funnelCategory
FROM tblFunnelCategoryLU
WHERE
c_funnelCategory LIKE 'b%' AND
n_programTypeID = 1 and
b_activeChoice = 1
ORDER BY tblFunnelCategoryLU.c_funnelCategory
* HOWEVER:when I add the maximumnumberofoptions attribute to the call, the "c_funnelCategory LIKE 'b%'" criteria is no
longer used,
but the tage still prepends an AND to the synatax and generates a syntax
error:
<cf_DisplayFilteredSelect
parentTable="tblFunnelCategoryLU"
primaryKey="n_funnelCategoryID"
primaryKeyType="integer"
foreignKey="n_funnelCategoryID"
displayColumn="c_funnelCategory"
displaycolumntype="varchar(50)"
required="No"
label="Diet Choice ID"
whereClauseExtension="n_programTypeID = 1 and b_activeChoice =
1"
maximumnumberofoptions="50">
* generates the following
syntax:
SELECT tblFunnelCategoryLU.n_funnelCategoryID,
tblFunnelCategoryLU.c_funnelCategory
FROM tblFunnelCategoryLU
WHERE AND
n_programTypeID = 1 and
b_activeChoice = 1
ORDER BY tblFunnelCategoryLU.c_funnelCategory
Dan
