Re: Executing queries with parameters

"Andree Clausing" <[email protected]> Tue, 13 Jan 2009 21:03:21 +0100
Newsgroups gmane.comp.db.rekall.general
Message-ID <[email protected]>
Hello Klaus..

is RechnungErfolgteZahllungAm a string or a timetamp?

Gruß 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