Re: Beginner many-to-many problems

[prev] [thread] [next] [Date index for 2004/07/11]

On Sat, Jul 10, 2004 at 10:13:00PM -0400, Jesse Sheidlower wrote:
> In practice I'd almost certainly be wanting to use additional
> ORDER BY clauses and perhaps other things like LIMITs or
> things to grab citations by their initial letter, to limit
> the result set; I don't know if I'd have to use some more
> complicated thing like add_constructor with more raw SQL to
> accomplish this.

add_constructor will only really cope with a single table. You'll want 
to drop right back to set_sql here.

> Second, I'd like to add a citation with accompanying subjects,
> preferably in one shot. 

You can't. You'll need to write something yourself to do this.

Tony