[Zope] newbie question about input box for sql method

[Charlie Derr]

Dmitiris,
	Thanx for the help.  That is exactly what I need.  My one remaining problem
is sorting out the difference between a Z SQL Method and the object that
uses it.   When I try to edit my Z SQL Method, it gives me a template with a
spot for arguments and a spot for a query.   I can't really see the dtml (if
there is any?) associated with that method.   I'm guessing I want to create
a Z Search Method that calls this Z SQL Method and then edit the dtml for
the Z Search Method?

	Thanx again for the response, i'm sure it won't be too long before i figure
out where to plug in your suggestion,
		:-]   ~c

|-----Original Message-----
|From: Dimitris Andrakakis [mailto:dandraka_info@yahoo.com]
|Sent: Monday, May 08, 2000 7:30 PM
|To: Charlie Derr; zope@zope.org
|Subject: Re: [Zope] newbie question about input box for sql method
|
|
|Charlie wrote:
|> Hi all,
|> I've followed the Z SQL Method instructions and built a simple interface
|to
|> a database.  I have an input form with four text-input boxes.  The values
|> entered into the four input boxes get INSERTed as a database record when
|the
|> submit button is clicked.  I want to change one of those text-input boxes
|> into a selection box -- limiting the user to a dozen or so predefined
|values
|> (which would be selectable from a menu that appears on the box when you
|> click on it).  From the way the Z SQL Method is used in zope, it almost
|> looks like i might have to go into it (SQL.py) and set things up
|the way I
|> want.  Is this right?  Is there a better solution?
|
|NO ! DONT JUMP ! FOR GOD'S SAKE !!! If I get you right, you want what
|windoze call a "list box" right ? So, instead of:
|
|<input name="my_db_object" width=30 value="">
|
|you will use:
|
|<select name="my_db_object" size="1">
|    <option selected value="01">01</option>
|    <option value="02">02</option>
|    <option value="03">03</option>
|    <option value="04">04</option>
|...etc.
|    </select>
|
|...life is sooo simple :-)
|
|Dimitris Andrakakis
|http://atlas.central.ntua.gr:8000/~mc94068
|
|
|__________________________________________________
|Do You Yahoo!?
|Talk to your friends online with Yahoo! Messenger.
|http://im.yahoo.com