Re: [Zope] Problem with DTML and JOINS(ZSQL)

2008-04-15 Thread Peter Bengtsson
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

Re: [Zope] Problem with DTML and JOINS(ZSQL)

2008-04-15 Thread Jaroslav Lukesh
, 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

[Zope] Problem with DTML and JOINS(ZSQL)

2008-04-15 Thread member madhangc
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