Did you try using '%' instead of '*'? Your JDBC driver (the JDBC-ODBC
bridge) will translate to the appropriate character for you. Queries from
JDBC WILL NOT work with '*' even if they are going to an Access DB.
Aaron
> -----Original Message-----
> From: Nitin Kulkarni [mailto:[EMAIL PROTECTED]]
> Sent: Friday, July 16, 1999 1:43 AM
> To: [EMAIL PROTECTED]
> Subject: Re: Using 'Like' Query on MS-ACCESS Database
>
>
> Hi,
> We tried the query you gave us and we are getting the
> following error.
>
> 'javawebserver: [Microsoft][ODBC Driver Manager] Invalid
> argument value'.
>
> You had given the example of a static query whereas we are
> using a dynamic
> query. so we changed the variable and put ? in it's place.
>
> Also % doesn't work with MS Access. so we used * init's place.
>
<snip>
___________________________________________________________________________
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
