access VS asp (frontpage 98) query mismatch

[bigdan]

Hi,

I have a MS Access 97 database and i'm trying to do a query with an ASP file (front page 98) for an intranet.

I built my query in access and is working fine and when i copy that one in my asp file i got an error message.

Here's my query statement:

SELECT [Host table].site, [Host table].adresse, [Host table].[Host name]
FROM [Host table]
WHERE ((([Host table].[Host name]) Like ("*" & "piex" & "*&quot));

Here's the error message:

Erreur de base de données : [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 2.

It's working if a replace the "like" by = and i remove the *& but i have to write all the "host name" without error. The thing i want to do is to search a pattern in that field.

The final query that i want is to replace the "piex" with a variable from a html form (user input), example '%%value1%%' and search that pattern in the field "host name".


Any Help will be very appreciate!!!!!!

NB this thread is the same as posted in the ASP forums.


Dan!!!!!

 

[Gilnockie]

I am having a similar problem with FP 2000 and Acess 2000. I am trying to embed a single table with a look up facility in a page but every time I test it the page loads FP2000 and the original page.

The URL is

http://members.tripod.com/oz_vc_sites/

Can anyone help?