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