Re: questions

"Jonathan Ellis" <[email protected]> Mon, 23 Oct 2006 06:54:08 -0700
Newsgroups gmane.comp.python.spyce.general
Message-ID <[email protected]>
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=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