[Zope] Newbie Question

Meilicke, Scott scott.meilicke@intp.com
Fri, 2 Nov 2001 15:18:54 -0800


Hi Lynn,

I have cc'ed the group as I'm sure there are other thoughts on this out
there.

First Question:
Once you have your ZSQL methods working, create a Z Search Interface to see
how to create forms and result methods automagically.  Their just plain DTML
methods.

Using the form and results DTML methods that the Z Search Interface
generates, look at how it is setup to create your own DTML method containing
three forms, each pointing to a different ZSQL method.  

Second Question:

I imagine you could do something like putting the ZSQL method name in your
database, and using them to refine your search?

So your main form would call a ZSQL method that returns you data, and the
names of four other ZSQL methods, perhaps sql_1, sql_2, sql_3, sql_4.  Use
these fields to make a <a href> link on the results of the first ZSQL, so
you can click result 4, for example, and it executes sql_4.

Third Question:

Are your labels stored in the database?  If so, just call those columns as
the name.  If not, you may be able to do something like <dtml-if
expr="result_1 == '1'>USE</dtml-if>.  Python is probably a better tool here.


-Scott

-----Original Message-----
From: Lynn Mayes [mailto:LMayes@advpol.com]
Sent: Friday, November 02, 2001 3:04 PM
To: 'Meilicke, Scott'
Subject: RE: [Zope] Newbie Question


Hi Meilicke,

I gave it a shot - but I keep getting either key errors, or can't submit a
string into an in tag.  Anyway, specifically here - I have already created
an outer join query from 2 tables - the query is actually a ZSQL Method
select query.  It works fine.  I also have created 3 separate ZSQL Methods
querying 3 different ZSQL Methods - they all work individually.  What I want
to do is have all 3 queries on an interface of somekind, so when they pull
up the page, they click on whichever search they would like to do.

Also, I would like to know how to put another ZSQL method into the query
results page - do you know how?  Like query A spits out data 1-4, and on the
results page, I want to further look at item 4.

Lastly, I have data on the SQL tables that came from an Access form option
box, items 1-4.  All that show up in the table is the numerical value.
Within the ZSQL method, I would like change change the 1 to say "USE" .  Do
you know how this would work?

Thanx again,
Lynn Mayes
-----Original Message-----
From: Meilicke, Scott [mailto:scott.meilicke@intp.com]
Sent: Friday, November 02, 2001 1:15 PM
To: 'Lynn Mayes'; 'Zope@zope.org'
Subject: RE: [Zope] Newbie Question


Within a DTML method, I have two forms, each having their action point to
back to itself - the DTML method. 
The query to execute is determined by a dtml-if statement, looking for the
NAME from the form. 
The DTML method id is 'atp_search' 
<FORM METHOD="GET" ACTION="atp_search"> 
Enter any character to search by Model #: <INPUT TYPE="Text" NAME="model"> 
<INPUT TYPE="Submit" VALUE="Go!"> 
</FORM> 
<!-- PN search --> 
<FORM METHOD="GET" ACTION="atp_search"> 
Enter any character to search by Mfg Part #: <INPUT TYPE="Text" NAME="mfg" >

<INPUT TYPE="Submit" VALUE="Go!"> 
</FORM> 
<dtml-if model> 
<dtml-in atp_model size=50 start=query_start> 
  display stuff from the atp_model ZSQL query 
</dtml-in> 
</dtml-if> 
<dtml-if mfg> 
<dtml-in atp_mfg size=50 start=query_start> 
  display different stuff from the atp_mfg ZSQL query 
</dtml-in> 
</dtml-if> 
-Scott 
-----Original Message----- 
From: Lynn Mayes [mailto:LMayes@advpol.com] 
Sent: Friday, November 02, 2001 1:08 PM 
To: 'Zope@zope.org' 
Subject: [Zope] Newbie Question 


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.  
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? 
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? 
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 )