sqlobject-discuss

[SQLObject] Arbitrary SQL statement

[Mike M. <mm...@wo...>]

Hello,

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?

TIA,
Mike
-- 
the Moum's (Mike, Dede, Suzanne, Jeff, Kristen)
Tipp City, Ohio, USA
Visit the Baha'i World web site at www.bahai.org
Visit the U.S. Baha'i web site at www.us.bahai.org

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