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