On Monday 09 March 2009 03:55:48 pm Ricardo Aráoz wrote:
> johnf wrote:
> > On Monday 09 March 2009 02:33:03 pm Uwe Grauer wrote:
> >> 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
> >
> > The current dataset is very small < 100. But I guess if you had all 50
> > states it might be something to be concerned about.
>
> LOL.
> OTOH if you could tell me how many provinces does Germany, or Argentina
> have (no googling).......
LOL I have no idea. I'm like every other US citizen. I have no idea about
the rest of the world.
--
John Fabiani
_______________________________________________
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]
