Hi there,
> Try to use the % char instead of the *
> in your query (that is the appropriate ODBC convention)
isn't % a SQL standard?
And MS usually have their own practices so they use something else (in
this case *).
Wildcard * works in Access, but % don't. In MS SQL7 it's the opposite.
> |However the query deos not run successfully and returns a null
> |resultset.
Need some more information, like what kind of exceptions does it throw?
Do the query work in the query window for Access?
Are you using the executeQuery() for the select statement?
How do you prepare the statement?
Perhaps something like this:
stmt = con.prepareStatement("Select * from Empdet where Empfname like ?
AND Emplname like ?");
It is important NOT to use the '' surrounding string arguments when
preparing statements.
regards
Stein
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
