Re: questions

The html generated is:
<select name="day" id="day"><option value="1">1</option><option 
value="2">2</option><option value="3">3</option><option 
value="4">4</option><option value="5">5</option></select></td>

On Friday 27 October 2006 13:51, you wrote:
> What html is being generated for the select?
>
> On Fri, 27 Oct 2006 11:15:46 +0100, "Mary Jane Boholst"
>
> <[email protected]> said:
> > Hello again,
> > Sorry I should have put this question in with the other one. I have
> > created a
> > drop down menu using the following code:
> > <SNIP>
> > [[id = session.get('id')]]
> > [[unit = db.timetable.selectone_by(id=id)]]
> > [[day = str(unit.day)]]
> > [[all1=db.timetable.select(db.timetable.c.starttime=='09:00',
> > distinct=True)]]
> > <SNIP>
> > <f:form>
> > <SNIP>
> > <f:select name=day data="[(L.day,L.day) for L in all1]" default="=day" />
> > <SNIP>
> > </f:form>
> > However the default option does not seem to be working. Can anyone shed
> > some
> > light on why this might be so?
> > thanks in advance,
> > MJ
> >
> > Jonathan Ellis wrote:
> > > you can, but SqlSoup won't turn it into objects for you...
> > >
> > > use db.timetable._table to get the underlying SqlAlchemy table object,
> > > with which you can do lower-level selects
> > > (see http://www.sqlalchemy.org/docs/sqlconstruction.myt -- further
> > > questions on that are better directed to the SA mailing list)
> > >
> > > or, just grab db.engine and write raw sql
> > >
> > > On Tue, 24 Oct 2006 16:30:53 +0100, "Mary Jane Boholst"
> > >
> > > <[email protected]> said:
> > >> does that mean that I cannot do the SQL "select distinct day from
> > >> timetable;" which is what I was trying to achieve?
> > >> Thanks again.
> > >> MJ
> > >>
> > >> Jonathan Ellis wrote:
> > >>> the first argument to select must be a (where) clause of some sort;
> > >>> [db.timetable.c.day] is invalid
> > >>>
> > >>> a suggestion: when trying something new, change one thing at a time.
> > >>> obviously this statement didn't work before adding the "distinct;" if
> > >>> you had started with a working statement and then added distinct, it
> > >>> would have been clear where the problem was [not].
> > >>>
> > >>> On Tue, 24 Oct 2006 09:53:28 +0100, "Mary Jane Boholst"
> > >>>
> > >>> <[email protected]> said:
> > >>>> Thank you for the clarification. What is the syntax for the use of
> > >>>> distinct=True with the select statement. I seem to be getting errors
> > >>>> with the following syntax:
> > >>>> days=db.timetable.select([db.timetable.c.day], distinct=True).
> > >>>> Thanks again for all your help.
> > >>>> MJ
> > >>>>
> > >>>> On Monday 23 October 2006 17:32, Jonathan Ellis wrote:
> > >>>>> As discussed in a recent thread with someone else, you cannot use
> > >>>>> [[= inside an active tag.  just prefix a value with = to cause it
> > >>>>> to be eval'd instead.  (The only exception is the "data" attribute
> > >>>>> which is _always_ eval'd like this.)  So,
> > >>>>>
> > >>>>> <f:select name=day data="[L.day for L in all]" default="=unit.day"
> > >>>>> />
> > >>>>>
> > >>>>> btw, distinct=True does nothing in f:select, perhaps you meant to
> > >>>>> put it in timetable.select().
> > >>>>>
> > >>>>> On Mon, 23 Oct 2006 15:26:45 +0100, "Mary Jane Boholst"
> > >>>>>
> > >>>>> <[email protected]> said:
> > >>>>>> Hi,
> > >>>>>> OK. I have added the tag with the default attribute (attached
> > >>>>>> file) but
> >
> > I
> >
> > >>>>>> now
> > >>>>>> do not get anything displayed in the column in the table. The page
> > >>>>>> displays
> > >>>>>> but there are no drop down menus. This is rather strange. The
> > >>>>>> spyce compiler
> > >>>>>> does not seem to be complaining about the code but nothing is
> >
> > displayed.
> >
> > >>>>>> Is
> > >>>>>> there something wrong with my code that I am just not seeing? Is
> > >>>>>> this something to do with the browser that I am using? Any help
> > >>>>>> will be gratefully
> > >>>>>> received.
> > >>>>>> Thanks very much for all your help.
> > >>>>>> MJ
> > >>>>>>
> > >>>>>> On Monday 23 October 2006 14:54, Jonathan Ellis wrote:
> > >>>>>>> use the "default" attribute
> > >>>>>>>
> > >>>>>>> <f:select data=... default=onevalue />
> > >>>>>>>
> > >>>>>>> On Mon, 23 Oct 2006 14:05:31 +0100, "Mary Jane Boholst"
> > >>>>>>>
> > >>>>>>> <[email protected]> said:
> > >>>>>>>> Hello again,
> > >>>>>>>> I am having problems with the <f:select> tag and having a
> > >>>>>>>> particular value selected on a page. Basically what I want to do
> > >>>>>>>> is have the day that is in a particular row of a database
> > >>>>>>>> selected in the drop down menu. Is there a way for me to do
> > >>>>>>>> this?
> > >>>>>>>> Thanks in advance for any help given.
> > >>>>>>>> MJ
> > >>>>>>>> PS sorry for any bounced email, the email address I use is a
> > >>>>>>>> valid one as it is a work address. I have no idea why this would
> > >>>>>>>> happen.
> > >>>>>>>>
> > >>>>>>>> Jonathan Ellis wrote:
> > >>>>>>>>> Try <%= day %> to see if it's a sequence before using it in the
> > >>>>>>>>> f:select
> > >>>>>>>>>
> > >>>>>>>>> just add ", distinct=True" to your select args to perform
> > >>>>>>>>> "select distinct," although I would guess that something's
> > >>>>>>>>> wrong with your model if days in the timetable are not already
> > >>>>>>>>> unique :)
> > >>>>>>>>>
> > >>>>>>>>> On Fri, 13 Oct 2006 11:48:07 +0100, "Mary Jane Boholst"
> > >>>>>>>>>
> > >>>>>>>>> <[email protected]> said:
> > >>>>>>>>>> I keep
> > >>>>>>>>>> getting an error when I try to use the <f:select> tag with/
> > >>>>>>>>>> data="[d.day for d in day]"/ where
> > >>>>>>>>>> /day=db.timetable.select(order_by=[db.timetable.c.day])/.  The
> > >>>>>>>>>> error is TypeError:unpack non-sequence. Any help with why this
> > >>>>>>>>>> is not working would be useful. Also is there a way of doing
> > >>>>>>>>>> the sql query "select distinct day from timetable;" in
> > >>>>>>>>>> spyce/sqlalchemy? Thanks for all your help.
> > >>>>>>>>>> MJ
> > >>>>>>>>>>
> > >>>>>>>>>> Jonathan Ellis wrote:
> > >>>>>>>>>>> On Tue, 19 Sep 2006 15:25:33 +0100, "Mary Jane Boholst"
> > >>>>>>>>>>>
> > >>>>>>>>>>> <[email protected]> said:
> > >>>>>>>>>>>> Hello again,
> > >>>>>>>>>>>> I am currently attempting to develop a web interface linked
> > >>>>>>>>>>>> to a database and was wondering if anyone knew how I could
> > >>>>>>>>>>>> display the contents of a table or part table in a database
> > >>>>>>>>>>>> as a table in a web page. Failing that does anyone know of
> > >>>>>>>>>>>> somewhere where I could find an example?
> > >>>>>>>>>>>
> > >>>>>>>>>>> get a list of data from the db, and display it with spy:table
> > >>>>>>>>>>> or a manual for loop.
> > >>>>>>>>>>>
> > >>>>>>>>>>>> Also is there a way of creating drop down lists using a
> > >>>>>>>>>>>> database connection to populate the contents of the drop
> > >>>>>>>>>>>> down menu?
> > >>>>>>>>>>>
> > >>>>>>>>>>> same things, only with f:select.
> > >>>>>>>>>>>
> > >>>>>>>>>>> it is almost the same as using spy:ul as shown over here:
> > >>>>>>>>>>> http://spyce.sourceforge.net/docs/whats-new-2-1.html
> > >>>>>>>>>>>
> > >>>>>>>>>>> -Jonathan
> > >>>>>>>>
> > >>>>>>>> ----------------------------------------------------------------
> > >>>>>>>>----- ---- Using Tomcat but need to do more? Need to support web
> > >>>>>>>> services, security? Get stuff done quickly with pre-integrated
> > >>>>>>>> technology to make your job easier
> > >>>>>>>> Download IBM WebSphere Application Server v.1.0.1 based on
> > >>>>>>>> Apache Geronimo
> > >>>>>>>> http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&da
> > >>>>>>>>t=121 642 _______________________________________________
> > >>>>>>>> Spyce-users mailing list
> > >>>>>>>> [email protected]
> > >>>>>>>> https://lists.sourceforge.net/lists/listinfo/spyce-users
> >
> > -------------------------------------------------------------------------
> > Using Tomcat but need to do more? Need to support web services, security?
> > Get stuff done quickly with pre-integrated technology to make your job
> > easier
> > Download IBM WebSphere Application Server v.1.0.1 based on Apache
> > Geronimo
> > http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
> > _______________________________________________
> > Spyce-users mailing list
> > [email protected]
> > https://lists.sourceforge.net/lists/listinfo/spyce-users

-------------------------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642