This one time, at band camp, Lanaghan, Kevin M said:
LKM>Is there a command I can use that will do some type of a pass
LKM>through to oracle.
LKM>
LKM>The problem:
LKM>I need to get back the current lab statuses on a patient. Every
LKM>time the lab status changes a new record gets entered - we track
LKM>these so it needs to be a separate record. Ideally I want to
LKM>retrieve the current status for all labs on a patient for the
LKM>current visit where the status on each lab is an ordinal value
LKM>ranging from 1 to 5.
Kevin,
You might be able to make use of Castor's pass through mechanism (the
CALL SQL feature in the OQL impl) to send raw SQL to the database. See
more info here:
http://www.castor.org/jdo-faq.html#OQL
(see the question: Can I write a pass-thru OQL?)
Bruce
--
perl -e 'print unpack("u30","<0G)U8V4\@4VYY9&5R\"F9E<G)E=\$\!F<FEI+F-O;0\`\`");'
-----------------------------------------------------------
If you wish to unsubscribe from this mailing, send mail to
[EMAIL PROTECTED] with a subject of:
unsubscribe castor-dev
