There is no webpy API to generate
"FROM [master].[dbo].[User]"
only
"FROM [User]"
On Nov 13, 12:45 pm, Crim <crimsonang...@gmail.com> wrote:
> what cant i use? the web2py statement?
>
> On Nov 13, 12:26 pm, mdipierro <mdipie...@cs.depaul.edu> wrote:
>
> > You cannot this in web2py. perhaps you can create a database view.
>
> > On Nov 13, 12:11 pm, Crim <crimsonang...@gmail.com> 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
>
>
