Re: questions

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