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