On Fri, 2 Mar 2007 12:38:40 -0500, Ed Leafe wrote:
> 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()
Duh.
Thanks Ed -- somehow I was expecting a collision with the formatString
'%', but that's Dabo for you -- think too hard and you'll get it
wrong:-)
--
Bill Bedford
"Nothing is as important as model railways and even that isn't very
important"
-some wiseguy somewhere
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users
