Zope is agnostic of whatever SQL you enter. In other words, they
compile differently and their errors are completely different.
I suggest you do this:
1. Fake the ZSQL to make sure your DTML is correct by changing the SQL
to something like this:
SELECT 'drug_name_test', 'route_of_admin_test', et
, 2008 1:08 PM
Subject: [Zope] Problem with DTML and JOINS(ZSQL)
Dear all, I am developing a web application for a biological research
institute down here in india. I have some
problem in using JOINS. The below is the queries i used,
SQL query
File name : drug
select drug_name,dtype from
Dear all, I am developing a web application for a biological research
institute down here in india. I have some
problem in using JOINS. The below is the queries i used,
*SQL query
**File name : drug*
select drug_name,dtype from bio_info_schema.drug order by dtype
*File name:drug_gene_details*
No