newbie question about input box for sql method
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? Thanx much in advance, ~c
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
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
participants (2)
-
Charlie Derr -
Dimitris Andrakakis