Re: Executing queries with parameters
"Klaus Schneider-Grosch (gmx.de)" <[email protected]> Tue, 13 Jan 2009 20:56:50 +0100
| Newsgroups | gmane.comp.db.rekall.general |
|---|---|
| Message-ID | <[email protected]> |
Am Montag, 12. Januar 2009 17:30:19 schrieb Andree Clausing: > Shure, execute query's from Python works as expected, there is a howto in > the > Rekall manual. > > You can build your own query as string and execute it. > > Andree > > > Am 12.01.2009, 16:36 Uhr, schrieb Klaus Schneider-Grosch (gmx.de) > > <[email protected]>: > > Hello, > > > > is it possible to execute a query with parameters from a python script, > > and if > > yes, how to do it? > > > > Alternatively, is it possible to roll my own query in the way that is > > described in the rekall manual for forms ("Roll Your Own Form") with > > xml-Code? > > > > Thank a lot, > > Klaus > > _______________________________________________ > > Rekall mailing list > > [email protected] > > http://www.mailman.a-i-s.co.uk/cgi-bin/mailman/listinfo/rekall > > _______________________________________________ > Rekall mailing list > [email protected] > http://www.mailman.a-i-s.co.uk/cgi-bin/mailman/listinfo/rekall This is the code: def eventFunc (button) : button.getBlock().getForm().openQuery('SummeKunde', { 'RechnungErfolgteZahllungAm' : '2008%' }) The query 'SummeKunde' delivers every year, but I want to get only the results of the year 2008. So I add the parameters of fieldname and the WHERE clause '2008%' What am I doing wrong? Thank you, Klaus