I'm using java application and i don't know how to add my Crystal Report to
my program. hope you share the info if you could find ways. thank you



> ----------
> From: 	J.T. Wenting[SMTP:jwenting@h...]
> Reply To: 	Pro_JavaServer_Pages
> Sent: 	Wednesday, April 04, 2001 2:42 PM
> To: 	Pro_JavaServer_Pages
> Subject: 	[pro_jsp] RE: search engine in jsp and access
> 
> You'll have to use a LIKE clause in your SQL WHERE clause.
> For example, String query= "SELECT * from TEXTS WHERE UCASE(TEXT) LIKE
> \"%?%\"";
> String search="java";
> stmt.setString(1, search.toUpper());
> 
> What wildcards to use for the LIKE and what to use for UCASE (converting
> the
> result to uppercase) is database dependent.
> This way the result will not be case-sensitive. By not converting to
> uppercase, you get case-sensitive search.
> 
> > -----Original Message-----
> > From: Super Powerfulrez [mailto:powerfulrez@g...]
> > Sent: Wednesday, April 04, 2001 05:53
> > To: Pro_JavaServer_Pages
> > Subject: [pro_jsp] search engine in jsp and access
> >
> >
> > i want to do something like a search engine where ppl write a
> > word and the
> > jsp will look for the word in the access database for example i type
> > 'java' but my access database only has 'professional java' but it
> > will also
> > print this result out what is the query to do this?
> >
> > benjamin
> >
> >