Hi David,
> I need to implement a search engine .
> I'm working with ORACLE, but the matter is that I don't know how to write
> with Castor oql queries equivalent to sql queries :
>
> SELECT
> table1.field1,
> table1.field2,
> table1.field3,
> FROM
> table1
> WHERE
> upper(table1.field1) like "%TXT1%"
> and upper(table1.field2 ) like "%TXT2%"
> and upper(table1.field3 ) like "%TXT3%"
Seems like the mailing list archive needs a good search engine too ;-)
This question pops up every few weeks or so, maybe it would be even good
for the FAQ.
Well, at least in the Castor CVS there is (for some time already) a
patch that allows you to use SQL functions in your OQL query. "Problem"
there is, that you have to know what database exactly you are using, as
the functions are simply "passed trough" to the DB. Otherwise this
should work fine ...
--
mfg
Thorsten Thielen
Ipcon Informationssysteme - www.ipcon.de
-----------------------------------------------------------
If you wish to unsubscribe from this mailing, send mail to
[EMAIL PROTECTED] with a subject of:
unsubscribe castor-dev
