Re: questions
"Jonathan Ellis" <[email protected]> Fri, 27 Oct 2006 05:51:31 -0700
| Newsgroups | gmane.comp.python.spyce.general |
|---|---|
| Message-ID | <[email protected]> |
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&dat=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 -- C++ is history repeated as tragedy. Java is history repeated as farce. --Scott McKay ------------------------------------------------------------------------- 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