Re: questions
Mary Jane Boholst <[email protected]> Fri, 27 Oct 2006 10:35:20 +0100
| Newsgroups | gmane.comp.python.spyce.general |
|---|---|
| Message-ID | <[email protected]> |
Hello again, Just a quick question, can you change the font colour for buttons created using the active tag <f:submit>? Can this just be done using style sheets? 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