Hello



Does anybody know why this doesn't work:

Set RS = MyConn.Execute("SELECT Klanten.FirmaNaam, ..., 

Beheerder,Klanten,  ContactPersoon WHERE Beheerder.BeheerderID = 

Klanten.BeheerderID and Gemeente.PostNr = Klanten.PostNr and 

ContactPersoon.ContactCode = Klanten.ContactCode and 

JuridischeVorm.JurVormID = Klanten.JurVormID and 

Verantwoordelijken.VerantwoordelijkeID = Klanten.VerantwoordelijkeID and 

Klanten.FirmaNaam LIKE '%" & SearchText & "%' order by Klanten.FirmaNaam")



When we work with just one table everything goes well!

Our browser displays:

No value given for a requested parameter



We work with IIS and an Access database



Thanks

Koen,



Perhaps one of your field names is incorrect or misspelled, or you have

specified the wrong table name. You have left out your FROM clause, so it is

hard to see if you have listed all the tables used in the SQL statement.



-- Z





----- Original Message -----

From: "Koen Wagemans" <koenwagemans@h...>

To: "Access ASP" <access_asp@p...>

Sent: Friday, December 14, 2001 3:30 PM

Subject: [access_asp] linking tables in asp





> Hello

>

> Does anybody know why this doesn't work:

> Set RS = MyConn.Execute("SELECT Klanten.FirmaNaam, ...,

> Beheerder,Klanten,  ContactPersoon WHERE Beheerder.BeheerderID 

> Klanten.BeheerderID and Gemeente.PostNr = Klanten.PostNr and

> ContactPersoon.ContactCode = Klanten.ContactCode and

> JuridischeVorm.JurVormID = Klanten.JurVormID and

> Verantwoordelijken.VerantwoordelijkeID = Klanten.VerantwoordelijkeID and

> Klanten.FirmaNaam LIKE '%" & SearchText & "%' order by Klanten.FirmaNaam")

>

> When we work with just one table everything goes well!

> Our browser displays:

> No value given for a requested parameter

>

> We work with IIS and an Access database

>

> Thanks




$subst('Email.Unsub').