[Zope-DB] Giving the user the option to view certain fields in a query

[Laura McCord]

Yeah, I think you are right. I think what I am going to do is make the
Title of one of my fields such as 'UserName' in the results page
clickable. When the user clicks it, it will pass values into a query
that will spit out the results of only the username.

Thanks for your response.

-Laura

-----Original Message-----
From: Philip Kilner [mailto:phil at xfr.co.uk] 
Sent: Thursday, May 06, 2004 10:05 AM
To: Laura McCord
Cc: zope-db at zope.org
Subject: Re: [Zope-DB] Giving the user the option to view certain fields
in a query


Hi Laura,

Laura McCord wrote:
> Is it at all possible to add checkboxes for each field of the select 
> statement in a form? I want to allow my user to view the query anyway 
> they want. So if the user only wants to see the username of the 
> resulting query instead of all of the fields in the table they would 
> check the username box. Is this possible?
> 

I'd be inclined to treat this as a formatting issue in your ZPT (Make 
certain columns display conditionally upon a form value?) - doing this 
in the SQL is messy!

However, it does sound as though you're looking for something closer to 
a general purpose report generator...a lot of work to write!

-- 

Regards,

PhilK

Email: phil at xfr.co.uk / Voicemail & Facsimile: 07092 070518

"The lyf so short, the craft so long to learne" - Chaucer