>> On Fri, Mar 7, 2008 at 10:21 AM, Brian Blais <[EMAIL PROTECTED]>  
>> wrote:
>>
>> Hello,
>>
>> I am trying to insert rows into a sqlite database, and am getting the
>> error:  SQL logic error or missing database.  This only happens with
>> inserts, not selects, which are working fine.
>>


I found the problem:

I had:

         userdb=web.select('users')
         user=userdb[0]


and I needed:

         userdb=web.select('users')
         users=[x for x in userdb]
         user=users[0]


I don't completely understand how web.select works, and I realize  
that I am doing more operations than necessary.  I'll clean it up  
later, but at least now I can get it to work!



                thanks for everyone's help on this,


                                Brian Blais




--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups 
"web.py" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at http://groups.google.com/group/webpy?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to