[Zope] Newbie Question

[zope@virtosi.com]

On Fri, 2 Nov 2001, Lynn Mayes wrote:

> Hi there,
> 
> Looked through many archived mailing lists, and I don't see specifally what
> I want - or I didn't look in the right place.  In any case, if this is an
> old question, please forgive me.
> 
> Couple of things:
> 1) Working with SQL tables through Zope - Have created queries, and they
> work fine.  However, I would like to create one area (DTML method), where I
> can have 3 different submit buttons, querying 3 different queries - I am
> sure this is possible, I just am not too sure how, as this is still new to
> me.  Want to have the user be able to pick what ever he/she wants to query
> from one location.  

three buttons from one set of <FORM> tags??? (three forms would seem 
easy..)

> 
> 2) If I run query A, I get results, but when I try to edit the results page,
> I can't.  I need to edit the query results page, how do I do this?
> 

so you get the data back from the query as such:
	<dtml-in SOME-SQL>
		<dtml-var QUERY-FIELD1> ... <dtml-var QUERY-FIELD2>
	</dtml-in>
	
	and what do you want to do? to mess with the data returned you 
	use the <dtml-call> tag i believe, or pass it to a Python script 
	external method...  


> 3) In the SQL table, I have values 1-4 from a option box in an Access from.
> I want to substitue the 1 for the word use in the query results - how do I
> do this?

you want to do a substitue-relpace like 
"sub XXX for ZZZ in the string  XXXYYYZZZAAA " ??

again, i think you are going to have to use the dtml-call tag (which 
executes python inbetween the quotes)

hope that helps...

> 
> Thanx so much for your time.
> 
> Sincerely,
> Lynn Mayes 
> 
> _______________________________________________
> 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 )
>