the db, and then just create a DAL
> model based on that view (turn off migrations for that model so the DAL
> does not attempt to create a table for it). From that point, you can use
> that model for queries via the DAL.
>
> Anthony
>
> On Thursday, April 27, 2017 at 10:25:35 PM
Unfortunately, I cannot combine the two tables. The existing product uses
one of them extensively for queue processing and I don't want to possibly
break any of that functionality. All I want to do is update the SQLFORM
with information from the new table. I can use db.executesql but won't that
solution.
On Saturday, April 22, 2017 at 4:51:21 PM UTC-4, George D Elig wrote:
>
> I have the following tables defined and would like to display rows of
> cats, followed by rows of dogs
>
> db.define_table(‘cat’,
>
> Field('name', 'string', length=45),
>
> Field(‘
I have the following tables defined and would like to display rows of cats,
followed by rows of dogs
db.define_table(‘cat’,
Field('name', 'string', length=45),
Field(‘age’, ‘integer’),
Field(‘apt_time’,’datetime’)
)
db.define_table(‘dog’,
Field('name', 'string', length=45),
Field(‘age’,
I have a simple SQL query that pulls a column value from a secondary table,
based on a ID being equal in both tables. The query uses an exists clause
on a subquery.
select sites.domain_name, batch.batch_name from sites, batch
where exists (select batch.id from batch
where
I have the following SQL statement that I'm having difficulty converting to
a db()Select statement. I could use a left join but I can only return one
row, which is being addressed with 'limit 1'
select sites.domain_name, batch.batch_name from sites, batch
where exists (select batch.id from
6 matches
Mail list logo