[Kexi] Kexi python Scripting

[Rüdiger Härtel]

Am Sonntag 09 März 2008 05:32:12 schrieben Sie:
> On Sunday 09 March 2008, Sebastian Sauer wrote:
> > Hi Rüdiger :)
> >
> > Rüdiger Härtel wrote:
> > > Here is the kexi project.
> > >
> > > Am Freitag 07 März 2008 14:03:45 schrieben Sie:
> > >> Rüdiger Härtel said the following, On 2008-03-07 13:52:
> > >> > I want to write a script to query some data from my db.
> > >> >
> > >> > the following works:
> > >> >
> > >> > cursor = connection.executeQueryString("SELECT * from emp where
> > >> > country = 'Germany'")
> > >> > ...
> > >> >
> > >> > but this does not work
> > >> >
> > >> > country = self.countries.get()
> > >> > sqlStmt = "SELECT * from emp where country = %s" % country
> > >> > cursor = connection.executeQueryString(sqlStmt)
> >
> > probably the country variable does contain the wrong value. Following
> > works fine with your testdb;
> >
> > import kexiapp
> > keximainwindow = kexiapp.get("KexiAppMainWindow")
> > connection = keximainwindow.getConnection()
> > country="Germany"
> > sqlStmt = 'SELECT * from tabelle1 WHERE country = \'%s\';' % country
> > cursor = connection.executeQueryString(sqlStmt)
> > if not cursor:
> > 	raise "No cursor"
> > while not cursor.eof():
> > 	for i in range( cursor.fieldCount() ):
> > 		print "%s %s" % (str(i), cursor.value(i))
> > 	cursor.moveNext()
>
> ah, problem found...
>
> replace
> country = self.countryList.get()
> with
> country = str(self.countryList.get())
> to turn that explicit into a local aware string.

Hello Sebastian,

thank you for this hint. 

Rüdiger