Re: Executing queries with parameters
"Klaus Schneider-Grosch (gmx.de)" <[email protected]> Tue, 13 Jan 2009 21:24:27 +0100
| Newsgroups | gmane.comp.db.rekall.general |
|---|---|
| Message-ID | <[email protected]> |
Hello Andree, RechnungErfolgteZahllungAm is a date Gru=DF aus Heidelberg Klaus Am Dienstag, 13. Januar 2009 21:03:21 schrieb Andree Clausing: > Hello Klaus.. > > is RechnungErfolgteZahllungAm a string or a timetamp? > > Gru=DF aus Halle / Westf. > > Andree > > Am 13.01.2009, 20:56 Uhr, schrieb Klaus Schneider-Grosch (gmx.de) > > <[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 > > _______________________________________________ > > 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