Did you try the Test tab at ZSQL method management page? If it does not
work, you will get error from SQL server. If it works and you does not get
any data, then your query is not fit to any data.
----- Original Message -----
From: member madhangc
To: zope@zope.org
Sent: Tuesday, April 15, 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 bio_info_schema.drug order by dtype
File name:drug_gene_details
Note : i used both the sql queries seperately, but neither one worked.
SELECT
drug.drug_name,drug.route_of_admin,drug.dose_adult,drug.dose_child,drug.adverse_effects,drug_gene.gene_name
FROM drug,drug_gene
WHERE drug.drug_name = drug_gene.drug_name and drug.drug_name=<dtml-sqlvar
drug_name type=string>
SELECT
drug.drug_name,drug.route_of_admin,drug.dose_adult,drug.dose_child,drug.adverse_effects,drug.dtype,drug_gene.gene_name
FROM drug INNER JOIN drug_gene
ON drug.drug_name = drug_gene.drug_name AND drug.drug_name=<dtml-sqlvar
drug_name type=string>
_______________________________________________
Zope maillist - Zope@zope.org
http://mail.zope.org/mailman/listinfo/zope
** No cross posts or HTML encoding! **
(Related lists -
http://mail.zope.org/mailman/listinfo/zope-announce
http://mail.zope.org/mailman/listinfo/zope-dev )
