Re: Executing queries with parameters

Sorry , false answer..

WHERE RechnungErfolgteZahllungAm > 2007 AND RechnungErfolgteZahllungAm <  
2009

Please take a look at the Database manual, perhabs the mysql manual.

Andree



Am 13.01.2009, 21:24 Uhr, schrieb Klaus Schneider-Grosch (gmx.de)  
<[email protected]>:

> Hello Andree,
>
> RechnungErfolgteZahllungAm is a date
>
> Gruß aus Heidelberg
> Klaus
>
> Am Dienstag, 13. Januar 2009 21:03:21 schrieb Andree Clausing:
>> 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
>>
>> _______________________________________________
>> 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