You cannot this in web2py. perhaps you can create a database view.
On Nov 13, 12:11 pm, Crim <[email protected]> wrote: > alright so i got a connection between my MSSql server any web2py. that > has been all sorted out but now im having issues with how to select a > tuple from web2py > > in web2py i have this code: > > if db(db.User.Email == s).select(): > print "success" > > which should check if the users email is in the db > > but when i write a select statement for my server its like so: > > SELECT TOP 1000 [Email] > ,[Name] > ,[PIN] > ,[Phone] > ,[Address] > ,[Mileage] > ,[MealPref] > FROM [master].[dbo].[User] > > notice the dbo? do i have to include this in my select .. (have tried > and it still gives errors) > > the error snapshot: > <type 'exceptions.KeyError'>('user') > > thanks, > Crim
