[Zope] returning queries

Colyn Brown colyn.brown@newtimes.com
Wed, 20 Nov 2002 19:20:01 -0700


Nevermind, I figured it out. I was using <dtml-var sequence-item> to get the
table name. I tried using <dtml-var sequence-key> just to see what would
happen and it worked. I have no idea why, but it does.

--colyn

> From: Colyn Brown <colyn.brown@newtimes.com>
> Date: Wed, 20 Nov 2002 19:11:16 -0700
> To: <zope@zope.org>
> Subject: [Zope] returning queries
> 
> I'm not sure if this is a Zope specific question or a mySQL question, but
> I'm asking here anyway.
> 
> I created SQL Method that returns a list of tables from a db (SHOW tables,
> called sql_show_tables). Then I proceeded to create the usual <dtml-in>
> statement to spit the results out on a page. It didn't work. Well, it did
> it's job, but it didn't return table names, it returned something like this:
> '<r instance at 8de19e0>' for a table name. I've tried REQUEST.set'ing the
> query to an array and that didn't work either. Everything I've tried just
> gives me that string. What bugs me is that manage_test does the job fine in
> reporting the results, and I can't (and I don't have access to those files).
> Anyone have any ideas?
> 
> ---colyn brown
> 
> 
>> From: "Andy McKay" <andy@agmweb.ca>
>> Date: Wed, 20 Nov 2002 17:48:16 -0800
>> To: <r.ineichen@projekt01.ch>, <zope@zope.org>
>> Subject: Re: [Zope] Bug in FileDirectoryView with INSTANCE_HOME on win?
>> 
>> File directory views work fine with instance home and fine on windows. I
>> have about 10 sandboxes and CMF sites. What is the exact problem? Are you
>> sure you Zope has an INSTANCE_HOME? Go to the Control Panel and if you have
>> INSTANCE_HOME registered it will show up there.
>> --
>> Andy McKay
>> www.agmweb.ca
>> 
>> 
>> 
>> _______________________________________________
>> 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 )
> 
> 
> _______________________________________________
> 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 )