Forum OpenACS Q&A: access arbitrary sql statement in arbitrary xql file?

Collapse
1: access arbitrary sql statement in arbitrary xql file?
Posted by tammy m on 10/31/03 06:01 PM
Hi

I just read that I can access an arbitrary sql statement in arbitrary xql file. In this other thread: No wrapper procs around SQL statements. I was told that I can access an arbitrary SQL statement in an arbitrary XQL file, so why the heck do I need a wrapper proc that does nothing but return a bitstream if I can run the SQL statement directly.

Can someone please post an example of exactly how I do that? I haven't seen it done in any code I've run across yet and it would be pretty useful to me.

Collapse
2: Re: access arbitrary sql statement in arbitrary xql file? (response to 1)
Posted by Randy O'Meara on 11/01/03 09:31 PM
Please?

Does *anyone* have an example of using the QD to call an SQL query from an *arbitrary* xql file? I could really use this too.

However, I'm beginning to believe that this is a *false* statement...

Collapse
3: Re: access arbitrary sql statement in arbitrary xql file? (response to 2)
Posted by tammy m on 11/03/03 11:49 PM
Hi,

Just FYI, Dave answered this. Thanks Dave:)

Collapse
4: Re: access arbitrary sql statement in arbitrary xql file? (response to 2)
Posted by tammy m on 11/06/03 04:33 AM
Ah,

I see a there was clue lurking about my logs... running with debug logging anyway...

NO FULLQUERY FOR dbqd.cms-forms.tcl.cr-procs.cms-forms::get_cr_item.select_map_attributes --> using default SQL