On Mar 2, 2007, at 12:24 PM, Bill Bedford wrote:
>> biz.setWhere("pkid = %s")
>>
>> #User enters '123' as the PK and clicks
>> biz.setParams(self.keyBox.Value)
>> self.requery()
>
> Neat, but how would you construct a where clause using the SQL %
> wildcard? as in
>
> name LIKE % sm%
biz.setWhere("name like %s")
biz.setParams("%sm%")
self.requery()
-- Ed Leafe
-- http://leafe.com
-- http://dabodev.com
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users