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

Reply via email to