Sorry! :o
I didn't see that misstype. All the issue was related with the
software that I use for coding, (textmate), I just did let textmate
auto complete my strings but it does it by reconstruct strings from
others previously written, at comments by massimo at db.py head,
boolean is wrong: 'booelan' and that was the whole issue.
I already fix it ;)
Thank you!
Oscar.
On 3 nov, 12:29, mdipierro <[EMAIL PROTECTED]> wrote:
> The point that Yarko is making (and he is right) is that "boolean" is
> a type. "booelan"
> is not. ;-)
>
> Massimo
>
> On Nov 2, 10:59 am, Oscar <[EMAIL PROTECTED]> wrote:
>
> > Yes,
>
> > Is supposed that "boolean" is a type, even describe as it in comments
> > at db.py file.
>
> > Regards,
>
> > Oscar.
>
> > On 3 nov, 11:52, "Yarko T" <[EMAIL PROTECTED]> wrote:
>
> > > Oscar -
> > > Are you asking why "booelan" is an unknown type?
>
> > > *grin*
>
> > > Kind regards,
> > > Yarko
>
> > > On Sun, Nov 2, 2008 at 9:32 AM, Oscar <[EMAIL PROTECTED]> wrote:
>
> > > > I have define my table as:
>
> > > > db.define_table('t2_person',
> > > > db.Field('name'),
> > > > db.Field('email'),
> > > > db.Field('nickname'),
> > > > db.Field('registration_key','string'),
> > > > db.Field('password','password'),
> > > > db.Field('created_by_ip'),
> > > > db.Field('created_on','datetime'),
> > > > db.Field('address','text'),
> > > > db.Field('phone1'),
> > > > db.Field('ext1'),
> > > > db.Field('phone2'),
> > > > db.Field('ext2'),
> > > > db.Field('celullar'),
> > > > db.Field('state'),
> > > > db.Field('zip_code'),
> > > > db.Field('country'),
> > > > db.Field('messages','booelan'))
>
> > > > Then I getting the following error:
>
> > > > Error traceback
>
> > > > 1.
> > > > 2.
> > > > 3.
> > > > 4.
> > > > 5.
> > > > 6.
> > > > 7.
> > > > 8.
> > > > 9.
>
> > > > Traceback (most recent call last):
> > > > File "/Users/ra/fuentes/web2py/gluon/restricted.py", line 62, in
> > > > restricted
> > > > exec ccode in environment
> > > > File "/Users/ra/fuentes/web2py/applications/diamante/models/db.py",
> > > > line 52, in <module>
> > > > db.Field('messages','booelan'))
> > > > File "/Users/ra/fuentes/web2py/gluon/sql.py", line 500, in
> > > > define_table
> > > > raise e
> > > > SyntaxError: SQLField: unkown field type
>
> > > > Why boolean type is returning an error?
>
> > > > Regards,
>
> > > > Taguapire.
>
> > > > On 3 nov, 10:14, Oscar <[EMAIL PROTECTED]> wrote:
> > > > > No problem!
>
> > > > > I already did it!
>
> > > > > Thanks!
>
> > > > > On 3 nov, 10:01, Oscar <[EMAIL PROTECTED]> wrote:
>
> > > > > > How I can get all functioality from this table, I mean, the UUID
> > > > > > added
> > > > > > automatically to the registry key field and other stuff?
>
> > > > > > Regards,
>
> > > > > > Oscar.
>
> > > > > > On 3 nov, 00:30, mdipierro <[EMAIL PROTECTED]> wrote:
>
> > > > > > > Normally you can do
>
> > > > > > > db.define_table('base_table',SQLField('myfield'))
> > > > > > > db.define_table('derived_table',db.base_table,SQLField('otherfield'))
>
> > > > > > > (both base_table and derived_table are created)
>
> > > > > > > or
>
> > > > > > > from gluon.sql import SQLTable
> > > > > > > base_table=SQLTable('base_table',SQLField('myfield'))
> > > > > > > db.define_table('derived_table',base_table,SQLField('otherfield'))
>
> > > > > > > (only derived_table is created)
>
> > > > > > > In the case T2 things are different because you want to modify the
> > > > > > > structure of a table used by T2.
> > > > > > > You can do it.
> > > > > > > All you need to do is define the table before you instantiate the
> > > > > > > T2
> > > > > > > object. Something like this:
>
> > > > > > > db.define_table('t2_person',
> > > > > > > db.Field('name'),
> > > > > > > db.Field('email'),
> > > > > > > db.Field('registration_key'),
> > > > > > > db.Field('password','password'),
> > > > > > > db.Field('created_by_ip'),
> > > > > > > db.Field('created_on','datetime'))
> > > > > > > db.t2_person.name.requires=IS_NOT_EMPTY()
>
> > > > db.t2_person.email.requires=[IS_EMAIL(),IS_NOT_IN_DB(db,'t2_person.email')]
> > > > > > > db.t2_person.password.requires=[IS_NOT_EMPTY(),CRYPT()]
> > > > > > > db.t2_person.exposes=['name','email','password']
> > > > > > > db.t2_person.displays=['name','email','password']
>
> > > > > > > t2=T2(request,response,session,cache,T,db)
>
> > > > > > > you can add fields to the t2_person table but you must have the
> > > > > > > above
> > > > > > > fields.
>
> > > > > > > Massimo
>
> > > > > > > On Nov 1, 11:33 pm, Oscar <[EMAIL PROTECTED]> wrote:
>
> > > > > > > > Hi,
>
> > > > > > > > I was looking for how to extend a model, I mean, I working with
> > > > > > > > T2
> > > > and
> > > > > > > > I want to add some more fields to t2_persona table, I tryed
> > > > defining
> > > > > > > > again the table in my new project but It didn't worked. Some oen
> > > > knows
> > > > > > > > how I can accomplish this?
>
> > > > > > > > Regards,
>
> > > > > > > > Oscar.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"web2py Web Framework" group.
To post to this group, send email to web2py@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/web2py?hl=en
-~----------~----~----~----~------~----~------~--~---
