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).......
--- StripMime Report -- processed MIME parts ---
multipart/alternative
text/plain (text body -- kept)
text/html
---
_______________________________________________
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]
