[Zope-dev] Easy SQL question

[Keith.Larson@Spatial.Com]

Hello ,

I am trying to pull text from a Mysql DB into a page inside zope.

I have the ZMYSQL connection setup and tested .

for example :
select renderText From Phrases where phrase_id = 3 and lang =1

I have also gotten the ZSQL method tested and working

example :
           
 Arguments 
           


phrase_id
renderText

                
       Query    
       template 
                



select renderText from Phrases
<dtml-sqlgroup where>
<dtml-if expr="phrase_id">
<dtml-sqltest name="phrase_id" type="int" >
</dtml-if>
</dtml-sqlgroup>

change and test enter 3 for  phrase id and I get the correct info
SQL used:
select renderText from Phrases
where
phrase_id = 3

Now for the duh section.

All of the above works fine with a submit button and entering info ,

I would like to pull the info into a Zope HTML page.

I believe that this is close

<dtml-call "REQUEST.set('phrase_id', foo)">

           <dtml-in expr="langtest()">
              <dtml-var expr="_['sequence-item'].renderText">
           </dtml-in>

but is foo supposed to be my var of whatever I want passed ?

 how do I pass the variable for phrase ID ( via a variable and changed per
request ) to the language test and display the results so the user never
knows .

I think I am close just missing the obvious I think anyhelp ?