Hi
You need to share more information. How are you
extracting data items from the session and passing
them to the Query - basically how are you forming the
query ? Code snippet will be useful.
--
Some other thoughts: Its better to make use of 'like'
instead of '=' in pattern matching (Ex. select * from
bcat where title like 'turbine' and publisher like
'elvesier' and location like 'ny'). This will ease
your user who will not have to be exact and they can
provide wild cards if needed (ex. '%ny%'). And
hopefully you _are_ taking care of sql injection
(accepting UI data into a Java object and validating
it before transforming it into query). Another safe
bet is to connect to DB through READ-ONLY connections
for pure queries.
hope this helps
-
Aditya
=====================================================
Mark your calendar for the next TSM
Saturday (5pm - 7pm) on 16th September 2006
AJAX Live
- Core Ajax components
- How to write Ajax code
- Lots of Ajax demos
Venue:
5th Floor, Conference Room
CommVault Systems (India) Pvt Ltd.
Ashoka Janardhan Chambers
S.P. Road, Begumpet
Hyderabad.
Helpline:
+91 - 98482 37656
To know more about TWINCLING Society
http://www.twincling.org/
=====================================================
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/twincling/
<*> Your email settings:
Individual Email | Traditional
<*> To change settings online go to:
http://groups.yahoo.com/group/twincling/join
(Yahoo! ID required)
<*> To change settings via email:
mailto:[EMAIL PROTECTED]
mailto:[EMAIL PROTECTED]
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
