[Zope] SQL Queries

Giampiero Raffaini giampiero@btinternet.com
Sun, 16 Jan 2000 15:48:10 GMT


16/01/2000 15:45:12
thanks again.
in CF i used to be able to link each title to a dynamically generated page using the ID, like this:
a href="newpage.cfm?#ID#
so that each title would go to its specific page thanks to the ID.
How do you do this in Zope?
Cheers

Original message from: schenck@ultra.posc.org
>Giampiero,
>
>You can easily do that.  Take a look at this code.  It is a DTML Method, tableCount_html 
>which displays a page that allows a user to select a table name from a select list in a form.  
>The options are retrieved from a data base before the page is displayed:
>
><dtml-var standard_html_header>
><form action="tableInstances" method="get">
><h2 align="center"><dtml-var document_title></h2>
><hr>
><p><font size="+1">Enter query parameters:</font></p>
><table>
><tr><th>Entity name</th>
>    <td><SELECT NAME="entity_name" SIZE=1>
><dtml-in getTableNames>
>  <OPTION><dtml-var table_def_nm null=""></OPTION>
></dtml-in>
></SELECT>
>    </td></tr>
><tr><td colspan=2 align=center>
><input type="SUBMIT" name="SUBMIT" value="Submit Query">
></td></tr>
></table>
></form>
><p>&nbsp;</p>
><dtml-var standard_html_footer>
>
>Here is the code for getTableNames, a Z SQL Method that uses the ODBC interface to 
>query an Oracle database for the possible list of tables to select from:
>
>select table_def_nm from table_def
>order by 1
>
>As you can see, when someone references tableCount_html the getTableNames method is 
>called without the user pressing any buttons.
>
>Dan Schenck
>POSC
>Houston, TX
>
>> ** Original Subject: [Zope] SQL Queries
>> ** Original Sender: Giampiero Raffaini <giampiero@btinternet.com>
>> ** Original Date: Sun, 16 Jan 2000 14:04:53 GMT
>
>> ** Original Message follows... 
>
>>
>> 16/01/2000 13:59:55
>> Hello there,
>> I am new to zope and i find it great. I am still learning it and I have a few questions, but one 
>in particular;
>> I used Coldfusion before and I was able to do this:
>> I had a db with movies, with Title,director,year and so on. I could run a query looking for 
>Tilte and ID and then 
>> output the result on a line and make each of the Titles a dynamically generated link 
>(something like 
>> <a href="newpage.cfm?#ID#>#Title#</a> if you know what I mean).
>> Now my question is:
>> is it possible in Zope to run SQL queries without the need to actually click on a Submit 
>button?
>> Cheers
>> 
>> 
>> _______________________________________________
>> Zope maillist  -  Zope@zope.org
>> http://lists.zope.org/mailman/listinfo/zope
>> **   No cross posts or HTML encoding!  **
>> (Related lists - 
>>  http://lists.zope.org/mailman/listinfo/zope-announce
>>  http://lists.zope.org/mailman/listinfo/zope-dev )
>> 
>
>
>>** --------- End Original Message ----------- **
>
>> 
>
>
>Dan R. Schenck mailto:schenck@posc.org
>POSC                  http://www.posc.org
>Suite 275
>10777 Westheimer 
>Houston, TX 77042
>
>
>
>_______________________________________________
>Zope maillist  -  Zope@zope.org
>http://lists.zope.org/mailman/listinfo/zope
>**   No cross posts or HTML encoding!  **
>(Related lists - 
> http://lists.zope.org/mailman/listinfo/zope-announce
> http://lists.zope.org/mailman/listinfo/zope-dev )
>
>