Re: questions

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=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

_______________________________________________
Spyce-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/spyce-users

<spy:parent title="Edit Summer School Timetable" />
[[.taglib as='ss' from='ssform.spi']]
[[.import name=session]]
[[.import name=redirect]]

[[id = session.get('id')]]
[[unit = db.timetable.selectone_by(id=id)]]
[[--print unit--]]
[[all=db.timetable.select()]]


<h2><center>Edit Summer School Timetable</center></h2>
<f:form><ss:blurb /></f:form>
<table align=center>
<tr>
  <th>ID</th>
  <th>Day</th>
  <th>Course</th>
  <th>Start</th>
  <th>End</th>
  <th>Title</th>
  <th>Tutor</th>
  <th>Tutor Initials</th>
 </tr>
<f:form>
<tr>
<f:hidden name="item_id" value="=id" />
<td>[[=unit.id]]</td>
<td><f:select name=day data="[L.day for L in all]" default="[[=unit.day]]" distinct=True />
</td>
<td><f:select name=course data="[L.course for L in all]" default="[[=unit.course]]" distinct=True />
</td>
<td><f:select name=start data="[L.starttime for L in all]" default="[[=unit.starttime]]" distinct=True /></td>
<td><f:select name=end multiple size=5 data="[L.endtime for L in all]" default="[[=unit.endtime]]" distinct=True /></td>
<td><f:text name="title" value="=unit.title" size =80 /></td>
<td><f:text name="tutor" value="=unit.givenby" size =30 /></td>
<td><f:text name="tutorinfo" value="=unit.tutorinfo" size =20 /></td>
<td><f:submit handler=action.update value="Update Entry" /></td> 
</tr>
</f:form>
</table>
<f:form>
<p><center><f:submit handler=action.home value="Home" /></center><p>
</f:form>