[Zope] Re: Defining a dictionary in ZPT?

2007-11-05 Thread Josef Meile
ok, thanks Duncan lastname goes here Good that you got it working. By the way, why do you need to define "query"? Do you really need a reference to the testquery function? Won't be enough by writing: Or are you using "query" somewhere else? Best regards Josef __

Re: [Zope] Re: Defining a dictionary in ZPT?

2007-11-02 Thread michael . milne
So use DTML? Or NKOTB? :-) On 11/2/07, Stefan H. Holek <[EMAIL PROTECTED]> wrote: > The only point being backed up by this thread, IMO, is that "Thou > shalt not code in TALES." > > Stefan > > > On 2. Nov 2007, at 12:53, michael nt milne wrote: > > > Backs up my point about more > > friendly and u

Re: [Zope] Re: Defining a dictionary in ZPT?

2007-11-02 Thread Stefan H. Holek
The only point being backed up by this thread, IMO, is that "Thou shalt not code in TALES." Stefan On 2. Nov 2007, at 12:53, michael nt milne wrote: Backs up my point about more friendly and usable error messages. -- Anything that, in happening, causes something else to happen, causes som

Re: [Zope] Re: Defining a dictionary in ZPT?

2007-11-02 Thread michael nt milne
ok, thanks Duncan lastname goes here works! I went down a blind alley with calling the database adapter due to confusion over the error message produced. Backs up my point about more friendly and usable error messages. Much appreciated! On 11/2/07, Duncan Booth <[EMAIL PROTECTED]> wrote: >

Re: [Zope] Re: Defining a dictionary in ZPT?

2007-11-02 Thread michael nt milne
So doing some more routing around on the lists I saw this advice > FWIW you > might want to call the query or execute methods directly on the DA > connection object if they are supported. Therefore my db connection object is ado_db_connection. Modifying my code to the below and calling the query

[Zope] Re: Defining a dictionary in ZPT?

2007-11-02 Thread Duncan Booth
"michael nt milne" <[EMAIL PROTECTED]> wrote: > tal:repeat="result python:query(id='IT')"> >First > Name  > > > but get this as a result. Thanks for the reply. > > Module Products.PTProfiler.ProfilerPatch, line 32, in __patched_call__ > Module Products.PageTemplates.ZRPythonExpr, line 47

Re: [Zope] Re: Defining a dictionary in ZPT?

2007-11-02 Thread michael nt milne
ps for completeness here is the testquery ZSQL which works fine when tested in the ZMI and manually inputting the id variable. select * from tblEmployees where department = () order by 'location' I have 'id' in the argument field Thanks On 11/2/07, michael nt milne <[EMAIL PROTECTED]> wrote: >

Re: [Zope] Re: Defining a dictionary in ZPT?

2007-11-02 Thread michael nt milne
Hi Josef firstname goes here gives the same > AttributeError: Results instance has no __call__ method As does First Name As does First Name ! Thanks for your help. Not easy this ZPT!, even when you have read the documentation :-) On 11/2/07, Josef Meile <[EMAIL PROTECTED]> wrote: >

[Zope] Re: Defining a dictionary in ZPT?

2007-11-02 Thread Josef Meile
Hi Michael michael nt milne schrieb: yeah I have modified to this First Name  but get this as a result. Thanks for the reply. Module Products.PTProfiler.ProfilerPatch, line 32, in __patched_call__ Module Products.PageTemplates.ZRPythonExpr, line 47, in __call__ - __traceback_info__: que

Re: [Zope] Re: Defining a dictionary in ZPT?

2007-11-01 Thread michael nt milne
1) don't make spaces around = in HTML attributes: tal:define="query here/testquery" a mistake 2) Why do you use repeat['result'] ? Can you point us to documentation where did you read it ? tal:replace="result/firstname" should work as expected or tal:replace="python:result[ 'firstn

[Zope] Re: Defining a dictionary in ZPT?

2007-11-01 Thread Radim Novotny
michael nt milne napsal(a): yeah I have modified to this First Name  1) don't make spaces around = in HTML attributes: tal:define="query here/testquery" 2) Why do you use repeat['result'] ? Can you point us to documentation where did you read it ? tal:replace="result/first