Re: help creating sqlalchemy/sqlsoup code for sql query

Thanks for this. It seems that the handler was not getting executed. 
This is fixed now. However, I have discovered a problem with my delete 
and update handlers. The handlers are being called however the incorrect 
entry is deleted. I am trying to as you can probably guess allow certain 
users to update, delete or insert items to a database. In an attempt to 
allow certain rows of the table to be deleted or updated I have created 
delete and update buttons. The handlers do not work as intended which is 
down to the id variable. The id variable is taken from the database and 
is intended to be used to identify the row to update or delete. However 
printing the id value reveals that the id of the uppermost row in the 
table is being used rather than the id of the row from which the button 
is pressed.
Could anyone explain why this is so? Does any one have an idea how I 
could use this id variable to delete or update all the rows of the table 
rather than just the uppermost row in the table? Or even just a way in 
which I can allow the update and deletion of certain rows in a table?
I am not sure if what I have just said makes sense, but any help would 
be useful.
Thanks in advance.
Regards,
MJ
Jonathan Ellis wrote:
> Well, the first step is to make sure the handler is actually getting
> executed.  Put a print statement in there to check.
>
> -J
>
> On Fri, 06 Oct 2006 16:22:33 +0100, "Mary Jane Boholst"
> <[email protected]> said:
>   
>> Thank you very much for this very helpful piece of code.
>> I have another question. (Last one for the week, promise!) I am trying 
>> to create a button on a page which inserts values from a form into a 
>> database. I have defined my handler and created the button but the data 
>> does not seem to be committed to the database. I do not get any error 
>> messages but checking the database for the data shows that it has not 
>> been inserted.
>> The code for my handler is:
>> [[!
>>     def insertentry(self, 
>> api,day,course,timeslottype,start,end,title,tutor):
>>           
>> api.db.timetable.insert(day=day,course=course,timeslottype=timeslottype,starttime=start,endtime=end,title=title,givenbby=tutor)
>> api.db.flush()
>> ]]
>>
>> The code for the button is:
>> <f:submit handler=self.insertentry value="Insert entry" />
>>  From reading around it seems that this should work. Is there something 
>> I am missing?
>> Thanks in advance for all help.
>> MJ
>> Jonathan Ellis wrote:
>>     
>>> from sqlalchemy import or_
>>> where = or_(db.timetable.c.course=='LAA', db.timetable.c.course=='COM')
>>> db.timetable.select(where, order_by=[db.timetable.c.day,
>>> db.timetable.c.starttime])
>>>
>>> On Wed, 4 Oct 2006 11:50:07 +0100, "Mary Jane Boholst"
>>> <[email protected]> said:
>>>   
>>>       
>>>> Hi again,
>>>> Another question which should be fairly simple to answer. I am trying to
>>>> carry 
>>>> out a fairly word query within my spyce code and am not sure how to do
>>>> it. 
>>>> The sql that I want to translate to sqlalchemy is select * from timetable 
>>>> where course='LAA' or course='COM' order by day, starttime.
>>>> I have tried several times to do this but I get errors trying to do both
>>>> the 
>>>> order by and the where clauses. 
>>>> Any help will be gratefully received. 
>>>> Thank you all for your help and suggestions. The login token problem is
>>>> now 
>>>> fixed and I have at the moment decided to use the example on the spyce
>>>> pages 
>>>> to help with the displaying of different pages for different users.
>>>> Thanks again,
>>>> MJ
>>>>
>>>> -------------------------------------------------------------------------
>>>> Take Surveys. Earn Cash. Influence the Future of IT
>>>> Join SourceForge.net's Techsay panel and you'll get the chance to share
>>>> your
>>>> opinions on IT & business topics through brief surveys -- and earn cash
>>>> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
>>>> _______________________________________________
>>>> Spyce-users mailing list
>>>> [email protected]
>>>> https://lists.sourceforge.net/lists/listinfo/spyce-users
>>>>     
>>>>         
>> -------------------------------------------------------------------------
>> Take Surveys. Earn Cash. Influence the Future of IT
>> Join SourceForge.net's Techsay panel and you'll get the chance to share
>> your
>> opinions on IT & business topics through brief surveys -- and earn cash
>> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
>> _______________________________________________
>> Spyce-users mailing list
>> [email protected]
>> https://lists.sourceforge.net/lists/listinfo/spyce-users
>>     

-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys -- and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV