[Zope] Z SQL Methods

[Rob Page]

> Search table foo for matches with a "like" select, user 
> clicks on an item
> and a new query is run using params from the clicked link. 
> The next page
> would be the result of the multitable query.
> 
> I've not a clue how I should format the sytax for first 
> result returned
> using DTML. Before I start into it has anyone else done this yet?

If I understand you correctly, you might try something like:

<UNTESTED THOUGHT>

Step1QueryForm
--------------
<FORM ACTION="Step2QueryForm">
<INPUT NAME= "keywords_from_web_form " TYPE="TEXT" VALUE="">
</FORM>

sqlFoo
--------
SELECT record_id, first_name, last_name, fav_color_code, postal_code 
FROM 
foo 
WHERE memo_field LIKE <!--#sqlvar keywords_from_web_form-->

Step2QueryForm
-----------------

<P>Click on one of the results:</P>
<UL>

  <!--#in sqlFoo-->

    <LI>
      <A
HREF="http://server.com/my_app/doc_that_displays_multitable_results?reco
rd_id=<!--#var record_id-->&fav_color_code=<!--#var
fav_color_code-->"><!--#var last_name-->, <!--#first_name--></A>
    </LI>

  <!--#/in-->

</UL>

</UNTESTED THOUGHT>

--Rob Page


--
Rob Page            Phone: +1 540 371 6909
Digital Creations   Fax:   +1 540 371 1201