Sorry. I still do not understand...
If you want the default value of the second table to have the same
values as the former table you can do
SQLField('price','double',default=db.add_product.price.default))
Massimo
On Sep 12, 4:41 pm, Andrew Evans <[email protected]> wrote:
> I am trying to make another table that uses those values from the
> add_product table
>
> ty for the fast reply :-)
>
> here is my sql layout
>
> db.define_table('category',
> SQLField('name'),
> SQLField('headline',length=512))
>
> db.define_table('add_product',
> SQLField('name'),
> SQLField('category',db.category, requires=IS_IN_DB(db.category.id,
> db.category.name)),
> SQLField('description', 'text'),
> SQLField('image','upload',default=''),
> SQLField('quantity','integer',default=0),
> SQLField('price','double',default=1.00))
>
> db.define_table('product',
> SQLField('name',db.add_product.name),
> SQLField('category',db.category, requires=IS_IN_DB(db.category.id,
> db.category.name)),
> SQLField('description',db.add_product.description),
> SQLField('small_image','upload'),
> SQLField('large_image','upload',db.add_product.image),
> SQLField('quantity','integer',db.add_product.quantity),
> SQLField('price','double',db.add_product.price))
>
> On Sun, Sep 12, 2010 at 2:33 PM, mdipierro <[email protected]> wrote:
> > what do you mean by?
>
> > SQLField('price','double',db.add_product.price)
>
> > I think this should just be
>
> > Field('price','double')
>
> > and same for the other fields:
>
> > db.define_table('product',
> > SQLField('name'),
> > SQLField('category',db.category,
> > requires=IS_IN_DB(db,db.category.id,'%(name)s')),
> > SQLField('description'),
> > SQLField('small_image','upload'),
> > SQLField('large_image','upload'),
> > SQLField('quantity','integer'),
> > SQLField('price','double'))
>
> > On Sep 12, 4:11 pm, ukolo <[email protected]> wrote:
> > > Receiving the following error in my DB Setup and can't figure it out
>
> > > Traceback (most recent call last):
> > > File "gluon/restricted.py", line 186, in restricted
> > > exec ccode in environment
> > > File "/home/www-data/web2py/applications/Working/models/db.py", line
> > > 60, in <module>
> > > SQLField('price','double',db.add_product.price))
> > > File "gluon/sql.py", line 1359, in define_table
> > > t._create(migrate=migrate, fake_migrate=fake_migrate)
> > > File "gluon/sql.py", line 1716, in _create
> > > referenced = field.type[10:].strip()
> > > AttributeError: 'Expression' object has no attribute 'strip'
>
> > > this is the table
>
> > > db.define_table('product',
> > > SQLField('name',db.add_product.name),
> > > SQLField('category',db.category, requires=IS_IN_DB(db.category.id,
> > > db.category.name)),
> > > SQLField('description',db.add_product.description),
> > > SQLField('small_image','upload'),
> > > SQLField('large_image','upload',db.add_product.image),
> > > SQLField('quantity','integer',db.add_product.quantity),
> > > SQLField('price','double',db.add_product.price))
>
> > > Any help would be appreciated
>
>
