Hi. I am trying to use a custom WHERE clause in an OperationBinding. I must be doing something wrong, because the query is still using "where '1'='1'". To simplify the issue, I tried with a small test case, and the problem still exists. Here is my ds.xml:
Can you tell what I am missing/doing wrong?
Thanks!
Code:
<DataSource dbName="mydb" tableName="mytable" ID="myds" dataSourceVersion="1" generatedBy="SC_SNAPSHOT-2009-12-17/EVAL Deployment 2009-12-17" serverType="sql" > <fields> <field name="approved" type="integer"></field> </fields> <operationBinding operationType="fetch"> <whereClause> approved=1 </whereClause> </operationBinding> </DataSource>
Thanks!
Comment