Error, exceptions.KeyError: (anything)
Hi there: I just don't know what's wrong, I've installed ZodbcDA and connects fine to M$Access databases. I can create SQL methods like: "select * from (database)" and it shows the whole thing without problems. I tried something like the examples on the Z SQL guide trying to make it give me the phone: ======================= select * from phonelist where <!--#sqltest phone column=name type=string--> ====================== and all what I get is the following error message: ====================== Error, exceptions.KeyError: phone SQL used: Could not render the query template! ====================== No matter what I put on the 'name' field of sqltest I get this error... Any ideas? - Atentamente, Victor Perez Muena Automation Support - Port Area (Los Vilos) Los Pelambres Project - Bechtel Chile Ltda. Ext. 8033, Phone: (2) 361-8033 - Fax: (2) 361-8025
"Perez, Victor" wrote:
I tried something like the examples on the Z SQL guide trying to make it give me the phone: ======================= select * from phonelist where <!--#sqltest phone column=name type=string--> ====================== Try: select * from phonelist where name = '<!--#var name-->' If that doesn't work try listing the columns you want returned, e.g. select name, number, city from phonelist where name = '<!--#var name-->'
- Craig -- Craig Allen - Managing Partner - Mutual Alchemy Web Architecture - http://alchemy.nu
On Tue, Jul 06, 1999 at 02:06:56PM -0700, Perez, Victor wrote:
Hi there:
I just don't know what's wrong, I've installed ZodbcDA and connects fine to M$Access databases. I can create SQL methods like: "select * from (database)" and it shows the whole thing without problems.
I tried something like the examples on the Z SQL guide trying to make it give me the phone:
======================= select * from phonelist where <!--#sqltest phone column=name type=string--> ======================
and all what I get is the following error message:
====================== Error, exceptions.KeyError: phone
Simple question: you are putting 'phone' in the Arguments attribute of the Z SQL Method, right? Ross -- Ross J. Reedstrom, Ph.D., <reedstrm@rice.edu> NSBRI Research Scientist/Programmer Computer and Information Technology Institute Rice University, 6100 S. Main St., Houston, TX 77005
participants (3)
-
Craig Allen -
Perez, Victor -
Ross J. Reedstrom