Announcement

Collapse
No announcement yet.
X
  • Filter
  • Time
Clear All
new posts

    WhereClause

    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:
    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>
    Can you tell what I am missing/doing wrong?

    Thanks!

    #2
    Missing <operationBindings> outer element.

    Comment

    Working...
    X