Run A Query In Trigger

[cyberws]

What is the best way to submit a query in a trigger?

For example:

$idvalue=$record->display('somecolum');

Run following query and store date:

select col1,col2 from table where id='$idvalue';

Thanks.

[cyberws]

Let me follow up. I know I can use mysql_query and such but I am trying to run things through the main Dataface wrapper.

[cyberws]

No resposne so I made my own wrapper that is called in all the custom class files. This issue has been resolved outside of Dataface classes.

[shannah]

I'm not actually clear on the question. But glad to hear you solved it.