Re: questions

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