Mailing List Archive: Zope: DB

Reference DTML-sqlvar in ZPT?

Index | Next | Previous | View Threaded

richard at flaaten

Jul 30, 2007, 9:55 AM

Post #1 of 6 (2119 views)
Permalink

Reference DTML-sqlvar in ZPT?

Dear list,

I have a ZPT that lists results from a Z SQL Method. It has one argument:
"dropdown-department". Everything works fine, except I cannot find a way
to include the passed SQL argument as a string in the ZPT document!

To explain it in another way, a user selects a value from a drop-down
list. This value is passed to a Z SQL Method. My ZPT displays these
results, and I need to include the passed value (DTML-sqlvar) in a heading
in the ZPT.

Any help would be much appreciated.

Richard

_______________________________________________
Zope-DB mailing list
Zope-DB[at]zope.org
http://mail.zope.org/mailman/listinfo/zope-db

charlie at egenix

Jul 30, 2007, 10:00 AM

Post #2 of 6 (2048 views)
Permalink

Re: Reference DTML-sqlvar in ZPT? [In reply to]

Am 30.07.2007, 18:55 Uhr, schrieb Richard Flaaten <richard[at]flaaten.com>:

> Dear list,
> I have a ZPT that lists results from a Z SQL Method. It has one argument:
> "dropdown-department". Everything works fine, except I cannot find a way
> to include the passed SQL argument as a string in the ZPT document!

> To explain it in another way, a user selects a value from a drop-down
> list. This value is passed to a Z SQL Method. My ZPT displays these
> results, and I need to include the passed value (DTML-sqlvar) in a
> heading
> in the ZPT.

Neither explanation is particularly helpful but it sound like you're
trying to do something you shouldn't!

You if you are wishing to call a ZSQL method and pass in a parameter from
your template this is done using a Python expression:

tal:content="python: mySQLMethod(SQLvar=ZPTvar)"...

You can pass variables into a PageTemplate using the options dictionary.

You might want to look at my presentation (with sample code) which touches
on Zope and RDBMS.

http://www.egenix.com/library/presentations/EuroPython2007-Zope-and-RDBMS/

Charlie

--
Charlie Clark
eGenix.com

Professional Python Services directly from the Source
>>> Python/Zope Consulting and Support ... http://www.egenix.com/
>>> mxODBC.Zope.Database.Adapter ... http://zope.egenix.com/
>>> mxODBC, mxDateTime, mxTextTools ... http://python.egenix.com/
________________________________________________________________________

:::: Try mxODBC.Zope.DA for Windows,Linux,Solaris,MacOSX for free ! ::::

eGenix.com Software, Skills and Services GmbH Pastor-Loeh-Str.48
D-40764 Langenfeld, Germany. CEO Dipl.-Math. Marc-Andre Lemburg
Registered at Amtsgericht Duesseldorf: HRB 46611
_______________________________________________
Zope-DB mailing list
Zope-DB[at]zope.org
http://mail.zope.org/mailman/listinfo/zope-db

richard at flaaten

Jul 30, 2007, 10:20 AM

Post #3 of 6 (2049 views)
Permalink

Re: Reference DTML-sqlvar in ZPT? [In reply to]

<quote who="Charlie Clark">
> Am 30.07.2007, 18:55 Uhr, schrieb Richard Flaaten <richard[at]flaaten.com>:
>
>> Dear list,
>> I have a ZPT that lists results from a Z SQL Method. It has one
>> argument:
>> "dropdown-department". Everything works fine, except I cannot find a way
>> to include the passed SQL argument as a string in the ZPT document!
>
>> To explain it in another way, a user selects a value from a drop-down
>> list. This value is passed to a Z SQL Method. My ZPT displays these
>> results, and I need to include the passed value (DTML-sqlvar) in a
>> heading
>> in the ZPT.
>
> Neither explanation is particularly helpful but it sound like you're
> trying to do something you shouldn't!
>
> You if you are wishing to call a ZSQL method and pass in a parameter from
> your template this is done using a Python expression:
>
> tal:content="python: mySQLMethod(SQLvar=ZPTvar)"...
>
> You can pass variables into a PageTemplate using the options dictionary.
>
> You might want to look at my presentation (with sample code) which touches
> on Zope and RDBMS.
>
> http://www.egenix.com/library/presentations/EuroPython2007-Zope-and-RDBMS/
>
> Charlie
>
> --
> Charlie Clark
> eGenix.com

Dear Charlie,

Thanks for your input.

All I want to do is use the dtml-sqlvar argument as a string in my ZPT. My
ZPT is simply a report containing the results of the SQL query; I need to
use the argument as a title for the page. I am not passing any arguments
in the ZPT.

Richard

Richard Flaaten
[richard[at]flaaten.com, mobil 905 87 330]

_______________________________________________
Zope-DB mailing list
Zope-DB[at]zope.org
http://mail.zope.org/mailman/listinfo/zope-db

charlie at egenix

Jul 30, 2007, 10:24 AM

Post #4 of 6 (2054 views)
Permalink

Re: Reference DTML-sqlvar in ZPT? [In reply to]

Am 30.07.2007, 19:18 Uhr, schrieb Richard Flaaten <richard[at]flaaten.com>:

Richard,

although this is actually a ZPT issue and nothing specific to do with
RDBMS.

> All I want to do is use the dtml-sqlvar argument as a string in my ZPT.
^^^^^^^^^^^^^^^^^^^^

