Re: [Spyce-users] questions

[Mary J. B. <Mar...@io...>]

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"
> <Mar...@io...> 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"
>>> <Mar...@io...> 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
>>>   
>>>