|
I am evaluating Castor for use in
a database project. I really like what I have seen so
far.
My question is can I do something like "pass
through sql". I need to dynamically build a sql statement and pass that
sql directly to the database and get the results back. For example, our
app will build a sql like the following:
SELECT COUNT(*) FROM table WHERE table.col_a =
'hello' AND substring(table.col_b,1,1) = 'Y'
All parts of the query will dynamically change
depending on what is needed. As you can see there is even some database
specific function calls.
Is this possible in Castor? If so, could you
give me an example.
Thank You,
|
