> -----Original Message----- > From: CRANFORD, CHRIS [mailto:[EMAIL PROTECTED] > Sent: 14 June 2004 18:13 > To: '[EMAIL PROTECTED]' > Subject: Query question > > > Anyone here familiar with using CATSEARCH type oracle > queries? If so, I am > trying to do something like: > SELECT COLNAME > FROM MYTABLE > WHERE CATSEARCH(MYFIELD,'motor',NULL) > 0 > OR SHORT_DESCRIPTION LIKE '%motor%' > The problem is I get an oracle error about functional > invocation; however I > and use an AND in my where clause and no errors occur. > Thanks for any help > anyone can provide.
Ok with the Value List Handler pattern. There are two options to consider 1. Deterministic result set In this case you are actually sure the SQL query will return a set of results that will not exhaust the memory and will not overload the network transfer between data and controller tiers. 2. Non deterministic result set In this case you are NOT actually sure the SQL query will return a set of results. Either it will exhaust the memory and take in reality to transfer the data. The difference between (1) and (2) is whether you can call SELECT COUNT(*) FROM ... to get the finite size of the database result set. So therefore it decide how you implement the Value List Handler pattern. If you cannot be sure how data you have, then you have write an optimistic version. This also affects how you design the GUI. In other words the web user will alway be able to click on the [NEXT] button in (2). Also you cannot tell the user exactly how much data is really available on page 1 of the iteration. Interesting stuff. For case (1) also consider the trade off between calling SQL to retrieve the size and to query the data. Effectively you are executing the same SQL twice. So what you might want to do is retrieve all the data first (if that is actually realistically) and then give the user the size as the size of the cache. -- Peter Pilgrim Operations/IT - Credit Suisse First Boston, 10 South Colonnade, London E14 4QJ, United Kingdom Tel: +44 (0)207 883 4447 ============================================================================== This message is for the sole use of the intended recipient. If you received this message in error please delete it and notify us. If this message was misdirected, CSFB does not waive any confidentiality or privilege. CSFB retains and monitors electronic communications sent through its network. Instructions transmitted over this system are not binding on CSFB until they are confirmed by us. Message transmission is not guaranteed to be secure. ============================================================================== --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