> My ZPT is simply a report containing the results of the SQL query; I
> need to
> use the argument as a title for the page. I am not passing any arguments
^^^^^^^^^^^^^^^^^^^^^
> in the ZPT.

Your explanation is self-contradictory: you seem to want to use an
argument within ZPT without passing it or defining it? Please provide a
code snippet.

Charlie
--
Charlie Clark
eGenix.com

Professional Python Services directly from the Source
>>> Python/Zope Consulting and Support ... http://www.egenix.com/
>>> mxODBC.Zope.Database.Adapter ... http://zope.egenix.com/
>>> mxODBC, mxDateTime, mxTextTools ... http://python.egenix.com/
________________________________________________________________________

:::: Try mxODBC.Zope.DA for Windows,Linux,Solaris,MacOSX for free ! ::::

eGenix.com Software, Skills and Services GmbH Pastor-Loeh-Str.48
D-40764 Langenfeld, Germany. CEO Dipl.-Math. Marc-Andre Lemburg
Registered at Amtsgericht Duesseldorf: HRB 46611
_______________________________________________
Zope-DB mailing list
Zope-DB[at]zope.org
http://mail.zope.org/mailman/listinfo/zope-db

richard at flaaten

Jul 30, 2007, 10:31 AM

Post #5 of 6 (2062 views)
Permalink

Re: Reference DTML-sqlvar in ZPT? [In reply to]

I guess my questions are confusing since I am new to Zope. The dtml-sqlvar
is already defined; the results from the Z SQL Method are already
presented; I just want to "remind" the user of what they passed to the Z
SQL Method.

In other words, I only want to print what they selected from a drop-down
list and passed to the Z SQL Method. I just want to print an already
defined variable. The problem is: how to print a dtml-sqlvar in ZPT? I
tried

<p tal:replace="dtml-sqlvar/dropdown-selection">dropdown-selection goes
here</p>

Which did not work.

Richard

<quote who="Charlie Clark">
> Am 30.07.2007, 19:18 Uhr, schrieb Richard Flaaten <richard[at]flaaten.com>:
>
> Richard,
>
> although this is actually a ZPT issue and nothing specific to do with
> RDBMS.
>
>> All I want to do is use the dtml-sqlvar argument as a string in my ZPT.
> ^^^^^^^^^^^^^^^^^^^^
>
>> My ZPT is simply a report containing the results of the SQL query; I
>> need to
>> use the argument as a title for the page. I am not passing any arguments
> ^^^^^^^^^^^^^^^^^^^^^
>> in the ZPT.
>
> Your explanation is self-contradictory: you seem to want to use an
> argument within ZPT without passing it or defining it? Please provide a
> code snippet.
>
> Charlie
> --
> Charlie Clark
> eGenix.com
>
> Professional Python Services directly from the Source
>>>> Python/Zope Consulting and Support ... http://www.egenix.com/
>>>> mxODBC.Zope.Database.Adapter ... http://zope.egenix.com/
>>>> mxODBC, mxDateTime, mxTextTools ... http://python.egenix.com/
> ________________________________________________________________________
>
> :::: Try mxODBC.Zope.DA for Windows,Linux,Solaris,MacOSX for free ! ::::
>
> eGenix.com Software, Skills and Services GmbH Pastor-Loeh-Str.48
> D-40764 Langenfeld, Germany. CEO Dipl.-Math. Marc-Andre Lemburg
> Registered at Amtsgericht Duesseldorf: HRB 46611
>

_______________________________________________
Zope-DB mailing list
Zope-DB[at]zope.org
http://mail.zope.org/mailman/listinfo/zope-db

maciej.wisniowski at coig

Jul 30, 2007, 12:35 PM

Post #6 of 6 (2061 views)
Permalink

Re: Reference DTML-sqlvar in ZPT? [In reply to]

> I guess my questions are confusing since I am new to Zope. The dtml-sqlvar
> is already defined; the results from the Z SQL Method are already
> presented; I just want to "remind" the user of what they passed to the Z
> SQL Method.
You can't get sql query parameters from it's results. It's like calling
a function. You pass some parameters to it and get results...

> In other words, I only want to print what they selected from a drop-down
> list and passed to the Z SQL Method. I just want to print an already
> defined variable. The problem is: how to print a dtml-sqlvar in ZPT? I
> tried
I think you're looking at this from the wrong side ;)

When you submit a form that contains your <select> list, then you have
chosen option at REQUEST object. You may get this with:
context.REQUEST.get('name-of-your-parameter')
and pass it into PageTemplate with results.

For example (may be buggy):

Your form with selection list (PageTemplate):
<form action="results.html">
<select name="my_item">
<option value="1">blablabal1</option>
<option value="2">blablabal2</option>
</select>
</form>

results.html (ScriptPython):
my_item = context.REQUEST.get('my_item')
results = context.mySQL(my_item=my_item)
return context.resultPageTemplate(my_item=my_item, results=results)

resultPageTemplate (PageTemplate):
<div tal:define="myitem python: options.get('my_item', 0);
results python: options.get('results', 0)">
You've chosen: <span tal:replace="my_item"></span>

<div tal:repeat="item results" tal:content="item/name"></div>
</div>

--
Maciej Wisniowski
_______________________________________________
Zope-DB mailing list
Zope-DB[at]zope.org
http://mail.zope.org/mailman/listinfo/zope-db

Index | Next | Previous | View Threaded

Interested in having your list archived? Contact lists@gossamer-threads.com