johnf wrote:
> I have a small table that contains the counties of California and Nevada.
>
> The data will be used in a dropdown list. I intend to use the "State"
> dropdown to trigger the setting of the where clause of the dropdown for the
> counties.
>
> My question what are your thoughts on the best way to filter the cursor based
> on the selected state.
>
> I see two ways. One using the dataset - something like
> datasetCursor.execute ("select * from dataset where state = '%s'" %
> (self.statecontID.Value))
>
> Or I could set the where clause.
> self.BizObj.setWhereClause("state = '%s'" %(self.statecontID.Value))
>
> Your recommendations would be very helpful.
If your result set isn't too big (< 1 second fetch time) i would prefer
to use a whereclause and refetch the records.
BTW better use the dbapi parameter substitution:
self.BizObj.setWhereClause("state = ?")
self.BizObj.setParams(self, (self.statecontID.Value,))
Uwe
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users
Searchable Archives: http://leafe.com/archives/search/dabo-users
This message: http://leafe.com/archives/byMID/[email protected]
