Re: [SQLObject] Arbitrary SQL statement

[Ian B. <ia...@co...>]

On Nov 25, 2003, at 7:59 PM, Mike Moum wrote:
> Is it possible to execute an arbitrary SQL statement from within SQL 
> Object?
> I know that select statements are possible, but how about any legal SQL
> statement?

Well, you can always do __connection__.query(sql).  But you do have to 
be concerned about cache consistency.  If you are just doing complex 
select statements it's not a problem -- if you are updating or deleting 
rows you may invalidate existing SQLObject instances (but those 
instances won't know about it, so you have a consistency problem).

--
Ian Bicking | ia...@co... | http://blog.ianbicking.org