[prev in list] [next in list] [prev in thread] [next in thread] 

List:       zope
Subject:    RE: Re: [Zope] dynamically generating sql queries?
From:       "siva k" <mannis2000 () hotmail ! com>
Date:       2007-03-29 10:59:15
Message-ID: BAY115-F24E7EB1F9B9E34DBAB7281DB6C0 () phx ! gbl
[Download RAW message or body]


Hi,

Thank you very much for your answer.
As you suggested, i concatenate the string with an integer to create a 
fieldname and then
pass it to zsql object along with language argument. I do everything inside 
a  Script (Python)
object that accepts 3 arguments (field,index,language)now.
-
result=field+str(index)
res=context.select_sql(field=result, language=language)
print res[0].result
return printed
-
I test this python script inside ZMI and run into problems.
It works only if I explicitly specify the columname like "print 
res[0].author_1".
another question- how can one specify row index here?(res[row index]). Each 
language has one row.

thanks

_________________________________________________________________
Express yourself instantly with MSN Messenger! Download today it's FREE! 
http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/

_______________________________________________
Zope maillist  -  Zope@zope.org
http://mail.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
 http://mail.zope.org/mailman/listinfo/zope-announce
 http://mail.zope.org/mailman/listinfo/zope-dev )
[prev in list] [next in list] [prev in thread] [next in thread]