I need some help with making an adrotationsystem. I have a database with an adlocation (url where the ad is to be shown) and a advertisementlocation (url where the ad is located) in it. What i want is to asign a specific advertisement to a specific page. What i need is an code which regocnizes the wanted url of the requested page(loc)and then asign the advertisement to this specific page. I've tried the script below. But everytime i try to use it, it states that the recordset is empty. I no there is a problem with "WHERE ALocation='" & Loc & "' and AShow"". Because when i delete the where statement the recordset is outputed. Can anybode lent me a hand on this problem?<BR><BR> Loc = Request.ServerVariables("SCRIPT_NAME")<BR> set rstAdvertisement = CreateObject("ADODB.Recordset") <BR> Set objConn = CreateObject("ADODB.Connection")<BR> <BR>objConn.Open("Provider=Microsoft.Jet.OLEDB.4.0 ;Data Source=w:mywebpagedataadverts.mdb")<BR>rstAdvertis ement.open "SELECT * FROM Advertisement WHERE ALocation='" & Loc & "' and AShow"<BR><BR><BR>Many many thanks.